i have been trying find out magic code allows search , important delete data in code. put search code , works great, when comes make delete stuck can't find right place , code make data delete. have everywhere have found in google. question can 1 solve delete issue or it's not possible @ current technology? code shown below:
<?php //load database connection $host = "localhost"; $user = "abcd"; $password = "******"; $database_name = "abcd"; $pdo = new pdo("mysql:host=$host;dbname=$database_name", $user, $password, array( pdo::attr_errmode => pdo::errmode_exception )); // search mysql database table $search=$_post['search']; $query = $pdo->prepare("select * wfuk post_code '%$search%' or telephone '%$search%' limit 0 , 10"); $query->bindvalue(1, "%$search%", pdo::param_str); $query->execute(); // display search result ?> <html> <head> <title> how create database search mysql & php script | tutorial.world.edu </title> </head> <body> <form action="search.php" method="post"> search: <input type="text" name="search" placeholder=" search here ... "/> <input type="submit" value="submit" /> </form> <?php if (!$query->rowcount() == 0) { echo "search found :<br/>"; echo "<table style=\"font-family:arial;color:#333333;\">"; echo "<tr> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">first name</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">last name</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">trade</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">post code</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">telephone</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">comments</td> <td style=\"border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;\">to use</td></tr>"; while ($results = $query->fetch()) { echo "<tr><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['first_name']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['last_name']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['trade']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['post_code']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['telephone']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo $results['comments']; echo "</td><td style=\"border-style:solid;border-width:1px;border-color:#98bf21;\">"; echo("<button onclick=\"location.href='search.php?del=" . $results['id'] . "'\"> delete user</button>"); echo "</td></tr>"; } echo "</table>"; } else { echo 'nothing found'; } ?>
the query need:
delete wfuk id = ? the value id parameter query string:
$query->bindvalue(1, $_get['del'], pdo::param_int); 
Comments
Post a Comment