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
Is server side a session?
What is difference between php and html?
What is a php 5?
Which function is used in php to delete a file?
What are major variables in research?
How is it possible to know the number of rows returned in result set?
How we can declare variable in php?
What is php programming used for?
How to reset/destroy a cookie in php?
What are the different types of statements that are present in php?
What does $_env means?
What’s the difference between htmlentities() and htmlspecialchars()?
Why php is used with mysql?
Is php free to use?
Where php language is used?
