Is there an easy way to update this data in database table
we have 2 table
1- lang 2- setting
$Show_setting=mysqli_query($db,"select * from lang inner join site_setting on lang.lang_code = site_setting.lang order by site_setting.id asc");
i have this form
<form method="post">
<?php
while($rowSetting=mysqli_fetch_object($Show_setting))
{?>
<input type="text"name="site_name['<?php echo $rowSetting->id ;?>']" value="<?php echo $rowSetting->site_name ;?>">
<input type="text" name="key_words['<?php echo $rowSetting->id ;?>']" value="<?php echo $rowSetting->key_words ;?>">
<input type="checkbox" value="1"name="lock_site['<?php echo $rowSetting->id ;?>']">
<textarea name="close_reason['<?php echo $rowSetting->id ;?>']">
<?php echo $rowSetting->message ;?>
</textarea>
<input type="text" name="num_topic_day['<?php echo $rowSetting->id ;?>']" value="<?php echo $rowSetting->num_topic_day ;?>">
<textarea name="msg_stop_topic['<?php echo $rowSetting->id ;?>']" >
<?php echo $rowSetting->msg_stop_topic;?>
</textarea>
<input type="hidden" name="id[<?php echo $rowSetting->id ;?>]" value="<?php echo $rowSetting->id ;?>">
<?php } ?>
<button type="submit" name="do" value="savethepage">
</form>
after i send the form and print the $_POST
this is the result
Array
(
[site_name] => Array
(
['1'] => site title 1 language
['2'] => site title 2 language
['3'] => site title 3 language
['4'] => site title 4 language
['5'] => site title 5 language
['6'] => site title 6 language
['7'] => site title 7 language
['8'] => site title 8 language
['9'] => site title 9 language
['12'] => site title 12 language
['13'] => site title 13 language
)
[key_words] => Array
(
['1'] => key word 1
['2'] => key word 2
['3'] => key word 3
['4'] => key word 4
['5'] => key word 5
['6'] => key word 6
['7'] => key word 7
['8'] => key word 8
['9'] => key word 9
['12'] => key word 12
['13'] => key word 13
)
[close_reason] => Array
(
['1'] => message 1
['2'] => message 2
['3'] => message 3
['4'] => message 4
['5'] => message 5
['6'] => message 6
['7'] => message 7
['8'] => message 8
['9'] => message 9
['12'] => message 12
['13'] => message 13
)
[num_topic_day] => Array
(
['1'] => 0
['2'] => 0
['3'] => 0
['4'] => 0
['5'] => 0
['6'] => 0
['7'] => 0
['8'] => 0
['9'] => 0
['12'] => 1
['13'] => 1
)
[msg_stop_topic] => Array
(
['1'] =>
['2'] =>
['3'] =>
['4'] =>
['5'] =>
['6'] =>
['7'] =>
['8'] =>
['9'] =>
['12'] =>
['13'] =>
)
[id] => Array
(
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[12] => 12
[13] => 13
)
[do] => SaveSetting
)
how i update the database table with this data
i try to much i faild
i want update the data like that
update record number 1 with id 1 and msg_stop_topic 1 value and key_words 1 value and site_title 1 value
update record number 1 with id 2 and msg_stop_topic 2 value and key_words 2 value and site_title 2 value
any help ?