Update Form using PHP

brownbrod · February 17, 2014

I have created a form to update records using the ID primary key. I am unable to use the Drop Down menu to select the record to update. I believe I have everything else correct. I would greatly appreciate your feedback.

Thanks,

<html>

<body>
<?php

$connect=mysql_connect('us70tudbs001.zam.alcatel-lucent.com:3306','norab','norab') or die("Unable to Connect");
@mysql_select_db('rightfirst') or die("Could not open the db");

$query="SELECT * FROM contacts";
$result=mysql_query($query) or die("Query Failed : ".mysql_error());

$i=0;

while($rows=mysql_fetch_array($result))
{
$roll[$i]=$rows['id'];
$i++;
}
$total_elmt=count($roll);
?>
<form method="post" action="">
Select the ID No. to Update: <select name="sel">
<option>Select</option>
<?php
for($j=0;$j<$total_elmt;$j++)
{
?></option><?php
echo $roll[$j];
?></option><?php
}
?>
</select><br />
First Name: <input name="first" type="text" /><br />
Last Name: <input name="last" type="text" /><br />
Phone: <input name="phone" type="text" /><br />
<input name="submit" type="submit" value="Updated"/><br />
<input name="reset" type="reset" value="Reset" />
</form>

<?php
if(isset($_POST['submit']))
{
$value=$_POST['sel'];
$first=$_POST['first'];
$last=$_POST['last'];
$phone=$_POST['phone'];

$query2 = "UPDATE contacts SET
first='$first',last='$last',phone='$phone' WHERE
id='$value'";
$result2=mysql_query($query2) or die("Query Failed :
".mysql_error());
echo "Successfully Updated";
}
?>
<p align=right><a href="view.php">VIEW RECORDS</a></p>

</body>

</html>

jazzman1 · February 17, 2014

I cannot see where the value attribute of select option tag is?

Please, use the code [ code ] tags when providing code.

Edited February 17, 2014 by jazzman1

tazmith · February 18, 2014



<?php


/*


* PDO version.


*/




$host = 'host';


$dbname = 'db_name';


$user = 'db_user';


$pass = 'db_pass';




try


{  


    $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);


}


catch(PDOException $e)


{


    echo $e->getMessage();


}






echo '<form method="POST">Select id to edit:


    <select name="id">';


    $query = $dbh->query('SELECT id FROM contacts ORDER BY id ASC');


    foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row)


    {


              echo '<option value="'.$row['id'].'">'.$row['id'].'</option>';


    }


    


    echo '</select>';


    


    echo '<br /><div>


            First Name: <input name="first" type="text" /><br />';




       echo '<input type="submit" name="submit" id="submit" value="Submit" />


            </form>';


            


        if (isset($_POST['submit']))


        {


               echo '<br />Editing ID: '.htmlspecialchars($_POST['id'],ENT_QUOTES). '';            


 


            if (empty($_POST['first']) === false)


            {        


                 //firstname has been edited, lets update.


                $update_query = $dbh->prepare('UPDATE contacts SET ' . 'first=:first WHERE ' . 'id=:id ');


                $update_query->bindParam(':first', $_POST['first']);


                $update_query->bindParam(':id', $_POST['id'], PDO::PARAM_INT);


                $update_query->execute();    


                echo '<br />Updated firstname to '.htmlspecialchars($_POST['first'],ENT_QUOTES).'';


            }


            


        }




        /*


   


/*


* mysql_ version.


*/




