Getting information from mysql using jquery

Question

i have mysql database for i fetch information using json for example:

$sql ="SELECT * FROM parent WHERE id = '$name'";       
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
 {
$abc=$row[id];
}
echo json_encode($abc)

Now how can i display this json encoded element in my main html file using jquery? what i want to do is based on this fetched element i want to do some if else operation.

for example:

if(value of row[id](should be achieved using jquery) ==null)
{}
else
{}

I am looking for something like $(xxxx).somefunction() Thanks in advance.

Collin Price · Accepted Answer · 2011-08-18 00:28:49Z

1

You could use jQuery to convert the JSON into a JavaScript object and then add the properties of the object into your html.

jQuery.parseJSON( json )

Add the JSON from the database to your webpage through:

echo "var myJson = ".json_encode($abc);

Then use jQuery to parse the JSON through:

myObject = jQuery.parseJSON(myJson);
alert(myObject.id);

answered Aug 18, 2011 at 0:28

Collin Price

5,8803 gold badges37 silver badges36 bronze badges

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

Comments

Johni · Accepted Answer · 2011-08-18 00:05:45Z

1

You can create a javascript var:

echo('var test = ' . json_encode($abc));

Now you can acces the var "test" with javascript.

answered Aug 18, 2011 at 0:05

Johni

2,9804 gold badges30 silver badges48 bronze badges

1 Comment

Dumb_Shock Over a year ago

hey i am looking for something like this $(xxxx).somefunction()

Collectives™ on Stack Overflow

Getting information from mysql using jquery

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related