Php Code for View, Search, Edit and Delete Record from MySql Table

Php Code for View, Search, Edit and Delete Record from MySql Table

 PHP (recursive acronym for "PHP: Hypertext Preprocessor") is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

This is the simple Code Example through which you can insert, Delete, View , Update from MySql Database.

Paste this code and save the file as written above. Create a database named test and create a table student as below structure.

 MySql Table

 CREATE TABLE `student` (  `roll` int(11) default NULL,  `class` varchar(20) default NULL,  `name` varchar(40) default NULL,  `f_name` varchar(40) default NULL,  `sex` varchar(6) default NULL,  `addr1` varchar(20) default NULL,  `addr2` varchar(20) default NULL,  `addr3` varchar(20) default NULL,  `city` varchar(20) default NULL,  `phone` varchar(12) default NULL,  `email` varchar(100)

default NULL,  `remarks` varchar(40) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 


Index.php [Main or Home Page]

 

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Search Student  Record</title>

</head>

<body>

<center><h1><u>Student Database</u></h1></center>

<form name="search" method="post" action="search.php">

<table style=" border:1px solid silver" cellpadding="10px" cellspacing="0px" align="center">

<tr>

<td colspan="3" style="background:#0066FF; color:#FFFFFF; font-size:20px">Search</td></tr>

<tr>

<td>Enter Search Keyword</td>

<td><input type="text" name="search" size="40" /></td>

<td><input type="submit" value="Search" /></td>

</tr>

<tr>

<td colspan="3">&nbsp;</td></tr>

<tr bgcolor="#CCCCCC">

<th><a href="add.php">Add Record</a></th>

<th><a href="del.php">Delete Record</a></th>

<th><a href="del.php">Update Record</a></th>

</tr>

</table>

</form>

</body>

</html>

 

 

Search.php

 <?

mysql_connect("localhost");

mysql_select_db("test") or die("database could not connect ");

?>

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Search Student  Record</title>

</head>

<body>

<center><h1><u>Student Database</u></h1></center>

<form name="search" method="post" action="search.php">

<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="0">

<tr>

<td colspan="3" style="background:#0066FF; color:#FFFFFF; font-size:20px">Search</td></tr>

<tr>

<td>Enter Search Keyword</td>

<td><input type="text" name="search" size="40" /></td>

<td><input type="submit" value="Search" /></td>

</tr>

<tr bgcolor="#666666" style="color:#FFFFFF">

<td>Roll & class</td>

<td>Name & Father's Name</td>

<td>&nbsp;</td>

 <?

$search=$_POST["search"];

$flag=0;

$query="select * from student where  name like '%$search%' ";

$result=mysql_query($query);

                         while ($row = mysql_fetch_array($result)) {

                         $flag=1;

                         echo "<tr ><td>",$row[0],", ",$row[1],"</td><td><a href='view.php?roll=",$row[0],"'>",$row[2],", ",$row[3],"</a></td><td><a href='edit.php?roll=",$row[0],"'>Edit</a> | <a href='del.php?roll=",$row[0],"'>Delete</a></td></tr>";

 

                         }

                         if($flag==0)

                         echo "<tr><td colspan='3' align='center' style='color:red'>Record not found</td></tr>";

                                                 

?>

<tr>

<td colspan="3">&nbsp;</td></tr>

<tr bgcolor="#CCCCCC">

<th colspan="3" align="right"><a href="add.php">Add Record</a></th>

</tr>

</table>

</form>

</body>

</html>

 

View.php

<?

mysql_connect("localhost");

mysql_select_db("test") or die("database could not connect ");

?>

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>View Student  Record</title>

</head>

<body>

<center><h1><u>Student Database</u></h1></center>

<?

$roll=$_GET["roll"];

$query="select * from student where roll='$roll'";

$result=mysql_query($query);

                         while ($row = mysql_fetch_array($result)) {

                         

?>

<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="1">

<tr>

<td colspan="4" style="background:#0066FF; color:#FFFFFF; font-size:20px">VIEW STUDENT DATABASE</td></tr>

<tr>

<td> Roll Number</td><td><? echo $row[0];?></td>

<td> Class</td><td><? echo $row[1];?></td>

</tr>

<tr>

<td> Name of Student</td><td><? echo $row[2];?></td>

<td> Father's Name</td><td><? echo $row[3];?></td>

</tr>

<tr>

<td>Sex</td><td><? echo $row[4];?></td>

<td>Address1</td><td><? echo $row[5];?></td></tr>

<tr>

<td>Address2</td><td><? echo $row[6];?></td>

<td>Address3</td><td><? echo $row[7];?></td></tr>

<tr>

<td>City</td><td><? echo $row[8];?></td>

<td>Phone</td><td><? echo $row[9];?></td></tr>

<tr>

<td>Email</td><td><? echo $row[10];?></td>

<td>Remarks</td><td><? echo $row[11];?></td></tr>

<tr>

 

</table>

<?

}

?>

<p align="center"><a href="index.php">Go Back to Home</a></p>

</body>

</html>

 

 

Add.php

<?

mysql_connect("localhost");

mysql_select_db("test") or die("database could not connect ");

?>

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Add Student  Record</title>

</head>

<body>

<center>

  <h1><u>Student Database</u></h1>

</center>

<?

if($_POST["do"]=="store")

{

$roll=$_POST["roll"];

$class=$_POST["class"];

$name=$_POST["name"];

$fname=$_POST["fname"];

$sex=$_POST["sex"];

$addr1=$_POST["addr1"];

$addr2=$_POST["addr2"];

$addr3=$_POST["addr3"];

$city=$_POST["city"];

$phone=$_POST["phone"];

$email=$_POST["email"];

$remarks=$_POST["remarks"];

$query="insert into student value($roll,'$class','$name','$fname','$sex','$addr1','$addr2','$addr3','$city','$phone','$email','$remarks')";

mysql_query($query);

            echo "<center>Successfully store in DATABASE</center>";

           

}

?>

<form name="add" method="post" action="add.php">

  <table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="0">

    <tr>

      <td colspan="4" style="background:#0066FF; color:#FFFFFF; font-size:20px">ADD STUDENT RECORD</td>

    </tr>

    <tr>

    <tr>

      <td>Enter Roll Number</td>

      <td><input type="text" name="roll" size="20"></td>

      <td>Enter Class</td>

      <td><input type="text" name="class" size="20"></td>

    </tr>

    <tr>

      <td>Enter Name of Student</td>

      <td><input type="text" name="name" size="20"></td>

      <td>Enter Father's Name</td>

      <td><input type="text" name="fname" size="20"></td>

    </tr>

    <tr>

      <td>Sex</td>

      <td><input type="radio" name="sex" value="Male">

        Male

        <input type="radio" name="sex" value="Female">

        Female </td>

      <td>Address1</td>

      <td><input type="text" name="addr1" size="20"></td>

    </tr>

    <tr>

      <td>Address2</td>

      <td><input type="text" name="addr2" size="20"></td>

      <td>Address3</td>

      <td><input type="text" name="addr3" size="20"></td>

    </tr>

    <tr>

      <td>City</td>

      <td><input type="text" name="city" size="20"></td>

      <td>Phone</td>

      <td><input type="text" name="phone" size="20"></td>

    </tr>

    <tr>

      <td>Email</td>

      <td><input type="text" name="email" size="20"></td>

      <td>Remarks</td>

      <td><input type="text" name="remarks" size="20"></td>

    </tr>

    <tr>

      <td colspan="4" align="center"><input type="hidden" name="do" value="store">

        <input type="submit" value="ADD RECORD"></td>

    </tr>

  </table>

</form>

<p align="center"><a href="index.php">Go Back to Home</a></p>

<?

include("search.php");?>

</body>

</html>

 

 

 

Edit.php

<?

mysql_connect("localhost");

mysql_select_db("test") or die("database could not connect ");

?>

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Update  Student  Record</title>

</head>

<body>

<?

if($_POST["do"]=="update")

{

$roll=$_POST["roll"];

$class=$_POST["class"];

$name=$_POST["name"];

$fname=$_POST["fname"];

$sex=$_POST["sex"];

$addr1=$_POST["addr1"];

$addr2=$_POST["addr2"];

$addr3=$_POST["addr3"];

$city=$_POST["city"];

$phone=$_POST["phone"];

$email=$_POST["email"];

$remarks=$_POST["remarks"];

$query="update student set name='$name',f_name='$fname',sex='$sex',addr1='$addr1',addr2='$addr2',addr3='$addr3',city='$city',

phone='$phone',email='$email',remarks='$remarks' where roll=$roll";

mysql_query($query);

 

            echo "<center>Successfully Updated in DATABASE</center>";

            include("search.php");

 

}

?>

<center>

  <h1><u>Student Database</u></h1>

</center>

<?

$roll=$_GET["roll"];

$query="select * from student where roll='$roll'";

$result=mysql_query($query);

                         while ($row = mysql_fetch_array($result)) {

                         

?>

<form name="update" method="post" action="edit.php">

  <table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="0">

    <tr>

      <td colspan="4" style="background:#0066FF; color:#FFFFFF; font-size:20px">ADD STUDENT RECORD</td>

    </tr>

    <tr>

    <tr>

      <td>Enter Roll Number</td>

      <td><? echo $row[0];?>

        <input type="hidden" name="roll" size="20" value="<? echo $row[0];?>"></td>

      <td>Enter Class</td>

      <td><input type="text" name="class" size="20" value="<? echo $row[1];?>" disabled="disabled"></td>

    </tr>

    <tr>

      <td>Enter Name of Student</td>

      <td><input type="text" name="name" size="20" value="<? echo $row[2];?>"></td>

      <td>Enter Father's Name</td>

      <td><input type="text" name="fname" size="20" value="<? echo $row[3];?>"></td>

    </tr>

    <tr>

      <td>Sex</td>

      <td><input type="radio" name="sex" value="Male" checked="checked">

        Male

        <input type="radio" name="sex" value="Female">

        Female </td>

      <td>Address1</td>

      <td><input type="text" name="addr1" size="20" value="<? echo $row[5];?>"></td>

    </tr>

    <tr>

      <td>Address2</td>

      <td><input type="text" name="addr2" size="20" value="<? echo $row[6];?>"></td>

      <td>Address3</td>

      <td><input type="text" name="addr3" size="20" value="<? echo $row[7];?>"></td>

    </tr>

    <tr>

      <td>City</td>

      <td><input type="text" name="city" size="20" value="<? echo $row[8];?>"></td>

      <td>Phone</td>

      <td><input type="text" name="phone" size="20" value="<? echo $row[9];?>"></td>

    </tr>

    <tr>

      <td>Email</td>

      <td><input type="text" name="email" size="20" value="<? echo $row[10];?>"></td>

      <td>Remarks</td>

      <td><input type="text" name="remarks" size="20" value="<? echo $row[11];?>"></td>

    </tr>

    <tr>

      <td colspan="4" align="center"><input type="hidden" name="do" value="update">

        <input type="submit" value="UPDATE RECORD"></td>

    </tr>

  </table>

</form>

<? } ?>

<p align="center"><a href="index.php">Go Back to Home</a></p>

</body>

</html>

 

 

Del.php

<?

mysql_connect("localhost");

mysql_select_db("test") or die("database could not connect ");

?>

<html>

<head>

<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Add Student  Record</title>

</head>

<body>

<?

$roll=$_GET["roll"];

$query="delete from student where roll=$roll";

mysql_query($query);

echo "<center>Successfully Deleted</center>";

include("search.php");

?>

</body>

</html>

 

If you found any error or if you have any feedback regarding this code example

mail me at gunjankumarverma@gmail.com

 

Post a Comment

Previous Post Next Post

Contact Form