Monday 3 September 2018
Subscribe to:
Post Comments (Atom)
<?php
//open connection to mysql db
$connection = mysqli_connect("localhost","root","","maps") or die("Error " . mysqli_error($connection));
//fetch table rows from mysql db
$sql = "select * from locations";
$result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection));
//create an array
$emparray[] = array();
while($row =mysqli_fetch_assoc($result))
{
$emparray[] = $row;
}
echo json_encode($emparray);
//close the db connection
mysqli_close($connection);
?>
while ( $row = $result->fetch_assoc() ){
$emparray[] = json_encode($row);
}
echo json_encode( $emparray );
while($row =mysqli_fetch_assoc($result))
{
$emparray[] = json_encode($row);
}
echo json_encode($emparray);
$emparray = $result->fetch_all( MYSQLI_ASSOC );
echo json_encode( $emparray );
while($row =mysqli_fetch_assoc($result))
{
$emparray[] = $row;
}
echo json_encode($emparray);
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment