PHP tchsp_cls_dbquery::tchsp_image_details_count 예제들

예제 #1

파일: tiny-carousel-query.php 프로젝트: mishravijay/coiner

 public static function tchsp_image_details_default()
 {
     global $wpdb;
     $prefix = $wpdb->prefix;
     $result = tchsp_cls_dbquery::tchsp_gallery_details_count(0);
     if ($result == 0) {
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_gallery` (`gal_title`, `gal_width`,`gal_height`) \r\r\n\t\t\tVALUES (%s, %d, %d)", array("Default Gallery", 100, 75));
         $wpdb->query($sql);
     }
     $result = tchsp_cls_dbquery::tchsp_image_details_count(0);
     if ($result == 0) {
         $img_title1 = "Tiny Carousel Horizontal Slider Plus Image 1";
         $img_title2 = "Tiny Carousel Horizontal Slider Plus Image 2";
         $img_title3 = "Tiny Carousel Horizontal Slider Plus Image 3";
         $img_title4 = "Tiny Carousel Horizontal Slider Plus Image 4";
         $img_imageurl1 = TCHSP_URL . "images/Sing_1.jpg";
         $img_imageurl2 = TCHSP_URL . "images/Sing_2.jpg";
         $img_imageurl3 = TCHSP_URL . "images/Sing_3.jpg";
         $img_imageurl4 = TCHSP_URL . "images/Sing_4.jpg";
         //$img_imageurl5 = TCHSP_URL . "images/Sing_5.jpg";
         //$img_imageurl6 = TCHSP_URL . "images/Sing_6.jpg";
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title1, $img_imageurl1, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title2, $img_imageurl2, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title3, $img_imageurl3, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title4, $img_imageurl4, "1"));
         $wpdb->query($sql);
         //$sql = $wpdb->prepare("INSERT INTO `".$prefix."tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`)
         //VALUES (%s, %s, %d)", array($img_title, $img_imageurl5, "1"));
         //$wpdb->query($sql);
         //$sql = $wpdb->prepare("INSERT INTO `".$prefix."tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`)
         //VALUES (%s, %s, %d)", array($img_title, $img_imageurl6, "1"));
         //$wpdb->query($sql);
     }
     return true;
 }

예제 #2

파일: tiny-carousel-image-edit.php 프로젝트: mishravijay/coiner

<?php

if (preg_match('#' . basename(__FILE__) . '#', $_SERVER['PHP_SELF'])) {
    die('You are not allowed to call this page directly.');
}
?>

<div class="wrap">
<?php 
$did = isset($_GET['did']) ? $_GET['did'] : '0';
if (!is_numeric($did)) {
    die('<p>Are you sure you want to do this?</p>');
}
// First check if ID exist with requested ID
$result = '0';
$result = tchsp_cls_dbquery::tchsp_image_details_count($did);
if ($result != '1') {
    ?>
<div class="error fade"><p><strong><?php 
    _e('Oops, selected details doesnt exist.', TCHSP_TDOMAIN);
    ?>
</strong></p></div><?php 
} else {
    $tchsp_errors = array();
    $tchsp_success = '';
    $tchsp_error_found = FALSE;
    $data = array();
    $data = tchsp_cls_dbquery::tchsp_image_details_select($did);
    // Preset the form fields
    $form = array('img_id' => $data[0]['img_id'], 'img_title' => $data[0]['img_title'], 'img_imageurl' => $data[0]['img_imageurl'], 'img_link' => $data[0]['img_link'], 'img_linktarget' => $data[0]['img_linktarget'], 'img_display' => $data[0]['img_display'], 'img_gal_id' => $data[0]['img_gal_id']);
}