phpѧϰ±Ê¼Ç£¨11£©:MYSQLÔÚphp5ÖеÄÓ¦ÓÃ
1¡¢phpÓëmysql½¨Á¢Á¬½Ó
php.ini ¼ÓÔØmysql×é¼þ
extension=php_mysql.dllǰµÄ;È¥µô
exetension_dir=""·¾¶ÊÇ·ñÕýÈ·
PhpÁ¬½Ómysqlº¯Êý
mysql_connect:¿ªÆôMYSQLÁ¬½Ó
mysql_select_dir:´ò¿ªÒ»¸öÊý¾Ý¿â
@ºÍor die Òþ²Ø´íÎóºÍÌõ¼þÏÔʾ
mysql_connect("Ö÷»ú","Óû§Ãû","ÃÜÂë");
mysql_select_db("´ò¿ªÊý¾Ý¿â",Á¬½Ó±êʶ·û);
Èç¹û²»ÌرðÉùÃ÷Á¬½Ó±êʶ·û£¬ÔòĬÈÏΪÊÇÉÏÒ»´Î´ò¿ªµÄÁ¬½Ó¡£
2¡¢ÈçºÎÈ¥Ö´ÐÐÒ»¸öSQLÓï¾ä
mysql_query(sqlÓï¾ä,Á¬½Ó±êʶ·û);
˵Ã÷£ºmysql_queryÓÃÀ´¸ù¾ÝÁ¬½Ó±êʶ·ûÏò¸ÃÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°Êý¾Ý¿â·¢ËͲéѯ£¬
Èç¹ûÁ¬½Ó±êʶ·ûĬÈÏ£¬ÔòĬÈÏÈÏΪÊÇÉÏÒ»´Î´ò¿ªµÄÁ¬½Ó¡£
·µ»ØÖµ£º³É¹¦ºó·µ»ØÒ»¸ö½á¹û±êʶ·û£¬Ê§°Üʱ·µ»Øfalse¡£
$sql="select * from test";
$result=@mysql_query($sql,$conn) or die(mysql_error());
3¡¢Á½ÖÖ²éѯº¯Êýarray/rowÇø±ð
¸ñʽ£ºmysql_fetch_row(result);
˵Ã÷£ºmysql_fetch_rowÓÃÀ´²éѯ½á¹ûµÄÒ»Ðб£´æÖÁÊý×飬¸ÃÊý×éϱê´Ó0¿ªÊ¼£¬
ÿһ¸öÊý×éÔªËØ¶ÔÓ¦Ò»¸öÓò¡£Í¨¹ýÑ»·£¬¿ÉÒÔ½«²éѯ½á¹ûÈ«²¿»ñµÃ¡£
¸ñʽ£ºmysql_fetch_array(result);
˵Ã÷£ºmysql_fetch_arrayºÍmysql_fetch_row¹¦ÄÜ»ù±¾Ïàͬ£¬Ö»²»¹ýËü³ýÁË¿ÉÒÔÓÃ
´Ó0¿ªÊ¼µÄÆ«ÒÆÀï×öË÷Òý£¬»¹¿ÉÒÔÓÃÓòÃû×öË÷Òý¡£
mysql_query("set names'GBK'")½â¾öÖÐÎÄÂÒÂë
Öµ·µ»ØÏÂÒ»ÐеÄËùÓÐÓòÖµ£¬²¢½«Æä±£´æÖÁÒ»¸öÊý×éÖУ¬Ã»ÓÐÐÐʱ·µ»Øfalse¡£
4¡¢ÆäËû³£ÓÃMysqlº¯Êý½éÉÜ
mysql_num_rows :ÓÃÓÚ¼ÆËã²éѯ½á¹ûÖÐËùµÃÐеÄÊýÄ¿
mysql_insert_id :´«»Ø×îºóÒ»´ÎʹÓÃinsertÖ¸ÁîµÄid
mysql_tablename :È¡µÃÊý¾Ý¿âÃû³Æ
mysql_error :·µ»Ø´íÎóÐÅÏ¢
mysql_close :¹Ø±ÕmysqlÁ´½Ó
<?php
/*
* Created on 2010-1-3
* Author : CHAUVET
* Function:Êý¾Ý¿âÁ¬½ÓÑÝʾ
*
*/
$conn=mysql_connect("localhost","root","");
if($conn){
echo "Á¬½Ó³É¹¦£¡£¡£¡";
}
printf("<br/>");
//@mysql_connect("localhost","root","good") or die("Á¬½ÓÓÐÎ󣡣¡£¡");
mysql_query("set names 'gb2312'");
mysql_select_db("newdb",$conn);
$ary=mysql_query("select * from `test`",$conn) or die(mysql_error());
//$row=mysql_fetch_row($ary);
//echo($row[1]);
//print_r($row);
//print("<p>");
//$arr=mysql_fetch_array($ary)
Ïà¹ØÎĵµ£º
°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......
ƽʱÎÒÃÇÔÚʹÓÃMySQLÊý¾Ý¿âµÄʱºò¾³£»áÒòΪ²Ù×÷ʧÎóÔì³ÉÊý¾Ý¶ªÊ§£¬MySQLÊý¾Ý¿â±¸·Ý¿ÉÒÔ°ïÖúÎÒÃDZÜÃâÓÉÓÚ¸÷ÖÖÔÒòÔì³ÉµÄÊý¾Ý¶ªÊ§»ò×ÅÊý¾Ý¿âµÄÆäËûÎÊÌâ¡£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆÎªÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸öMySQLÊý¾Ý¿â±¸·ÝTestA£¬²¢»Ö¸´µ½µ½hostB»úÖÐ ......
ÓôÃÆ£¡CSDNµÄ²©¿Í±à¼Æ÷ÓÒ±ßÔõôûÓÐÏÔʾ³öÀ´Íê°¡£¬¸ã¸öʲô“ÈçºÎʹÓÿͻ§¶Ëд²©¿Í”£¬º¦ÎÒÊäÈëµÄ×Ö¶¼±»ÄǸöÌáʾµ²×¡ÁË£¡
תÈëÕýÌ⣺
½ñÌìÒ»´óÔçÆðÀ´£¬´ò¿ªeclipseÆô¶¯tomcat£¬×òÍí»¹Õý³£ÔËÐеÄÒ»¸öÏîĿȴ±¨´í£¬¸øÎÒµÄÐÄÇéÕæÊÇÒ»¸ö´ò»÷ѽ~~ÐÂÄêµÚÒ»Ìì¾Í²»Ì«Ë³Àû£¡
¾¹ý¼ì²é²ÅÖªµÀʹÓõÄÊý¾Ý¿âmysqlûÓÐÆô¶¯£¬ ......
MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×Ö¶Î from ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢&nb ......
¡¡¡¡´Ó PHP 3 ¿ªÊ¼Îª±£´æ¶ÔÏóÌṩÁËÒ»×éÐòÁл¯ºÍ·´ÐòÁл¯µÄº¯Êý£ºserialize¡¢unserialize£¬Ëü¿ÉÒÔ·½±ãµÄ±£´æÊý¾Ý·½±ãµÄ×ö³ÉCACHE£¬¶ø´æ´¢Ìå»ýÒ²±ÈXMLҪСµÄ¶à£¬Ëü½á¹¹Óë JS µÄ JSON ÏàÄâ£¬ÍøÉÏÓÐÒ»×éÓà JS Ä£Äâ serialize ʵÏֵķ½·¨£¬Ê¹ÓÃËü¿ÉÒÔºÍPHP ÔÚÊý¾Ý´«µÝÉϸü½ôÃܵĽáºÏ£®
¡¡¡¡JavaScript °æ±¾£¨stable£©£ ......