how to fetch data using jquery

Posted by user3566029 on Stack Overflow See other posts from Stack Overflow or by user3566029
Published on 2014-06-02T02:50:23Z Indexed on 2014/06/02 3:26 UTC
Read the original article Hit count: 111

Filed under:
|
|
|
|

I have tried to connect my index.php file in 000webhost.com using jQuery.

From the site menu I have connected with 000webhost using FTP details available in 000webhost.com.

When I tried to read data from jQuery it doesn’t working.

Anyone please tell me what should I need to change? Should I need to connect my Dreamweaver database to webhost? If yes please explain?

This is what I have done.

index.php

$mysql_host = "mysql0.000webhost.com";

$mysql_database = "a000000_mydb";

$mysql_user = "a000000_root";

$mysql_password = "******";

$conn=@mysql_connect ( $mysql_host,$mysql_user,$mysql_password )or die('aa');

mysql_select_db($mysql_database,$conn) or die('eoor on db');

$quer=mysql_query("SELECT * FROM sam");

$res=array();

while($row=mysql_fetch_row($quer)) {

  $res[]=$row;  

}

print(json_encode($res));

return json_encode($res);

mysql_close();

index.html

$.get('public_html/index.php', function( data ) {
    alert( 'Successful' +data);
});

© Stack Overflow or respective owner

Related posts about JavaScript

Related posts about php