麻烦各位大哥看一下我的代码错在哪?急啊~`

Readygo技术搜索引擎网络搜索 efish 2008-1-17 4:58:14

麻烦各位大哥看一下我的代码错在哪?急啊~`

楼主skycry8765（3214）2004-03-12 11:07:20 在 Web 开发 / PHP 提问

require("inc/condb.inc.php");
$sql="select * from userlist where usernumber="".$_POST.""";
$result=mysql_query($sql,$db_id);
$i=0;
while($array=mysql_fetch_array($result))
{
$username=$array;
$usernumber=$array;
}
require("inc/closedb.inc.php");
$day_date=date("Y-m-d");
$a_p_noon=date("a");
$day_time=date("H:i:s");
$c="pm";
$d="am";
if ($usernumber<600000000000)
{
require("inc/condb.inc.php");
if(strcmp($c,$a_p_noon))
{
$sql="select * from worklist where usernumber="$usernumber" and day_date="$day_date"";
$result=mysql_query($sql,$db_id);
if(mysql_num_rows($result)!=0)
{
$i=0;
while($array=mysql_fetch_array($result))
{
$a_m_key=$array;
$userid=$array;
$a_m_outkey=$array;
}
if($a_m_key=1)
{
if(($day_time<11:30:00)&&($day_time>07:30:00)&&($a_m_outkey!="1"))
{
$sql="update worklist set a_m_out="$day_time",a_m_outkey="1"
where userid=$userid";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
else
{
if(($day_time>=11:30:00)&&($day_time<12:00:00))
{
$sql="update worklist set a_m_exit="$day_time",a_m_exitkey="1"
where userid=$userid";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
else
{
header("Location:http://127.0.0.1/security/index.php");
}
}
}

}
else
{
$sql="insert worklist
(username,usernumber,a_m_time,a_m_key,p_m_time,p_m_key,day_date,
a_m_out,a_m_outkey,a_m_exit,a_m_exitkey,p_m_out,p_m_outkey,p_m_exit,p_m_exitkey)
values("$username","$usernumber","$day_time","1","00:00:00","0","$day_date",
"00:00:00","0","00:00:00","0","00:00:00","0","00:00:00","0")";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
}
else
{
$sql="select * from worklist where usernumber="$usernumber" and day_date="$day_date"";
$result1=mysql_query($sql,$db_id);
if(mysql_num_rows($result1)!=0)
{
$i=0;
while($array=mysql_fetch_array($result1))
{
$p_m_key=$array;
$userid=$array;
$p_m_outkey=$array;
}
if($p_m_key!=0)
{
if(($day_time<16:00:00)&&($day_time>14:00"00)&&($p_m_outkey!="1"))
{
$sql="update worklist set p_m_out="$day_time",p_m_outkey="1"
where userid=$userid";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
else
{
if($day_time>=16:00:00)
{
$sql="update worklist set p_m_exit="$day_time",p_m_exitkey="1"
where userid=$userid";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
else
{
header("Location:http://127.0.0.1/security/index.php");
}
}
}
else
//上午到了,下午记录
{
$sql="update worklist set p_m_time="$day_time",p_m_key="1"
where userid=$userid";
require("inc/condb.inc.php");
$result2=mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
}
else
//上午没到,重新注册
{
$sql="insert worklist
(username,usernumber,a_m_time,a_m_key,p_m_time,p_m_key,day_date,
a_m_out,a_m_outkey,a_m_exit,a_m_exitkey,p_m_out,p_m_outkey,p_m_exit,p_m_exitkey)
values("$username","$usernumber","00:00:00","0","$day_time","1","$day_date",
"00:00:00","0","00:00:00","0","00:00:00","0","00:00:00","0")";
mysql_query($sql,$db_id);
require("inc/closedb.inc.php");
header("Location:http://127.0.0.1/security/index.php");
}
} 问题点数：100、回复次数：5Top

责任编辑: efish 参与评论查找更多：

相关文章
难道这里真的没有人知道这个吗？？？？真没高手吗？… 难道这里真的没有人知道这个吗？？？？真没高手吗？？？能回答的分马上送上 300分！！

如何在Delphi中调用带参数的存储过程（要返回查询结… 如何在Delphi中调用带参数的存储过程（要返回查询结果的）？

如何用Active Directory中的WinNT://的接口，在某个… 如何用Active Directory中的WinNT://的接口，在某个组中添加一个用户？

请问：能具体解释什么是流吗？请问：能具体解释什么是流吗？

在datawindow中用crosstab定义的列的标题是否可以改… 在datawindow中用crosstab定义的列的标题是否可以改动，怎么改动？

北京招聘有VC经验并且熟悉.NET的程序员北京招聘有VC经验并且熟悉.NET的程序员

女朋友之定义(真爱的解释) 女朋友之定义(真爱的解释)

如何应用两台ADSL服务器，实现两台服务器共同合作带… 如何应用两台ADSL服务器，实现两台服务器共同合作带客户机上网，高手回答

请问在Internet上如何实现数据包广播？？请问在Internet上如何实现数据包广播？？

ACCESS 函数问题 ACCESS 函数问题

2秒记住本站域名

玩过泡泡龙吗？Readygo?Go! 再加上.Com.Cn的后缀，那就是大名小顶的readygo.com.cn

分类导航