一、话前唠叨

今天trylife接上两篇继续说帝国CMS SQL类中的对象num()与num1();上边两篇查阅下面两个连接:

query()  与 query1() http://www.trylife.cn/ecms-repeatedly-development-with-db_sql-php/
fetch() 与 fetch1() http://www.trylife.cn/ecms-repeatedly-development-fetch/

简述: 对象num()和num1()都执行的mysql_num_rows(),只是前者参数是SQL语句,后者是SQL语句执行结果;用于获得行数;

二、num()示例

< ?php
include("../../class/connect.php");
include("../../class/db_sql.php");
$link=db_connect();
$empire=new mysqlquery();

$num=$empire->num("select id from {$dbtbpre}ecms_news");
echo $num;

db_close();
$empire=null;
?>

三、num1()示例

< ?php
include("../../class/connect.php");
include("../../class/db_sql.php");
$link=db_connect();
$empire=new mysqlquery();

$sql=$empire->query("select * from {$dbtbpre}ecms_news");
$num1=$empire->num1($sql);
echo $num1;

db_close();
$empire=null;
?>