passing multidimensional array to mysql using generated input fields

Question

<?php

if (isset ($_POST['submit'])){


$name=$_POST['name'];
$sports=$_POST['sports'];
$data=array();
for($x=0,$l=count($sports); $x<$l; $x++){
    $myArray = explode(',', $name[$x]);// you can use your own filter for names          
    foreach($myArray as $nm){
        $data[]=array('name'=>$nm,'sports'=>$sports[$x]);
    }
}
var_dump($data);


$query="INSERT INTO athletes (name, sports) VALUES ('".$data."')";

    $result = mysqli_query($dbc, $query);

    mysqli_free_result( $result);


}

?>

getting error array to string conversion. hot do i pass that in the database in separate rows. the output is working wonderfully when i dump just the way i want it but i cant seem to get it passed to the database.

@Randy Yes that's correct. This seems like something that is very hard to accomplish. — Shanna Chambers
– Shanna Chambers, Commented Aug 17, 2016 at 9:08
I've only edited to make it more obvious, I didn't actually change your question. I honestly don't have the answer for you. — Randy
– Randy, Commented Aug 17, 2016 at 9:11
@ShannaChambers if you are asking some question and someone helps you(not mine) then you should not update your question as correct answer. Now, the viewers does not find what was the actual problem and now the question is not valid as it is already correct. Users are not here for wasting time, they are here only because they can help someone like you. — Rohan Kumar
– Rohan Kumar, Commented Aug 17, 2016 at 10:52

Rohan Kumar · Accepted Answer · 2016-08-17 10:49:06Z

2

I think you don't need to make multidimensional array name[][], you just use name[] so in your PHP code it is just like,

$name=$_POST['name'];
$sports=$_POST['sports'];
$data=array();
for($x=0,$l=count($sports); $x<$l; $x++){
    $myArray = explode(',', $name[$x]);// you can use your own filter for names          
    foreach($myArray as $nm){
        $data[]=array('name'=>$nm,'sports'=>$sports[$x]);
    }
}
var_dump($data);

Demo

You can change $data while inserting in database like,

$data[]='("'.trim($nm).'","'.trim($sports[$x]).'")';

And after your loop ends you can create query like,

$sql ="INSERT INTO <table> (name,sports) VALUES ".implode(',',$data);

Demo with Query

edited Aug 17, 2016 at 10:49

answered Aug 17, 2016 at 9:18

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

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

10 Comments

Shanna Chambers Over a year ago

@ Rohan Kumaram getting alot of error when i submit i just copied your code and paste

Shanna Chambers Over a year ago

Warning: explode() expects parameter 2 to be string, array given in C:\xampp\htdocs\mul.php on line 10 Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\mul.php on line 11 Warning: explode() expects parameter 2 to be string, array given in C:\xampp\htdocs\mul.php on line 10 Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\mul.php on line 11 array(0) { }

Rohan Kumar Over a year ago

Make sure you are using $name[$x] and not $name. And see my updated answer for online demo.

Shanna Chambers Over a year ago

i also used the update but when i press submit it gives me that error in your code you assigned the array values but in mine in mine i am passing them from the input fields. related to the demo one on the web

Shanna Chambers Over a year ago

ok it seems like its working now i am gonna implement it so that it passes to the database thanks. i will let you know what happens

|

Maulik Savaliya · Accepted Answer · 2016-08-17 09:36:16Z

0

You need to create separate array from post value for each row.

http://sandbox.onlinephpfunctions.com/code/c8aede27dc5675a8715be328dec6c5ea4c669522

answered Aug 17, 2016 at 9:36

Maulik Savaliya

1,2688 silver badges19 bronze badges

1 Comment

Shanna Chambers Over a year ago

got it to work but how would one insert $data in the mysql database now

Collectives™ on Stack Overflow

passing multidimensional array to mysql using generated input fields

2 Answers 2

10 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related