echo '<form method="POST">Select id to edit:


    <select name="id" id="ids">';


    $query = "SELECT id FROM contacts ORDER BY id ASC";


    $result = mysql_query($query) or die ( mysql_error ());


    while ($row = mysql_fetch_array($result,MYSQL_ASSOC))


    {


              echo '<option value="'.$row['id'].'">'.$row['id'].'</option>';


    }


    


    echo '</select>';


    


    echo '<br /><div>


            First Name: <input name="first" type="text" /><br />';




      


      echo '<input type="submit" name="submit" id="submit" value="Submit" />


            </form>';


            


        if (isset($_POST['submit']))


        {


            echo '<br /><br />Editing id: ' .htmlspecialchars($_POST['id'],ENT_QUOTES). '';


            


            if (empty($_POST['first']) === false)


            {        


                $id = (int)$_POST['id'];


                $firstname = mysql_real_escape_string($_POST['first']);


                $update_query = "UPDATE contacts SET first = '$firstname' WHERE id = '$id'");


                $update_result = mysql_query($update_result) or die ( mysql_error ());    


                echo '<br />Updated firstname to '.htmlspecialchars($_POST['first'],ENT_QUOTES).'';


            }


        }


       


?>

Edited February 18, 2014 by tazmith

brownbrod · February 18, 2014

This worked perfectly. Now. is there a way to show what the old value is before you udpate it? What I have seen looks to be very complexed. For example: Let's say I am updating ID 5 and I want to make sure it belongs to Catherine ('first'). How would I do that?

Thanks so much for your help.

Ch0cu3r · February 18, 2014

Better option would be to populate the select field with the users first name, setting the id as the value for that option, eg

echo '<form method="POST">Select name to edit: <select name="id">';

    $query = $dbh->query('SELECT id, first FROM contacts ORDER BY first ASC');

    foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row)
    {
              // set record id as value, and first name as option label
              echo '<option value="'.$row['id'].'">'.$row['first'].'</option>';
    }

    echo '</select>';

Now you'd select the the name you want to edit, and then when the form is submitted the name will be updated to whatever you entered into the name field.

Edited February 18, 2014 by Ch0cu3r

brownbrod · February 18, 2014

I need to update the Name using the "ID" that is associated with the name. So what I was wondering is can I view what is already in the "first" field before it is changed?

Ch0cu3r · February 18, 2014

That is what my code change does. It sets the Name as the label for the select input. It still sends the id associated with that name when form is submitted.

Live Example

http://phpfiddle.org/lite/code/c71-1p4 (click the run button, right hand side when page loads)

tazmith · February 18, 2014

I need to update the Name using the "ID" that is associated with the name. So what I was wondering is can I view what is already in the "first" field before it is changed?

if you wanted to you could have a drop down with the ID'S, and submit leading to a page like update.php?updateid=userid which will than show the input fields for first, last, ect. And than on that submit, create the POST submit.

tazmith · February 19, 2014

Hope this helps you. It's basic, this can be done in many ways, but here's a re-vamped version of what I did in my 1st post.

Note: I wen't with the PDO version, because mysql_ is just bad practice in my opinion, but that's only my opinion

<?php
 
$host = 'host';
$dbname = 'db_name';
$user = 'db_user';
$pass = 'db_pass';
 
