public function queryAllStoreInfo()
{
include_once '../Database/Database_Connection.php';
$databaseConnection = new Database_Connection();
$databaseConnection->createDatabase();
$databaseConnection->databaseConnect();
$sql = "select * from scudsbook_store_info";
$result = mysqli_query($databaseConnection->conn, $sql);
$i = 1;
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
$this->_store_name[$i] = $row['store_name'];
$this->_store_rating[$i] = $row['store_rating'];
$this->_store_category[$i] = $row['store_category'];
$this->_store_location_lat[$i] = $row['store_location_lat'];
$this->_store_location_lan[$i] = $row['store_location_lan'];
$this->_default_address_street[$i] = $row['address_street'];
$this->_default_address_street_ref[$i] = $row['address_ref'];
$this->_default_address_city[$i] = $row['address_city'];
$this->_default_address_state[$i] = $row['address_state'];
$this->_default_address_zip[$i] = $row['address_zip'];
$this->_default_address_country[$i] = $row['address_country'];
$i++;
}
} else {
echo "0 results";
}
mysqli_close($databaseConnection->conn);
$databaseConnection->conn_state = false;
}
showStoreInfo();
?>
<br><br>
<div id="delete_store" align="center">
<input type=text name=_delete_store id=_delete_store>
<input type=submit name=delete id="delete_address" value=delete>
</div>
</form>
</div>
<?php
if ($_POST) {
include_once '../Database/Database_Connection.php';
$databaseConnection = new Database_Connection();
$databaseConnection->createDatabase();
$_store_name = $_POST['_store_name'];
if (!empty($_store_name)) {
$_store_rating = $_POST['_store_rating'];
$_store_category = $_POST['_store_category'];
$_default_address_street = $_POST['_default_address_street'];
$_default_address_city = $_POST['_default_address_city'];
$_default_address_state = $_POST['_default_address_state'];
$_default_address_zip = $_POST['_default_address_zip'];
$_default_address_country = $_POST['_default_address_country'];
// get latitude, longitude and formatted address
$data_arr = geocode($_default_address_street . ',' . $_default_address_city . ',' . $_default_address_state . ',' . $_default_address_zip . ',' . $_default_address_country);
// if able to geocode the address
if ($data_arr) {
$latitude = $data_arr[0];
$longitude = $data_arr[1];
