(一)確定LAMP已在WIN10安裝妥當並提供服務,安裝過程詳如:20191224在win10下載、安裝並使用Appserv9.3.0應用程式伺服程式
(二)設計可連線MYSQL並新增資料庫、資料表、資料錄的PHP程式:
(1)在本機用記事本編寫 如下內容並存在c:\appserv\www之中檔名為c1.php
<body bgcolor=LIGHTGREEN> <?php function executeSQL($con,$sql){ if( $query= mysqli_query($con, $sql) ){ echo " [$sql] OK!<br> "; } else { echo " [$sql] Failure!<br> "; } return $query; }
$con = mysqli_connect('127.0.0.1', 'root', 'w??????', 'mysql'); if (!$con) { echo "Error"; exit(); } $sql = 'drop DATABASE selldb;'; executeSQL($con,$sql);
$sql = 'CREATE DATABASE selldb default character set utf8;'; executeSQL($con,$sql);
$sql = 'use selldb;'; executeSQL($con,$sql);
$sql="CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20))"; executeSQL($con,$sql);
$sql = 'set names utf8;'; executeSQL($con,$sql);
$sql="insert into custs(id,name,amount,tel) values ('10001','小狗',156,'08-233375');"; executeSQL($con,$sql);
$sql="insert into custs(id,name,amount,tel) values ('10002','小貓',256,'08-233375');"; executeSQL($con,$sql);
$sql="insert into custs(id,name,amount,tel) values ('10001','小草',1000,'08-233375');"; executeSQL($con,$sql);
$sql="insert into custs (id,name,amount,tel) values ('10002','天牛' ,3000,'03-933375');"; executeSQL($con,$sql);
$sql="insert into custs (id,name,amount,tel) values ('20002','天牛' ,3000,'03-933375');"; executeSQL($con,$sql);
$sql="insert into custs (id,name,amount,tel) values ('30002','天牛' ,3000,'03-933375');"; executeSQL($con,$sql);
$sql= "select id,name,amount,tel from custs"; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
while ($row = mysqli_fetch_array($query)){ echo $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . "<br>"; } mysqli_close ($con);
?>
</body>
(2) 執行c1.php結果如下
[drop DATABASE selldb;] OK! [CREATE DATABASE selldb default character set utf8;] OK! [use selldb;] OK! [CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20))] OK! [set names utf8;] OK! [insert into custs(id,name,amount,tel) values ('10001','小狗',156,'08-233375');] OK! [insert into custs(id,name,amount,tel) values ('10002','小貓',256,'08-233375');] OK! [insert into custs(id,name,amount,tel) values ('10001','小草',1000,'08-233375');] OK! [insert into custs (id,name,amount,tel) values ('10002','天牛' ,3000,'03-933375');] OK! [insert into custs (id,name,amount,tel) values ('20002','天牛' ,3000,'03-933375');] OK! [insert into custs (id,name,amount,tel) values ('30002','天牛' ,3000,'03-933375');] OK! select id,name,amount,tel from custs OK! 10001:小狗:156 10002:小貓:256 10001:小草:1000 10002:天牛:3000 20002:天牛:3000 30002:天牛:3000
|