PHPÖеij£ÓõÄ25¸öMYSQLº¯Êý
1¡¢mysql_connect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó {3RY4HVT?
¸ñʽ£º Fv n:V\eb
resource mysql_connect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]]) _I;+p eq
Àý£º 1(V>8}zn
$conn = @mysql_connect("localhost", "username", "password") or dir("²»ÄÜÁ¬½Óµ½Mysql Server"); LqnN5l@ _B
˵Ã÷£ºÊ¹ÓøÃÁ¬½Ó±ØÐëÏÔʾµÄ¹Ø±ÕÁ¬½Ó !mFx= +
hQ!slO
2¡¢mysql_pconnect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó F.P4c:GD
¸ñʽ£º =$`xis\
resource mysql_pconnect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]]) KjR^6v
Àý£º \VL[,z=q.
$conn = @mysql_pconnect("localhost", "username", "password") or dir("²»ÄÜÁ¬½Óµ½Mysql Server"); 19od# d3+
˵Ã÷£ºÊ¹ÓøÃÁ¬½Óº¯Êý²»ÐèÒªÏÔʾµÄ¹Ø±ÕÁ¬½Ó£¬ËüÏ൱ÓÚʹÓÃÁËÁ¬½Ó³Ø bH}6N>Fp
b&.j>=
3¡¢mysql_close()-¹Ø±ÕÊý¾Ý¿âÁ¬½Ó %1Gat6V<'
Àý£º 1 h(oty2p
$conn = @mysql_connect("localhost", "username", "password") or die("²»ÄÜÁ¬½Óµ½Mysql Server"); S4]}/Imn)
@mysql_select_db("MyDatabase") or die("²»ÄÜÑ¡ÔñÕâ¸öÊý¾Ý¿â£¬»òÊý¾Ý¿â²»´æÔÚ"); /60 `"xH
echo "ÄãÒѾÁ¬½Óµ½MyDatabaseÊý¾Ý¿â"; Sbub|
mysql_close(); Ui6f>0?
@MIBW)P<
4¡¢mysql_select_db()-Ñ¡ÔñÊý¾Ý¿â j&(2ze:=*$
¸ñʽ£º ?qr-t+
boolean mysql_select_db(string db_name [, resource link_id]) loVUB'OSv
Àý£º $M\|zUQu.
$conn = @mysql_connect("localhost", "username", "password") or die("²»ÄÜÁ¬½Óµ½Mysql Server"); m#SDB6l
@mysql_select_db("MyDatabase") or die("²»ÄÜÑ¡ÔñÕâ¸öÊý¾Ý¿â£¬»òÊý¾Ý¿â²»´æÔÚ"); "&/:"~r
,eq[X\B>
5¡¢mysql_query()-²éѯMySQL )&di c6r
¸ñʽ£º ?Dro)fH1
resource mysql_query (string query, [resource link_id]) z'a#lA.$}
Àý£º $Gb] K{e
$linkId = @mysql_connect("localhost", "username", "password") or die("²»ÄÜÁ¬½Óµ½Mysql Server"); Ju$=Tn
@mysql_select_db("MyDatabas
Ïà¹ØÎĵµ£º
MySQL×Ö·û´®ÁÐÀàÐÍÇø·Ö
1.
Ê×ÏÈCHAR, VARCHAR, TEXTºÍBINARY, VARBINARY, BLOBµÄÇø±ð£º
CHAR, VARCHAR, TEXT³ÆΪ·Ç¶þ½øÖÆ×Ö·û´®£»
BINARY, VARBINARY, BLOB³ÆΪ¶þ½øÖÆ×Ö·û´®£»
¶þ½øÖÆ×Ö·û´®ºÍ·Ç¶þ½øÖÆ×Ö·û´®µÄÇø±ðÊÇ£º
¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö½Ú×Ö·û´®£¬·Ç¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö·û×Ö·û´®£»
ºóÕß¿ÉÒÔ¶¨Òå×Ö·û¼ ......
mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin" ......
±¾ÊµÀýÖ»ÀûÓõ½JQueryÀà¿â±¾ÉíµÄº¯ÊýºÍ¹¦ÄÜ£¬²»ÐèÒªµÚÈý·½²å¼þµÄÖ§³Ö¡£ÁíÍ⣬ËùÓÐ±íµ¥ÐÅÏ¢¶¼ÊÇÀûÓÃPHPMailerÀà¿âÓʼþµÄÐÎʽ·¢Ë͸ø¹ÜÀíÔ±¡£Èç¹ûÄã¶ÔJQueryµÄ»ù±¾Óï·¨»¹²»ÊǺÜÊìϤ£¬ÇëËÑË÷±¾Õ¾µÄ½Ì³Ì×ÊÔ´¡£Èç¹ûÄã¶ÔPHPMailerÓ÷¨²»ÊìϤ£¬Çë²é¿´±¾Õ¾µÄÁíһƪÎÄÕ¡¶Ê¹ÓÃPHPMailerÀà¿â·¢Ë͵ç×ÓÓʼþ¡·¡£
µÚÒ»²½£¬´´½¨Ò»¸ö±íµ¥HTM ......
±¾ÎÄתÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......
һѡÔñÌ⣺
1.ÏÂÃæµÄÄǸöÑ¡Ïî¿ÉÒÔ»ñÈ¡±íµ¥Ìá½»µÄÖµ£¿£¨¶àÑ¡£© b d
<form name='frm1' method="post">
<input type="text" name="name" ><input type="submit" name="a">
</form>
A.$_GET['name']
B.$_POST['name']
C.$_SESSION['name']
D.$_REQUEST['name']
E.$_GLOBAL['name']
2.ÍüÀ²¡£ ......