PHP Database::ExecuteQuery Examples

Example #1

File: reg.php Project: Zerolone/mybbs

     echo '添加会员失败！';
     DebugStr($MyDatabase->SqlStr);
     exit;
 }
 //插入会员扩展数据表
 $ArrField = array('uid', 'postnum', 'rvrc', 'money', 'lastvisit', 'thisvisit', 'onlineip');
 $ArrValue = array($winduid, 0, $rg_regrvrc, $rg_regmoney, TIMESTAMP, TIMESTAMP, ONLINEIP);
 if ($MyDatabase->Insert('user_ext', $ArrField, $ArrValue)) {
 } else {
     echo '添加会员扩展数据失败！';
     exit;
 }
 //更新论坛信息，最新会员，总会员数
 $SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'bbsinfo` SET `newmember`=\'' . $rg_name . '\',`totalmember`=`totalmember`+1 WHERE id=1';
 $MyDatabase->SqlStr = $SqlStr;
 $MyDatabase->ExecuteQuery();
 /*
 	$ArrField=array('newmember',		'totalmember');
 	$ArrValue=array($rg_name, 			'totalmember+1');
 	if($MyDatabase->Update('bbsinfo', $ArrField, $ArrValue, '`id`=1')){
 	}else{
 		echo '更新会员数据失败！';
 		DebugStr($MyDatabase->SqlStr);
 		exit();
 	}*/
 $windid = $rg_name;
 $windpwd = $rg_pwd;
 if ($rg_yz == 1) {
     Cookie("winduser", $winduid . "\t" . $windpwd);
     Cookie("ck_info", DB_CKPATH . "\t" . DB_CKDOMAIN);
     Cookie('lastvisit', '', 0);

Example #2

File: index.php Project: risos007/thechurch

<?
include("Grid.class.php");
include("DB/DataBase.class.php");
include("GridSource.class.php");
include("GridPresenter.class.php");


$date = Database::ExecuteQuery("SELECT fecha FROM reservaciones LIMIT 0,1");
$concat = Database::ExecuteQuery("SELECT CONCAT(sum(nadultos), '.', sum(nninios)) FROM reservaciones WHERE id = 7");

#echo $d = $date[0][0];
#echo strlen($d);
/*
echo " ";
echo $c = $concat[0][0];
echo "<br/>";
echo $sum = $d+$c;

if(is_float($c))
	echo	"true";
else
	echo "false";
*/
$sql = "
 SELECT resultados.Agencias                            ,
  SUM(resultados.AdultosTour1)'Adultos Mayan Adventure',
  SUM(resultados.NiniosTour1) 'Niños Mayan Adventure'  ,
  SUM(resultados.AdultosTour2) 'Adultos Tulum Xtreme'  ,
  SUM(resultados.NiniosTour2) 'Niños Tulum Xtreme'     ,
  SUM(resultados.AdultosTour3)'Adultos Mayan Xtreme'   ,
  SUM(resultados.NiniosTour3) 'Niños Mayan Xtreme'     ,

Example #3

File: article.php Project: Zerolone/myblog

 /**
  * 根据编号，增加一个点击
  *
  */
 function UpdateHits($id)
 {
     $CateTitle = '';
     //-------------------0
     $SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'article`';
     $SqlStr .= ' SET `hits`=`hits`+1';
     $SqlStr .= ' WHERE 1=1';
     $SqlStr .= ' AND `id`=' . $id;
     $MyDatabase = new Database();
     $MyDatabase->SqlStr = $SqlStr;
     $MyDatabase->ExecuteQuery();
 }