(1) code:
<body bgcolor=yellow> <?php $con = @mysqli_connect('localhost', 'root', 'w1????', 'mysql'); if (!$con) { echo "Error: " . mysqli_connect_error(); exit(); } echo 'Connected to MySQL OK!<hr>';
$sql = 'drop DATABASE IF EXISTS selldb;'; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql = 'CREATE DATABASE selldb default character set utf8;'; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql = 'use selldb;'; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql = 'DROP TABLE IF EXISTS custs'; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql= "CREATE TABLE custs (id varchar(10) , name varchar(20), amount float default 0, tel varchar(20) default 'none' )" ; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql = 'set names utf8;'; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql="insert into custs (id,name,amount,tel) values ('10001','小草' ,1000,'08-233375');"; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql="insert into custs (id,name,amount,tel) values ('10002','天牛' ,3000,'03-933375');"; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql="insert into custs (id,name,amount,tel) values ('10003','地虎' ,5000,'02-444375');"; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
$sql= "select id,name,amount,tel from custs"; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!<br> "; } else { echo " $sql Failure!<br> "; }
echo "資料查詢如下<br>"; while ($row = mysqli_fetch_array($query)){ echo $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . ":" . $row['tel'] . "<br>"; }
mysqli_close ($con);
?> </body>
(2)result:
Connected to MySQL OK!
drop DATABASE IF EXISTS selldb; OK! CREATE DATABASE selldb default character set utf8; OK! use selldb; OK! DROP TABLE IF EXISTS custs OK! CREATE TABLE custs (id varchar(10) , name varchar(20), amount float default 0, tel varchar(20) default 'none' ) OK! set names utf8; 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 ('10003','地虎' ,5000,'02-444375'); OK! select id,name,amount,tel from custs OK! 資料查詢如下 10001:小草:1000:08-233375 10002:天牛:3000:03-933375 10003:地虎:5000:02-444375 |