我是php新手。我正在开发一个表单与以下代码:
<td>Severity:</td>
<td>
<?php $dbc = mysql_connect('localhost', 'root', ''); // root connection
mysql_select_db('ticket', $dbc); // db selection
$query = "SELECT id, severity FROM severity" ; // retrieving value from table severity in db
$result = mysql_query($query, $dbc); //
echo'<select name="sever">';
echo '<option value="Default"> Please Select Severity </option>';
while($row = mysql_fetch_assoc( $result ))
{
echo '<option value="'.$row['id'].'">' . $row['severity'] . '</option>';
}
echo '</select>';
?>
</td>
在数据库中,我创建了3个严重性级别,值如下:
Table Severity (ID, Severity, Hours)值(1, 'Critical', '12'),(2, 'Major', '24'),(3, 'Minor', '36');
我有一个日期函数,格式为
<td> Expected Completed Date: </td>
<td> <input name="exc_date" style="width:150px" type="text" /> </td>
一旦我选择严重性,我希望预期完成的日期将根据严重性的选择自动生成。
我有点模棱两可,我需要如何在预期完成日期的形式生成php代码。
请帮助我,并提前感谢您的建议。
纯Javascript解决方案(不含jQuery)
jsFiddle演示使用data-hours
属性输出每个选项的小时数:
echo '<option data-hours="'.$row['hours'].'" value="'.$row['id'].'">' . $row['severity'] . '</option>';
还提供<select>
和server
的ID,然后使用Javascript进行更改:
window.onload = function(){
document.getElementById("server").onchange = function(){
var timeObj = document.getElementById("exc_date");
if(this.value != 'Default'){
var hours = this.options[this.selectedIndex].getAttribute('data-hours');
var now = new Date();
now.setHours(now.getHours() + (hours*1));
var nowStr = now.getDate() + "/" + (now.getMonth()+1) + "/" + now.getFullYear();
timeObj.value = hours + " hours, " + nowStr;
} else {
timeObj.value = '';
}
};
};
将ID为exc_date
的元素更新为小时数。
将PHP部分改为
<td>Severity:</td>
<td>
<?php $dbc = mysql_connect('localhost', 'root', ''); // root connection
mysql_select_db('ticket', $dbc); // db selection
$query = "SELECT id, severity, hours FROM severity" ; // retrieving value from table severity in db
$result = mysql_query($query, $dbc); //
echo'<select name="sever">';
echo '<option value="Default"> Please Select Severity </option>';
while($row = mysql_fetch_assoc( $result ))
{
echo '<option value="'.$row['id'].'" data-hours="'.$row['hours'].'">'
. $row['severity'] . '</option>';
}
echo '</select>';
?>
</td>
并添加JavaScript - http://jsfiddle.net/8YCwb/.