PHP Update multiple MySQL fields in single query

Question

I am basically just trying to update multiple values in my table  What would be the best way to go about this  Here is the current code    postsPerPage     POST  postsPerPage     style     POST  style     mysql connect   localhost    user    pass   or die   Error      mysql error     mysql select db   db     mysql query  UPDATE settings SET postsPerPage    postsPerPage WHERE id    1    or die mysql error       The other update I want to include is   mysql query  UPDATE settings SET style    style WHERE id    1    or die mysql error       Thanks

User · Answer

Comma separate the values   UPDATE settings SET postsPerPage    postsPerPage  style    style WHERE id    1

User · Answer

I guess you can use    con   new mysqli  localhost    my user    my password    world     sql    UPDATE  some table  SET  txid     txid    data      data  WHERE  wallet      wallet    if   mysqli- gt query  sql   con         print  wallet  wallet updated    else      printf  Errormessage   s n    con- gt error      con- gt close

User · Answer

If you are using pdo  it will look like   sql    UPDATE users SET firstname    firstname  lastname    lastname WHERE id   id    query    this- gt pdo- gt prepare  sql    result    query- gt execute array   firstname    gt   firstname    lastname    gt   lastname    id    gt   id

User · Answer

Add your multiple columns with comma separations   UPDATE settings SET postsPerPage    postsPerPage  style   style WHERE id    1    However  you re not sanitizing your inputs    This would mean any random hacker could destroy your database   See this question  What  39 s the best method for sanitizing user input with PHP   Also  is style a number or a string   I m assuming a string  so it would need to be quoted

[php] PHP: Update multiple MySQL fields in single query

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to sql-update