i tried to fetch database values using jquery, but it's not working
code - final.html: http://pastebin.com/vMy5invc
api.php
<?php
$host = "localhost";
$user = "root";
$pass = "";
$databaseName = "vhc";
$tableName = "users";
$con = mysql_connect($host,$user,$pass);
$dbs = mysql_select_db($databaseName, $con);
$data = array();
$result = mysql_query("SELECT `id`,`name`,`email`,`location` FROM $tableName");
while ( $row = mysql_fetch_row($result) )
{
$data[] = $row;
}
echo json_encode( $data );
?>
you shoud replace $tableName with ".$tableName."
<?php
$host = "localhost";
$user = "root";
$pass = "";
$databaseName = "vhc";
$tableName = "users";
$con = mysql_connect($host,$user,$pass);
$dbs = mysql_select_db($databaseName, $con);
$data = array();
$result = mysql_query("SELECT `id`,`name`,`email`,`location` FROM ".$tableName."");
while ( $row = mysql_fetch_row($result) )
{
$data[] = $row;
}
echo json_encode( $data );
?>