完全可以的~~下面是一个查找订单的函数~~函数肯定需要一个UserID的参数,另外可以选择的参数,与查询方式有关,如果按订单号查找的话就还需要一个OrderID,如果按时间查找的话,就还需要两个Date:$BeginDate和$EndDate。函数实现如下:function SearchOrder($UserID)
{
$n = func_num_args();
$m = func_get_args();
$link = new db;
$result = array(); if ($n == 3)
{
$BeginDate = $m[1];
$EndDate = $m[2]; $sql = "select OrderId from TOrder where UserId = '".$UserID."'";
if ($BeginDate <> "")
{
$sql .= " and CreateTime > '".$BeginDate."'";
}
if ($EndDate <> "")
{
$sql .=" and CreateTime < '".$EndDate." 23:59:59'";
}
$sql .= " order by CreateTime desc"; $link->query($sql);
for ($i=0;$i<$link->num_rows();$i++)
{
$tmp = $link->next_record();
$result[] = $tmp["OrderId"];
}
}
elseif ($n == 2)
{
$OrderID = $m[1]; $sql = "select OrderId from TOrder where UserId = '".$UserID."' and OrderId = ".$OrderID." order by CreateTime desc";
$link->query($sql);
for ($i=0;$i<$link->num_rows();$i++)
{
$tmp = $link->next_record();
$result[] = $tmp["OrderId"];
}
}
return $result;
}
{
$n = func_num_args();
$m = func_get_args();
$link = new db;
$result = array(); if ($n == 3)
{
$BeginDate = $m[1];
$EndDate = $m[2]; $sql = "select OrderId from TOrder where UserId = '".$UserID."'";
if ($BeginDate <> "")
{
$sql .= " and CreateTime > '".$BeginDate."'";
}
if ($EndDate <> "")
{
$sql .=" and CreateTime < '".$EndDate." 23:59:59'";
}
$sql .= " order by CreateTime desc"; $link->query($sql);
for ($i=0;$i<$link->num_rows();$i++)
{
$tmp = $link->next_record();
$result[] = $tmp["OrderId"];
}
}
elseif ($n == 2)
{
$OrderID = $m[1]; $sql = "select OrderId from TOrder where UserId = '".$UserID."' and OrderId = ".$OrderID." order by CreateTime desc";
$link->query($sql);
for ($i=0;$i<$link->num_rows();$i++)
{
$tmp = $link->next_record();
$result[] = $tmp["OrderId"];
}
}
return $result;
}
解决方案 »
- 参数确实是true,但是还是有警告mysql_fetch_row() expects parameter 1 to be resource?
- php怎样替换css文件中相应的内容?
- 我的php连接mssql2005数据库 错误在那啊
- No power to use this!
- fwrite写文件时,会给特殊的字符加上\,如何才能不让它加\呢?
- 简单的PHP代码分析!在线等!......
- 帮忙看看是不是session_start()惹的祸
- 求教一个关于php扩展的问题
- thinkphp怎么使用mongdb原生sql ?
- 请问有谁用过shuipfcms吗?
- 如何开发PHP的DLL函数库。
- 欢迎php爱好者多去"中国linux论坛",上面也有一个php论坛!(www.linuxforum.net)
其实也就是func_num_args()
和func_get_args();这两个函数而已:)