好的,所以我有一个选择项目,其中选项来自数据库:
<select id="subject_code" name="subject_code">;
<?php
$stmt = $database->prepare('SELECT subject_code, subject_name FROM subject_schedule');
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$subj_code = $row['subject_code'];
$subj_name = $row['subject_name'];
echo "<option value=" . $subj_name . ">" . $subj_code . "</option>";
}
?>
</select>
一个输入框,所选项应在其中放置其值:
<input id="subject_name" type="text" autocomplete="off" placeholder="Subject Name" name="time">
和一个脚本,它将完成这项工作:
$("#subject_code").on('change',function(){
//get selected option
var option = $(":selected",this);
//get its value
var value = option.val();
//get input box
var input = $("#subject_name")[0];
// set value and disable input
input.value = value;
});
的问题是,每当我选择一个值,其中有空格,输入框只显示从数据库中的第一个单词。例子:
首选输出:
subject code: ENG111
subject name: Communication Arts 1
电流输出
subject code: ENG111
subject name: Communication
问题在于引号:
替换:
echo "<option value=" . $subj_name . ">" . $subj_code . "</option>";
与这个:
echo "<option value='" . $subj_name . "'>" . $subj_code . "</option>";
jsFiddle