I have wamp with php nd mysql installed. My php file is in PC wamp/www/Demo folder in which I written query for inserting values getting by url.
Now I want to send multiple rows of data collected from android application to MySQL Wamp server through PHP file.
My php file code is as below,
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);
if(! $conn )
$sql1 = "INSERT INTO order_details (`order_no`,`item_name`,`item_value`) VALUES ('$order_no','$item_name','$item_value')";
$retval = mysqli_query( $conn,$sql1 );
if(! $retval )
echo "entered success";
and calling url is
What I have tried:
Tried below url for single row insertion
It is not possible to pass all row values like this way
what to do? please suggest.