Example #1
0
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>";
    }
}
Example #2
0
            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 {
Example #3
0
 * 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>
Example #4
0
                    } 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'] != '') {