how to insert multiple json data into mysql database in php

Solutions on MaxInterview for how to insert multiple json data into mysql database in php by the best coders in the world

Search
showing results for - "how to insert multiple json data into mysql database in php"
Jazmín
02 Jun 2017
1<?php 
2
3$josndata = '{
4"Customer":{ "name":"Jonny", "country":"CANADA", "ContactNo":524587777 },
5"Student":{ "name":"Gussy", "country":"USA", "ContactNo":9856452100}
6}';  
7
8// Database connection
9$conn = new mysqli('localhost', 'username', 'password', 'databasename');
10
11// Insert data Query
12$sql = "INSERT INTO student_table ( name, jsondata )
13VALUES ('Multidata', '$josndata')";
14
15if ($conn->query($sql) === TRUE) {
16  echo "Insert your Multiple JSON record successfully";
17} 
18?>
source
similar questions
how to insert json data into mysql using phpphp mysqli connect to two databases pdofetch multiple rows in phpphp pass 2 date value to javascriptmerge two arrays one as key to another phpreturn multiple rows from mysqli php and encode jsonphp pdo multiple insertphp bulk insert mysqlphp multiple variables assign same valuephp json array push in js filephp mysql row to jsonappend data to json file phpstore json in mysqlhow to start on row 2 spreadsheet inserting to database using phpassign multiple variables phphow to bulk insert array into sql phpmerge two json in phparray merge with same key in phpphp mysql query multiple wherephp execute 2 queries
queries leading to this page
entering multiple data to mysql with json and phphow to insert multiple json data into mysql database in phpphp insert multiple records into mysql pdo from json filehow to impoert multiple json data into mysql database in phphow to insert multiple json data into mysql database in php