1 Replies - 37408 Views - Last Post: 16 August 2011 - 08:42 AM Rate Topic: -----

#1 ravi951   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 29
  • Joined: 21-July 11

inserting and deleting records in php

Posted 16 August 2011 - 06:55 AM

hi all,
i have written a code in php for inserting and deleting multiple records using check boxes."test" is the database name. "emp" is the table name
which contains the following records in my database.

empno empname desig
1111 raju pilot
1112 ram chef
1113 ramu doctor
1114 paul engineer
1115 ajay player

now i want to delete one or more records and insert the records in to the above table..
i have written the below code for deleting but the table values are not displaying and i need to delete also using check box.
below is delete_multiple2.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="emp"; // Table name
// Connect to server and select databse.
mysql_connect($host, $username, $password)or die("cannot connect");
mysql_select_db($db_name)or die("cannot select DB");
// Check if delete button active, start this
if(isset($_POST['delete'])){
    if(sizeof($_POST['chkbx'])){
        foreach($_POST['chkbx'] AS $val){
            $sql = mysql_query("DELETE FROM $tbl_name WHERE id=".(int)$val)or die(mysql_error());
        }
    }
    // if successful redirect to delete_multiple.php

    if($sql){
        header('Location:delete_multiple2.php');//THIS WAS SAMPLE.PHP - YOU MIGHT WANT TO CHANGE IT BACK
    }
}
 $sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
 ?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>EmpNo</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>EmpName</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Desig</strong></td>
</tr>
<?php
$x = 0;
while($rows=mysql_fetch_array($result)){
$x++;
?>
    <tr>
        <td align="center" bgcolor="#FFFFFF"><input name="chkbx[]" type="checkbox" id="checkbox_<? echo $x; // you need a unique id per checkbox ?>" value="<? echo $rows['id']; ?>"></td>
        <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
        <td bgcolor="#FFFFFF"><? echo $rows['empno']; ?></td>
        <td bgcolor="#FFFFFF"><? echo $rows['emoname']; ?></td>
        <td bgcolor="#FFFFFF"><? echo $rows['desig']; ?></td>
    </tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>



also i have written for inserting records into database.
but it is not inserting.....
below is insert.php
<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="emp"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

// Count table rows 
$count=mysql_num_rows($result);

<?php
while($rows=mysql_fetch_array($result))
{
?>

<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="y" /></td>
<td align="center"><input name="empno[]" type="text" id="name" value="<? echo $rows['empno'];?>"></td>
<td align="center"><input name="empname[]" type="text" id="empname" value="<? echo $rows['empname'];?>"></td>
<td align="center"><input name="desig[]" type="text" id="desig" value="<? echo $rows['desig'];?>"></td>
</tr>

<?php
}
?>
<input type="submit" name="Submit" value="Submit">

<?php

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

// Check if button name "Submit" is active, do this 
if($checkbox){
for($i=0;$i<$count;$i++)
{
$sql1="INSERT INTO $tbl_name (empno, empname, desig)VALUES('$no[$i]', '$name[$i]', '$desig[$i]')";
$result1=mysql_query($sql1);
}
}


i want to integrate these two things so that it will be easy for inserting
and deleting any no of times..
kindly tell me how to do it....
where is my code went wrong.......

Is This A Good Question/Topic? 0
  • +

Replies To: inserting and deleting records in php

#2 Dormilich   User is offline

  • 痛覚残留
  • member icon

Reputation: 4278
  • View blog
  • Posts: 13,571
  • Joined: 08-June 10

Re: inserting and deleting records in php

Posted 16 August 2011 - 08:42 AM

see here.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1