Total members 11778 |It is currently Wed Jun 19, 2019 8:55 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





inserting and deleting in php to database example
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.

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




Author:
Newbie
User avatar Posts: 7
Have thanks: 0 time

Your code looks working well ,please post me the errors you are getting , also after you delete records you have this lines of code :
Code:
    if($sql){
        header('Location:delete_multiple2.php');//THIS WAS SAMPLE.PHP - YOU MIGHT WANT TO CHANGE IT BACK
    }


it moves you to different page.


Author:
Mastermind
User avatar Posts: 2707
Have thanks: 74 time
Post new topic Reply to topic  [ 2 posts ] 

  Related Posts  to : inserting and deleting in php
 inserting and deleting using php     -  
 deleting using javascript     -  
 error in inserting record     -  
 Inserting video into the game     -  



Topic Tags

PHP Database






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com