php POST表单查询更新动态变量 [英] php POST form query update dynamic variable

问题描述

我有这个表格

<form method="post" action="process.php">
    Name: <input type="text" name="name" value="">
    <br />
    English: <input type="text" name="english" value="">
    <br />
    French: <input type="text" name="french" value="">
    <br />
    <input type="submit" name="submit" value="Submit">  
</form>

我们在process.php上进行此查询

and we make this query on process.php

$query = "
        UPDATE
        `translations_structure`
        SET
        `updated_on` = '".time()."',
        `english` = '".utf8_encode($english)."',
        `french` = '".utf8_encode($french)."'
        WHERE
        `id` = '".$id."'";

如果我编辑表格语言并添加更多语言，则表格将动态修改为可以说这个例子

and if i edit the table languages and add more languages the form dynamically will modify to lets say this example

<form method="post" action="process.php">
    Name: <input type="text" name="name" value="">
    <br />
    English: <input type="text" name="english" value="">
    <br />
    French: <input type="text" name="french" value="">
    <br />
    Spanish: <input type="text" name="spanish" value="">
    <br />
    German: <input type="text" name="german" value="">
    <br />
    <input type="submit" name="submit" value="Submit">  
</form>

以及我需要动态修改的查询

and the query i need to dynamically be edited

$query = "
        UPDATE
        `translations_structure`
        SET
        `updated_on` = '".time()."',
        `english` = '".utf8_encode($english)."',
        `french` = '".utf8_encode($french)."',
        `spanish` = '".utf8_encode($spanish)."',
        `german` = '".utf8_encode($german)."'
        WHERE
        `id` = '".$id."'";

我不了解的是我如何在查询代码中动态地做到这一点

*表单字段的名称与变量i POST
的名称相同*并且表中列的名称与POST

what i don't understand is how i make this dynamically inside the query the code

*the name of the form field is the same of the name of the variable i POST
*and the name of the column from the table is the same of the name of the POST

    `english` = '".utf8_encode($english)."',
    `french` = '".utf8_encode($french)."',
    `spanish` = '".utf8_encode($spanish)."',
    `german` = '".utf8_encode($german)."',
    `other_language` = '".utf8_encode($other_language)."',
    `other_language2` = '".utf8_encode($other_language2)."'

在上面，我已经解释了如何进行查询，但是我不明白如何编写变量

here above i have explained how i make the query but i cant understand how to write the variables

我知道我需要些困难，但也许有人知道我需要什么

I know is a little bit difficult what i need but maybe someone understand what i need

谢谢你

thank you

我将首先解释我想做什么:

我有一个名为翻译"的表格，我在哪里存储语言.例如:英语，法语，西班牙语等.
我使用一种表格来更新新值，问题是我想动态地执行此操作，而不是手动在每个php文件上插入此查询，因为语言表会增长或编辑，并且我想动态地工作而不是编辑每个php文件.
变量名称与数据库中的字段名称相同我设法为表格翻译中的名称创建一个数组

I will explain first what i want to do:

I have a table called "translations" where i store the languages. ex: english, french, spanish, etc.
I use a form to update the new values, the problem is that i want to do it dynamically not to insert this query on every php file manually because the languages table will grow or edit and i want to work dynamically not to edit every php file.
the variable names are the same like fields name in database i manage to make an array for the names on table translations

这是我到目前为止要使它具有动态性的功能问题是我不知道如何在查询$ _POST ['english']，$ _ POST ['french']等中插入变量

this is what i have until now to make it dynamic the problem is i don't know how to insert variables in the query $_POST['english'], $_POST['french'], etc

$db = new DB();
$query = $db->query("SELECT * FROM `translations_languages` ORDER BY `name` ASC");
while($row = $query->fetch_assoc()){
    $values[] = "`{$row['name']}` = '{$row['name']}'";
}

    $dynamic_result = "".strtolower(implode(",", $values))."";
    $query = "
    UPDATE
    `translations_structure`
    SET
    `updated_on` = '".time()."',
    $dynamic_result
    WHERE
    `id` = '".$id."'
    ";

echo "$query";

这就是查询的正常显示方式

and this is how the query looks normally

$query = "
            UPDATE
            `translations_structure`
            SET
            `updated_on` = '".time()."',
            `english` = '".utf8_encode($english)."',
            `french` = '".utf8_encode($french)."',
            `spanish` = '".utf8_encode($spanish)."'
            WHERE
            `id` = '".$id."'";

我想将这些值添加到查询中

i want to add these values to the query

`english` = '".utf8_encode($english)."',
`french` = '".utf8_encode($french)."',
`spanish` = '".utf8_encode($spanish)."'

推荐答案

您只需要创建一个动态更新数组.像这样:

you just need to create a dynamic update array. Something like this:

$languagesToUpdate = array();

// this is an example, you should modify as your script:

// create a variable/constant to make sure you update only allowed fields
$allowedLanguages = array('english' => true, 'french' => true, 'spanish' => true, 'german' => true, 'other_language' => true);

// iterate threw post and check for allowed languages and add to languagesToUpdate the language we need to update with it's value
foreach ($_POST as $post => $value) {
    if (isset($allowedLanguages[$post]) && $allowedLanguages[$post]) {
        $languagesToUpdate[] = '`' . $post . '` = "' . utf8_encode($value) . '"';
    }
}

// add additional data like updated_on
$languagesToUpdate[] = '`updated_on` = ' . time() . '';

//update database
$db = 'UPDATE `translations_structure` SET '.implode(', ', $languagesToUpdate).' WHERE `id` = '.(int)$id;

// this will produce something like this:
// UPDATE `translations_structure` SET `english` = "English text", `spanish` = "Spanish text", `updated_on` = 1479720637 WHERE `id` = 1

这篇关于php POST表单查询更新动态变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！