update-delete-multiple-row

<?php

//connect to Database
$host = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "update-multiple-rows";

$con = mysqli_connect($host, $db_user, $db_pass, $db_name);
if(mysqli_connect_errno()){
    echo "Failed to connect to MySql!". mysqli_connect_error();
    }

$sql1 = "SELECT * FROM test_mysql";
$result = mysqli_query($con, $sql1);

?>

<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">

<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>

<?php
while ($rows=mysqli_fetch_assoc($result)){ ?>
    <tr>
    <td align="center">
    <?php $id[]=$rows['id']; ?><?php echo $rows['id']; ?>
    </td>
    <td align="center">
    <input name="name[]" type="text" id="name" value="<?=$rows['name']; ?>">
    </td>
    <td align="center">
    <input name="lastname[]" type="text" id="lastname" value="<?=$rows['lastname']; ?>">
    </td>
    <td align="center">
    <input name="email[]" type="text" id="email" value="<?=$rows['email']; ?>">
    </td>
    </tr>
<?php } ?>

<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</table>

<?php

if ($_SERVER["REQUEST_METHOD"] == "POST" && $_POST["Submit"] != ""){
    $count = mysqli_num_rows($result);
    $error = '';
    for($i=0;$i<$count;$i++){
        //echo "passed !";
        $sql2="UPDATE $test_mysql SET name='".$_POST["name"][$i]."', lastname='".$_POST["lastname"][$i]."', email='".$_POST["email"][$i]."' WHERE id=$i";
        //$_POST["name"][$i]."',lastname='".$_POST["lastname"][$i]."', email='".$_POST["email"][$i]."' WHERE id='$id[$i]'";
        //echo "passed 2!";
        // echo sql2;
        // echo "passed 3!";
        $result1=mysqli_query($con, $sql2);
        if(mysqli_query($con, $sql2) === FALSE){
            $error .= 'SQL query failed, SQL: '.$sql2.', Error: '.mysqli_error() . "\n";
        }
    }
    //mysqli_close($con);
    if(!$error){
        header("Location: update-multiple-2.php");
    }else{
        echo $error;
        exit();
    }
}





 ?>