how can I insert more than 2 arrays using php to mysql database

Question

I have 2 arrays (as an example but I've 8) to insert the record to MySQL database. But I'm confused about how to insert them. Please guide me about.

$bunit = $_POST['bunit'];
$prodID = $_POST['productID'];
$section = $_POST['section'];
$remarks = array();
$remarksType = array();



INSERT INTO `remarks` (`remarks_id`, `remarks`,`bunit`, `prodID`,  `remarks_section_ID`, `remarks_type`, `remarks_defectID`, `remarks_productID`, `remarks_active`) VALUES (NULL, '$remarks', '$bunit', '$prodID', '$section', '$remarksType', '1', '2', 1);"

I'm stuck at inserting the data to mysql, $bunit, $prodID & $section will be same while $remarks and $remarkType are arrays and they will be dynamic and separate. how would i write the foreach statement to insert each entry to mysql — Muhammad Usman, Apr 02 '19 at 19:14

score -1 · Answer 1 · edited Apr 02 '19 at 13:56

-1

Hey before insert you have do one thing encode array to json_encode() and insert to db when retrieve from db simple use json_decode()

$bunit = $_POST['bunit'];
$prodID = $_POST['productID'];
$section = $_POST['section'];
$remarks = json_encode(array('id'=>1 ,'data'=>'remarks')) ;
$remarksType = json_encode(array('id'=>1 ,'data'=>'remarksType'));
$sql = "INSERT INTO `remarks` (`remarks_id`, `remarks`,`bunit`, `prodID`,  `remarks_section_ID`, `remarks_type`, `remarks_defectID`, `remarks_productID`, `remarks_active`) VALUES (NULL, '$remarks', '$bunit', '$prodID', '$section', '$remarksType', '1', '2', 1);"

edited Apr 02 '19 at 13:56

RiggsFolly

93,638
21
103
149

answered Apr 02 '19 at 13:31

Pardeep Dhiman

50
6

2

Where does the OP mantion anything about JSON? This is irrelevant to the actual question – RiggsFolly Apr 02 '19 at 13:59
@RiggsFolly you said you want to store array in database so i sugggest to you that you can insert using json_enode(). what is the problem you are facing in this – Pardeep Dhiman Apr 03 '19 at 04:00
Not my Downvote by the way! – RiggsFolly Apr 03 '19 at 09:00

how can I insert more than 2 arrays using php to mysql database

1 Answers1