check box row delete need help

[adamsu]

<?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"> </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.

 

[attachment deleted by admin]

[dougjohnson]

Access denied usually means the Mysql user doesn't exist OR the password you are using is invalid OR the user does not have rights to do what you are asking.  Check user Mysql access rights.

[rondog]

the username and password you are using to connect to your mysql server are incorrect

[Pikachu2000]

mysql_connect and mysql_select_db must come before you execute the first query.

[adamsu]

mysql_connect and mysql_select_db must come before you execute the first query.

I took username and password out.

[adamsu]

yes! it works! thanks to pikachu2000

 

theres one problem though, it says....

Warning: Invalid argument supplied for foreach() in /home/sumersadl/public_html/testfile/delete_multiple.php on line 17

 

Warning: implode() [function.implode]: Invalid arguments passed in /home/sumersadl/public_html/testfile/delete_multiple.php on line 21

Query failed: "DELETE FROM test_mysql WHERE id IN ()"

 

at the top but it does delete, but it cant say that stuff above

 

thanks again!

[Pikachu2000]

You have no logic in place to check if the form has actually been submitted before allowing the script to try to process the data . . .