Create("localDatabase"); if(isset($_POST['sid'])||isset($_GET['sid'])){$sid=$_POST?$_POST['sid']:$_GET['sid'];} if(isset($_POST['name'])||isset($_GET['name'])){$name=$_POST?$_POST['name']:$_GET['name'];} if(isset($_POST['address'])||isset($_GET['address'])){$address=$_POST?$_POST['address']:$_GET['address'];} if(isset($_POST['city'])||isset($_GET['city'])){$city=$_POST?$_POST['city']:$_GET['city'];} if(isset($_POST['state'])||isset($_GET['state'])){$state=$_POST?$_POST['state']:$_GET['state'];} if(isset($_POST['zip'])||isset($_GET['zip'])){$zip=$_POST?$_POST['zip']:$_GET['zip'];} if(isset($_POST['phone'])||isset($_GET['phone'])){$phone=$_POST?$_POST['phone']:$_GET['phone'];}$phone=strip_phone($phone); if(isset($_POST['uname'])||isset($_GET['uname'])){$uname=$_POST?$_POST['uname']:$_GET['uname'];} echo $uname; if(isset($_POST['ucomment'])||isset($_GET['ucomment'])){$ucomment=$_POST?$_POST['ucomment']:$_GET['ucomment'];} $ip = $_SERVER['REMOTE_ADDR'];$refer = $_SERVER['HTTP_REFERER'];$msg = ""; if($uname <> ''){ $insBus= "INSERT INTO AllBusinessStage(store_id, name, address, city, state, zip, phone, uname, ucomment ) values (\"$sid\", \"$name\", \"$address\", \"$city\", \"$state\", \"$zip\", \"$phone\", \"$uname\", \"$ucomment\")"; $sql->Insert($insBus);$msg = "

Your Correction is submitted successfully.

Thank you for your help to improve our search engine.

"; } ?>

If you come across any incorrect business info, please edit the existing information to make the appropriate correction with your name and comment.

''){ echo $msg; } else { if(isset($_COOKIE['ylat'])){$ylat=$_COOKIE['ylat'];}else{$ylat ="28.4521";} //echo $ylat; if(isset($_COOKIE['ylon'])){$ylon=$_COOKIE['ylon'];}else{$ylon ="-81.4678";} //echo $ylon; $selList="SELECT name, address, city, state, left(zip,5), phone, website, latitude, longitude, category, subcat1, round(SQRT(POW(69.1 * (latitude - $ylat), 2) + POW(69.1 * ($ylon - longitude) * COS(latitude / 57.3), 2)),1) AS distance, store_id, tagkey, facebook, twitter, delivery, smenu, yelpid FROM AllBusiness WHERE store_id = '$sid'"; $sql->Query($selList); for ($i=0;$i<$sql->rows;$i++) { $sql->Fetch($i); $name = $sql->data[0]; $name1 = str_replace("'","",$name);$name1 = str_replace("&","",$name1);$name1 = str_replace(" ","-",$name1); if ($isupper =='0'){$name=ucwords(strtolower($name));} $address = $sql->data[1]; $address=strtolower($address);$address=ucwords($address); $city = $sql->data[2]; $city1=strtolower($city);$city1=ucwords($city1); $state = $sql->data[3]; $state1=strtolower($state); $zip = $sql->data[4]; $phone = $sql->data[5]; $website = $sql->data[6]; $latitude = $sql->data[7]; $longitude = $sql->data[8]; $category = $sql->data[9]; $subcategory= $sql->data[10]; $distance = $sql->data[11]; $storeid = $sql->data[12]; //$list = "$name, $Address, $city, $state, $zip"; } $sql->Close(); echo $list ?>