CREATE TABLE employees (  id tinyint(4) DEFAULT '0' NOT NULL 

AUTO_INCREMENT,  first varchar(20),  last varchar(20),  

address varchar(255),  position varchar(50),  PRIMARY KEY (id),  

UNIQUE id (id));

INSERT INTO employees VALUES (1,'Bob','Smith',

'128 Here St, Cityname','Marketing Manager');

INSERT INTO employees VALUES (2,'John','Roberts','45 There St , 

Townville','Telephonist');

INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd, 

Snowston','Doorman');

$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$result = mysql_query("SELECT * FROM employees",$db);

printf("First Name: %s

\n", mysql_result($result,0,"first"));

printf("Last Name: %s

\n", mysql_result($r
上一页  [1] [2] [3] [4] [5] [6] [7] [8] 下一页 



在google里搜索更多建立Apache+PHP3+MySQL驱动的动态网站











 





Web



www.51ec.org