Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
|
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 16th, 2011, 09:58 AM
Authorized User
 
Join Date: Jul 2011
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default inserting and deleting in php

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
Code:
<?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
Code:
<?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.......





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with inserting, deleting, and updating using the detalis view bivek BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 10 December 1st, 2009 06:10 PM
Inserting data into MS_ACCESS in PHP lakshmi_annayappa PHP Databases 1 June 25th, 2008 03:38 AM
mysql/php inserting into a table mark jonas Beginning PHP 1 February 25th, 2007 05:54 AM
deleting images from a directory using php Adam H-W Beginning PHP 1 June 7th, 2006 08:57 AM
inserting into oracle using php cblake PHP Databases 1 May 26th, 2005 03:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.