»ñÈ¡ mysql ·þÎñÆ÷µÄʱ¼ä£¬·µ»Ø¿Õ£¿
<?php $conn=............. function GetNowTime(){ $rvt=mysql_query("select now() as svTime",$conn); $rt=mysql_fetch_object($rvt); return $rt->svTime; mysql_free_result($rvt); mysql_close($conn); } echo GetNowTime() //²»ÄÜ»ñÈ¡mysql ·þÎñÆ÷µÄµ±Ç°Ê±¼ä£¬Õâ¸ö·½·¨¶ÔÂ𣿠?>
mysqlµÄµ±Ç°Ê±¼äº¯ÊýΪnow(); phpµÄµ±Ç°Ê±¼äº¯ÊýΪdate(); ÏëÓà php »ñÈ¡ mysql ·þÎñÆ÷µÄʱ¼ä£¬¶ø²»ÊÇ php ËùÔÚ·þÎñÆ÷µÄʱ¼ä¡£ »ñÈ¡²»ÁËʱ¼ä ÊDz»ÊÇ ¸ú·þÎñÆ÷Óйأ¿ÒýÓà »ñÈ¡²»ÁËʱ¼ä ÊDz»ÊÇ ¸ú·þÎñÆ÷Óйأ¿ ÄãдµÄº¯ÊýÀïÃæµÄ $conn ÊǸö¿Õ±äÁ¿£¬ËùÒÔº¯ÊýûÓÐÁ¬½ÓÉÏÊý¾Ý¿â£¬µ¼ÖÂÈ¡²»µ½Öµ Äã¿ÉÒÔÔÚº¯ÊýÀïÃæ global $conn; ¾Í¿ÉÒÔÁË // $conn ÔÚº¯ÊýÍâ´´½¨µÄÊý¾Ý¿âÁ¬½Ó
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÏÖÔÚÎÒÏë°ÑmysqlÊý¾ÝÀïµÄÊý¾Ý¿âÃû£ºmysqlDB,±íÃû£ºcdb_members£¬×ֶΰüº¬name password headpic addtime jifen SQLÊý¾Ý¿âÀï Êý¾Ý¿âÃû£ºsq_ha315a ±íÃû£ºfs_ms_user ×Ö¶ÎÒ²°üº¬name password headpic addti ......