在同一时间插入多个值，如同时插入单个变量和数组变量 - Insert Multiple value in same time Like Single Variable and Also Array Variable at same time

Insert Multiple value in same time Like Single Variable and Also Array Variable at same time

如何使用php在mysql数据库中转义和插入

<input type="text" name="job_name">
<input type="text" name="job_code">
<input type="text" name="roles[]">
<input type="text" name="roles[]">
<input type="text" name="roles[]">
<input type="text" name="return[]">
<input type="text" name="return[]">
<input type="text" name="return[]">
$job_name = $_POST['job_name'];
$job_code = $_POST['job_code'];
$rool_weight = $_POST['rools'];
$return_weight = $_POST['return'];

如何对包括数组和变量在内的所有值进行scape。并在每行和数组上重复插入变量。。

尝试这个

// ESCAPE STRING FUNCTION.
function escape_string($string)
{
    global $connection;
    $escape_string = mysqli_real_escape_string($connection, $string);
    return $escape_string;
}
// ESCAPE ARRAY FUNCTION.
function escape_array($array)
{
    $arr = is_array($array) ? array_map('escape_string', $array) : $array;
    return $arr;
}
$job_name = escape_string($_POST['job_name']);
$job_code = escape_string($_POST['job_code']);
$rool_weight = escape_array($_POST['rools']);
$return_weight = escape_array($_POST['return']);