php script to get data from database android

Question

i m trying to build a JSON array from mysql. it does not get the information from mysql

<?php
$host="localhost";
$pwd="";
$user="root";
$db="mydb";

$con=mysqli_connect($host,$user,$pwd,$db) or die('Unable to connect'); 
if(mysqli_connect_error($con))
{
echo"failded to connect";
}
$query = mysqli_query($con,"select * from product");
if ($query)
{
    while($row = mysqli_fetch_array($query))
    {
        $flag[] = $row;

    }
  print(json_encode($flag));


}
mysqli_close($con);
 ?>

Notice: Array to string conversion in C:\wamp\www\new\count.php on line 19

What does this error mean and how do I fix it?

It must be $flag = $row; instead of $flag[] = $row; as $row is already an array I reckon. — Echoes
– Echoes, Commented May 15, 2017 at 13:29

Anuj Tiwary · Accepted Answer · 2017-05-15 13:41:09Z

2

Please initialize $flag something like this $flag = array()

hope it was helpful to you.

edited May 15, 2017 at 13:41

answered May 15, 2017 at 13:29

Anuj Tiwary

3381 silver badge10 bronze badges

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

1 Comment

Agam Banga Over a year ago

This won't solve the problem though. It will just remove the warning of uninitialized variable. Please update the answer as its not resolving the issue

baiju jha · Accepted Answer · 2017-05-15 13:31:48Z

1

change print to print_r(json_encode($flag)) you won't get any error

answered May 15, 2017 at 13:31

baiju jha

4732 silver badges10 bronze badges

1 Comment

baiju jha Over a year ago

write print_r($row) inside loop and check if it shows something then also if not then check database that contains data or not

WasteD · Accepted Answer · 2017-05-15 13:32:07Z

0

You are converting your array to a json array so you have to use var_dump or print_r().

answered May 15, 2017 at 13:32

WasteD

7786 silver badges25 bronze badges

3 Comments

Hamza Ay Over a year ago

the result must be Something like that [{"image":"http:\/\/192.168.1.104:81\/new\/image\/laVacheQuiRit.jpg","namee":"la vache qui rit","rank":"190","realName":"fromage vache ","createdBy":"danone","Appearance":"1900","powers":"190"}]

WasteD Over a year ago

@HamzaAy What is the output if you replace print with var_dump?

Hamza Ay Over a year ago

Something like thatarray (size=4) 0 => array (size=6) 0 => string '192.168.100.93:81/new/categorie/boisson.jpg' (length=50) 'image' => string '192.168.100.93:81/new/categorie/boisson.jpg' (length=50) 1 => string 'Boisson' (length=7) 'categorie' => string 'Boisson' (length=7) 2 => string '2' (length=1) 'quantite' => string '2' (length=1)

Collectives™ on Stack Overflow

php script to get data from database android

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related