帮小妹看看这个问题咋回事?
deploy.php
<?php
$host="10.110.10.10";
$user="root";
$passwd="kittym";
$db="monitor";
?> NewIssue.php
<?php
include 'deploy.php';$id=mysql_connect($host,$user,$passwd);
mysql_select_db($db,$id);
$dbname="select customer from monitor.CUSTOMER order by customer";
$result_db=mysql_query($dbname);?>
<script language="javascript" src="Calendar.js">
</script>
<script language="javascript">
var cdr;
function f_instanceCalendar()
{
cdr = new Calendar("cdr");
document.write(cdr);
cdr.showMoreDay = true;
}
</script> <script language="javascript">
f_instanceCalendar();
</script><form action="AddTask.php" method=post name=form2 >
<font size=3.5><B>Customer:
<SELECT name="dbname_name" onChange="show()" value=<?php echo $dbname_name;?>>
<?
if ($dbname_name == ''|| $dbname_name == NULL ) {
echo "<OPTION selected value=ALL> ALL </option>";
}
else{
if ($dbname_name == 'ALL'){
echo "<OPTION selected value=$dbname_name> $dbname_name </option>";}
else{
echo "<OPTION value=ALL> ALL </option>";
echo "<OPTION selected value=$dbname_name> $dbname_name </option>";}
}
while ($data=mysql_fetch_array($result_db, MYSQL_ASSOC)){
foreach( $data as $d){
if ($d != $dbname_name){
echo "<OPTION value=$d> $d </option>";}
}
}
?>
</SELECT> <br> </br>
Current Date:
<input type=text name="Currentdate" onClick="cdr.show(this)" value="<?=date("Y-m-d")?>"> <br> </br>
Task: <td><textarea name="Task" rows=1 cols=60>
</textarea></td> <br> </br>Description: <td><textarea name="Description" rows=2 cols=60>
</textarea></td> <br> </br>Resolution:<td><textarea name="Resolution" rows=3 cols=60>
</textarea></td> <br> </br>
Status: <td><select name="Status">
<option selected>Pending
<option>Resloved
</select></td> <br> </br>
TicketNo. <td><input type=text name="TicketNo." size=10></td> <br> </br>
BugNo. <td><input type=text name="BugNo." size=10></td> <br> </br>
Whocreated: <td><input type=text name="WhoCreated" size=20></td> <br> </br>
<input type=submit name="Submit" value=Save></form> AddTask.php
<?php
include 'deploy.php';
$id=mysql_connect($host,$user,$passwd);
mysql_select_db($db,$id);
$dbname_name =$_POST['dbname_name'];
$CurrentDate =$_POST['Currentdate'];
$Task=$_POST['Task'];
$Description=$_POST['Description'];
$Resolution=$_POST['Resolution'];
$Status =$_POST['Status'];
$TicketNo.=$_POST['TicketNo.'];
$BugNo.=$_POST['BugNo.'];
$Whocreated=$_POST['WhoCreated'];$query="insert into Data_Issue_List(Company,Date,Task,Description,Resolution,Status,Ticket_No,Bug_No,Who_Created) values ('$dbname_name','$Currentdate','$Task','$Description','$Resolution', '$Status',$TicketNo.,$BugNo.,'$WhoCreated')";$result=mysql_query($query);
if($result)
{echo"it is finished";
}
else{echo"<font color=\'#ff0000\'>It is failed... :( </font>";
}
?>
其中有个mysql里面有个一个ID是自增的。所以没有必要插入这个column.
我一提交就出错,不清楚错在那里?请各位帮我看看啊,谢谢啦。
deploy.php
<?php
$host="10.110.10.10";
$user="root";
$passwd="kittym";
$db="monitor";
?> NewIssue.php
<?php
include 'deploy.php';$id=mysql_connect($host,$user,$passwd);
mysql_select_db($db,$id);
$dbname="select customer from monitor.CUSTOMER order by customer";
$result_db=mysql_query($dbname);?>
<script language="javascript" src="Calendar.js">
</script>
<script language="javascript">
var cdr;
function f_instanceCalendar()
{
cdr = new Calendar("cdr");
document.write(cdr);
cdr.showMoreDay = true;
}
</script> <script language="javascript">
f_instanceCalendar();
</script><form action="AddTask.php" method=post name=form2 >
<font size=3.5><B>Customer:
<SELECT name="dbname_name" onChange="show()" value=<?php echo $dbname_name;?>>
<?
if ($dbname_name == ''|| $dbname_name == NULL ) {
echo "<OPTION selected value=ALL> ALL </option>";
}
else{
if ($dbname_name == 'ALL'){
echo "<OPTION selected value=$dbname_name> $dbname_name </option>";}
else{
echo "<OPTION value=ALL> ALL </option>";
echo "<OPTION selected value=$dbname_name> $dbname_name </option>";}
}
while ($data=mysql_fetch_array($result_db, MYSQL_ASSOC)){
foreach( $data as $d){
if ($d != $dbname_name){
echo "<OPTION value=$d> $d </option>";}
}
}
?>
</SELECT> <br> </br>
Current Date:
<input type=text name="Currentdate" onClick="cdr.show(this)" value="<?=date("Y-m-d")?>"> <br> </br>
Task: <td><textarea name="Task" rows=1 cols=60>
</textarea></td> <br> </br>Description: <td><textarea name="Description" rows=2 cols=60>
</textarea></td> <br> </br>Resolution:<td><textarea name="Resolution" rows=3 cols=60>
</textarea></td> <br> </br>
Status: <td><select name="Status">
<option selected>Pending
<option>Resloved
</select></td> <br> </br>
TicketNo. <td><input type=text name="TicketNo." size=10></td> <br> </br>
BugNo. <td><input type=text name="BugNo." size=10></td> <br> </br>
Whocreated: <td><input type=text name="WhoCreated" size=20></td> <br> </br>
<input type=submit name="Submit" value=Save></form> AddTask.php
<?php
include 'deploy.php';
$id=mysql_connect($host,$user,$passwd);
mysql_select_db($db,$id);
$dbname_name =$_POST['dbname_name'];
$CurrentDate =$_POST['Currentdate'];
$Task=$_POST['Task'];
$Description=$_POST['Description'];
$Resolution=$_POST['Resolution'];
$Status =$_POST['Status'];
$TicketNo.=$_POST['TicketNo.'];
$BugNo.=$_POST['BugNo.'];
$Whocreated=$_POST['WhoCreated'];$query="insert into Data_Issue_List(Company,Date,Task,Description,Resolution,Status,Ticket_No,Bug_No,Who_Created) values ('$dbname_name','$Currentdate','$Task','$Description','$Resolution', '$Status',$TicketNo.,$BugNo.,'$WhoCreated')";$result=mysql_query($query);
if($result)
{echo"it is finished";
}
else{echo"<font color=\'#ff0000\'>It is failed... :( </font>";
}
?>
其中有个mysql里面有个一个ID是自增的。所以没有必要插入这个column.
我一提交就出错,不清楚错在那里?请各位帮我看看啊,谢谢啦。
我不是太明白你的意思,怎么转化引号?数据库是不支持中文的。
报的错误就是:It is failed... :( 能否帮我看看我写的AddTask.php
这段代码有没有错误啊
thanks
是在sever上跑的,不是本地。
我已经填写了
我在mysql里面定义的是INTEGER 类型。
麻烦各位帮我看一下。谢谢!