Update MySQL using HTML Form and PHP

Question

I ve been looking through dozens of threads on here about this but have yet to find a solution   I ve created a form that is supposed to show database table contents in input boxes  and when the content of the input boxes are changed and submitted the database is supposed to update    lt html gt   lt head gt   lt  head gt   lt body gt    lt  php   dbhost            dbuser            dbpass            conn   mysql connect  dbhost   dbuser   dbpass   if    conn       die  Could not connect      mysql error       mysql select db            query    SELECT   FROM anstalld    result   mysql query  query  or die mysql error        gt     lt form method  post  action   lt  php   PHP SELF   gt   gt   lt table width  400  border  0  cellspacing  1  cellpadding  2  gt   lt tr gt    lt  php   while  row   mysql fetch array  result                   namn    row  namn     mandag    row  mandag     tisdag    row  tisdag     onsdag    row  onsdag     torsdag    row  torsdag     fredag    row  fredag      gt     lt td width  100  gt  lt  td gt   lt td gt  lt    namn  gt  lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt Mandag lt  td gt   lt td gt  lt input name  mandagid  type  text  value   lt    mandag  gt   gt  lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt Tisdag lt  td gt   lt td gt  lt input name  tisdagid  type  text  value   lt    tisdag  gt   gt  lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt Onsdag lt  td gt   lt td gt  lt input name  onsdagid  type  text  value   lt    onsdag  gt   gt  lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt Torsdag lt  td gt   lt td gt  lt input name  torsdagid  type  text  value   lt    torsdag  gt   gt  lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt Fredag lt  td gt   lt td gt  lt input name  fredagid  type  text  value   lt    fredag  gt   gt  lt  td gt   lt  tr gt   lt  php     gt   lt tr gt   lt td width  100  gt   lt  td gt   lt td gt   lt  td gt   lt  tr gt   lt tr gt   lt td width  100  gt   lt  td gt   lt td gt   lt input name  update  type  submit  id  update  value  Update  gt   lt  td gt   lt  tr gt   lt  table gt   lt  form gt      lt  php  if isset   POST  update         namn     POST  namnid     mandag     POST  mandagid     tisdag     POST  tisdagid     onsdag     POST  onsdagid     torsdag     POST  torsdagid     fredag     POST  fredagid      sql   mysql query  UPDATE anstalld SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn       retval   mysql query   sql   conn    if    retval       die  Could not update data      mysql error       echo  Updated data successfully n          gt   lt  body gt   lt  html gt    The forms show the content of the database fine  but upon updating I get this message      You have an error in your SQL syntax  check the manual that   corresponds to your MySQL server version for the right syntax to use   near  1  at line 1   I appreciate any help I can get on this

User · Answer

First of all use      mysqli connect  dbhost  dbuser  dbpass  dbname   Second - put mysqli  everywhere instead of mysql   Third - use this      sql    UPDATE anstalld SET mandag      mandag    tisdag      tisdag    onsdag      onsdag    torsdag      torsdag    fredag      fredag   WHERE namn      namn      retval   mysqli query   conn   sql      execute your query  if Your data is being updated in your database but not in your table its because when you will click on update button  the request is made to the same file  It first selects the data from the database when it is not updated prints it in the table and then update it according to the flow  If you have to update it as you click on update button then put this section   lt  php if isset   POST  update         namn     POST  namnid     mandag     POST  mandagid     tisdag     POST  tisdagid     onsdag     POST  onsdagid     torsdag     POST  torsdagid     fredag     POST  fredagid      sql   mysql query  UPDATE anstalld SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn       retval   mysql query   sql   conn    if    retval     die  Could not update data      mysql error       echo  Updated data successfully n          gt     after connecting with database

User · Answer

Update query may have some issues    query    UPDATE anstalld SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn     echo  query    Please make sure that  your variable not having values with qoutes        May be the query is breaking somewhere    echo the query and try to execute in phpmyadmin itself  Then you can find the issues

User · Answer

Your sql is incorrect    sql   mysql query  UPDATE anstalld       only   sql    UPDATE anstalld

User · Answer

Try it this way  Put the table name in quotes       beside put variable     xyz      So your sql query will be like    sql   mysql query  UPDATE  anstalld  SET mandag       mandag    WHERE namn     name or die mysql error

User · Answer

you have error in your sql syntax   please use this query and checkout    query   mysql query  UPDATE  anstalld  SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn

User · Answer

You have already executed your query here   sql   mysql query  UPDATE anstalld SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn       So this line has the problem   retval   mysql query   sql   conn       sql is not a query its a result set here   Try something like this    sql    UPDATE anstalld SET mandag     mandag   tisdag     tisdag   onsdag     onsdag   torsdag     torsdag   fredag     fredag  WHERE namn     namn         retval   mysql query   sql   conn      execute your query      As a sidenote  MySQL   extension is deprecated use MySQLi   or PDO   instead

User · Answer

Use  mysqli instead of mysql  and you need to pass the database name or schema   before    conn   mysql connect  dbhost   dbuser   dbpass     after    conn   mysql connect  dbhost   dbuser   dbpass   myDBname

[php] Update MySQL using HTML Form and PHP

Examples related to php

Examples related to html

Examples related to mysql

Examples related to forms

Examples related to sql-update