gateblogs

DISPLAYING DATA

Create file named contact-list.php and the put these code :

<?php 
 include('connect_db.php');
?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8"/>
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <meta name="description" content="php,form"/>

    <title>Display data from database</title>

 <!-- CSS -->
 <style>
  body {
   font-family : arial;
  }
  
  table {
   margin : 15px auto;
   border-collapse: collapse;
  }
  
  td, th {
   border : 1px solid #999;
   padding : 15px;
  }
  
  a {
   text-decoration : none;
   font-size : 12px;
   color : blue;
   cursor : pointer;
  }
  
  a:hover {
   text-decoration : underline;
  }
  
  .error {
   color : red;
  }
 </style>
  </head>
  <body>
  
  <table >
 <th>Name</th>
 <th>Phone</th>
 <th>Email</th>
  
   <?php   
  $query = $connect->query("SELECT * FROM my_table_1");
  $data = $query->fetch_all(MYSQLI_ASSOC);
  
  foreach($data as $row) {
  ?>
<tr>
    <td><?php echo $row['name']?></td>
    <td><?php echo $row['phone']?></td>
    <td><?php echo $row['email']?></td>
   </tr>
<?php   
  }
  
  $query->free(); 
  $connect->close();
   ?>
 
  </table>
</body>
</html>

Note : fetch_all(MYSQLI_ASSOC) = Fetch or display all data according on database column table's name see documentation.

UPDATE OR ALTER DATA

After displaying data from database, now back to contact-list.php and add some table column :

/*To display error if user delete id from debugger*/
<div class="error" align="center">
<?php if(isset($error_id)) {echo $error_id;} ?></div>
<table>
 <th>Name</th>
 <th>Phone</th>
 <th>Email</th>
 <th>Alter</th>
  
   <?php   
  $query = $connect->query("SELECT * FROM my_table_1");
  $data = $query->fetch_all(MYSQLI_ASSOC);
  
  if($query->num_rows > 0){
   foreach($data as $row) {
   ?>
<tr>
     <td><?php echo $row['name']?></td>
     <td><?php echo $row['phone']?></td>
     <td><?php echo $row['email']?></td>
     <td><a target="_blank" href="contact_edit_form.php?id=<?php echo $row['id'];?>">Update</a></td>
    </tr>
<?php   
   }
  } else {
   echo '<h2 align="center">
No Data Available</h2>
';
  }
  
  $query->free(); 
  $connect->close();
   ?>
 
  </table>

Note : num_rows = to count all records data on database.

Now create file to be filed by form to alter data, just copy contact_form.php (see on previous article) to make easier and then rename it into contact_edit_form.php.

<?php
 include('connect_db.php');
 
 /* To prevent user if delete id on URL */
 if(!isset($_GET['id']) || empty($_GET['id'])) {
  header("Location: contact-list.php");
 }
 $query = $connect->query("SELECT * FROM my_table_1 WHERE id ='".$_GET['id']."'");
 $data = $query->fetch_assoc();
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8"/>
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <meta name="description" content="php,form"/>

    <title>Update Database MySQL</title>

 <!-- CSS -->
 <style>
  body {
   font-family : arial;
  }
  
  form {
   margin : 0 auto;
   padding-top : 15px;
   max-width : 300px;
  }
  
  .form-space {
   margin-bottom : 15px;
  }
  
  input {
   border : 1px solid #999;
   height : 30px;
   width : 100%;
  }
  
  button {
   padding : 10px;
  }
  
  .error {
   color : red;
  }
 </style>
  </head>
  <body>
  
  <h1 align="center">
Edit Contact Form</h1>
<form method="post" action="contact-edit-save.php">
  <div class="form-space">
   <div>
Your Name</div>
<input type="text" name="yourname" value="<?php echo $data['name'] ?>" />
   <div class="error" align="center">
<?php if(isset($err_name)) {echo $err_name;} ?></div>
</div>
<div class="form-space">
   <div>
Your Phone</div>
<input type="text" name="yourphone" value="<?php echo $data['phone'] ?>" />
   <div class="error" align="center">
<?php if(isset($err_phone)) {echo $err_phone;} ?></div>
</div>
<div class="form-space">
   <div>
Your Email</div>
<input type="text" name="yourmail" value="<?php echo $data['email'] ?>" />
   <div class="error" align="center">
