PHP Examples - Student Details
Delete Data From Database - Form
Program:
// php10.php
<html > <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PHP EXAMPLE 9 : Database with Form - Deletion </title> </head> <body> <?php echo "<br/>PHP Example 9"; echo"<br/>"; // line break echo"<h1>"; echo"Delete Data From DATABASE"; echo"</h1>"; echo"<br/>"; // echo"<br>CONNECTING..."; $con = mysql_connect("localhost","root",""); // Connecting to the database if(!$con) die('Connection Failed'.mysql_error()); echo"<br>CONNECTED..."; if(!mysql_select_db("DB1",$con)) { if(mysql_query("CREATE DATABASE DB1",$con)) // Creating database echo"<br><br>DB1 Created..."; else echo 'Error Occured...'.mysql_error(); mysql_select_db("DB1",$con); // Creating tables mysql_query(" CREATE TABLE Students( Rollnum int NOT NULL, Name varchar(20), Mark int, PRIMARY KEY(Rollnum) )",$con); } $data= mysql_query(" SELECT Rollnum FROM Students ",$con); // Retreiving data echo"<center> <h2><b><u> STUDENT DETAILS </u></b></h2> <form method=\"post\" action=\"deletedata.php\"><br/><br/><br/> Select Roll Number: <select name=\"selection\">"; while($rec=mysql_fetch_array($data)) { echo "<option>".$rec['Rollnum']."</option>"; } echo "</select> <input type=\"submit\" value=\"Delete\" /> </form> </center>"; mysql_close($con); // Closing connection ?> </body> </html>
// deletedata.php
<html > <head> <title>PHP EXAMPLE 9 : Database with Form - Deletion</title> </head> <body> <?php echo "<br/>PHP Example 9"; echo"<br/>"; // line break echo"<h1>"; echo"Delete Data From DATABASE"; echo"</h1>"; echo"<br/>"; //echo $_POST['selection']; echo"<br>CONNECTING..."; $con = mysql_connect("localhost","root",""); // Connecting to the database if(!$con) die('Connection Failed'.mysql_error()); echo"<br>CONNECTED..."; if(!mysql_select_db("DB1",$con)) { if(mysql_query("CREATE DATABASE DB1",$con)) // Creating database echo"<br><br>DB1 Created..."; else echo 'Error Occured...'.mysql_error(); mysql_select_db("DB1",$con); // Creating tables mysql_query(" CREATE TABLE Students( Rollnum int NOT NULL, Name varchar(20), Mark int, PRIMARY KEY(Rollnum) )",$con); } $deleteqry="SELECT * FROM Students where Rollnum =". $_POST['selection']; $data1= mysql_query($deleteqry,$con); // Retreiving data //echo $data1; if($rec=mysql_fetch_array($data1)) echo "<br/>Deleting...<br/>".$rec['Rollnum']." ".$rec['Name']." ".$rec['Mark']."<br/>"; else die( "<br/> Error in database access...".mysql_errno()); $deleterec = "DELETE FROM Students WHERE Rollnum=".$_POST['selection']; if(!mysql_query($deleterec,$con)) die( "<br/> Error in deletion...".mysql_errno()); echo"<br><br>Record Deleted...<br/> Updated Table..."; $data= mysql_query(" SELECT * FROM Students ",$con); // Retreiving data echo "<table border='2'> <tr> <th> Roll No</th> <th> Name</th> <th> Mark </th> </tr>"; while($rec=mysql_fetch_array($data)) { echo "<tr><td>".$rec['Rollnum']."</td><td>".$rec['Name']."</td><td>".$rec['Mark']."</td></tr>"; } echo"</table>"; // mysql_query(" DROP DB1 ",$con); mysql_close($con); // Closing connection echo "<br/><br/><br/><br/><b>"; echo"WWW.2K8618.BLOGSPOT.COM"; echo"</b>"; ?> </body> </html>
Output:
I accept there are numerous more pleasurable open doors ahead for people that took a gander at your site.
ReplyDeletesafety course in chennai
Great post.
ReplyDeletehttps://forums.factorio.com/memberlist.php?mode=viewprofile&u=95749
Great post.
ReplyDeletehttps://hypothes.is/users/KendallEmmerich
Great post.
ReplyDeletehttps://community.hodinkee.com/members/RobertStanfield
Become a Data Science expert with us. study Data Science Course in Hyderabad with Innomatics where you get a great experience and better knowledge.
ReplyDeleteElevate your expertise with our Course in South Delhi, where you'll tackle challenges in programming, web development, and database management.
ReplyDelete