当前位置: 首页>>代码示例>>PHP>>正文


PHP database::selectSQL方法代码示例

本文整理汇总了PHP中database::selectSQL方法的典型用法代码示例。如果您正苦于以下问题:PHP database::selectSQL方法的具体用法?PHP database::selectSQL怎么用?PHP database::selectSQL使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在database的用法示例。


在下文中一共展示了database::selectSQL方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: database

<style>
#div_preview{
	font-family:Tahoma, Geneva, sans-serif;
	font-size:13px;
}
</style>
<div id="div_preview">
<?


require("class_mysql.php");
$db=new database();
if($_GET['want']=="preview"){
	
	
	$result_preview = $db->selectSQL("content_style");
	$rs_preview=mysql_fetch_array($result_preview);
	$preview_object=$rs_preview[content_header];
	echo"preview_object---->$preview_object";
	$img="../object_system/$preview_object";
	if(!$preview_object){
		echo"ไม่มีไฟล์ข้อมูล";
	}else{
	?>
    
    <img src="<?php 
echo $img;
?>
" />
    <a href="preview_content_style.php?del_file=<?php 
echo $img;
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:preview_content_style.php

示例2:

//ทำการเพิ่มข้อมูลเมื่อมี User ใหม่เข้ามา
if (!$rs_num) {
    $table = "footer_style";
    $field = "admin_id";
    $admin_id = $rs_admin_id['admin_id'];
    $obj_manage_data->insert_data($table, $field, $admin_id);
}
//##### Check table home end #####
//include("fckeditor/fckeditor.php");
$admin_id = $rs_admin_id['admin_id'];
if ($_SESSION['admin_status'] == "3") {
    echo "admin here";
    $admin_id = 1;
}
//Check User and Management by User End
$result_footer = $db->selectSQL("footer_style where admin_id='" . $admin_id . "'");
$rs_footer = mysql_fetch_array($result_footer);
$footer_num = @mysql_num_rows($rs_footer);
$footer_bg = $rs_footer[footer_bg];
$footer_repeat = $rs_footer[footer_repeat];
$footer_color = $rs_footer[footer_color];
?>
<style>
#devtext_title{	
	padding:5px;
	font-weight:bold;
	font-size:13px;
	border-top:#dedede solid 1px;
	border-bottom:#dedede solid 1px;
	background:#efefef;
}
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:style_footer.php

示例3: database

	font-family:Tahoma, Geneva, sans-serif;
	font-size:13px;
}
</style>
<div id="div_preview">
<?
echo"test";
require("class_mysql.php");
$db=new database();
if($_GET['want']=="preview"){
	
	$bg_id=$_GET['bg_id'];
	echo"bg_id---->$bg_id";
	$admin_id=$_GET['admin_id'];
	//echo"object_position------->$object_position";
	$result_preview = $db->selectSQL("bg_style where admin_id='$admin_id'");
	$rs_preview=mysql_fetch_array($result_preview);
	$preview_object=$rs_preview[bg_name];
	
	echo"preview_object---->$preview_object";
	$img="../object_system/$admin_id/$preview_object";
	if(!$preview_object){
		echo"ไม่มีไฟล์ข้อมูล";
	}else{
	?>
    
    <img src="<?php 
echo $img;
?>
" />
    <a href="preview_style_process.php?del_file=<?php 
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:preview_style_process.php

示例4: database

	background:#efefef;
}
#devtext tr td a{
	color:#000;
	text-decoration:none;

	 
}
</style>

<div id="devtext_title">
จัดการใส่รูปภาพลงบน Laout
<?
require("class_mysql.php");
	$db=new database();
	$result_select_style=$db->selectSQL('select_style');
	$rs_select_style=mysql_fetch_array($result_select_style);
	//echo"select_laout_number:$rs_select_labout[select_laout_number]<br>";
	$select_style_number=$rs_select_labout[select_style_number];
	echo"$select_style_number<br>";
?>
</div>
<br style="clear:both" />
<div id="devtext">
<table>
	<tr>
    	<td>
        <a href="index.php?page=style_system&select_page=picture_style&page_style=bg">
        <img src="../images_system/App_Store.png"  border="0"/><br>
        จัดการภาพพื้นหลัง
        </a>
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:picture_style.php

