Home Delete record in php and mysqli
Reply: 0

Delete record in php and mysqli

user3023
1#
user3023 Published in April 21, 2018, 3:30 pm

l have created an application using php,html and mysql. The application can store a user's information such as id, name, bio, and date created into the database and display in html table. The id is an auto increment value which increases with every data entered by the user. The insert part of the application works fine but when l try to delete a record nothing happens. An html form is part of the code which l have intentionally decided not to include. Here is a snapshot of my code:

   $records = array();

 if(!empty($_POST)) {
    if(isset($_POST['firstName'],$_POST['lastName'], $_POST['bio'])){
    $firstName = trim($_POST['firstName']);
    $lastName  = trim($_POST['lastName']);
    $bio       = trim($_POST['bio']);

if(!empty($firstName) && !empty($lastName) && !empty($bio)) {
    $insert = $db->prepare("INSERT INTO people (firstName, lastName, 
    bio, created) VALUES (?, ?,?, NOW())");
    $insert->bind_param('sss', $firstName, $lastName, $bio); 

    if($insert->execute()){

        header('Location: addressbook.php');
        die();
       }

      }
      }
     }

  if($results = $db->query("SELECT * FROM people")){
  if($results->num_rows){
   while($row = $results->fetch_object()){
    $records[] = $row;
  }
 $results->free();  
}
 } 


 ?>

 <!DOCTYPE html>
 <html>
 <head></head>
 <body>
 <div class = "container">



<?php
    if(!count($records)){

    echo 'No records found';
    }

    else{


?>
<table class="table">
<thead>
    <tr>
        <th>ID</th>
        <th>First Name</th>
        <th>Last Name</th>
        <th>Bio</th>
        <th>Created</th>
        <th>Delete</th>
    </tr>
</thead>
<tbody>

    <?php
        foreach ($records as $r) {


    ?>
        <tr>
            <td><?php echo escape($r->id);?></td>
            <td><?php echo escape($r->firstName); ?></td>
            <td><?php echo escape($r->lastName); ?></td>
            <td><?php echo escape($r->bio); ?></td>
            <td><?php echo escape($r->created); ?></td>
            <td>
            <a  onclick="return confirm('Do you want to delete the 
          record')" href="addressbook.php?idd=<?php echo $row['id'] ?>" 
          class="btn btn- 
          danger">Delete</a></td>



        <?php

        }
        ?>
     </tr>

 //My guess is the problem is with this code down here for deleting

    <?php

    if(isset($_POST['idd'])){
        $idd = $_POST['idd'];
        $results = $db->query("DELETE FROM people WHERE id=$idd");
        if($results){
            header('Location: addressbook.php');
        }
    }
   ?>



  </tbody>
 </table>

   <?php

   }
   ?>
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.30837 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO