Return PHP MySQL select as json

Question

So I have a SQL database with a number of objects in that contain name price and images, I would like to know how I can select them using php and output the result into json

<?php
$db = mysqli_connect ('localhost', 'root', '', 'car_rental') or die  ("SQL is Off");


$car = (isset($_GET['car']) ? $_GET['car'] : null);

mysqli_select_db($db,"car_rental");


$SQL = "SELECT * FROM `products` WHERE name LIKE \'%$car%\'";
$result = mysql_query($SQL);

while ( $db_field = mysql_fetch_assoc($result) ) {

print $db_field['sku'] . "<BR>";
print $db_field['name'] . "<BR>";
print $db_field['img'] . "<BR>";
print $db_field['price'] . "<BR>";

}

?>

This is my current code car variable will change dependent on car selected thanks

seem to get this error mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\db\search.php on line 13 — Ahmed Bakir
– Ahmed Bakir, Commented Jan 20, 2016 at 10:23

devpro · Accepted Answer · 2016-01-20 10:51:56Z

6

For getting all values in json format, you need to use like that:

<?
$newArr = array();
while ( $db_field = mysql_fetch_assoc($result) ) {
    $newArr[] = $db_field;
}
echo json_encode($newArr); // get all products in json format.
?>

UPDATE 1:

You are mixing mysqli extension with mysql. Change mysql into mysqli

UPDATE 2:

Why are you connecting database twice in code?

Modified Code:

<?php

$link = mysqli_connect("localhost", "root", "", "car_rental");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$car = (isset($_GET['car']) ? $_GET['car'] : null);

$query = "SELECT * FROM `products` WHERE name LIKE '%$car%'";

if ($result = mysqli_query($link, $query)) {

    $newArr = array();
    /* fetch associative array */
    while ($db_field = mysqli_fetch_assoc($result)) {
        $newArr[] = $db_field;
    }
    echo json_encode($newArr); // get all products in json format.    
}

?>

Side Note:

Also on PHP error reporting in development phase for saving your time.

edited Jan 20, 2016 at 10:51

answered Jan 20, 2016 at 10:22

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Ahmed Bakir Over a year ago

get the following error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\db\search.php on line 13 false

devpro Over a year ago

@AhmedBakir: i have changed the variable , try now.

devpro Over a year ago

You are mixing mysqli extension with mysql @AhmedBakir

devpro Over a year ago

@AhmedBakir: Change mysql into mysqli

Ahmed Bakir Over a year ago

thanks it works i wasnt aware that i connected to my DB twice @devpro

|

Collectives™ on Stack Overflow

Return PHP MySQL select as json

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related