PHPÖеij£ÓõÄ25¸öMYSQLº¯Êý
1¡¢mysql_connect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó
¸ñʽ£º
resource mysql_connect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]])
Àý£º
$conn = @mysql_connect(”localhost”, “username”, “password”) or dir(”²»ÄÜÁ¬½Óµ½Mysql Server”);
˵Ã÷£ºÊ¹ÓøÃÁ¬½Ó±ØÐëÏÔʾµÄ¹Ø±ÕÁ¬½Ó
2¡¢mysql_pconnect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó
¸ñʽ£º
resource mysql_pconnect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]])
Àý£º
$conn = @mysql_pconnect(”localhost”, “username”, “password”) or dir(”²»ÄÜÁ¬½Óµ½Mysql Server”);
˵Ã÷£ºÊ¹ÓøÃÁ¬½Óº¯Êý²»ÐèÒªÏÔʾµÄ¹Ø±ÕÁ¬½Ó£¬ËüÏ൱ÓÚʹÓÃÁËÁ¬½Ó³Ø
3¡¢mysql_close()-¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
Àý£º
$conn = @mysql_connect(”localhost”, “username”, “password”) or die(”²»ÄÜÁ¬½Óµ½Mysql Server”);
@mysql_select_db(”MyDatabase”) or die(”²»ÄÜÑ¡ÔñÕâ¸öÊý¾Ý¿â£¬»òÊý¾Ý¿â²»´æÔÚ”);
echo “ÄãÒѾÁ¬½Óµ½MyDatabaseÊý¾Ý¿â”;
mysql_close();
4¡¢mysql_select_db()-Ñ¡ÔñÊý¾Ý¿â
¸ñʽ£º
boolean mysql_select_db(string db_name [, resource link_id])
Àý£º
$conn = @mysql_connect(”localhost”, “username”, “password”) or die(”²»ÄÜÁ¬½Óµ½Mysql Server”);
@mysql_select_db(”MyDatabase”) or die(”²»ÄÜÑ¡ÔñÕâ¸öÊý¾Ý¿â£¬»òÊý¾Ý¿â²»´æÔÚ”);
5¡¢mysql_query()-²éѯMySQL
¸ñʽ£º
resource mysql_query (string query, [resource link_id])
Àý£º
$linkId = @mysql_connect(”localhost”, “username”, “password”) or die(”²»ÄÜÁ¬½Óµ½Mysql Server”);
@mysql_select_db(”MyDatabase”) or die(”²»ÄÜÑ¡ÔñÕâ¸öÊý¾Ý¿â£¬»òÕßÊý¾Ý¿â²»´æÔÚ”);
$query = “select * from MyTable”;
$result = mysql_query($query);
mysql_close();
˵Ã÷£ºÈôSQL²éѯִÐгɹ¦£¬Ôò·µ»Ø×ÊÔ´±êʶ·û£¬Ê§°Üʱ·µ»ØFALSE¡£ÈôÖ´Ðиüгɹ¦£¬Ôò·µ»ØTRUE£¬·ñÔò·µ»ØFALSE
6¡¢mysql_db_query()-²éѯMySQL
¸ñʽ£º
re
Ïà¹ØÎĵµ£º
Ô¤ÆÚ×¼±¸£º
Ò»¸ö139ÓÊÏ䣬ÊÕµ½Óʼþºó£¬¿ÉÒÔÃâ·Ñ¸øÄã¶ÌÐÅÌáÐÑ¡£Èç¹ûÄã²»ÐèÒª¶ÌÐÅÌáÐѹ¦ÄÜ£¬ÓÃʲôÓÊÏ䶼¿ÉÒÔ
ÁíÍâÒ»¸ö¿ÉÒÔÔËÐÐPHPÎļþµÄWeb·þÎñÆ÷£¨Ï൱ÓÚ¼à¿Ø·þÎñÆ÷£©£¬ÏÖÔÚÃâ·ÑµÄPHPÍøÕ¾¿Õ¼äºÜ¶à£¬ÉÏÍøËÑËÑ¡£Èç¹û½«PHP¼à¿ØÎļþ·Åµ½Äã×Ô¼ºµÄ·þÎñ
Æ÷ÉÏ£¬Õâ¸ö¼à¿ØÎļþÒ²¾ÍµÈÓÚ°ÚÉ裬·þÎñÆ÷¹ÒµôÁË£¬ËüÒ²ÎÞ·¨ÔËÐÐÁË£¬ÔõÃ´Ä ......
a:
ΪʲôҪʹÓûº´æ¼¼Êõ£¿ÀíÓɺܼòµ¥£ºÌá¸ßЧÂÊ¡£ÔÚ³ÌÐò¿ª·¢ÖУ¬»ñÈ¡ÐÅÏ¢µÄ·½Ê½Ö÷ÒªÊDzéѯÊý¾Ý¿â£¬³ý´ËÒÔÍ⣬Ҳ¿ÉÄÜÊÇͨ¹ýWeb Services»òÕß±ðµÄijÖÖ·½·¨£¬ÎÞÂÛÄÄÖÖ·½·¨£¬ÔÚ´óÁ¿µÄ²¢·¢·ÃÎÊÃæÇ°£¬ËüÃǶ¼¿ÉÄܳÉΪЧÂʵÄÆ¿¾±£¬ÎªÁ˽â¾öÕâЩÎÊÌ⣬ÈËÃÇÌá³öÁ˺ܶà½â¾ö·½°¸£¬ÆäÖÐÒ» ЩÊÇÀûÓÃÓÅ»¯Èí¼þ£¨È磺APC£¬Eaccelerator£¬ ......
javaÓëmysqlÂÒÂëµÄÎÊÌâ
javaÓëmysqlÂÒÂëµÄÎÊÌâ
¹Ø¼ü×Ö: javaÓëmysqlÂÒÂëµÄÎÊÌâ
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF ......
mysql procedure ûÓÐreturn²ÎÊý ¿ÉÒÔoutÒ»¸ö±äÁ¿¸ø¿Í»§¶Ë µ«ÊÇout²ÎÊýÓÖ²»Ö§³ÖÓαêÀàÐÍ£¬ÈçºÎÄÜout³öÒ»¸ö½á¹û¼¯ÄØ£¿
·½·¨ºÜ¼òµ¥ ¾ÍÊÇÔÚprocedureÀïÖ´ÐÐÒ»¸öselect £¨select .... from ...£©
eg.
CREATE PROCEDURE `CREATE_ACCOUNT`(
ACCOUNT CHAR(32),
PASSWORD CHAR(32), ......
PHP£¬JavaºÍ.NETµÄ¹ýÈ¥£¬ÏÖÔÚºÍδÀ´
±¾ÎĶÔWeb±à³ÌÓïÑÔ½øÐÐÁËÒ»·ÌÖÂÛ£¬ÌÖÂ۵ĶÔÏóÖ÷ÒªÊÇPHP£¬JavaºÍ.NETƽ̨ÉϵÄVB.NETºÍC#¡£ÎÄÕ¶ÔËÄÖÖÓïÑÔÔÚWeb¿ª·¢ÉϵÄÌصã½øÐÐÁ˼òÂÔµÄÃèÊö£¬²¢Ö÷ÒªÔÚÐÔÄÜ·½Ãæ½øÐÐÁ˱Ƚϡ£
¡¾51CTO¾«Ñ¡ÒëÎÄ¡¿PHP£¬JavaºÍ.NETÒѾ³ÉΪÁËδÀ´ÎåÄêÄÚ³ÌÐòÔ±±ØÐë¾ß±¸µÄ¼¼ÄÜ£¬¶øÕâÈýÖÖÓïÑÔ£¨»òÕß¿ÉÒÔ³Æ֮Π......