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;
}
