updating/deleting form data with php to update database using phpmyadmin

Question

I am in the midst of completing a uni assignment and ive come across the issue of being totally stumped on how to update and delete data in my database through the use of a form.

I have successfully connected the database so that when the user selects the the addressID in the previous page they wish to work on, it will take them to the updateform.php page.

My code for the form is as follows:

<form method="post">
<tr>
    <td>Firstline</td>
    <td><input type="text" name="firstline" class="form-control"/></td>
</tr>
<tr>
    <td>Secondline</td>
    <td><input type="text" name="secondline" class="form-control"/></td>
</tr>
<tr>
    <td>City</td>
    <td><input type="text" name="city" class="form-control"/></td>
</tr>
<tr>
    <td>State</td>
    <td><input type="text" name="state" class="form-control"/></td>
</tr>
    <tr>
    <td>Zip</td>
    <td><input type="text" name="zip" class="form-control"/></td>
</tr>
<tr>
    <td></td>
    <td><input type="submit" name="submit" value="Update" class="btn btn-success btn-lg"/></td>
</tr>
    <tr>
    <td></td>
    <td><input type="delete" name="submit" value="Delete" class="btn btn-success btn-lg"/></td>
</tr>

I am now completely stumped on how to connect the data they enter in the form to update the database.

I am trying to update the addresses table with the selected addressID chosen earlier if that helps.

Any push in the correct direction will be greatly appeciated.

Kind Regards

Mayank Pandeyz · Accepted Answer · 2016-10-22 03:50:44Z

2

Change these line:

<form method="post">

to

<form method="post" action="process.php">

and

<input type="submit" name="submit" value="Update" class="btn btn-success btn-lg"/>

to

<input type="submit" name="update" value="Update" class="btn btn-success btn-lg"/>

and

<input type="delete" name="submit" value="Delete" class="btn btn-success btn-lg"/>

to

<input type="delete" name="delete" value="Delete" class="btn btn-success btn-lg"/>

process.php:

if(isset($_REQUEST['update']))
{
    // update block
    // get all required value and fire update query
}

if(isset($_REQUEST['delete']))
{
    // delete block
    // get all required value and fire delete query
}

answered Oct 22, 2016 at 3:50

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

geebee Over a year ago

Thank you. Ill give it a crack.

geebee Over a year ago

i am completely stumped on how to complete this process. Any ideas for me to get on my way?

Darren Burns · Accepted Answer · 2016-10-22 06:39:36Z

0

You could try something like this:

updateform.php

    <?php

    if ($_SERVER['REQUEST_METHOD'] == 'POST') {

strip tags from user input:

    $firstline= trim(strip_tags($_POST['first_line']));
    $secondline= trim(strip_tags($_POST['second_line']));

create query:

    $myquery = "INSERT INTO tablename (firstline, secondline) 
                VALUES ($firstline', '$secondline')";

execute query (confirm success/failure if/else):

    if (@mysqli_query($database, $myquery)) {
    print '<p>Entries accepted</p>';
    }

    else    {
    print '<p style="color: red;">Could not INSERT values because:<br />'
    . mysqli_error($database) . '</p>;
   }

   }

   ?>

Then have your form post values for the query variables:

<form action="updateform.php" method="post">
    <tr>
    <td>Firstline</td>
    <td><input type="text" name="firstline" size="20" value= <?php  if (isset($_POST['firstline'])) {
                                                                                print htmlspecialchars($_POST['first_line']);
                                                                                } ?> /></td>

    <tr>
    <td>Secondline</td>
    <td><input type="text" name="secondline" size="20" value= <?php if (isset($_POST['secondline'])) {
                                                                                print htmlspecialchars($_POST['second_line']);
                                                                                } ?> /></td>

    <tr>
    <td></td>
    <td><input type="submit" name="submit" value="Update" class="btn btn-success btn-lg"/></td>
    </tr>
    <tr>
    <td></td>
    <td><input type="delete" name="submit" value="Delete" class="btn btn-success btn-lg"/></td>

edited Oct 22, 2016 at 6:39

answered Oct 22, 2016 at 5:10

Darren Burns

134 bronze badges

3 Comments

geebee Over a year ago

Im getting a whole bunch of undefined index errors with the strip tags.

Darren Burns Over a year ago

The first line of the php code should check request method is post:... if ($_SERVER['REQUEST_METHOD'] == 'POST') { ...and then close that bracket just before closing the ?> bracket... I will edit the code above for you.

Darren Burns Over a year ago

Should solve the undefined indexes...my fault for forgetting that

Collectives™ on Stack Overflow

updating/deleting form data with php to update database using phpmyadmin

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related