¹ØÓÚ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Ìõ¡£Õâ¾ÍºÜÆæ¹ÖÁË¡£µ½µ×ÊÇÔõô»ØÊÂÄØ£¿
¹þ¹þ£¬ÕæÊÇÈç´Ë¡£Ð»¹ýÁË
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
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)ÖеÄÊý¾ ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......
Çë½Ì¸ßÊÖ°ïæ£¬session_start£¨£©·ÅÔÚÍⲿµÄÎļþÓà require »ò include °üº¬½øÀ´£¬ÇëÎÊÕâÑù×öºÏÀíÂ𣿣¿´úÂëÔËÐÐÊÇÕý³£µÄ£¬ÕâÑù×öºÏÀíÂ𣿣¿Çë¸ßÊÖÖ¸µã¡£¡£¡£¡£ лл····
require »ò include ......