T
XTSQL是一种文本数据库,文件存储方式类似mys
ql，兼容部分s
ql语句.
PHP需4.0以上版本才能运行。
官方网站：http://t
xtsql.com/
t
xtSQL简单例子（来源：http://smvcn.xhblog.com/archives/2007/259845.shtml）
<?
php
include('./t
xtSQL.class.
php');
$s
ql = new t
xtSQL('./data');
$s
ql->connect('root', 'bar');
/*创建数据库
$s
ql->createdb(array('db' => 'demo')) or die('Error creating t
xtSQL DB, t
xtSQL said: '.$s
ql->get_last_error());
*/
/*选择数据库*/
$s
ql->selectdb ( 'demo' );
/*创建表
$columns = array('id' => array('type' => 'int', 'auto_increment' => 1, 'permanent' => 1 ),
'name' => array('type' => 'string', 'max' => 50),
'email' => array('type' => 'string', 'max' => 50)
);
foreach($columns as $k => $v){
echo "\$colums[$k]=";
foreach($v as $k1 => $v1){
echo "$k1:$v1 ";
}
echo "<br>";
}
$s
ql->execute('create table',array(
'table' => 'table1',
'columns' => $columns)) or die('建表发生错误:'.$s
ql->get_last_error());
if($s
ql->table_exists('table1','demo')){
echo "建表成功";
}else{
echo "建表失败";
}
*/
/*插入纪录
$value = array(0 => array('name' => 'abc','email' => 'abc@123.com'),
1 => array('name' => '123','email' => '123@bac.com'),
2 => array('name' => 'df','email' => 'reg@bac.com'),
3 => array('name' => 'trt','email' => 'hgh@bac.com'),
4 => array('name' => 'tyty','email' => 'ytyt@bac.com')
);
for($i=0;$i<5;$i++){
echo "\$value[$i]:";
foreach($value[$i] as $k => $v){
echo "[$k]=$v ";
}
echo "<br>";
}
for($i=0;$i<5;$i++){
if(!$s
ql->execute('insert',array('table' => 'table1','values' => $value[$i] ))){
die('An error occurred, t
xtSQL said: '.$s
ql->get_last_error());
}else{
echo "插入成功<br>";
}
}
*/
/*修改表数据
$value = array('name' => 'abc','email' => 'aaa@123.com');
if(!$s
ql->execute('update',array('table' => 'table1','where' => array('id = 1'),'values' => $value))){
die('An error occurred, t
xtSQL said: '.$s
ql->get_last_error());
}else{
echo "修改成功";
}
*/
/*删除表内容
$delete = array('table' => 'table1','where' => array('id > 1'));
$delcount = $s
ql->execute('delete',$delete);
echo $delcount;
*/
/*显示表内容*/
$select = array('table' => 'table1','orderby' => array('id','asc')/*,'where' => array('email =~ %bac%'),'limit' => array(0,9)*/);
$data = $s
ql->execute('select',$select);
echo "<table border=1><tr><th>id</th><th>name</th><th>email</th></tr>";
foreach ( $data as $key => $row )
{
echo "<tr>";
foreach($row as $k => $v){
echo "<td>$v</td>";
}
echo "</tr>";
}
echo "</table>";
echo "表内共有 ".$s
ql->table_count('table1')." 行<BR>";
/*加入主键
$s
ql->execute('alter table',array('table' => 'table1','action' => 'addkey','name' => 'id','values' => array('name' => 'id')));
*/
echo "最后插入ID号:".$s
ql->last_insert_id('table1') ;
$s
ql->disconnect();
?>
YXPHP6是一款无需数据库的模板平台，支持自定义模板开发和官方模板二次开发。它适用于企业建站、blog，拥有强大模板引擎、原生态数据操作和智能缓存功能，后台采用AJAX编写，支持自动升级和在线模板同步。
97
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
