How to insert data from array into mysql using php

Question

I have this arrays of firstname and lastname, i want to insert the names into the database, the arrays looks like this:

Array(
[0] => firstname1
[1] => firstname2
[2] => firstname3
)

Array(
[0] => lastname1
[1] => lastname2
[2] => lastname3
)

I have this code to insert them but it does'nt work

         $fname = $_POST['fname'];
         $lname = $_POST['lname'];

         for($i=0, $count = count($fname); $i < $count; $i++){
         $lastname = $lname[$i];
          $firstname = $fname[$i];
         $query = mysqli_query($con,"INSERT INTO 
       persons(firstname,lastname)VALUES('$firstname','$lastname')");
    }

Printing the strings in the array is not a prolem, but when i insert it an error saying Notice: Array to string conversion in D:\xampp\htdocs\SPAC_Online_Grading_System\system\pages\addfunction.php on line 259 How can i make it work?

Not only is this an under-researched duplicate. Your query is vulnerable to injection attacks. Keep researching. — mickmackusa
– mickmackusa ♦, Commented May 2, 2018 at 8:04
Danger: You are vulnerable to SQL injection attacks that you need to defend yourself from. — Quentin
– Quentin, Commented May 2, 2018 at 8:04
Possible duplicate of Insert rows from two arrays into mysql table in php ...this is just one of MANY. — mickmackusa
– mickmackusa ♦, Commented May 2, 2018 at 8:07
Sorry if it seems to you that it is under-researched duplicate, but asking questions here is really my last option,hehe Yeah, its vulnerable but i'm not concerned about that right now, I just want to insert these things. — Rouge
– Rouge, Commented May 2, 2018 at 8:10

Sébastien S. · Accepted Answer · 2018-05-02 08:05:25Z

0

Your loop condition is wrong, change :

for($i=0, $count = count($fname); $i < $count; $i++)

To :

for($i=0; $i < count($fname); $i++)

Also note that you are vulnerable to SQL injections, you should prepare and bind your statements

answered May 2, 2018 at 8:05

Sébastien S.

1,54412 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ghazal Ehsan · Accepted Answer · 2018-05-02 08:28:20Z

0

You loop is wrong. Try this code:

 <?php 
 $fname = $_POST['fname'];
 $lname = $_POST['lname'];

 for($i=0; $i < count($fname); $i++){

   $firstname = $fname[$i];
   $lastname = $lname[$i];

   $query = mysqli_query($con,"INSERT INTO 
      persons(firstname,lastname)VALUES('$firstname','$lastname')");
 }
 ?>

answered May 2, 2018 at 8:28

Ghazal Ehsan

874 bronze badges

Comments

pr1nc3 · Accepted Answer · 2018-05-02 08:29:22Z

0

    for($i=0; $i<count($fname);$i++){
        $lastname = $lname[$i];
        $firstname = $fname[$i];
        $stmt = $conn->prepare($con,"INSERT INTO persons(firstname,lastname)VALUES(?,?)");
        $stmt->bind_param("ss", $firstname, $lastname);
        $stmt->execute();
    }

Try this code. It is secure from sql injection(using prepare statements) and fixed your for loop.

answered May 2, 2018 at 8:29

pr1nc3

8,3763 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to insert data from array into mysql using php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related