Jump to content

Delete and Update Button not working!


spanner206
Go to solution Solved by Ch0cu3r,

Recommended Posts

hi ive been trying to sort this out all day, im very inexperianced in php but really want to do well in it and at the moment ive got a table working linked to a database and which pulls records but now i want to get an update and delete button but i cant seem to hack it heres the code.

<?php
 
$con = mysqli_connect("localhost","root","","lcm");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
//updates table.
if (isset($_POST['update'])){;
 
$UpdateQuery = "UPDATE tbl_contactinfo SET Name='$_POST[Name]', Address='$_POST[Address]' WHERE Name='$_POST[hidden]'";
mysql_query($UpdateQuery, $con);
}
if (isset($_POST['delete'])){;
 
$DeleteQuery =  "DELETE FROM tbl_contactinfo WHERE Name='$_POST[hidden]'";
mysql_query($DeleteQuery, $con);
}
//selects the table.
$sql = "Select * from tbl_contactinfo";
if ($result = mysqli_query($con, $sql))
{
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Address</th>
</tr>";
 
while($row = mysqli_fetch_array($result))
{
echo '<form action="index1.php" method="post">';
echo '<tr>';
echo '<td><input type="text" name="name" value="' . $row['Name'] . '" /></td>'; 
echo '<td><input type="text" name="address" value="' . $row['Address'] . '" /></td>';
echo '<td><input type="hidden" name="hidden" value="' . $row['ID'] . '" /></td>'; 
echo '<td><input type="submit" name="update" value="update" /></td>';
echo '<td><input type="submit" name="delete" value="delete" /></td>';
echo '</tr>';
echo '</form>';
}
echo "</table>";
 
}
?>
<html>
<body>
 
<form action="insert.php" method="post">
Name: <input type="text" name="Name">
Address: <input type="text" name="Address">
<input type="submit">
</form>
 
</body>
</html>
and error messages ive been getting.
 
( ! ) Notice: Undefined index: Name in C:\wamp\www\Index1.php on line 12 Call Stack # Time Memory Function Location 1 0.0000 147208 {main}( ) ..\Index1.php:0
( ! ) Notice: Undefined index: Address in C:\wamp\www\Index1.php on line 12 Call Stack # Time Memory Function Location 1 0.0000 147208 {main}( ) ..\Index1.php:0
( ! ) Warning: mysql_query() expects parameter 2 to be resource, object given in C:\wamp\www\Index1.php on line 13 Call Stack # Time Memory Function Location 1 0.0000 147208 {main}( ) ..\Index1.php:0 2 0.1562 154608 mysql_query ( ) ..\Index1.php:13

 

these are for update and for delete

( ! ) Warning: mysql_query() expects parameter 2 to be resource, object given in C:\wamp\www\Index1.php on line 18 Call Stack # Time Memory Function Location 1 0.0000 147208 {main}( ) ..\Index1.php:0 2 0.1406 154456 mysql_query ( ) ..\Index1.php:18

ive stoped the error messages before dont no how i did it but they wernt showing, only problem is when i pressed them nothing happened any help will be great.

Link to comment
Share on other sites

Lots of problems:

 

1. You need to run the POST vars through mysqli_real_escape_string() or use prepared statements before using them in your query.

2. Your form input is name etc.  and you are trying to use $_POST[Name].

3. You're mixing mysql and mysqli functions which won't work.

etc...

Link to comment
Share on other sites

  • Solution

Also you're trying to update/delete records where Name = $_POST['hidden']. The form field named hidden is set to the records ID not the Name

echo '<td><input type="hidden" name="hidden" value="' . $row['ID'] . '" /></td>'; 

You need to change your update/delete queries where clause to WHERE ID = $_POST['hidden']

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.