¹ØÓÚmysql²éѯ·µ»ØÊý×éµÄÒ»¸öСÎÊÌâ - PHP / »ù´¡±à³Ì
ÎÒÓÐÒ»¸ö²éѯ
$arr_status = array('1' => 'ÉêÇëÖÐ', '2'=>'´¦ÀíÖÐ', '3' => 'ÒÑ·¢»õ', '4' => 'ÒÑÍË¿î');
$lotterylist = array();
$sqltext = "SELECT* from {$tablepre}exchange WHERE uid = '$discuz_uid' ORDER BY exchangetime DESC LIMIT $start_limit, $tpp";
$query = $db->query($sqltext);
while($lottery = $db->fetch_array($query)) {
$lotterylist[$lottery['giftid']] = $lottery;
$lotterylist[$lottery['giftid']]['status_name'] = $arr_status[$lottery['status']];
$lotterylist[$lottery['giftid']]['exchangetime'] = date('m-d H:i',$lottery['exchangetime']);
}
Íê³ÉÖ®ºó£¬ÎÒÓÃcount($lotterylist)µÃµ½µÄ½á¹ûÊÇ4
µ«ÊÇÎÒprint³ö$sqltext£¬Äõ½Êý¾Ý¿âÈ¥Ö´ÐУ¬µÃµ½µÄ¼Ç¼½á¹ûÓÐ9Ìõ¡£Õâ¾ÍºÜÆæ¹ÖÁË¡£µ½µ×ÊÇÔõô»ØÊÂÄØ£¿
¹þ¹þ£¬ÕæÊÇÈç´Ë¡£Ð»¹ýÁË
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......