function storeImages($sizes, $photo_id) { for ($i = 0; $i < count($sizes); $i++) { // echo "This is sizes src : ".$sizes[$i]->src."<br></br>" ; // echo "This is sizes width : ".$sizes[$i]->width."<br></br>" ; // echo "This is sizes height : ".$sizes[$i]->height."<br></br>" ; // echo "This is sizes type : ".$sizes[$i]->type."<br></br>" ; // echo "This is sizes type : ".$photo_id."<br></br>" ; // echo "<img src=\"".$sizes[$i]->src."\" >"; $sql = "INSERT INTO IMAGES (PID, SRC, WIDTH, HEIGHT, TYPE) \n VALUES ('" . $photo_id . "','" . mysql_real_escape_string($sizes[$i]->src) . "','" . $sizes[$i]->width . "','" . $sizes[$i]->height . "','" . mysql_real_escape_string($sizes[$i]->type) . "')"; $res = mysql_query($sql); $msg = $res ? successMessage("Uploaded and saved to IMAGES.") : errorMessage("Problem in saving to IMAGES"); echo "=== : " . $photo_id . " : " . $msg . " <br>"; } }
try { $stmt = $DB->prepare($sql); $stmt->bindValue(":pt", $page_title); $stmt->bindValue(":pdsc", $page_desc); $stmt->bindValue(":mkey", $meta_keywords); $stmt->bindValue(":mdesc", $meta_desc); $stmt->bindValue(":parent", $parent); $stmt->bindValue(":so", $sort_order); $stmt->bindValue(":status", $status); $stmt->bindValue(":palias", $page_alias); $stmt->execute(); if ($stmt->rowCount() > 0) { $msg = successMessage("Page added successfully"); } else { if ($stmt->rowCount() == 0) { $msg = successMessage("No changes affected"); } else { $msg = errorMessage("Failed to add page"); } } } catch (Exception $ex) { echo errorMessage($ex->getMessage()); } } } else { $msg = errorMessage("All fields are mandatory"); } } if (isset($_GET["edit"]) && $_GET["edit"] != "") { $pageTitle = "Edit Page"; try {
* Time: 3:37 PM */ require "../libs/config.php"; $pageTitle = "Manage Pages"; $msg = ''; if (isset($_GET["del"]) && $_GET["del"] != "") { $sql = "DELETE FROM " . TABLE_PAGES . " WHERE `page_id` = :id"; try { $stmt = $DB->prepare($sql); $stmt->bindValue(":id", db_prepare_input($_GET["del"])); $stmt->execute(); } catch (Exception $ex) { echo errorMessage($ex->getMessage()); } if ($stmt->rowCount() > 0) { $msg = successMessage("Record deleted successfully"); } else { $msg = errorMessage(mysql_error()); } } include "header.php"; echo $msg; ?> <div class="title" style="text-align:right;"><a href="add_edit_page.php">Add Page</a></div> <table class="bordered"> <tr> <th><strong>Title</strong></th> <th><strong>Parent</strong></th> <th><strong>Sort Order</strong></th> <th><strong>Status</strong></th> <th><strong>Action</strong></th>
} else { errorMessage('Access Token Error!'); } break; case 'UpdateMap': if ($member->VerifiedMemberKey(array('member_id' => $_POST['memberID'], 'key' => $_POST['memberKEY']))) { $place->UpdatePlaceMap(array('place_id' => $_POST['place'], 'address' => $_POST['place_address'], 'address_real' => $_POST['place_address_real'], 'latitude' => $_POST['place_latitude'], 'longitude' => $_POST['place_longitude'], 'city_id' => $_POST['place_city'], 'district_id' => $_POST['place_district'])); successMessage('Place update Success.'); } else { errorMessage('Access Token Error!'); } break; case 'UpdateStatus': if ($member->VerifiedMemberKey(array('member_id' => $_POST['memberID'], 'key' => $_POST['memberKEY']))) { $place->UpdateStatusPlace(array('place_id' => $_POST['place'], 'status' => $_POST['status'])); successMessage('Place status updated.'); } else { errorMessage('Access Token Error!'); } break; default: errorMessage('PLACE-API Error!'); break; } break; default: errorMessage('API not found!'); break; } } else { if ($_GET['calling'] != '') {