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 do you display the output directly to the browser?
What are php parameters?
What is putenv?
How to get a total number of rows available in the table?
What is faster?
Can php variables have numbers?
What is the difference between md5(), crc32() and sha1() crypto on php?
Code to upload a file in PHP?
How to create an array from php string?
How to access a specific character in a string?
What is the difference between abstract class and interface in php?
What is Mcrypt used for?
Explain include(), include_once, require() and require_once?
What are the three parts of an http request?
What does the arrow mean in php?
