PHP program for ADD, DELETE, UPDATE, ShowDatabase
HTML____
Main Page
<body>
<h1>WEL COME TO DATA MANIPULATION PROGRAM</h1>
<h2>Data Modification</h2>
<form action="addrecord.html" method="post">
Add Record: <input type="submit" value="Add Record">
</form>
<form action="ShowData.php" method="post">
Show Data: <input type="submit" value="Show Data">
</form>
<form action="delete.html" method="post">
Delete: <input type="submit" value="Delete">
</form>
<form action="update.html" method="post">
Update: <input type="submit" value="Update">
</form>
</body>
HTML SCRIPT FOR ADDRECORD.HTM
<body>
<form action="ADDRECORD.php" method="post">
id:<input type="text" name="id"/>
First Name:<input type="text" name="firstname"/>
Last Name:<input type="text" name="lastname"/>
Age:<input type="text" name="age"/>
<input type="submit"/>
</form>
</body>
PHP FOR ADDRECORD.PHP
<html>
<?php
$con = mysql_connect("localhost","root","Spider1");
if(!$con)
{
die('Could not connect' . mysql_error());
}
mysql_select_db("db_next",$con);
$sql = "INSERT INTO stu(id, firstName, lastname, age) VALUES('$_POST[id]','$_POST[firstname]','$_POST[lastname]','$_POST[age]')";
if (!mysql_query($sql,$con))
{
die('Error:' . mysql_error());
}
else
echo "1 Record added";
mysql_close($con);
?>
<a href="D:\trial_of_php\formsq2l.html">Back to the Home</a>
</html>
HTML FOR UPDATE.HTM
<body>
<form action="update.php" method="post">
id:<input type="text" name="id3"/>
First Name:<input type="text" name="firstname3"/>
Last Name:<input type="text" name="lastname3"/>
Age:<input type="text" name="age3"/>
<input type="submit"/>
</form>
</body>
UPDATE.PHP
<?php
$con = mysql_connect("localhost","root","Spider1");
if(!$con)
{
die('Could not connect' . mysql_error());
}
mysql_select_db("db_next", $con);
$id = $_POST['id'];
$f_name = $_POST['firstname'];
$l_name = $_POST['lastname'];
$age = $_POST['age'];
$id3 = $_POST['id3'];
$f_name3 = $_POST['firstname3'];
$l_name3 = $_POST['lastname3'];
$age3 = $_POST['age3'];
$id2 = mysql_query("UPDATE stu SET id = '$id3' WHERE id = '$id3'");
$fname = mysql_query("UPDATE stu SET firstname = '$f_name3' WHERE id = '$id3'");
$lname = mysql_query("UPDATE stu SET lastname = '$l_name3' WHERE id = '$id3'");
$age2 = mysql_query("UPDATE stu SET age = '$age3' WHERE id = '$id3'");
if(!mysql_query($id2) && !mysql_query($fname) && !mysql_query($lname) && !mysql_query($age2))
{
echo "Record is Modified";
}
else
echo "Try another time";
mysql_close($con);
?>
<html><body><a href="d:\trial_of_php\formsq2l.html">Back to home</a></body></html>
DELETE RECORD.HTM
<body>
<form action="2delete.php" method="post">
Enter the ID no:<input type="text" name="id"/>
<input type="submit"/>
</form>
</body>
DELETE RECORD.PHP
<?php
$con = mysql_connect("localhost","root","Spider1");
if(!$con)
{
die('Could not connect' . mysql_error());
}
mysql_select_db("db_next", $con);
$next = $_POST['id'];
$result = mysql_query("DELETE FROM stu WHERE id = '$next'");
if(!mysql_query($result,$con))
{
echo "Your selected $next is delete";
echo "";
}
else
echo "SCRIPT CHECK KARO";
mysql_close($con);
?>
<html><body><a href="d:\trial_of_php\DELETE.html">Back to home</a></body></html>
SHOWDATABASE.PHP
<html>
<?php
$con = mysql_connect("localhost","root","Spider1");
if(!$con)
{
die('Could not connect' . mysql_error());
}
mysql_select_db("db_next", $con);
$result = mysql_query("SELECT * FROM stu");
echo "<table border='1'>
<tr>
<th>id</th>
<th>firstname</th>
<th>lastname</th>
<th>age</th>
</tr>";
while ($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
<body>
<form action="formsq2l.html" method="post">
Back to Home page:<input type="submit" value="Back">
</form>
</body>
</html>
