how i can slove this error,SQLSTATE[42000]?

Question

please help me to solve this error.i tired from searching solution... error: 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 'WHERE name=NULL' at line 1

my database have 3 column=id(int),name(varchar),comment(varchar) and i want insert comment to it.

my php code :

<?php
include "./Config.php";
include './MyPDO.php';

  $response = array() ;
  $connect = MyPDO::getInstance();

  $name = $_REQUEST['name'];
  $comment=$_REQUEST['comment'];

        $query =  " INSERT INTO user "
                . " (comment) "
                . " VALUES "
                . " (:comment) "
                . " WHERE name=:name ";

        $stmt = $connect->prepare($query);
        $stmt->bindParam(":name",$name);
        $stmt->bindParam(":comment",$comment);
        try {
                $stmt->execute();
                $response['massage'] = "sucess";
                echo json_encode($response);
                exit;
        } catch (PDOException $ex) { 
                $response['massage'] = "error";
                $response['error']=$ex->getMessage();
                echo json_encode($response);
        }

`INSERT` is for creating new rows, `UPDATE` is for creating new rows. It makes no sense to have `WHERE` in an `INSERT` query. — Barmar, Mar 16 '20 at 21:37

score 0 · Accepted Answer · answered Mar 16 '20 at 21:36

0

Looks like you mixed the syntax here. You seem to want to update an existing record. Use

update user
set comment = :comment
where name = :name

insert if for creating a new record.

answered Mar 16 '20 at 21:36

juergen d

201,996
37
293
362

score 0 · Answer 2 · answered Mar 16 '20 at 21:38

The insert into ... values() syntax does not take a where clause.

If you want to insert, then:

insert into user(name, comment) values(:name, :comment)

But actually it looks like you might want an update:

update users set comment = :comment where name = :name;

The former creates a new record in the table, with the given name and comment.

The latter modifies the already-existing record that has the same name and sets its comment value.

how i can slove this error,SQLSTATE[42000]?

2 Answers2