feiwen
(feiwen)
中级会员
 
老会员
UID 22716
精华
0
积分 407
帖子 406
金钱 407 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2003-8-25
状态 离线
|
[推荐阅读] 怎样解决php生成word文件时出现的错误？
http://www.xm165.com/phpclass/operation.inc
<?
Class MYSQL
{
Function SQLQUERY($selectfield,$tablename,$condiction)
{
$SQL_QUERY = " SELECT ".$selectfield." FROM ".$tablename." ".$condiction;
//echo $SQL_QUERY."<br>";
$queryresult = mysql_query($SQL_QUERY);
RETURN $queryresult;
}
FUNCTION SQLINSERT($selectfield,$tablename,$fieldvalue)
{
$SQL_INSERT = " INSERT INTO ".$tablename." (".$selectfield.") VALUES (".$fieldvalue.")";
//echo $SQL_INSERT."<br>";
$result = mysql_query($SQL_INSERT);
RETURN $result ;
}
FUNCTION SQLDELE($tablename,$condiction)
{
$SQL_DELETE = "DELETE FROM ".$tablename." ".$condiction;
//echo $SQL_DELETE;
$result = mysql_query($SQL_DELETE);
RETURN $result;
}
FUNCTION SQLUPDATES($field_value,$tablename,$condiction)
{
$SQL_UPDATE = "UPDATE ".$tablename." SET ".$field_value." ".$condiction;
//echo $SQL_UPDATE."<br>";
$result = mysql_query($SQL_UPDATE);
RETURN $result;
}
FUNCTION SQLUPDATE($selectfield,$tablename,$condiction,$fieldvalue)
{
$SQL_UPDATE = "UPDATE ".$tablename." SET ".$selectfield." = '".$fieldvalue."'".$condiction;
//echo $SQL_UPDATE."<br>";
$result = mysql_query($SQL_UPDATE);
RETURN $result;
}
}
Class ORACLE
{
FUNCTION OL_CLOSE($conn)
{
ocilogoff($conn);
}
FUNCTION OL_MaxRecord($field,$tablename,$condiction,$conn)
{
$maxRecord = "select count(".$field.") from ".$tablename." ".$condiction;
$maxRecord = ociparse($conn,$maxRecord);
ociexecute($maxRecord);
ocifetchinto($maxRecord,&$maxrows);
$rows = $maxrows[0];
OCIFreeStatement($maxRecord);
RETURN $rows;
}
FUNCTION OL_SumRecord($field,$tablename,$condiction,$conn)
{
$maxRecord = "select sum(".$field.") from ".$tablename." ".$condiction;
$maxRecord = ociparse($conn,$maxRecord);
ociexecute($maxRecord);
ocifetchinto($maxRecord,&$maxrows);
$rows = $maxrows[0];
OCIFreeStatement($maxRecord);
RETURN $rows;
}
FUNCTION OL_DOSQL($dosql,$conn)
{
$dosql = ociparse($conn,$dosql);
$dosql = ociexecute($dosql);
//OCIFreeStatement($dosql);
return $dosql;
}
FUNCTION OL_MAXID($tablename,$conn)
{
$sql = "select id from ".$tablename." order by id desc";
$sql = ociparse($conn,$sql);
ociexecute($sql);
ocifetchinto($sql,&$array);
$rows = $array[0]+1;
OCIFreeStatement($sql);
RETURN $rows;
}
}
?>
只有这一个能看到内容啊,还没用
其实那个我觉得是生成的html页,但不知道为什么多了那几行
否则那几行不可能写错路径
应该是生成html的源代码发生了一点小问题
|
|
