Start New Discussion within our Web Development Community

how to insert data in multi dimension array into mysql database in php.

this is what I have done so far.I'm little bit new to this suff.please help...


       require 'connection1.php';





        foreach( $stu as $key =>$info){

            $in="INSERT INTO $tbl ('number','name','age') VALUES ('$key','$info[number]','$info[name]','$info[age]')";




THat won't work - as you probably know. WHy are you using a repeat of the data into a multidimensional array? THe loop won't work as you expect either. If you have a Primary Key field, just ignore this in the SQL - so no need for a $key - anyway you have different number of fields and values, so it'll throw an error. Also you need to sanitize your input (post) variables before using this type of query. If you use a bound, parameterized query (mysqli or PDO), then it's OK.

This article has been dead for over six months. Start a new discussion instead.