Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username="usrname";
- $password="passwd";
- $database="a1xxxxx_mydb";
- $host="mysqlxx.000webhost.com";
- mysql_connect($host,$username,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- if (isset($_GET["userLatitude"]) && isset($_GET["userLongitude"])) {
- $userLatitude=$_GET['userLatitude'];
- $userLongitude=$_GET['userLongitude'];
- $result = mysql_query("SELECT locationName, ( 6371 * acos( cos( radians(floatval( $userLatitude) )) * cos( radians( locationLatitude ) ) * cos( radians( locationLongitude ) - radians( floatval($userLatitude)) ) + sin( radians(floatval($userLongitude)) ) * sin( radians( locationLatitude) ) ) ) AS distance
- FROM Location HAVING distance < 2 ORDER BY distance LIMIT 0 ,20") or die(mysql_error());
- echo $result;
- // check for empty result
- if (mysql_num_rows($result) > 0) {
- // looping through all results
- // products node
- $response["Location"] = array();
- while ($row = mysql_fetch_array($result)) {
- // temp user array
- $product = array();
- $product["locationName"] = $row["locationName"];
- $product["locationInfo"] = $row["locationInfo"];
- $product["locationLatitude"] = $row["locationLatitude"];
- $product["locationLongitude"] = $row["locationLongitude"];
- $product["locationPic"] = $row["locationPic"];
- $product["city"] = $row["city"];
- // push single product into final response array
- array_push($response["Location"], $product);
- }
- // success
- $response["success"] = 1;
- // echoing JSON response
- echo json_encode($response);
- } else {
- // no products found
- $response["success"] = 0;
- $response["message"] = "No products found";
- // echo no users JSON
- echo json_encode($response);
- }
- }
- else {
- // required field is missing
- $response["success"] = 0;
- $response["message"] = "Required field(s) is missing";
- // echoing JSON response
- echo json_encode($response);
- }
- mysql_close();
- ?>
- mysql_upgrade -u root -p
- service mysqld restart
- my $rv = $sth_indexq->fetchall_arrayref;
- DBD::mysql::st execute failed: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50520, now running 50528. Please use mysql_upgrade to fix this error. at
- ...
- my $rv = $sth_indexq->fetchrow_arrayref;
- mysql_upgrade --force -uroot -p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement