inserting and deleting using php

ravi95111111 · **Posted:** Fri Aug 12, 2011 1:00 pm

hi all,
i have written a script for deleting more than one records using check box.
but it is not working.below is the code ...

Code:

<script>
function fundel(sno)
{
rv=confirm("u want to delete");
if(rv==true)
{
location="delete.php?seno="+sno;
}
}
</script>
<form method="post" action="delrec.php">
<table border='1'>
<?php
mysql_connect("localhost","root","");
mysql_select_db("test");
$data=mysql_query("select * from emp");
while($rec=mysql_fetch_row($data))
{
echo"<tr><td><input type='checkbox' name=$rec[2]'
value='$rec[2]'><td>$rec[0]<td>$rec[1]<td>$rec[2]<td><input type='button' value='delete'
onclick='fundel($rec[2])'>";
}
?>
</table>
<input type='submit' value='delrec'>
</form>

below ids the delrec.php.

Code:

/*<?php
$qs=$_REQUEST['seno'];
mysql_connect("localhost","root","");
mysql_select_db("test");
mysql_query("delete from emp where sno=$qs");
header('location:getrec.php");
?>*/
<script>
function delrec(sno)
{
rv=confirm("u want to delete");
if(rv==true)
{
location="delete.php?seno="+sno;
}
}
</script>

also is the delete.php..

Code:

<?php
$qs=$_REQUEST['seno'];
mysql_connect("localhost","root","");
mysql_select_db("test");
mysql_query("delete from emp where sno=$qs");
header("location:getrec.php");
?>
/*<script>
function delrec(sno)
{
rv=confirm("u want to delete");
if(rv==true)
{
location="delete.php?seno="+sno;
}
}
</script>
*/

also i want to insert values of three fields using php code.
i have written the code.when i click the insert button it should get inserted
into database....
below is the code for insert function..

Code:

<table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td><form name="form1" method="post" action="ins.php">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><strong>Insert Data Into mySQL Database </strong></td>
</tr>
<tr>
<td width="71">Name</td>
<td width="6">:</td>
<td width="301"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td>Lastname</td>
<td>:</td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>

also the ins.php..

Code:

<?php

/*$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="test_mysql"; // Table name*/

// Connect to server and select database.
mysql_connect("localhost", "root", "")or die("cannot connect"); 
mysql_select_db("test")or die("cannot select DB");

// Get values from form 
$empno=$_POST['empno'];
$empname=$_POST['empname'];
$desig=$_POST['desig'];

// Insert data into mysql 
$sql="INSERT INTO emp(empno, empname, desig)VALUES('$empno', '$empname', '$desig')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful". 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='insert.php'>Back to main page</a>";
}

else 
{
echo "ERROR";
}
// close connection 
mysql_close();
?>

i want all these to be integrated into one form so that i can easily insert,delete using php
kindly tell me how to do it....

msi_333 · **Posted:** Fri Aug 12, 2011 5:11 pm

add a hidden parameter with value delete in delete form and with value insert in insert form like this

Code:

and in sql php code do checking on param1 value to do your action ,

inserting and deleting using php

Users browsing similar posts