Question

How to insert MySQL multiple rows in a form using input type text and update all the rows in PHP

Answer 1

/* index.php */

$db_host        = 'localhost';
$db_user        = 'user';
$db_password    = 'password';
$db_name        = 'db_name';
 
$mysqli = new mysqli($db_host, $db_user, $db_password , $db_name);

$sql = "SELECT query, query_id FROM query_table WHERE user_id = ?";
    
$sql_query = $mysqli->prepare($sql);
$sql_query->bind_param('s', $user_id);
$sql_query->execute();

$sql_query->bind_result($query, $query_id);
$sql_query->store_result();

?>
<form action="update.php" method="post">
<?php
while ($sql_query->fetch())
{
?>
    <input type="text" name="query[]" value="<?php echo $query; ?>"><br />
<?php
}
?>
<button type="submit">Update</button>                                            
</form>

<?php
$sql_query->close();
$mysqli->close(); 
?>

/* update.php */

$db_host        = 'localhost';
$db_user        = 'user';
$db_password    = 'password';
$db_name        = 'db_name';
 
$mysqli = new mysqli($db_host, $db_user, $db_password , $db_name);
    
for ($i = 0; $i < count($_POST['query']); $i++)
{
    if ($sql_query = $mysqli->prepare("UPDATE query_table SET query = ? WHERE query_id = ?"))
    {
        $sql_query->bind_param('ss', $_POST['query'][$i], $_POST['query-id'][$i]);
        $sql_query->execute();
    } 
}
$sql_query->close();
$mysqli->close(); 

 

Cleaner teeth, healthier you!
Get The Secret to a Bright and Healthy Smile