Introduction to Imperial CMS extended SQL program writing, Imperial CMS database statements & SQL statement formats
Basic example:
Note: The following examples are based on placing PHP files in the system root directory.
Example 1: Connect to MYSQL program. (a.php)
<?php
require('e/class/connect.php'); //引入数据库配置文件和公共函数文件
require('e/class/db_sql.php'); //引入数据库操作文件
$link=db_connect(); //连接MYSQL
$empire=new mysqlquery(); //声明数据库操作类
db_close(); //关闭MYSQL链接
$empire=null; //注消操作类变量
?>Example 2: Program to operate MYSQL data. (b.php)
<?php
require('e/class/connect.php'); //引入数据库配置文件和公共函数文件
require('e/class/db_sql.php'); //引入数据库操作文件
$link=db_connect(); //连接MYSQL
$empire=new mysqlquery(); //声明数据库操作类
$empire->query("update {$dbtbpre}ecms_news set onclick=onclick+1"); //给新闻表的点击数加1
db_close(); //关闭MYSQL链接
$empire=null; //注消操作类变量
?>Example 3: Program to read MYSQL data. (c.php)
<?php
require('e/class/connect.php'); //引入数据库配置文件和公共函数文件
require('e/class/db_sql.php'); //引入数据库操作文件
$link=db_connect(); //连接MYSQL
$empire=new mysqlquery(); //声明数据库操作类
$sql=$empire->query("select * from {$dbtbpre}ecms_news order by newstime limit 10"); //查询新闻表最新10条记录
while($r=$empire->fetch($sql)) //循环获取查询记录
{
echo"标题：".$r['title']."<br>";
}
db_close(); //关闭MYSQL链接
$empire=null; //注消操作类变量
?>Description of commonly used functions in the database operation class in the /e/class/db_sql.php file:
1. Execute SQL function:
$empire->query("SQL语句");
$empire->query1("SQL语句");Description:
Returns true if the execution is successful, false if the execution is unsuccessful;
The difference between the two is: an error in query() directly interrupts program execution, while an error in query1() does not interrupt program execution.
Usage example:
$sql=$empire->query("select * from {$dbtbpre}ecms_news");2. Loop reading database record function:
$empire->fetch($sql)Description:
$sql is the result returned by query executing SQL.
Usage example:
$sql=$empire->query("select * from {$dbtbpre}ecms_news");
while($r=$empire->fetch($sql))
{
echo"标题：".$r['title']."<br>";
}3. Function to read a single database record: (not looping)
$empire->fetch1("SQL语句")Usage example:
$r=$empire->fetch1("select * from {$dbtbpre}ecms_news where id=1");
echo"标题：".$r['title'];4. Function to count the number of SQL query records:
$empire->num("SQL语句")
$empire->num1($sql)Description:
The difference between the two is: num() directly writes SQL statements, while $sql in num1() is the result returned by query executing SQL.
Usage example:
$num=$empire->num("select id from {$dbtbpre}ecms_news");
echo"新闻表共有 ".$num." 条新闻";5. Statistical SQL query record number function 2: (a more efficient function compared to num)
$empire->gettotal("统计SQL语句");Description:
The difference between gettotal() and num() is: gettotal() uses SQL's own count(*) function to calculate statistics, while num() uses PHP's own function, and gettotal() is more efficient.
The statistics in gettotal() must be as total, such as: "count(*) as total".
Usage example:
$num=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_news");
echo"新闻表共有 ".$num." 条新闻";6. Get the auto-increment ID value function just inserted into the table:
$empire->lastid()Usage example:
$empire->query("insert into {$dbtbpre}ecms_news(title) values('标题')");
$lastid=$empire->lastid();
echo"刚插入的信息ID为：".$lastid;7. Move the SQL query result record pointer:
$empire->seek($sql,$pit)Description:
$sql is the result returned by query executing SQL, and $pit is the offset number of the pointer.
Usage example:
$sql=$empire->query("select * from {$dbtbpre}ecms_news");
$empire->seek($sql,2);8. Release the SQL query result function: (generally not needed)
$empire->free($sql)Description:
$sql is the result returned by query executing SQL.
Usage example:
$sql=$empire->query("select * from {$dbtbpre}ecms_news");
$empire->free($sql);
