FUDforum: PHP discussions » 脪禄赂枚SQLITE脢媒戮脻脌脿

Home » General » PHP discussions » 脪禄赂枚SQLITE脢媒戮脻脌脿

Show: Today's Messages :: Polls :: Message Navigator

脪禄赂枚SQLITE脢媒戮脻脌脿 [message #23686]

Sat, 26 March 2005 09:20

jejwe

Messages: 1
Registered: March 2005

Karma: 0

Junior Member

<?
/*
\* ===========================================
\* 项目: 作业
\* 功能: sqlite 数据库操作类
\* 版本: 1.0
\* 建立日期: 2004//
\* 修改日期: ---------
\* ------------------------------------------
\* 作者: 乔伟
\* ===========================================
*/

//========================================================================= ====
class dbclass{

var $dbname='data/jivi-data';//设置数据库名
var $err;
//--------打开数据库
function open_db(){
$this->db=@sqlite_open($this->dbname,0777);
if(!$this->db){
$this->echoerr("数据库连接失败");
}
}

//--------查询数据,并返回指针
function query_db($query_string){
$this->result=@sqlite_query($this->db,$query_string);
if(!$this->result){
$this->err="query_db";
$this->echoerr("执行语句".$query_string."出错");
}
return $this->result;
}
//---------移动指针
function sqlite_data_seek($numrow) {
if(!isset($this->result)){
$this->err="sqlite_data_seek";
$this->echoerr("指针未建立");
}
if ($numrow==0) {
return sqlite_rewind($this->result);
} else {
return sqlite_seek($this->result, $numrow);
}
}

//---------根据指针将数据生成二维数组
function make_data_array(){
$rows=array();
if(!isset($this->result)){
$this->err="make_data_array";
$this->echoerr("指针未建立");
}
while($dbarray=@sqlite_fetch_array($this->result)){
if(!$dbarray){
$this->err="make_data_array";
$this->echoerr("无法完成数组");
}
array_push($rows,$dbarray);
}
return $rows;
}

//---------根据指针将数据生成固定记录的二维数组
function make_guding_array($count,$seek){
$rows=array();
$coun=$this->get_numrows();
if(!isset($this->result)){
$this->err="make_guding_array";
$this->echoerr("指针未建立");
}
for($i=1;$i<=$count;$i++){
$c=$seek+$i;
if($c>$coun){
break;
}
$dbarray=@sqlite_fetch_array($this->result);
if(!$dbarray){
$this->err="make_guding_array";
$this->echoerr("无法完成数组");
}
array_push($rows,$dbarray);
}
return $rows;
}

//----------获得记录总数
function get_numrows(){
if(!isset($this->result)){
$this->err="numrows";
$this->echoerr("指针未建立");
}
return @sqlite_num_rows($this->result);
}

//------------错误
function echoerr($msg){
$message = "错误在函数【$this->err 】: $msg ";
$message .= "日期:".date("d.m.Y @ H:i")." ";
$message .= "脚本:".getenv("REQUEST_URI")." ";
die("$message");
}

function db_close(){
sqlite_close($this->db);
}

}

?>

[Updated on: Sat, 26 March 2005 09:22]

Report message to a moderator

Previous Topic:	Pop window loads link # and store it in variable
Next Topic:	Can someone please explain to me that what is the advantage of using *.inc as extension name?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:18:08 GMT 2024

Total time taken to generate the page: 0.02495 seconds