PHP½«Í¼Æ¬´æÈëMYSQL
ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
ǰÌ᣺
1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏȰÑpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pic` (
`pic_id` int(11) NOT NULL auto_increment,
`pic_userid` int(11) NOT NULL,
`pic_content` longblob NOT NULL,
PRIMARY KEY (`pic_id`)
)
ÔÙ½Ó×ÅÐÞ¸Äcommon_db.phpÖеÄÊý¾Ý¿âÁ¬½ÓµÄÓû§ÃûºÍÃÜÂ룬¸ù¾ÝÄãMYSQLÉèÖõÄÀ´
×îºóÔËÐÐupload.phpÎļþ½øÐÐÉÏ´«£¬¶ødisplay_all.phpÊÇÏÔʾÊý¾Ý¿âÖÐËùÓеÄͼƬ
ͼƬÉÏ´«upload.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÉÏ´«</title>
</head>
<body>
<form action="post_action.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
<p> </p>
<p>
<label></label>
<label>
<input type="file" name="file" />
</label>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Ìá½»" />
</label>
</p>
<p> </p>
</form>
</body>
</html>
Á¬½ÓÊý¾Ý¿âµÄcommon_db.php:
<?php
/**
* Á¬½ÓÊý¾Ý¿âµÄº¯Êý
* Á¬½Ó³É¹¦½«»á·µ»ØÒ»¸öÁ¬½Ó×ÊÔ´
* @return mix
*/
function getLink() {
$link = mysql_connect("localhost","root","") or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Óʧ°Ü!");
if(!mysql_select_db("crm",$link)) die("Êý¾Ý¿âÁ¬½Óʧ°Ü!");
return $link;
}
?>
´¦ÀíÉÏ´«µÄpost_action.php:
<?php
/**
* ±¾ÎļþÊǽ«Í¼Æ¬ÎļþÉÏ´«µ½·þÎñÆ÷¶Ë
* ²¢ÇÒ¶ÁÈ¡¸ÃÎļþµÄ¶þ½øÖÆÄÚÈÝ´æÈëµ½MYSQLµÄ
* pic±íÖÐlongblob×Ö¶Î
*
*/
//Ç¿ÖÆÒ³ÃæÊ¹ÓÃgb2312±àÂë
header("Content-Type: text/
Ïà¹ØÎĵµ£º
Mysql³£ÓÃÃüÁî½Å±¾
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÊÇ mysql -hÖ÷»ú -uÓû§Ãû -pÃØÃÜ
Àý×ÓÊÇ mysql -hlocalhost -uroot -p123456
Ҫȷ¶¨mysql°²×°Ê±ºò¹´Ñ¡ÁË¿ÉÒÔÔ¶³ÌÁ´½Ó¡£Èç¹ûµÇ½±¾µØ¼ÆËã»ú£¬-h¿ÉÒÔÊ¡ÂÔ£¬¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬 ......
1.PHP±à³ÌÄÜÁ¦
2.MysqlÄÜÁ¦
A.Á˽⣺֪µÀʹÓÃPHPÁ´½ÓÊý¾Ý¿â£»¶®µÃһЩ¼òµ¥µÄSQL;½¨Á¢Ò»Ð©¼òµ¥µÄË÷Òý£»¶®µÃÓù¤¾ß¼òµ¥²Ù×÷Ò»ÏÂÊý¾Ý¿â£¨Ôöɾ¸Ä²éÊý¾Ý±í½á¹¹£©¡£
B.ÊìϤ£º¶®µÃÔÚ¿ª·¢Ó¦ÓÃÉÏÉè¼ÆÊý¾Ý¿â£¬½¨Á¢Ò»Ð©ÓÐЧµÄË÷Òý£¬ÓÃexplain·ÖÎöSQLÐÔÄÜ£¬Ñ¹Á¦²âÊԵȵȡ£
C.ºÜÊìϤ£ºÉîÈëÁ˽âÊý¾Ý¿âË÷Òý£¬´æ´¢ÒýÇæÔÀíÒÔ¼°ÔËÐлúÖÆ£ ......
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£s ......
Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid adate
1 a1
2 a2
3 a3
TableB
bid bdate
1 b1
2 b2
4 b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......