PHP²Ù×÷mysqlÊý¾Ý¿â¼òµ¥Ê¾Àý
ÏÈ´´½¨Ò»¸öÊý¾Ý¿âMyDB
CREATE DATABASE `mydb` ;
ÔÙ´´½¨Ò»¸ö¼òµ¥µÄÊý¾Ý±í
CREATE TABLE `MyDB`.`MyTable` (
`Name` VARCHAR( 20 ) NOT NULL ,
`Age` INT NOT NULL
) ENGINE = MYISAM
²åÈëһЩÊý¾Ý
INSERT INTO `mydb`.`mytable` (
`Name` ,
`Age`
)
VALUES (
'Jim', '15'
), (
'Amy', '16'
), (
'Jack', '12'
), (
'Mike', '21'
);
н¨Ò»¸öPHPÍøÒ³
<?php
$m_DB = mysql_connect("localhost","root","123"); //Á¬½ÓÊý¾Ý¿â
mysql_select_db("MyDB",$m_DB); //Ñ¡ÔñÒª²Ù×÷µÄÊý¾Ý¿â
$sql = "SELECT * from MyTable"; //¹¹Ôì²éѯÓï¾ä
$re = mysql_query($sql,$m_DB); //Ö´Ðвéѯ
while($row=mysql_fetch_array($re)){ //Ñ»·Êä³öÊý¾Ý
print_r($row); //´òÓ¡³öÀ´
print("<br/>");
}
mysql_close($m_DB);
?>
ÔËÐнá¹ûÈçÏ£º
Array ( [0] => Amy [Name] => Amy [1] => 16 [Age] => 16 )
Array ( [0] => Jim [Name] => Jim [1] => 15 [Age] => 15 )
Array ( [0] => Jack [Name] => Jack [1] => 12 [Age] => 12 )
Array ( [0] => Mike [Name] => Mike [1] => 21 [Age] => 21 )
Ïà¹ØÎĵµ£º
<?php
/**
+++++++++++++++++++++=+++++ÉÏ´«Í¼Æ¬++++++++++++++++++++++++++++++++++++++++
—————————————————————————————&mdas ......
tomcat °²×°Ä¿Â¼ÏµÄconfĿ¼ÖеÄcontext.xmlÓëweb.xmlÎļþ·Ö±ðÐÞ¸ÄÈçÏ£º
context.xml мÓÈçÏÂÄÚÈÝ£º
<Resource name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://Êý¾Ý¿âµØÖ·:3306/Êý¾Ý¿âà ......
Ò»¡¢Apache HTTP Server °²×°£º
ÔËÐÐApache .msi Îļþ£¬°²×°³ÌÐò½«ÒªÇóÄãÌîдÈçÏÂÄÚÈÝ£º
1. Network Domain¼üÈëÄãµÄ·þÎñÆ÷£¨»òÕßÊÇÄã¼´½«×¢²áµÄ·þÎñÆ÷£©µÄDNS ÓòÃû¡£ÀýÈ磬ÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³ÆÊÇserver.mydomain.net,ÄãÖ»ÐèÔÚÕâÀïÊäÈëmydomain.net¡£
2. Server Name ¾ÍÊÇÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³Æ£¬»¹ÊÇÉÏÃæµÄÀ ......