mysqlÊý¾Ý¿â²åÈëʱ¼äÎÊÌâ - PHP / ¿ªÔ´×ÊÔ´
ÔÚmysqlÊý¾Ý¿âÖп´regtime×ֶεÄʱ¼äÈ«ÊÇÕâÑùµÄ£¬int ÀàÐ͵ġ£ÎÒÔÚmysqlÖеĺ¯Êýnow() , µ«×îºóÏÔʾµÄÊÇ 1970-01-01 08:33:30 , Çë½ÌÊÇÔõô»áÊ¡£ËüÕâÖÖд·¨ÊÇÔõôдµÄ¡£
[code=SQL]1260408600
1262151130
1263202361
1263868682
1263869167
1263869299
1263870797
1263870832
1263870959
1263871816
1263871855
1263871928
1263871996
1263872110
1263872863
1263885264
[/code]
Èç¹ûÊÇphp£¬ÄÇôÕâ¸öÖµÊÇtime()µÄÖµ
ÎÒÓõÄÊǵÚÈý·½µÄϵͳshopex £¬ ÕâÀïµÄÀàÐͲ»Äܸġ£»áÓ°ÏìÆäËüµÄ¡£
select UNIX_TIMESTAMP(regtime) from sdb_members
²é³öÀ´È«ÊÇ 0
select from_UNIXTIME(regtime) from sdb_members
лл¿ÉÒÔÁË~£¡
Ïà¹ØÎÊ´ð£º
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)ÖеÄÊý¾ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
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
Í ......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......