如何更新不同列中的某些值？

Question

I have a table called settings in mysql database, it looks like this:

How do I update these values without having a query for each setting?

Code:

<?php

function getSetting($name) {
     global $mysqli;

     $result = $mysqli->query("SELECT * FROM settings WHERE name='{$name}'");

     while ($row = $result->fetch_assoc()) {
          echo $row['value'];
     }
}

?>

<form name ="settings" method ="post" action="" id="form">

<h2>Settings</h2><br>    

Site Title: <input name="sitetitle" value="<?php getSetting('sitetitle'); ?>" type="text" class="forminput" /><br><br>
Date Format: <input name="dateformat" value="<?php getSetting('dateformat'); ?>" type="text" class="forminput" /><br><br>
Time Format: <input name="timeformat" value="<?php getSetting('timeformat'); ?>" type="text" class="forminput" /><br>

<br>

<input type="submit" name ='submit' value="Save Changes">

</form>

Answer 1

Create a stored procedure which takes the 3 values as arguments and runs the updates internally. Then your submit can simply call the procedure (1 query)