Php how can insert arrays?

Question

I am creating an insert in my db, through a "for" to several arrays but I cannot access each element or its respective value, how can I organize it in such a way that it enters all the arrays?

my arrays are as follows and they are in a called object: jsonRequest1

Array
(
    [0] => Array
        (
            [id_question] => 1
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿Es usted propietario de la organizaciÃ³n?
            [active] => 1
        )

    [1] => Array
        (
            [id_question] => 2
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿QuÃ© rol ocupa dentro de la organizaciÃ³n?
            [active] => 1
        )

    [2] => Array
        (
            [id_question] => 3
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿Conoce usted las funciones del control organizacional? 

            [active] => 1
        )

    [3] => Array
        (
            [id_question] => 4
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿Considera usted que en la organizaciÃ³n que gerencia el control se realiza de forma previa o posterior a los hechos?
            [active] => 1
        )

    [4] => Array
        (
            [id_question] => 5
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿QuÃ© tipo de prÃ¡cticas realiza en la organizaciÃ³n para ejercer el control? 
            [active] => 1
        )

    [5] => Array
        (
            [id_question] => 6
            [id_subcategory] => 1
            [subcategory_name] => Aspectos generales del control organizacional
            [question_name] => Â¿De manera percibe usted las inversiones realizadas en mecanismos de control para la organizaciÃ³n?
            [active] => 1
        ))

My code in PHP is as follows so far:

$connect = new mysqli($servername, $username, $password, $dbname);
  if ($connect->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  }
  $connect->set_charset("utf8");
 $jsonRequest1 = json_decode(file_get_contents("php://input"));
if (!$jsonRequest1) {
    exit("No hay datos");
}
$connect = include_once "conect.php";

$array = json_decode(json_encode($jsonRequest1),true);
echo "<pre>";
print_r($array);
echo"</pre>";
 print $jsonRequest1[$id_question];
$cadena = "INSERT INTO qrequest ($id_question, $id_subcategory)" ;


for ($i = 0; $i < count($id_question); $i++){
    $cadena.="('".$id_question[$i]."', '".$id_subcategory[$i]."'),";
}

echo json_encode(array('cadena'=> $cadena))

error in console

Please can you help me, or how else can I perform the insert? I have tried with foreach but it has not been possible either since it does not find the values.

thanks

score 0 · Answer 1 · answered Jul 02 '22 at 16:29

I readjusted the code with double foreach to enter the values but I get the following error, what am I missing?

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, object given in C:\wamp\www\hexagono\registerRequest1.php on line 53

insert($array, $connect);

 function insert($array, $connect)  
 {  

if(is_array($array))  
{  

     $values = array();  
     foreach($array as $row => $value) 
      
     {  
      foreach($value as $key => $valor){
        
    
     echo "<pre>";
     print_r("clave ".$key." valor ".$valor."<br/>");
     echo"</pre>";

     echo json_encode([
      [$key => $valor] ,
  ]);
     
          $id_question = mysqli_real_escape_string($connect, $valor[0]);  
        var_dump($valor[0]);
          $id_subcategory = mysqli_real_escape_string($connect, $valor[1]);   
          $valor[] = "('$id_question', '$id_subcategory')";  

     } 
    }
     $sql = "INSERT INTO qrequest(id_question, id_subcategory) VALUES ";  
     $sql .= implode(', ', $valor);
     var_dump($result->array); 
     mysqli_query($connect, $sql);  
}  
 }
?>

Php how can insert arrays?

1 Answers1