<body> <nav> <ul> <li class="navbar"><a href="Database/Database_Store_Manager.php">Admin</a></li> <li class="navbar"><a href="log_in.html">Log in</a></li> <li class="navbar"><a href="cart.html">Cart</a></li> </ul> </nav> <?php if ($_POST) { // get latitude, longitude and formatted address $sc_zip = $_POST['searchbox']; include_once '../Database/Store_Information.php'; $store_info = new Store_Information(); $store_info->queryAllStoreInfo(); $index = count($store_info->_store_name); $counter_php = 1; $latitude = $store_info->_store_location_lat[1]; $longitude = $store_info->_store_location_lan[1]; $formatted_address = $store_info->_default_address_street[1] . " " . $store_info->_default_address_city[1] . " " . $store_info->_default_address_state[1] . " " . $store_info->_default_address_zip[1]; ?> <!-- google map will be shown here --> <div id="gmap_canvas">Loading map...</div> <!-- JavaScript to show google map --> <script type="text/javascript" src="http://maps.google.com/maps/api/js"></script> <script type="text/javascript"> function init_map() {
/** * List all saved Store information in Manager page */ function showStoreInfo() { include_once '../Database/Store_Information.php'; $store_info = new Store_Information(); $store_info->queryAllStoreInfo(); echo "<table id='tb_store_info_dba' border='1' align=center><tr><th>Store Name</th><th>Store Rating</th><th>Store Category</th><th>Store lat</th><th>Store lan</th>\n <th>Store Address Street</th><th>Store Address Street Ref</th><th>Store Address City</th><th>Store Address State</th><th>Store Address Zip</th>\n <th>Store Address Country</th></tr>"; // output data of each row for ($x = 1; $x <= count($store_info->_store_name); $x++) { echo "<tr><td>" . $store_info->_store_name[$x] . "</td><td>" . $store_info->_store_rating[$x] . "</td><td>" . $store_info->_store_category[$x] . "</td><td>" . $store_info->_store_location_lat[$x] . "</td><td>" . $store_info->_store_location_lan[$x] . "</td><td>" . $store_info->_default_address_street[$x] . "</td><td>" . $store_info->_default_address_street_ref[$x] . "</td><td>" . $store_info->_default_address_city[$x] . "</td><td>" . $store_info->_default_address_state[$x] . "</td><td>" . $store_info->_default_address_zip[$x] . "</td><td>" . $store_info->_default_address_country[$x] . "</td></tr>"; } echo "</table>"; }