PHP Database::getPictureTbl Examples

Example #1

File: getting_transaction.php Project: pattadonprapin/wlbsapp

function get_picture($json)
{
    $database = new Database();
    $pictureTbl = $database->getPictureTbl();
    $pictures = $pictureTbl->getAllByShopId($json->{'ShopId'});
    $ret_array = array();
    $cnt = 0;
    foreach ($pictures as $pic) {
        $ret_array[$cnt++] = array("PictureId" => (int) $pic->PictureId, "Name" => $pic->Name, "ShopId" => (int) $pic->ShopId, "SavePath" => $pic->SavePath);
    }
    echo "{Picture : " . json_encode($ret_array) . "}";
    exit;
}

Example #2

File: saving_transaction.php Project: pattadonprapin/wlbsapp

function save_picture($json)
{
    $newFilename = "";
    if (!empty($_FILES['file']['name'])) {
        $filename = $_FILES['file']['name'];
        $spt = explode(".", $filename);
        $extension = $spt[1];
        $newFilename = "resource/shop/" . uniqid(date('mdy', time())) . "." . $extension;
        $isMove = move_uploaded_file($_FILES['file']['tmp_name'], "../" . $newFilename);
        if (!$isMove) {
            echo_save_unsuc_msg();
        }
    }
    $database = new Database();
    $pictureTbl = $database->getPictureTbl();
    $picture = new Picture();
    $picture->Name = $json->{'Name'};
    $picture->ShopId = $json->{'ShopId'};
    $picture->SavePath = $newFilename;
    $success = $pictureTbl->save($picture);
    if ($success) {
        echo_save_suc_msg();
    } else {
        echo_save_unsuc_msg();
        unlink("../" . $newFilename);
    }
}

Example #3

File: removing_transaction.php Project: pattadonprapin/wlbsapp

function remove_picture($json)
{
    $database = new Database();
    $pictureTbl = $database->getPictureTbl();
    $picture = $pictureTbl->get($json->{'PictureId'});
    if (!empty($picture->SavePath)) {
        unlink("../" . $picture->SavePath);
    }
    $success = $pictureTbl->remove($json->{'PictureId'});
    if ($success) {
        echo_rm_suc_msg();
    } else {
        echo_rm_unsuc_msg();
    }
}