inserting checkbox values in mysql +PHP - Page 3

[asadalim1]

What error exactly ?

here are the errors,
Warning: Invalid argument supplied for foreach() in C:\wamp\www\dynamic\edit.php on line 16

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\dynamic\edit.php on line 25

<form id="form1" name="form1" method="post" action="edit.php">
   
   team: <input type="text" name="team" /><br />
    <br>
        <?php
    $sql = 'SELECT * From team';
    $con = mysql_connect("localhost","root","talk21") or die;
    $result = mysql_db_query(lastr, $sql); 
       while ($rec = mysql_fetch_array($result)) 
    {
       print "\n<input type='checkbox'  name=team[]' value='".$rec['id']."'checked> ".$rec['team']." </input>"; 
 }
 if(isset($_POST['submit'])){
  $q="delete from team"; //delete all the teams
  mysql_query($q);
  foreach($_POST['team'] as $value){
    $q="insert into team (team) values ('$value')";
mysql_query($q); //so by the end, the table will have records which were checked and all the records which were unchecked will be removed.
 }
}
//I list these teams in my form. 
$q="select id,team from table";
$res=mysql_query($q);
echo "<form method='post' action='check.php'>";
while($row=mysql_fetch_array($res)){
  echo "<input type='checkbox' name='team[]' value='$id' checked>".$team."<br />"; //this will list all the teams in the database
}
echo "<input type='submit' name='submit' value='submit'>";
echo "</form>";

[nav33n]

1st error means, the value passed to foreach is not an array. Check if you are passing array to foreach loop.
2nd error means, the query is returning empty result.

[asadalim1]

1st error, i think something is missing from the foreach loop,

2nd error, the table team is populated? so it must be something else

[nav33n]

As I said, foreach will give this error if you aren't giving an array as input. And there are so many queries. Check out what's on line 25. That query isn't working.

[asadalim1]

As I said, foreach will give this error if you aren't giving an array as input. And there are so many queries. Check out what's on line 25. That query isn't working.

I dnt understand team[] is an array on line 11,
foreach($_POST as $value){ // this is an aray .

Also line 25 i dnt understand there is no syntax error and the table has records.

[nav33n]

print the values of team before foreach.
print_r($_POST); If its an array, it ll print the whole array. else it ll print only 1 value.

[asadalim1]

print the values of team before foreach.
print_r($_POST); If its an array, it ll print the whole array. else it ll print only 1 value.

I have simplified the coding to just delete the selected checkbox.

the flow is to check if checkbox is checked and Delete when submit button is click.

1. if(!isset($_POST)){ // see if checkbox is checked

2. foreach($_POST as $value){ // loop trough the checkboxes

3. $sql = "DELETE FROM team WHERE id={$_POST}"; //delete selected teams

<form id="form1" name="form1" method="post" action="edit.php">

        <?php
    $sql = 'SELECT * From team';
    $con = mysql_connect("localhost","root","talk21") or die;
    $result = mysql_db_query(lastr, $sql); 
       while ($rec = mysql_fetch_array($result)) 
    {
      print "\n<input type='checkbox' name=team[]' value='".$rec['id']."' > ".$rec['team']." </input>";     
}
  if(!isset($_POST['team'])){
 }
  foreach($_POST['team'] as $value){
  }
if(isset($_POST['submit'])){
}
  $sql = "DELETE FROM team WHERE id={$_POST['team']}"; //delete selected teams
  mysql_query($q);
  
   echo "<input type='submit' name='submit' value='submit'>";   
?>

There are no errors in the code above, however it doesn’t do anything.:(