PHP - Check Database And Delete

Hi,   I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?   Thank you.

Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="databasename"; // Database name
$tbl_name="test_mysql"; // Table name

foreach($_POST['checkbox'] AS $ID) {
      $values[] = '\''.intval($ID).'\'';
    }

    $values = implode(', ',$values);

    $myQuery = "DELETE FROM $tbl_name WHERE id IN ($values)"; 
    
    if(mysql_query($myQuery)) {
      header('Location: delete_multiple.php');
    } else {
      echo 'Query failed: "'.$myQuery.'"';
    }

// 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=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?php
// Check if delete button active, start this // edited


if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

alright so i was wondering if someone could make this work for you? then once its fixed you could post the code (by the way this is the third time, ive needed help with this same file its's only onefile so yeah, its supposed to pull out everything that was in the data base like the picture.


Warning: mysql_query() [function.mysql-query]: Access denied for user 'root'@'localhost' (using password: NO) in /home/sumersadl/public_html/testfile/delete_multiple.php on line 16

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/sumersadl/public_html/testfile/delete_multiple.php on line 16
Query failed: "DELETE FROM test_mysql WHERE id IN ('1', '5', '4', '2', '3')"
are error codes im getting when i check all the boxes and click delete

ive been working on this for a while and i was just wondering because i need it fixed by june 13th
so thank you very much if you fix this and get it working correctly !

The picture below is what it pulls that information


and picture 3 is what it looks like when it pulls the information


picture 4.png is what i use to put more info in there

thanks again.

Can I use php to delete multiple rows that have a checkbox selected. I'm not sure how to go about doing this.  Any  suggestions? 

[/b]Hi people I'm having problem with inplementing a check box delete form in the jquery directory tree ....Realy I need help with this ! I am using
the php code below....


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
            <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
            <head>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
            <title>jQuery Drop Down Menu</title>
            
            <!-- CSS For The Menu -->
            <link rel="stylesheet" href="stylee.css" />
            
            </head>
            <body>
            
            <!-- Menu Start -->
            <div id="jQ-menu">
            
            <?php
            error_reporting(0);
               $path = "store/".$diro."/";
            
               function createDir($path = '.')
               {   
                  if ($handle = opendir($path))
                  {
                     echo "<ul>";
                  
                     while (false !== ($file = readdir($handle)))
                     {
                        if (is_dir($path.$file) && $file != '.' && $file !='..')
                           printSubDir($file, $path, $queue);
                        else if ($file != '.' && $file !='..')
                           $queue[] = $file;
                     }
                     
                     printQueue($queue, $path);
                     echo "</ul>";
                  }
               }
               
               function printQueue($queue, $path)
               {
                  foreach ($queue as $file)
                  {
                     printFile($file, $path);
                  }
               }
               echo"<form action='osnovni_dokumenti.php?id=" . $data['ideo']. "' method='POST'>";
               function printFile($file, $path)
               {
                  
                  echo "<li><input type='checkbox' name='del[]' value='$file'/><a href=\"".$path.$file."\"><img src='slike_izgled/file.png'> $file</a></li>";
                              
               }
               
               function printSubDir($dir, $path)
               {
                  echo "<li><img src='slike_izgled/directory.png' width='20' height='20'> <span class=\"toggle\">$dir</span>";
                  createDir($path.$dir."/");
                  echo "</li>";
               }
               
               createDir($path);
               echo"<p align='center'><input type='submit' name='filedel' value='Delete'></p>
               </form>";
               
               
               
               
         
                     
            ?>
            
            </div>
            <!-- End Menu -->
            
            
            <!-- Add jQuery From the Google AJAX Libraries -->
            <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"></script>
            
            <!-- jQuery Color Plugin -->
            <script type="text/javascript" src="jquery.color.js"></script>
            
            <!-- Import The jQuery Script -->
            <script type="text/javascript" src="jMenu.js"></script>
            
            </body>
            </html>
if(isset($_POST['filedel'])) {
            
            
                                    
                              $id = $_POST[del];
                              $count = count($id);
                              
                              
                              
                              for ($i=0; $i<$count; $i++){                     
                                                      
                              
                              $files = $_POST['del'];      
                     
                                          
                              echo"$files.$count";
                           }
         
         
         
                        
   
         
            
            }
         

Hi guys,

I am recent working on my php to delete the information in a database. When I insert the value in the url bar something is like: www.mysite.com/delete.php?myfavorites=what ever it is&user=test. When I inserted the value in the url bar, it did not search for the value in a database to delete it while match with the username in the url bar.


Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbname');


$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $favorites = clean($_GET['favorites']);
    $username = clean($_GET['user']);


if($favorites == '' && $username == '') {
   // both are empty
   $errmsg_arr[] = 'Favorites are missing.';
   $errflag = true;

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {

$insert = array();
if(isset($_GET['favorites'])) {
    $insert[] = 'favorites = \'' . clean($_GET['favorites']) . '\'';
}
if(isset($_GET['username'])) {
    $insert[] = 'username = \'' . clean($_GET['username']) . '\'';
}


if (count($insert)>0) {
   $names = implode(',',$insert);


if($favorites && $username) {

mysql_query("DELETE valuedata FROM favorites WHERE username='$username'");
$deleted = mysql_affected_rows();
if($deleted > 0) {
    echo("The value in favorites are deleted");
    } else {
        echo("failed");
    }
    }else{
   echo("failed");
   }
 }
}
mysql_close($link);
?>

If you know how to delete the value in a database for each row while it match with the username in the url, please say so as i would like to know how to do it.

Any advise would be much appreciated.

Thanks,
Mark