how to insert, update data in database
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 |
Why do we use interface in php?
How can we upload a file in php?
Whether site will complete the execution of the script if Fatal error occurs ?
Is not null in php?
What is new keyword in php?
What is the use of pear in php?
hi sir am kiran kumar finished my mca 2009 passed out sir .. i have more doubts regarding open source technologies sir if we pass zend exam in php can we get a job opportunity in foreign countries sir and is it good demand for php compared to dot net and java and some other technologies like sap , erp sir bcoz my friends saying they are finished dot net and java courses they telling in php we cannot earn more and we cannot go onsite opportunity even big companies not dealing with php is it right ah sir ? please send ur valuable suggestions to my email sir kiranpulsar2007@gmail.com please send ur phone number also sir thanking u sir
Can you extend a final defined class?
What is use of count() function in php?
Why do we need session?
What are the environmental variables?
Which is the best web server?