我试图拥有一个选择标签和一个输入。当我在下拉列表框中选择列时,该列的相应值应显示在输入框中。我想有能力修改输入字段并将其发布到TXT文件。但是,就目前而言,我似乎无法获得如何使用一个查询,而在HTML代码中,我与列名称和值是一个值分开。这似乎进行了密集的逻辑,必须有一种更简单的方法来做到这一点。我可以使用第一个查询中的变量输入到第二个查询语句中检索此值并以输入形式出现的变量?我不知道如何整合。非常感激任何的帮助。我的PHP和HTML代码在下面发布。您会看到QueryAlarms和QueryAlarmsl实际上是相同的。这是我不确定使用一个或两个查询更有效的地方。感谢您的时间。
<?php
include_once 'DbConnect.php';
function connect(){
mysql_connect(DB_HOST, DB_USER,DB_PASS) or die ('Could not connect to the database unfortunately' .mysql_error());
mysql_select_db(DB_NAME);
}
function close(){
mysql_close();
}
function querySensors (){
$myData = mysql_query("Select TEMPERATURE,HUMIDITY, CO2, PH From ANALOG_SENSORS ORDER BY ArduinoTime DESC LIMIT 1;");
while($record = mysql_fetch_array($myData)){
echo'<option value="' . $record['TEMPERATURE'] . '">' . $record['TEMPERATURE'] .'</option>';
echo'<option value="' . $record['HUMIDITY'] . '">' . $record['HUMIDITY'] .'</option>';
echo'<option value="' . $record['CO2'] . '">' . $record['CO2'] .'</option>';
echo'<option value="' . $record['PH'] . '">' . $record['PH'] .'</option>';
}
}
function queryAlarmsL (){
$myData = mysql_query("Select ArduinoTime, Alarm1A, Alarm1B, Alarm2A, Alarm2B, CycleTime, Setpoint From ANALOG_SENSORS ORDER BY ArduinoTime DESC LIMIT 1;");
while($record = mysql_fetch_array($myData)){
echo'<option value=`$ArduinoTime`>Arduino Time</option>/n';
echo'<option value=`$Alarm1A`>Alarm 1 On Time</option>/n';
echo'<option value=`$Alarm1B`>Alarm 1 Off Time</option>/n';
echo'<option value=`$Alarm2A`>Alarm 2 On Time</option>/n';
echo'<option value=`$Alarm2B`>Alarm 2 Off Time</option>/n';
echo'<option value=`$CycleTime`>Cycle Time</option>/n';
echo'<option value=`$Setpoint`>PH Setpoint 1</option>/n';
echo'<option value="' . $record['ArduinoTime'] . '">' . $record['ArduinoTime'] .'</option>';
echo'<option value="' . $record['Alarm1A'] . '">' . $record['Alarm1A'] .'</option>';
echo'<option value="' . $record['Alarm1B'] . '">' . $record['Alarm1B'] .'</option>';
echo'<option value="' . $record['Alarm2A'] . '">' . $record['Alarm2A'] .'</option>';
echo'<option value="' . $record['Alarm2B'] . '">' . $record['Alarm2B'] .'</option>';
echo'<option value="' . $record['CycleTime'] . '">' . $record['CycleTime'] .'</option>';
echo'<option value="' . $record['Setpoint'] . '">' . $record['Setpoint'] .'</option>';
}
}
function queryAlarms (){
$myData = mysql_query("Select ArduinoTime, Alarm1A, Alarm1B, Alarm2A, Alarm2B, CycleTime, Setpoint From ANALOG_SENSORS ORDER BY ArduinoTime DESC LIMIT 1;");
while($record = mysql_fetch_array($myData)){
echo'<option value="' . $record['ArduinoTime'] . '">' . $record['ArduinoTime'] .'</option>';
echo'<option value="' . $record['Alarm1A'] . '">' . $record['Alarm1A'] .'</option>';
echo'<option value="' . $record['Alarm1B'] . '">' . $record['Alarm1B'] .'</option>';
echo'<option value="' . $record['Alarm2A'] . '">' . $record['Alarm2A'] .'</option>';
echo'<option value="' . $record['Alarm2B'] . '">' . $record['Alarm2B'] .'</option>';
echo'<option value="' . $record['CycleTime'] . '">' . $record['CycleTime'] .'</option>';
echo'<option value="' . $record['Setpoint'] . '">' . $record['Setpoint'] .'</option>';
}
}
?>
这是HTML代码
<?php
include_once 'DbFunction.php';
connect();
?>
<html>
<head>
<title> Test TEMP</title>
</head>
<body>
<header>
<h1 align="center"> Trial of Temp </h1>
</header>
<section>
<article>
<hgroup>
</hgroup>
<p align="center";style="position:absolute; bottom:110px;>
<select name="dropdown">
<?php querySensors () ?>
</select>
</p>
</article>
<article>
<br>
<table>
<p style="position: fixed; bottom: 0; width:100%; text-align: center">
<ul>
<select name1="dropdown1">
<ul>
<?php queryAlarmsL() ?>
</select>
</article>
<article>
<p align="center">
<ul> <select name2="dropdown2"><ul>
<?php queryAlarms() ?>
</select>
</article>
</table>
<?php close() ?>
</p>
</article>
<article>
</article>
</section>
<aside>
<!--SideBar here -->
</aside>
</body>
</html>
使用fetch_assoc()而不是fetch Array,它应该起作用。
也为了您对MySQLI驱动程序的安全更新,因为MySQL*已弃用。:http://se2.php.net/manual/en/intro.mysqli.php而且您尚未使用Connect()函数,因此您未连接到SQL。