0

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 ?

Paul T.
  • 4,015
  • 11
  • 22
  • 27

0 Answers0