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
Explain Type juggling?
What is string and its function?
What is php and why it is used?
How to check a variable is an array or not in php?
What is an operator in php?
What is abstraction php?
Describe which programming language does php parallel to?
How can we execute a php script using command line?
How does php server work?
When are you supposed to use endif to end the conditional statement?
What are php magic quotes?
What is the use of mysql_fetch_array in php?
How can I convert ereg expressions to preg in php?
How to create a session? How to set a value in session?
How many keywords are there in php?
