txtSQL----第一个例子创建数据库db和创建一个表table和插入第一条数据最后打印到数组

<?php
include('./timer.php');
$timer = new Timer();
$timer->start();
//=========================================================
include('./txtSQL.php');
$sql = new txtSQL('./data');
$sql->connect('root','bpkLie123');

$sql->query('CREATE DATABASE db');
$sql->selectdb('db');
//$sql->query('DROP TABLE table');
$sql->query('CREATE TABLE table SET(id(auto_increment=1, permanent=0), name(default=NONAME))');
$sql->query('INSERT INTO table SET(id, name) VALUES(1, "root")');

$results = $sql->query('SELECT * FROM db.table ORDER id ASC');
while ( $row = $sql->fetch_array($results) )
{
    $rows[] = $row;
}
print_r($rows);
echo '<hr>'.$timer->finish().$timer->getTime() . ' Seconds To Execute'.'<hr>';

?>