Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sekar
please find the updated script for insert , delete ,update
1.form.php
2.formaction.php
3.edit.php
4.delete.php
5.update.php
6.updateaction.php
1.form.php
<html>
<head>
<title>Phone directory</title>
</head>
<body>
<form name="frm" method="post" action="formaction.php"
enctype="multipart/form-data">
<TABLE border="0" cellpadding="0" cellspacing="0"
width="600" height="500">
<TR>
<TD>SNO :</TD>
<TD><INPUT TYPE="text" NAME="sno"></TD>
</TR>
<TR>
<TD>Name :</TD>
<TD><INPUT TYPE="text" NAME="name"></TD>
</TR>
<TR>
<TD>Password :</TD>
<TD><INPUT TYPE="password" NAME="pwd"></TD>
</TR>
<TR>
<TD>Message :</TD>
<TD><textarea name="msg" rows="5"
cols="20"></textarea></TD>
</TR>
<TR>
<TD>Sex :</TD>
<TD>Male<INPUT TYPE="radio" NAME="sex"
value="male">Female<INPUT TYPE="radio" NAME="sex"
value="female"></TD>
</TR>
<TR>
<TD>Plan :</TD>
<TD>fplan<INPUT TYPE="checkbox" NAME="plan[]"
value="fplan">cplan<INPUT TYPE="checkbox" NAME="plan[]"
value="cplan">dplan<INPUT TYPE="checkbox" NAME="plan[]"
value="dplan">eplan<INPUT TYPE="checkbox" NAME="plan[]"
value="eplan"></TD>
</TR>
<TR>
<TD>Place :</TD>
<TD><select name="place"><option
value="chennai">chennai</option><option
value="pune">pune</option><option
value="banglore">banglore</option></select></TD>
</TR>
<TR>
<TD>Upload :</TD>
<TD><input type="file" name="upload"
value="upload"></TD>
</TR>
<TR>
<TD><INPUT TYPE="submit" name="submit"
value="submit"></TD>
<TD><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);
$sno = $_POST['sno'];
$name = $_POST['name'];
$pwd = $_POST['pwd'];
$msg = $_POST['msg'];
$sex = $_POST['sex'];
//Check box query
echo $place = $_POST['place'];
$plan = $_POST['plan'];
foreach($plan as $p)
{
$plans.=$p;
echo $p;
}
//file upload query
$upload = $_POST['upload'];
if($_FILES['upload']['error']>0)
{
echo "error";
}
else
{
$target = "images/";
$img = $_FILES['upload']['name'];
$target = $target.$img;
if(move_uploaded_file($_FILES['upload']
['tmp_name'],$target))
{
echo "sucess";
echo "<br>";
echo "<A HREF='form.php'>BACK</A>";
}
else
{
echo "failure";
echo "<br>";
echo "<A HREF='form.php'>BACK</A>";
}
}
$insert = mysql_query("insert into phone_tab(sno, name,
password, message, sex, plan, place, upload) values
('$sno','$name','$pwd','$msg','$sex','$plans','$place','$img
')");
?>
3.edit.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test", $con);
$select = mysql_query("select * from phone_tab");
echo "<table border='1' cellpadding='0'
width='800'>";
while($sresult = mysql_fetch_array($select))
{
$sno = $sresult['sno'];
$name = $sresult['name'];
$pwd = $sresult['password'];
$msg = $sresult['message'];
$sex = $sresult['sex'];
$plans = $sresult['plan'];
$place = $sresult['place'];
$upload = $sresult['upload'];
echo "<tr><td>$sno</td><td>$name</td><td>$pwd</td><t
d>$msg</td><td>$sex</td><td>$plans</td><td>$place</td><td>$u
pload</td><td><A HREF='delete.php?
sno=$sno'>DELETE</A></td><td><A HREF='update.php?
sno=$sno'>UPDATE</A></td></tr>";
}
echo "</table>";
?>
4.delete.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test", $con);
$sno = $_GET['sno'];
$delete = mysql_query("delete from phone_tab where
sno = $sno");
if($delete)
{
echo "deleted";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
else
{
echo "failed";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
?>
5.update.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test", $con);
$sno = $_GET['sno'];
$update = mysql_query("select * from phone_tab
where sno = $sno");
while($uresult = mysql_fetch_array($update))
{
$sno = $uresult['sno'];
$name = $uresult['name'];
$pwd = $uresult['password'];
$msg = $uresult['message'];
$sex = $uresult['sex'];
$plans = $uresult['plan'];
$place = $uresult['place'];
$upload = $uresult['upload'];
echo "<form name='frm' method='post'
action='updateaction.php' enctype='multipart/form-
data'><table border='1' cellpadding='0'
cellspacing='0'><tr><td><INPUT TYPE='text' NAME='sno'
value='$sno'></td><td><INPUT TYPE='text' NAME='name'
value='$name'></td><td><INPUT TYPE='text' NAME='pwd'
value='$pwd'></td><td><INPUT TYPE='text' NAME='msg'
value='$msg'></td><td><INPUT TYPE='text' NAME='sex'
value='$sex'></td><td><INPUT TYPE='text' NAME='plans'
value='$plans'></td><td><INPUT TYPE='text' NAME='place'
value='$place'></td><td><INPUT TYPE='text' NAME='upload'
value='$upload'></td><td><A HREF='delete.php?
sno=$sno'>DELETE</A></td><td><INPUT TYPE='submit'
value='update'></td></tr></table></form>";
}
if($update)
{
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
else
{
echo "failed";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
?>
6.updateaction.php
<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test", $con);
$sno = $_REQUEST['sno'];
$name = $_REQUEST['name'];
$pwd = $_REQUEST['pwd'];
$msg = $_REQUEST['msg'];
$sex = $_REQUEST['sex'];
$plans = $_REQUEST['plans'];
$place = $_REQUEST['place'];
$upload = $_REQUEST['upload'];
$uaction = mysql_query("update phone_tab set name
= '$name', password = '$pwd' where sno = $sno");
if($uaction)
{
echo "updated";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
else
{
echo "failed";
echo "<br>";
echo "<A HREF='edit.php'>back</A>";
}
?>
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How to create an empty array in php?
What is the main difference between require() and include()?
Is php the same as html?
How can we make a constant in php?
Tell me what does the scope of variables means?
What is var_dump?
Explain what does $_files means?
When viewing an html page in a browser, the browser often keeps this page in its cache. What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?
What is list function with their uses.
What is phpsessid?
What is a string in php?
How do you trim spaces in excel?
What is php rest api?
What is the use of array_count_values() in php?
How to create a public static method in PHP?
