³¬¼¶¼òµ¥µÄphp+mysqlÁôÑÔ±¾Ô´Âë
¹²3¸öÎļþ
IncDB.phpÊý¾Ý¿âÁ¬½Ó
index.phpÊ×Ò³
InsetToDB.phpÊý¾Ý¿â²Ù×÷
Êý¾Ý¿âlguestbookÀïÃæ½¨±í
CREATE TABLE `intd` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_bin NOT NULL,
`text` text character set utf8 collate utf8_bin NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=11 ; //´Ë¾ä²Î¿¼ÏÂÃæµÄÀ©Õ¹ÄÚÈÝ£»
IncDB.phpÊý¾Ý¿âÁ¬½Ó
<?php
$link=mysql_connect('localhost','root','root');
if(!$link)
{
die("<center>³ö´íÀ²:1!</center>");
}
if(!mysql_select_db('guestbook',$link))
{
die("<center>³ö´íÀ²:2!</center>");
}
?>
index.php´úÂë
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<?php
include("IncDB.php");
$result=mysql_query("SELECT * from intd",$link);
$row=mysql_fetch_row($result);
while($row)
{
echo "ID: ".$row[0]." ÐÕÃû: ".$row[1]." ʱ¼ä: ".$row[3]."<br>";
echo $row[2];
echo "<hr><br>";
$row=mysql_fetch_row($result);
}
mysql_close($link);
?>
<form method="POST" action="InsetToDB.php">
êdzÆ:<input type="text" size="8"; name="name">
<p>ÄÚÈÝ:<textarea rows="5" name="text" cols="60"></textarea>
</p>
<p><input type="submit" value="Ìá½»" name="B1"><input type="reset" value="ÖØÖÃ" name="B2"></p>
</form>
InsetToDB.phpµÄ´úÂ룺
<?php
include("IncDB.php");
$name=addslashes($_POST['name']);
$text=addslashes($_POST['text']);
$sql = "INSERT INTO `intd` (`id`, `name`, `text`, `datetime`) VALUES (NULL,
Ïà¹ØÎĵµ£º
ÓÅ»¯mysqlÊ×ÏÈÓ¦¸Ã¶àÓÃexplain select ,show variables, show status ,show processlistÕâЩ¹¤¾ß¡£
ÔÚдsqlµÄʱºò£¬ÔÚ´ó±íÉϲ»×ögroup by ²Ù×÷¡£
¶ÔÓÚË÷Òý£º
1.²»ÒªË÷ÒýÄã²»ÏëÒªµÄ¶«Î÷¡£
2.mysqlÄÜʹÓÃË÷ÒýµÄÇé¿ö£º> ,>=, =, <,<= ,if null ÒÔ¼°between
3.mysql²»Ê¹ÓÃË÷ÒýµÄÇé¿ö£ºÈç¹ûmysqlÄܹÀ¼Æ³ö ......
Ò».HTMLÒ³Ãæ×ªUTF-8±àÂëÎÊÌâ
1.ÔÚ<head>ºó£¬<title>ǰ¼ÓÈëÒ»ÐУº
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
˳Ðò²»ÄÜ´í£¬Ò»¶¨ÒªÔÚ<title>±êǩǰ¼ÓÈ룬·ñÔòÈç¹û<title>Óë</title>Ö®¼äÓÐÖÐÎÄ×Ö·ûµÄ»°£¬
ÏÔʾµÄ±êÌâÓпÉÄÜÊÇÂÒÂ룡
2.htmlÎ ......
sessionÎļþ±£´æÔÚ·þÎñÆ÷£¬¶Ôÿ¸ösession¶¼»áËæ»úÉú³ÉÒ»¸öΨһµÄsessionIdÀ´½øÐбêʶ£¬Ò»°ãÈç¹ûûÓÐÉèÖÃsessionµÄÉú´æÖÜÆÚ£¬Ôòsession»á±£´æÔÚÄÚ´æÖУ¬¹Ø±Õä¯ÀÀÆ÷£¬¸Ãsessionid»á×Ô¶¯×¢Ïú£¬ÖØÐÂÇëÇóʱÔò×Ô¶¯ÖØÐ·ÖÅä¡£
Èç¹û¿Í»§¶ËûÓнûÓÃcookie£¬ÔòÔÚʹÓÃsessionʱ£¬cookie»á°èÑÝ´æ´¢sessionIdºÍsessionÉú´æÖÜÆÚµÄ½ÇÉ«¡£¡ ......
PHPÖоÓȻûÓжÁÈ¡BMP¸ñʽͼƬµÄº¯Êý,»¹ºÃ¸ßÈËÒѾдºÃÒ»¸ö,ÎÒû¿´´úÂë,·´ÕýÄÜÕý³£Ê¹ÓÃ.
imagecreatefrombmp -- ´Ó BMP Îļþ»ò URL н¨Ò»Í¼Ïñ
function imagecreatefrombmp($file)
{
global $CurrentBit, $echoMode;
$f=fopen($file,"r");
$Header=fread($f,2);
if($Header=="BM" ......
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâÆªÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......