php³öÏÖÍøÒ³ÂÒÂëÎÊÌâ
ÓÃPHPmyAdmin²Ù×÷MySQLÊý¾Ý¿âºº×ÖÏÔʾÕý³£ £¬µ«ÓÃPHPÍøÒ³ÏÔʾMySQLÊý¾ÝʱËùÓкº×Ö¶¼±ä³ÉÁË?ºÅ¡£
Ö¢×´£ºÓÃPHPmyAdminÊäÈ뺺×ÖÕý³££¬µ«µ±PHPÍøÒ³ÏÔʾMySQLÊý¾Ýʱºº×־ͱä³ÉÁË?ºÅ£¬²¢ÇÒÓжàÉÙ¸öºº×Ö¾ÍÓжàÉÙ¸ö?ºÅ¡£ºÜ¶àѧԱ¶¼Óöµ½ÁË´ËÎÊÌ⣬ÓÈÆäÊÇÔÚ°²×°ÁË×îаæµÄAppservºó¡£Îª´ËÐí¶àѧԱ·ÅÆúÁËPHP£¬¸ÄѧASPÁË¡£
ÔÒò£ºÃ»ÓÐÔÚPHPÍøÒ³ÖÐÓôúÂë¸æËßMySQL¸ÃÒÔʲô×Ö·û¼¯Êä³öºº×Ö¡£
¡ï ½â¾ö·½·¨£º
Õâ²»ÊÇÂÒÂ룬ֻҪÔÚPHPÍøÒ³Í·²¿¼ÓÈëÒÔÏÂÒ»¶Î´úÂë¸æËßMySQLÒÔUTF8±àÂëÊä³öºº×Ö¼´¿É
<? mysql_query("SET NAMES UTF8");? ?>
??????? ÄãÒ²¿ÉÒÔÔÚÍøÒ³ÖÐPHP´úÂ벿·ÖÖ±½Ó²åÈëÉÏÊö´úÂëÆ¬¶Î£¨¼´È¥µôÁ½¶Ë<??>ºÅ£©¡£ÀýÈçÄãÓÃDreamweaverÁ¬½ÓÊý¾Ý¿â£¬ÄÇô¿ÉÒÔÔÚÍ·²¿µÄÁ¬½Ó´úÂë
<?php require_once(”Connections/connmessage.php”); ?>ÖмÓÈë¸Ã´úÂëʹÆä±ä³É<?
php require_once(”Connections/connmessage.php”);
mysql_query("SET NAMES UTF8");?
?? ?>
×¢Ò⣺Èç¹ûÄãµÄÍøÒ³±àÂëÊÇgb2312£¬ÄǾÍÊÇ SET NAMES GB2312¡£µ«±à¼Ô±Ç¿ÁÒÍÆ¼öÍøÒ³±àÂë¡¢MySQLÊý¾Ý±í×Ö·û¼¯¡¢PHPmyAdmin¶¼Í³Ò»Ê¹ÓÃUTF8¡£
Èç¹ûÒÔÉÏ·½·¨»¹ÊÇûÓþͱØÐëÕâÑù£º
1.Ò³ÃæheadÖÐ<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
2.PHPÒ³ÃæÔÚ±£´æµÄʱºòʹÓÃUTF-8±àÂë±£´æ
3.ÔÚMYSQLÖÐн¨Êý¾Ý¿âµÄʱºòÊý¾Ý¿âÑ¡ÔñUTF-8±àÂë
4.ÔÚPHPÁ¬½ÓÊý¾Ý¿âµÄʱºò,Ò²¾ÍÊÇmysql_connect()Ö®ºó¼ÓÈë
mysql_query("SET NAMES ”utf8”");
mysql_query("SET CHARACTER_SET_CLIENT=utf8");
mysql_query("SET CHARACTER_SET_RESULTS=utf8");
Âú×ãÒÔÉÏËĵ㼴¿ÉÍê³ÉȫվUTF-8±àÂë,¶øÇÒÔÚÊý¾Ý¿âÖÐÒ²²»»áÓÐÖÐÎÄÂÒÂë.
Ïà¹ØÎĵµ£º
1. ´´½¨Ë÷Òý
$ sudo /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf --all
Sphinx 0.9.7
Copyright (c) 2001-2007, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf'...
indexing index 'catalog'...
collected 8 docs, 0.0 MB
sorted 0.0 Mhits, 82.8% done
total 8 docs, 149 byt ......
PHPÌṩÁ½¸ö·½±ãÎÒÃÇÒýÓÃÊý¾ÝµÄħ·¨ÒýÓú¯Êýmagic_quotes_gpcºÍmagic_quotes_runtime£¬ÕâÁ½¸öº¯ÊýÈç¹ûÔÚphp.iniÉèÖÃΪONµÄʱºò£¬¾Í»áΪÎÒÃÇÒýÓõÄÊý¾ÝÅöµ½µ¥ÒýºÅ'ºÍË«ÒýºÅ"ÒÔ¼°·´Ð±Ïß \ ÊÇ×Ô¶¯¼ÓÉÏ·´Ð±Ïߣ¬°ïÎÒÃÇ×Ô¶¯×ªÒë·ûºÅ£¬È·±£Êý¾Ý²Ù×÷µÄÕýÈ·ÔËÐУ¬¿ÉÊÇÎÒÃÇÔÚphp²»Í¬µÄ°æ±¾»òÕß²»Í¬µÄ·þÎñÆ÷ÅäÖÃÏ£¬ÓеÄmagic_quotes_g ......
ÏȰ²×°apache http server һ·next£»
ÔÙ°²×°php£¬×¢ÒâÑ¡Ôñ Apache 2.2.x Module£»
°²×°½áÊøÒԺ󣬻¹ÐèÒªÐÞ¸Ä Apache µÄÅäÖÃÎļþ¡£Îļþ·¾¶Îª
C:\Program Files\Apache
Software Foundation\Apache2.2\conf\httpd.conf¡£
Óà Notepad ´ò¿ª
httpd.conf£¬ÔÚÎļþ×îºóÓÐÒÔ¡¡#BEGIN PHP INSTALLER EDITS - RE ......
×¢Òâ:ÒýÓÃ"·ÊÕ¼µÄ²©¿Í http://fatjames.extjs.org.cn/archives/40"
mysql5.x sql-mode ÒýÆðµÄ´íÎó
½ñÌì°²×°Á˸ömysql5.0,ÄÃÁËÒ»¸öºÜ¾ÃÖ®Ç°ÍøÉÏϵijÌÐò¼ì²éÒ»ÏÂÊÇ·ñ¹¤×÷Õý³£.
·¢ÏÖÒÔǰµÄ³ÌÐò¾ÓÈ»²»ÄÜÕý³£ÔËÐÐ,ÌáʾÐÅÏ¢ÈçÏÂ:
Database error: Invalid SQL: INSERT INTO
Survey_UserHistory(userId,jobId,type ......
×î½ü¸ø¹«Ë¾×öÒ»¸ö¼òµ¥µÄÍøÉÏÏîÄ¿£¬ÓÚÊÇÏëµ½ÁËÓÿªÔ´µÄ³ÌÐò£¬ËÑÁËһϣ¬¸Ð¾õͦÓÐÓõģ¬¾Í·¢ÉÏÀ´ÁË¡£
¹úÄÚPHP¿ªÔ´½¨Õ¾³ÌÐòÒ»ÀÀ
¹úÍâµÄ¿ªÔ´¼¼ÊõÒ²Ó°ÏìºÍÍÆ¶¯Á˹úÄÚ¿ªÔ´³ÌÐòµÄ·¢Õ¹£¬ÉÏÎÄÎÒ½éÉܵġ¶¹úÍâÓÅÐ㿪ԴPHP½¨Õ¾³ÌÐòÒ»ÀÀ¡· ÖУ¬ºÜ¶à¹úÍ⿪Դ³ÌÐò²¢²»Ì«·ûºÏÖйúÈ˵ÄʹÓÃϰ¹ß£¬¶ø¹úÄÚÓÐһЩ³§¼Ò»ò¸öÈËÒ²×öÁËһЩ²»´íµÄ²úÆ ......