Question 8336 in PHP Versions Question posted in
You can find a list of all versions here.

SQLSTATE[42000]: Syntax error or access violation: 1064 Error – PHP Versions

I am getting the following error on a website. I create ticket for this reason in my hosting provider. It told me "You need to edit the select query, not a select query suitable for the mariadb version on the server." they said.

error_log File:

 [25-Dec-2021 19:50:24 Europe] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and dripfeed= 2' at line 1 in /home/user/public_html/script.php:461
        Stack trace:
        #0 /home/user/public_html/script.php(461): PDO->query('SELECT * FROM o...')
        #1 /home/user/public_html/index.php(35): require_once('/home/user/...')
        #2 {main}
          thrown in /home/user/public_html/script.php on line 461

script.php File:

$dripfeedvarmi = $conn->query("SELECT * FROM demo WHERE user=$user_id and dripfeed=2");
        if ($dripfeedvarmi->rowCount())
        {
            $dripfeedcount = 1;
        }
        else
        {
            $dripfeedcount = 0;
        }

Current DB Version: 10.2.41-MariaDB-cll-lve
PHP Version: 7.4.25
OS: Linux

Thank you in advance for your help.

Tags:

2

Answers


  1. 0

    even if the MySQL syntax is correct, do not write code like this. Always prepare your query to make it secure!

    Try this example:

    $query = 'SELECT * FROM demo WHERE user = ? AND dripfeed = ?';
$array = array($user_id, 2);

$init = $conn->prepare($query);
$init->execute($array);

$rowCount = $init->rowCount();

if($rowCount > 0){
    $dripfeedcount = 1;
}else{
    $dripfeedcount = 0;
};

    Also if you are storing the id of the user, so why the column name is not user_id instead of user? Be clean…

    Edit 2023: If there is a table called users its a much better and cleaner way to define column names like id, name, age, etc… instead of user_id, user_name, or user_age

    Login or Signup to reply.
  2. 0

    You can also try like this to execute the query using prepare() and execute() methods.

    $stmt = $conn->prepare("SELECT * FROM demo WHERE user=:user and dripfeed=:dripfeed");
$stmt->execute([':user'=>$user_id,':dripfeed'=>2]);
$dripfeedcount = $stmt->rowCount();
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search