Update query with PDO and MySQL

Question

Im trying to write an update query with PDO only I cant get my code to execute   try     conn   new PDO  mysql host  hostdb  dbname  namedb    userdb   passdb    conn- gt exec  SET CHARACTER SET utf8            Sets encoding UTF-8  conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION      sql    UPDATE  access users             contact first name   contact surname   contact email   telephone          VALUES   firstname   surname   telephone   email                 statement    conn- gt prepare  sql     statement- gt bindValue   firstname    firstname     statement- gt bindValue   surname    surname     statement- gt bindValue   telephone    telephone     statement- gt bindValue   email    email     count    statement- gt execute        conn   null            Disconnect   catch PDOException  e      echo  e- gt getMessage

User · Accepted Answer

Your UPDATE syntax is wrong You probably meant to update a row not all of them so you have to use WHERE clause to target your specific row   Change  UPDATE  access users             contact first name   contact surname   contact email   telephone          VALUES   firstname   surname   telephone   email    to  UPDATE  access users        SET  contact first name     firstname          contact surname     surname          contact email     email          telephone     telephone   WHERE  user id     user id -- you probably have some sort of id

User · Answer

This has nothing to do with using PDO  it s just that you are confusing INSERT and UPDATE   Here s the difference     INSERT creates a new row   I m guessing that you really want to create a new row  UPDATE changes the values in an existing row  but if this is what you re doing you probably should use a WHERE clause to restrict the change to a specific row  because the default is that it applies to every row    So this will probably do what you want    sql    INSERT INTO  access users         contact first name   contact surname   contact email   telephone      VALUES   firstname   surname   email   telephone          Note that I ve also changed the order of columns  the order of your columns must match the order of values in your VALUES clause   MySQL also supports an alternative syntax for INSERT    sql    INSERT INTO  access users       SET  contact first name     firstname       contact surname     surname       contact email     email       telephone     telephone        This alternative syntax looks a bit more like an UPDATE statement  but it creates a new row like INSERT   The advantage is that it s easier to match up the columns to the correct parameters

User · Answer

Your update syntax is incorrect   Please check Update Syntax for the correct syntax    sql    UPDATE  access users  set  contact first name     firstname    contact surname     surname   contact email     email   telephone     telephone

[php] Update query with PDO and MySQL

Examples related to php

Examples related to mysql

Examples related to pdo