示例5: explode

 //--ต้องแก้ไข
 $file_array = explode(".", $file_name);
 $file_1 = $file_array[0];
 $file_2 = $file_array[1];
 $file_1 = strtolower($file_1);
 $file_2 = strtolower($file_2);
 $now = date("dmyihs");
 $file_1 = $file_1 . $now . '.' . $file_2;
 if ($file_2 == "jpg" or $file_2 == "gif" or $file_2 == "png" or $file_2 == "jpeg" or $file_2 == "swf") {
     if (is_dir($path_object)) {
         $object_name = $file_1;
         //echo"object_name$object_name<br>";
         copy($_FILES["content_header"]["tmp_name"], "../object_system/{$admin_id}/" . $object_name);
         //--ต้องแก้ไข
         //echo"sucessfully";
         $result_object = $db->selectSQL("content_style where admin_id='{$admin_id}'");
         $num_object = mysql_num_rows($result_object);
         $rs_object = mysql_fetch_array($result_object);
         $object_name_edit = $rs_object[content_header];
         //--ต้องแก้ไข
         $unlink = "../object_system/{$admin_id}/{$object_name_edit}";
         if ($unlink) {
             @unlink($unlink);
             //@ไม่ต้องการให้มันฟอ้งถ้าไม่มีไฟลล์ให้ลบ
             //file_exists();ใช้ function นี้ตรวจสอบก่อนว่ามีไฟลล์ใหลบมั้ย
         }
         if ($num_object) {
             //check ถ้ามีข้อมูลอยู่แล้วให้ทำการUpdate
             $strSQL = "UPDATE content_style SET content_header='{$object_name}',content_header_color='{$content_header_color}',content_border_color='{$content_border_color}',content_border_style='{$content_border_style}',content_width='{$content_width}',content_height='{$content_height}',content_font_color='{$content_font_color}',content_bg_color='{$content_bg_color}' where admin_id='{$admin_id}'";
             $query = mysql_query($strSQL);
             if (!$query) {
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:style_content_process.php

示例6: explode

//--ต้องแก้ไข
if ($file_bg) {
    echo "inside";
    $file_array = explode(".", $file_name);
    $file_1 = $file_array[0];
    $file_2 = $file_array[1];
    $file_1 = strtolower($file_1);
    $file_2 = strtolower($file_2);
    $now = date("dmyihs");
    $file_1 = $file_1 . $now . '.' . $file_2;
    if ($file_2 == "jpg" or $file_2 == "gif" or $file_2 == "png" or $file_2 == "jpeg" or $file_2 == "swf") {
        if (is_dir($path_object)) {
            $object_name = $file_1;
            copy($_FILES["footer_bg"]["tmp_name"], "../object_system/{$admin_id}/" . $object_name);
            //--ต้องแก้ไข
            $result_object = $db->selectSQL("footer_style");
            $num_object = mysql_num_rows($result_object);
            echo "num_objec{$num_object}";
            $rs_object = mysql_fetch_array($result_object);
            //$object_position_edit=$rs_object[bg_position];
            $object_name_edit = $rs_object[footer_bg];
            $unlink = "../object_system/{$admin_id}/{$object_name_edit}";
            if ($unlink) {
                @unlink($unlink);
                //@ไม่ต้องการให้มันฟอ้งถ้าไม่มีไฟลล์ให้ลบ
                //file_exists();ใช้ function นี้ตรวจสอบก่อนว่ามีไฟลล์ใหลบมั้ย
            }
            //echo"object_position_edit$object_position_edit";
            //echo"num_object$num_object<br>";
            if ($num_object) {
                //check ถ้ามีข้อมูลอยู่แล้วให้ทำการUpdateและแก้ไขรูปภาพ
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:style_footer_process.php

示例7: strtolower

 $file_2 = $file_array[1];
 $file_1 = strtolower($file_1);
 $file_2 = strtolower($file_2);
 $now = date("dmyihs");
 $file_1 = $file_1 . $now . '.' . $file_2;
 //echo "file1:= $file_1<br>";
 //echo "file2:= $file_2<br>";
 if ($file_2 == "jpg" or $file_2 == "gif" or $file_2 == "png" or $file_2 == "jpeg" or $file_2 == "swf") {
     //echo"hello $file_2<br>";
     if (is_dir($path_object)) {
         $object_name = $file_1;
         //echo"object_name$object_name<br>";
         copy($_FILES["file_header_bg"]["tmp_name"], "../object_system/" . $object_name);
         //--ต้องแก้ไข
         //echo"sucessfully";
         $result_object = $db->selectSQL("object_system where object_position='{$object_position}'");
         $num_object = mysql_num_rows($result_object);
         $rs_object = mysql_fetch_array($result_object);
         $object_position_edit = $rs_object[object_position];
         $object_name_edit = $rs_object[object_name];
         $unlink = "../object_system/{$object_name_edit}";
         if ($unlink) {
             @unlink($unlink);
             //@ไม่ต้องการให้มันฟอ้งถ้าไม่มีไฟลล์ให้ลบ
             //file_exists();ใช้ function นี้ตรวจสอบก่อนว่ามีไฟลล์ใหลบมั้ย
         }
         //echo"object_position_edit$object_position_edit";
         //echo"num_object$num_object<br>";
         if ($num_object) {
             //check ถ้ามีข้อมูลอยู่แล้วให้ทำการลบของเดิม
             $strSQL = "UPDATE object_system SET object_name='{$object_name}',object_position='{$object_position}',object_color='{$object_color}',object_width='{$object_width}',object_height='{$object_height}' where object_position='{$object_position_edit}'";
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:style_process.php

示例8:

//ทำการเพิ่มข้อมูลเมื่อมี User ใหม่เข้ามา
if (!$rs_num) {
    $table = "box_style";
    $field = "admin_id";
    $values = $rs_admin_id['admin_id'];
    $obj_manage_data->insert_data($table, $field, $values);
}
//##### Check table home end #####
//include("fckeditor/fckeditor.php");
$values = $rs_admin_id['admin_id'];
if ($_SESSION['admin_status'] == "3") {
    echo "admin here";
    $values = 1;
}
//Check User and Management by User End
$result_box = $db->selectSQL("box_style where admin_id='" . $values . "'");
$rs_box = mysql_fetch_array($result_box);
$box_num = mysql_num_rows($result_box);
$box_header = $rs_box[box_header];
$box_header_color = $rs_box[box_header_color];
$box_border_color = $rs_box[box_border_color];
$box_border_style = $rs_box[box_border_style];
$box_color_bg = $rs_box[box_color_bg];
$box_color = $rs_box[box_color];
$box_color_over = $rs_box[box_color_over];
$box_color_overed = $rs_box[box_color_overed];
$box_font_color = $rs_box[box_font_color];
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--สี-->
<script language=JavaScript src="javascript/picker.js"></script>
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:style_box.php

示例9: database

<? ob_start();
$db=new database();
?>
<?php 
//require("class_mysql.php");

$result_plugin= $db->selectSQL("plugin_on_web");
$rs_plugin=mysql_fetch_array($result_plugin);
$plugint_num=mysql_num_rows($result_plugin);

$plugin_code=$rs_plugin[plugin_code];
$plugin_name=$rs_plugin[plugin_name];
$plugin_position=$rs_plugin[plugin_position];
$plugin_status=$rs_plugin[plugin_status];
$plugin_important=$rs_plugin[plugin_important];

?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--สี-->
<script language=JavaScript src="javascript/picker.js"></script>
<!--สี-->
<style>
#devtext_title{	
	padding:5px;
	font-weight:bold;
	font-size:13px;
	border-top:#dedede solid 1px;
	border-bottom:#dedede solid 1px;
	background:#efefef;
}
#devtext a{
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:style_plugin.php

示例10: database

<? ob_start();
$db=new database();
?>
<?php 
//require("class_mysql.php");
$result_footer = $db->selectSQL("footer_style");
$rs_footer = mysql_fetch_array($result_footer);
$footer_num = @mysql_num_rows($rs_footer);
$footer_bg = $rs_footer[footer_bg];
$footer_repeat = $rs_footer[footer_repeat];
$footer_color = $rs_footer[footer_color];
?>
<style>
#devtext_title{	
	padding:5px;
	font-weight:bold;
	font-size:13px;
	border-top:#dedede solid 1px;
	border-bottom:#dedede solid 1px;
	background:#efefef;
}
#devtext a{
	color:#000;
	text-decoration:none;

	 
}
</style>
<!-- CKE-->
<script type="text/javascript" src="../ckeditor/ckeditor.js"></script>
<!-- CKE-->
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:style_footer.php

示例11: database

<? ob_start();
$db=new database();
?>
<?php 
//require("class_mysql.php");
$result_bg = $db->selectSQL("bg_style");
$rs_bg = mysql_fetch_array($result_bg);
$bg_num = @mysql_num_rows($rs_bg);
$bg_name = $rs_bg[bg_name];
$bg_repeat = $rs_bg[bg_repeat];
$bg_position = $rs_bg[bg_position];
$bg_color = $rs_bg[bg_color];
$bg_web_color = $rs_bg[bg_web_color];
?>
<style>
#devtext_title{	
	padding:5px;
	font-weight:bold;
	font-size:13px;
	border-top:#dedede solid 1px;
	border-bottom:#dedede solid 1px;
	background:#efefef;
}
#devtext a{
	color:#000;
	text-decoration:none;

	 
}
</style>
<!-- CKE-->
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:style_bg.php

示例12: database

<style>
#div_preview{
	font-family:Tahoma, Geneva, sans-serif;
	font-size:13px;
}
</style>
<div id="div_preview">
<?
$admin_id=$_GET['admin_id'];
require("class_mysql.php");
$db=new database();
if($_GET['want']=="preview"){
	
	$slide_position=$_GET['slide_position'];
	//echo"object_position------->$object_position";
	$result_preview = $db->selectSQL("slide_picture where slide_position='$slide_position' and admin_id='$admin_id'");
	$rs_preview=mysql_fetch_array($result_preview);
	$preview_object=$rs_preview[slide_picture_object];
	echo"preview_object---->$preview_object";
	$img="../slide_picture/$admin_id/$preview_object";
	echo"<br>$img";
	if(!$preview_object){
		echo"ไม่มีไฟล์ข้อมูล";
	}else{
	?>
    
    <img src="<?php 
echo $img;
?>
" />
    <a href="preveiw_slide.php?del_file=<?php 
开发者ID:nong053,项目名称:condo,代码行数:31,代码来源:preveiw_slide.php

示例13: explode

 //--ต้องแก้ไข
 $file_array = explode(".", $file_name);
 $file_1 = $file_array[0];
 $file_2 = $file_array[1];
 $file_1 = strtolower($file_1);
 $file_2 = strtolower($file_2);
 $now = date("dmyihs");
 $file_1 = $file_1 . $now . '.' . $file_2;
 if ($file_2 == "jpg" or $file_2 == "gif" or $file_2 == "png" or $file_2 == "jpeg" or $file_2 == "swf") {
     if (is_dir($path_object)) {
         $object_name = $file_1;
         //echo"object_name$object_name<br>";
         copy($_FILES["button_bg"]["tmp_name"], "../object_system/" . $object_name);
         //--ต้องแก้ไข
         //echo"sucessfully";
         $result_object = $db->selectSQL("button_style");
         $num_object = mysql_num_rows($result_object);
         $rs_object = mysql_fetch_array($result_object);
         $object_name_edit = $rs_object[button_bg];
         //--ต้องแก้ไข
         $unlink = "../object_system/{$object_name_edit}";
         if ($unlink) {
             @unlink($unlink);
             //@ไม่ต้องการให้มันฟอ้งถ้าไม่มีไฟลล์ให้ลบ
             //file_exists();ใช้ function นี้ตรวจสอบก่อนว่ามีไฟลล์ใหลบมั้ย
         }
         if ($num_object) {
             //check ถ้ามีข้อมูลอยู่แล้วให้ทำการUpdate
             $strSQL = "UPDATE button_style SET button_bg='{$object_name}',button_bg_color='{$button_bg_color}'";
             $query = mysql_query($strSQL);
             if (!$query) {
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:style_button_process.php

示例14: database

<? ob_start();
$db=new database();
?>
<?php 
//require("class_mysql.php");
$result_intro = $db->selectSQL("intro_style");
$rs_intro = mysql_fetch_array($result_intro);
$intro_num = @mysql_num_rows($rs_intro);
$intro_bg = $rs_intro[intro_bg];
$intro_repeat = $rs_intro[intro_repeat];
$intro_color = $rs_intro[intro_color];
$intro_detail = $rs_intro[intro_detail];
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
#devtext_title{	
	padding:5px;
	font-weight:bold;
	font-size:13px;
	border-top:#dedede solid 1px;
	border-bottom:#dedede solid 1px;
	background:#efefef;
}
#devtext a{
	color:#000;
	text-decoration:none;

	 
}
</style>
<!-- CKE-->
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:style_intro.php

示例15:

	color:#000;
	text-decoration:none;

	 
}
</style>

<div id="devtext_title">
ภาพสไลด์
</div>
<br style="clear:both">
<div id="box_style">
<div id="box_style_l" style="float:left">
<?php 
//require("class_mysql.php");
$result_slide_1 = $db->selectSQL("slide_picture  where slide_position='1'");
$rs_slide_1 = mysql_fetch_array($result_slide_1);
$slide_num_1 = mysql_num_rows($result_slide_1);
$slide_picture_object_1 = $rs_slide_1[slide_picture_object];
$slide_picture_link_1 = $rs_slide_1[slide_picture_link];
$result_slide_2 = $db->selectSQL("slide_picture where slide_position='2'");
$rs_slide_2 = mysql_fetch_array($result_slide_2);
$slide_num_2 = mysql_num_rows($result_slide_2);
$slide_picture_object_2 = $rs_slide_2[slide_picture_object];
$slide_picture_link_2 = $rs_slide_2[slide_picture_link];
$result_slide_3 = $db->selectSQL("slide_picture  where slide_position='3'");
$rs_slide_3 = mysql_fetch_array($result_slide_3);
$slide_num_3 = mysql_num_rows($result_slide_3);
$slide_picture_object_3 = $rs_slide_3[slide_picture_object];
$slide_picture_link_3 = $rs_slide_3[slide_picture_link];
?>
开发者ID:nong053,项目名称:web-ready,代码行数:31,代码来源:slide_picture.php


注:本文中的database::selectSQL方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。