try
{  
    $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
}
catch(PDOException $e)
{
    echo $e->getMessage();
}
 
 
if (!isset($_POST['selectid']) && !isset($_POST['submit']))
{
 
     echo '<form method="POST">Select ID to edit:
     <select name="id">';
     $query = $dbh->query('SELECT id FROM contacts ORDER BY id ASC');
     foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row)
     {
         echo '<option value="'.$row['id'].'">'.$row['id'].'</option>';
     }
 
     echo '</select>';
 
     echo '<input type="submit" name="selectid" id="selectid" value="Submit" />
     </form>';
}
 
     //selecting the id.
     if (isset($_POST['selectid']))
     {
         $query = $dbh->prepare('SELECT first,last,id FROM contacts WHERE ' . 'id=:id ');
         $query->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
         $query->execute();
         $row = $query->fetch(PDO::FETCH_ASSOC);
         $count = $query->rowCount();
        
         //incase of POST data manipulation
         if ($count < 1)
         {
             die('Error: User does not exist!');
         }
         
         echo 'Viewing ID: '.$row['id'].' Firstname: '.$row['first'].'';
         
         //the form.
         echo '<br /><br />
         <form method="POST"><div>
         First Name: <input type="text" name="first" value="'.$row['first'].'" /><br />
         Last Name: <input type="text" name="last" value="'.$row['last'].'" /><br />
         <input type="hidden" name="id" value="'.$row['id'].'" />
         <input type="submit" name="submit" id="submit" value="Submit" />';
                  
         echo '<br /><br /><a href="pagehere.php">go back</a>';
     }
     
     //submitting.
     if (isset($_POST['submit']))
     {
        if (empty($_POST['first']) === false)
        {
            //update firstname, since it was updated.
            $firstname_update = $dbh->prepare('UPDATE contacts SET ' . 'first=:first WHERE ' . 'id=:id ');
            $firstname_update->bindParam(':firstname', $_POST['first']);
            $firstname_update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
            $firstname_update->execute();
     
           //echo if wanted.
           echo 'Updating Firstname of ID: '.htmlspecialchars($_POST['id'],ENT_QUOTES).' to '.htmlspecialchars($_POST['first'],ENT_QUOTES).'';
     
          //just continue onward for lastname, phone, whatever you wan't really.
     
          echo '<br /><br /><a href="pagehere.php">go back</a>';
        }
     }
?>

brownbrod · February 19, 2014

_{This is what I needed. Thanks for your guidance. I really appreciate it. Have a great day!}

tazmith · February 19, 2014

No problem, glad I could help.

brownbrod · February 20, 2014

One more question. Using this formula can I update two fields in one submit? For example:

//update firstname, since it was updated.
   $firstname_update = $dbh->prepare('UPDATE contacts SET ' . 'first=:first WHERE ' . 'id=:id ');
   $firstname_update->bindParam(':firstname', $_POST['first']);
   $firstname_update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
   $firstname_update->execute();

//update lastname, since it was updated.
   $lastname_update = $dbh->prepare('UPDATE contacts SET ' . last=:lastWHERE ' . 'id=:id ');
   $lastname_update->bindParam(':lastname, $_POST[last]);
   $lastname_update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
   $lastname_update->execute();

So when I click "SUBMIT" it updates both?

This is just an example.

I greatly appreciate your feedback. Thanks so much!!!

tazmith · February 20, 2014

you can run everything through 1 update if you wanted.

You don't need to use

if (empty($_POST['first']) === false)

{
}

instead you could just update everything on

if (isset($_POST['submit']))
{
  //run query that updates all $_POST data here.
}

Ch0cu3r · February 21, 2014

One more question.   Using this formula can I update two fields in one submit?   For example:

//update firstname, since it was updated.

   $firstname_update = $dbh->prepare('UPDATE contacts SET ' . 'first=:first WHERE ' . 'id=:id ');

   $firstname_update->bindParam(':firstname', $_POST['first']);

   $firstname_update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);

   $firstname_update->execute();

//update lastname, since it was updated.

   $lastname_update = $dbh->prepare('UPDATE contacts SET ' . last=:lastWHERE ' . 'id=:id ');

   $lastname_update->bindParam(':lastname, $_POST[last]);

   $lastname_update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);

   $lastname_update->execute();

So when I click "SUBMIT" it updates both?

This is just an example.

I greatly appreciate your feedback.   Thanks so much!!!

Yes, you can update the lastname in a separate query. But it is more effeicent to update the firstname, and lastname within one query, using

//update firstname and lastname fields
$update = $dbh->prepare('UPDATE contacts SET first=:firstname, last=:lastname WHERE id=:id '); /* the update query */
$update->bindParam(':firstname', $_POST['first']); /* the firstname field */
$update->bindParam(':lastname', $_POST['last']);   /* the lastname field */
$update->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
$update->execute();

Edited February 21, 2014 by Ch0cu3r

brownbrod · February 21, 2014

As always!! Thank you for your help. You are awesome!!

Sign In

Update Form using PHP

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information