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