<?php if(isset($err_mail)) {echo $err_mail;} ?></div>
</div>
<input type="hidden" value="<?php echo $data['id'] ?>" name="id" />
  <button>Submit</button>
 </form>
</body>
  </html>

$_GET = to get data from URL according on variable.

Copy contact-form-save.php(see on previous article) and then paste it with name contact-edit-save.php. and alter some code like these :

<?php 
 include('connect_db.php');
 
 global $alter;
 $valid = false;
 $name = $_POST['yourname'];
 $phone = $_POST['yourphone'];
 $mail = $_POST['yourmail'];
 $id = $_POST['id'];
 
 if(!isset($id) || empty($id)){
  $error_id = 'Please do not delete ID';
  include('contact-list.php');
  die();
 }
  
 if(empty($name) && empty($phone) && empty($mail)){
  $err_name = 'Column name cannot be empty';
  $err_phone = 'Column phone cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_edit_form.php');
 } else if(empty($name) && empty($phone)){
  $err_name = 'Column name cannot be empty';
  $err_phone = 'Column phone cannot be empty';
  include('contact_form.php');
 } else if(empty($name) && empty($mail)){
  $err_name = 'Column name cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_edit_form.php');
 } else if(empty($phone) && empty($mail)){
  $err_phone = 'Column phone cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_edit_form.php');
 } else if(empty($name)){
  $err_name = 'Column name cannot be empty';
  include('contact_edit_form.php');
 } else if(empty($phone)){
  $err_phone = 'Column phone cannot be empty';
  include('contact_edit_form.php');
 } else if(empty($mail)){
  $err_mail = 'Column email cannot be empty';
  include('contact_edit_form.php');
 } else {
   $valid = true;
   $alter = $connect->query("UPDATE my_table_1 SET name = '".$name."', email = '".$mail."' , phone = '".$phone."' WHERE id='".$id."'");
 }

 if($valid == true && $alter == true){
  echo 'Your data has been altered succesfully';
 } else if($valid == true && $alter == false) {
  echo 'Failed to alter your data';
 }
 $connect->close();
?>

Now try to change for example name, change into your name or whatever :

Open your contact-list.php on browser and see if your data has changed :

DELETE DATA
To delete data from database create file contact_delete.php like these code :

<?php
include('connect_db.php');
$id = $_GET['id'];
global $id;

if(!isset($id) && empty($id)){
 $error_id = 'Please do not delete ID';
 include('contact-list.php');
 die();
} else {
 $del = $connect->query("DELETE FROM my_table_1 WHERE id='".$id."'"); 
}

if($del == true){
 echo 'Your data with id : <b>'.$id.'</b> has deleted';
} else {
 echo 'Failed to delete data with id : <b>'.$id.'</b>';
}

$del->free(); 
$connect->close();
?>

After you create file contact_delete.php now open contact-list.php and then add delete column and link code

<table>
 <th>Name</th>
 <th>Phone</th>
 <th>Email</th>
 <th>Alter</th>
 <th>Delete</th>
  
   <?php   
  $query = $connect->query("SELECT * FROM my_table_1");
  $data = $query->fetch_all(MYSQLI_ASSOC);
  
  if($query->num_rows > 0){
   foreach($data as $row) {
   ?>
<tr>
     <td><?php echo $row['name']?></td>
     <td><?php echo $row['phone']?></td>
     <td><?php echo $row['email']?></td>
     <td><a target="_blank" href="contact_edit_form.php?id=<?php echo $row['id'];?>">Update</a></td>
     <td><a onclick="conf('Are you sure to delete data with id : <?php echo $row['id'];?>?',<?php echo $row['id'];?>)">Delete</a></td>
    </tr>
<?php   
   }
  } else {
   echo '<h2 align="center">
No Data Available</h2>
';
  }
  $connect->close();
   ?>
  </table>
<script type="text/javascript">
 function conf(x,id){
  var con = confirm(x);
  if(con == true){
   window.location.href = "http://127.0.0.1/contact_delete.php?id="+id;
  } else {
   return false;
  }
 }
  </script>

We put some javascript to avoid if user click on wrong data. And then now try to delete your data

And if successful it would be :

Now back to contact-list.php and see if data my_column_2 (id = 2) has deleted.

Finally you can insert, display, update and delete your data from database using PHP. If you want to get more information, syntax and code about PHP you can visit php.net.

PHP display data, update and delete from database MySQL

Blog Pages List

Search This Blog

Blog Archive

Share Donation Link