¹ØÓÚmysql²éѯÓï¾ä ÎҺܲˣ¡
ÔÚÒ»¸ö½Ì³ÌÉÏ¿´µ½ÈçÏ´úÂ룺
$db = 'samples';
mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
echo ' <b>µÚ¶þ²½: </b> ³É¹¦Á¬½Óµ½ ('.$db.') ! <BR>';
ÇëÎÊ Èç¹û²»³É¹¦ Ò²¾ÍÊÇdie»áÏÔʾ ÄÇô µÚ¶þ²½ÄÇÒ»¾ä»°»á²»»áÏÔÊ¾ÄØ£¿
ÎÒ¾õµÃÈç¹ûû³É¹¦µÄ»°»áÏÔʾ:
Could not select database samples because of : ..............
µÚ¶þ²½:³É¹¦Á¬½Óµ½samples!
ÇëÎÊΪʲô ʧ°ÜµÄ»° echo ' <b>µÚ¶þ²½: </b> ³É¹¦Á¬½Óµ½ ('.$db.') ! <BR>';
Ò»¾ä²»»áÏÔÊ¾ÄØ£¿ ÕâÒѾÊÇÏÂÒ»¾ä»°Á˰¡
·Ç³£¸Ðл£¡ÎÒµÄapiÀï¶Ôdieûһ¸öÖйú×Ö¡£¡£ ÎÒÖ»¿´µ½ÁËexit() Õâ»ØÃ÷°×ÁË£¡Ð»Ð»ÁË£¡
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÈçºÎ°ÑMySQLÖÃÓÚÖ»¶Á£¨²»Ê¹ÓÃread_only±äÁ¿£ºhttp://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_read_only£©£¿
ÏÖÔÚÓÐÒ»¸öÇ¨ÒÆ³ÌÐò¡£ÎÒ´òËã¹ýÁËÇ¨ÒÆÈÕÖ®ºó£¬¾Í³ÌÐòÒÀÈ»¿ÉÓ㬵«ÊDZ£³ÖÖ» ......
100215 9:55:47 [Warning] Aborted connection 247 to db: 'gases' user: 'root' host: 'localhost' (Got an error reading communication packets)
100215 9:55:47 [Warning] Aborted connection 257 to db: 'ga ......
PHPÖУ¬Ê¹ÓÃmysqlÊý¾Ý¿â,Linuxϵͳ¡£
ÔÚʹÓÃËÑË÷¹¦ÄÜʱ£¬Ö±½ÓÖ´ÐÐÕâÑùµÄÓï¾ä°²È«Âð£¿
$keyword=$_POST["keyword"];
$sql="select * from abc where a_name like '%$keyword%'";
$rs=mysql_q ......