CRUD Example in PHP

CRUD : the meaning of Create, Read, Update, and Delete.

connect.php

 <?php 
$localhost 	= "localhost"; 
$username 	= "root"; 
$password 	= ""; 
$dbname 	= "samueldb"; 
$con = new mysqli($localhost, $username, $password, $dbname); 
if($con->connect_error) {
    die("connection failed : " . $con->connect_error); } 
 ?>

index.php

 <?php 
 require_once 'header.php';
 ?>
<div class="container">
	<div class="jumbotron">
	<h1>CRUD Example in PHP</h1>
	<p>.</p>
</div>
</div>
<?php 
 require_once 'footer.php';
 ?>

insert.php

<?php 
require_once 'connect.php';
require_once 'header.php';
?>
<div class="container">
	<?php 
	if(isset($_POST['addnew'])){
		if( empty($_POST['firstname']) || empty($_POST['lastname']) 
		|| empty($_POST['address']) || empty($_POST['contact']) ){
			echo "Please fillout all required fields"; 
		}else{		
			$firstname  = $_POST['firstname'];
			$lastname 	= $_POST['lastname'];
			$address 	= $_POST['address'];
			$contact  	= $_POST['contact'];
			$sql = "INSERT INTO users(firstname,lastname,address,contact) 
		    VALUES('$firstname','$lastname','$address','$contact')";

if( $con->query($sql) === TRUE){
				echo "<div class='alert alert-success'>Successfully added new user</div>";
			}else{
				echo "<div class='alert alert-danger'>
				Error: There was an error while adding new user</div>";
			}
		}
	}
	?>
	<div class="row">
	<div class="col-md-6 col-md-offset-3">
		<div class="box">
			<h3><i class="glyphicon glyphicon-plus"></i> Add New User</h3> 
			<form action="" method="POST">
				<label for="firstname">Firstname</label>
				<input type="text" id="firstname"  name="firstname" class="form-control"><br>
				<label for="lastname">Lastname</label>
				<input type="text"  name="lastname" id="lastname" class="form-control"><br>
				<label for="address">Address</label>
				<textarea rows="4" name="address" class="form-control">

Contact

users.php

 <?php 
require_once 'connect.php';
require_once 'header.php';
echo "<div class='container'>";
if( isset($_POST['delete'])){
	$sql = "DELETE FROM users WHERE user_id=" . $_POST['userid'];
	if($con->query($sql) === TRUE){
		echo "<div class='alert alert-success'>Successfully delete  user</div>";
	}
}

$sql 	= "SELECT * FROM users";
$result = $con->query($sql); 
if( $result->num_rows > 0)
{ 
	?>
	<h2>List of all Users</h2>
	<table class="table table-bordered table-striped">
		<tr>
			<td>Firstname</td>
			<td>Lastname</td>
			<td>Address</td>
			<td>Contact</td>
			<td width="70px">Delete</td>
			<td width="70px">EDIT</td>
		</tr>
	<?php
	while( $row = $result->fetch_assoc()){ 
		echo "<form action='' method='POST'>";	//added
		echo "<input type='hidden' value='". $row['user_id']."' name='userid' />"; //added
		echo "<tr>";
		echo "<td>".$row['firstname'] . "</td>";
		echo "<td>".$row['lastname'] . "</td>";
		echo "<td>".$row['address'] . "</td>";
		echo "<td>".$row['contact'] . "</td>";
		echo "<td><input type='submit' name='delete' value='Delete' class='btn btn-danger' /></td>";  
		echo "<td><a href='edit.php?id=".$row['user_id']."' class='btn btn-info'>Edit</a></td>";
		echo "</tr>";
		echo "</form>"; //added 
	}
	?>
	</table>
<?php 
}
else{
	echo "<br><br>No Record Found";
}
?> 
</div>
<?php 
 require_once 'footer.php';
?> 

header.php

    <!DOCTYPE html>
<html>
<head>
	<title>Basic CRUD in PHP</title>
	<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/
	3.3.7/css/bootstrap.min.css">
	<style type="text/css">
		.box{
			background: #f0f0f0;
			padding: 20px;
		}
	</style>
</head>
<body> 

<div class="container"> 
  <nav class="navbar navbar-default">
    <div class="container-fluid">
      <div class="navbar-header">
        <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" 
        data-target="#navbar" aria-expanded="false" aria-controls="navbar">
          <span class="sr-only">Toggle navigation</span>
          <span class="icon-bar"></span>
          <span class="icon-bar"></span>
          <span class="icon-bar"></span>
        </button>
        <a class="navbar-brand" href="index.php">CRUD </a>
      </div>
      <div id="navbar" class="navbar-collapse collapse">
        <ul class="nav navbar-nav">
          <li class="active"><a href="index.php">Home</a></li>
          <li><a href="insert.php">Add User</a></li> 
          <li><a href="users.php">All Users</a></li>
        </ul>
        
      </div><!--/.nav-collapse -->
    </div><!--/.container-fluid -->
  </nav> 
</div>

footer.php

    <hr>
<div class="container">
	<a href="https://rojgarbharat.info/" target="_bank">ROJGAR BHARAT JOB PORTAL</a>
</div>
</body>
</html>

Output

Download Source Code

Download

Next Topic

← prev next →

MYSQL Database

PHP Programs

PHP Projects