Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sekar
here am creating 6 script
1.form.php
2.formaction.php
3.edit.php
4.delete.php
5.update.php
6.updateaction.php
1.form.php
<html>
<head>
<title>EMP Details</title>
</head>
<body>
<FORM METHOD=POST ACTION="formaction.php"
enctype="multipart/form-data">
<TABLE border="0" cellpadding="0" cellspacing="0"
width="500">
<TR>
<TD>Name :</TD>
<TD><INPUT TYPE="text" NAME="name"></TD>
</TR>
<TR>
<TD>Age :</TD>
<TD><INPUT TYPE="text" NAME="age"></TD>
</TR>
<TR>
<TD>Salary :</TD>
<TD><INPUT TYPE="text" NAME="salary"></TD>
</TR>
<TR>
<TD colspan=""2><INPUT TYPE="submit"
value="submit" name="submit"> <A
HREF="edit.php">EDIT</A></TD>
</TR>
</TABLE>
</FORM>
</body>
</html>
2.formaction.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
$name = $_POST['name'];
$age = $_POST['age'];
$salary = $_POST['salary'];
$insert = mysql_query("insert into emp_tab
(name,age,salary) values ('$name','$age',$salary)");
if($insert)
{
echo "sucess";
echo "<br>";
echo "<A HREF='form.php'>back</A>";
}
else
{
echo "fail";
echo "<br>";
echo "<A HREF='form.php'>back</A>";
}
?>
3.edit.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
$select = mysql_query("select * from emp_tab");
echo "<table border='0' cellpadding='0'
cellspacing='0' width='500'>";
while($sresult = mysql_fetch_array($select))
{
$id = $sresult['id'];
$name = $sresult['name'];
$age = $sresult['age'];
$salary = $sresult['salary'];
echo "<tr><td>$name</td><td>$age</td><td>$salary</td
><td><A HREF='delete.php?name=$name'>DELETE</A></td><td><A
HREF='update.php'>UPDATE</A></td></tr>";
}
echo "</table>";
?>
4.delete.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
$name = $_GET['name'];
$delete = mysql_query("delete from emp_tab where
name = '$name'");
if($delete)
{
echo "sucess";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
else
{
echo "fail";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
?>
5.update.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
$update = mysql_query("select * from emp_tab");
echo "<table border='0' width='600'>";
while($uresult = mysql_fetch_array($update))
{
$id = $uresult['id'];
$name = $uresult['name'];
$age = $uresult['age'];
$salary = $uresult['salary'];
echo "<tr><td><INPUT TYPE='text' NAME=''
value='$name'></td><td><INPUT TYPE='text' NAME=''
value='$age'></td><td><INPUT TYPE='text' NAME=''
value='$salary'></td><td><A HREF='delete.php?
name=$name'>DELETE</A></td><td><A HREF='updateaction.php?
name=$name'>UPDATE</A></td></tr>";
}
echo "</table>";
?>
6.updateaction.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
$name = $_REQUEST['name'];
$age = $_REQUEST['age'];
$salary = $_REQUEST['salary'];
echo $uaction = mysql_query("UPDATE emp_tab SET age
= '$age',salary = '$salary' where name = '$name'");
if($uaction)
{
echo "sucess";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
else
{
echo "fail";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
?>
| Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
Why php is used with mysql?
How can you create a session in php?
What is the meaning of symbol '$' in jquery?
How do you check is php not empty?
Explain about getters and setters in php?
Php code to find whether a number armstrong or not?
Describe session in php.
What is inheritance in php with example?
Explain how does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?
What are the differences between php constants and variables?
What is the difference between php 5 and php 7?
Why do we show php code in browser?
How can we display information of a variable and readable by human with php?
What is the difference between php and java?
What is the goto statement useful for?
