¹ØÓÚMySQLµÄ²éѯ½á¹û
´úÂëÈçÏ£º
$sql = "select count(*) from admin";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
echo $num;
Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬
ÎÒÏëÊä³ö²éѯµÄ½á¹û£¬Ó¦¸ÃÔõôÐ޸ģ¿
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
jspÌá½»Ò³±àÂëÊÇUTF-8£¬MYSQL¿âÒ²ÊÇUTF-8,ΪʲôÌá½»ÁËÖÐÎÄ×Ö·ûÔÚÊý¾Ý¿âÀï±ä³ÉÂÒÂëÁËÄØ£¿
ÕâÖÖÎÊÌâÔõô½â¾ö£¿Ð»Ð»
ÁíÍ⣬JSPµ¯³ö¶Ô»°¿ò£¨±ÈÈ絯³ö¡°XXXÉóºËͨ¹ý¡±ÏÂÃæ¸úÈ·¶¨°´Å¥£©ºÍ·µ»ØÉÏÒ»Ò³ÒÔ¼°×ªµ ......
ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....
mysql_query("set names gb2312")
ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType=&q ......
ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£
Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£
......
ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁ˰ɡ£
¸Õѧmysql,ÕÕ×ÅÊ ......