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
What are php magic methods/functions?
What is the use of ajax in php?
Can we embedded directly PHP code into XHTML document? State Whether True or False?
Explain the types of string comparision function in PHP
Hi this is amul jani here, i complied my graduation in B.com stream.. but as career i looking for PHP language.. to get shape my career. so is that possible to enter in IT world.. for me how much scope of develop my career in this field.. amul jani
What is the most common http method?
How do you identify independent and dependent variables in regression analysis?
What is isset function in php?
Explain mail function in PHP with syntax?
What is the use of explode() function?
What is in a cookie?
What happens if an expected input field was not submitted?
what are interfaces and Abstart classes
Tell me how can we pass the variable through the navigation between the pages?
How to check curl is enabled or not in PHP
