同时插入多个值如单个变量和同时也是阵列变量

Question

how to escape and insert in mysql database using php

<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'];

how to scape all the value including array and variable. and insert variable repeatly on very row and array..

Answer 1

try this

// 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']);