Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert, update data in database
- 4 Answers
- 11641 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vipin gurjar
insert into Table(fieldsname) values(fields value);
update tableName set fieldname='$fieldvalue' condition;
delete from tableName condition;
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / 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 |
How we get browser details of clients machine?
How to calculate the length of a string?
Under what circumstance is it impossible to assign a default value to a parameter while declaring a function?
What is constructors and destructors?
describe arguments in header in php?
Which database is best for php?
Is it possible to use com component in php?
What is the difference between php 5 and php 7?
Difference between get and post method.
Does php support inheritance?
How can I make a script that can be bilanguage (supports English, German)?
What is global variable php?
PHP 
