<center><font color=black size=3>Input start date:</font>
<INPUT type="text" name="startdate" >
<font color=black size=3>Input end date:</font>
<INPUT type="text" name="enddate" >
<INPUT type="Submit" name="submit" value = "Submit" onclick=""></center>
这是我的2个text和1个submit,我想要在onclick中把2个text中的内容分别传到下面这段代码的数据库查询语句的where后面
mysql_connect("localhost", "meliorisuser", "ticketsql123!") or die(mysql_error());
mysql_select_db("support_xx") or die(mysql_error());
$strSql = "select tickets.ID as ID,ticket_messages.timestamp AS DateReceived,ticket_answers.timestamp as LastDate,tickets.status as status,tickets.partner as partner,tickets.phone as phone,ticket_categories.name as ProgramType,tickets.name as name,tickets.email as email,tickets.subject as subject,ticket_attachments.filename as yesno,tickets.timestamp as closeddate,ticket_reps.name as Representative from tickets LEFT OUTER join ticket_answers on tickets.ID = ticket_answers.ticket LEFT OUTER join ticket_categories on tickets.cat = ticket_categories.ID LEFT OUTER join ticket_reps on ticket_answers.rep = ticket_reps.ID LEFT OUTER join ticket_attachments on tickets.ID = ticket_attachments.ticket LEFT OUTER join ticket_messages on tickets.ID = ticket_messages.ticket where ";
//?mysql_query???user??????
$result=mysql_query($strSql);
请大侠指导,在线等!
<INPUT type="text" name="startdate" >
<font color=black size=3>Input end date:</font>
<INPUT type="text" name="enddate" >
<INPUT type="Submit" name="submit" value = "Submit" onclick=""></center>
这是我的2个text和1个submit,我想要在onclick中把2个text中的内容分别传到下面这段代码的数据库查询语句的where后面
mysql_connect("localhost", "meliorisuser", "ticketsql123!") or die(mysql_error());
mysql_select_db("support_xx") or die(mysql_error());
$strSql = "select tickets.ID as ID,ticket_messages.timestamp AS DateReceived,ticket_answers.timestamp as LastDate,tickets.status as status,tickets.partner as partner,tickets.phone as phone,ticket_categories.name as ProgramType,tickets.name as name,tickets.email as email,tickets.subject as subject,ticket_attachments.filename as yesno,tickets.timestamp as closeddate,ticket_reps.name as Representative from tickets LEFT OUTER join ticket_answers on tickets.ID = ticket_answers.ticket LEFT OUTER join ticket_categories on tickets.cat = ticket_categories.ID LEFT OUTER join ticket_reps on ticket_answers.rep = ticket_reps.ID LEFT OUTER join ticket_attachments on tickets.ID = ticket_attachments.ticket LEFT OUTER join ticket_messages on tickets.ID = ticket_messages.ticket where ";
//?mysql_query???user??????
$result=mysql_query($strSql);
请大侠指导,在线等!
2 在xxx.php里
$stardate = $_POST['startdate'];
$enddate = $_POST['enddate'];
直接拼凑sql语句.
个form,设置action=xxx.php是什么意思,是转去另外一个页面吗?
我今天刚学php,都不懂,请高手讲详细点,谢谢大家啊
{
代码
}<form action="***.php?action=shencheng" method="post" enctype="multipart/form-data"></form>
明白了吗?
php,asp,jsp的目标都是生成html等代码
这个是个现成的例子,可以用GET和POST的方法,这样可以把你的表单数据传送到另外的页面中进行处理。
也可以用AJAX方法提交,这样不用切换页面,http://www.w3school.com.cn/ajax/ajax_database.asp
这些都是现成的例子,看下就明白了
2 当然你不想用form,也可以通过一个函数,获取input值,通过get方式传送.建议好好学学基础知识.