(1)code
<body bgcolor=LIGHTGREEN> <?php$con = mysqli_connect('127.0.0.1', 'root', 'w1????xxx, 'selldb');if (!$con) { echo "Error"; exit(); } $sql = 'drop DATABASE 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="CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20))";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 ('20002','天牛' ,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 ('30002','天牛' ,3000,'03-933375');";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> "; } while ($row = mysqli_fetch_array($query)){ echo $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . "<br>";} mysqli_close ($con); ?></body>
(2)excute
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','小草',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:小草:1000 10002:天牛:3000 20002:天牛:3000 30002:天牛:3000
|