http://www.runoob.com/php/php...
Why only one piece of data is displayed after using this example operation, and how to display all data that meets the conditions
< /p>
For example, the query field I use is yesterday_str to query the data of 2017-04-18
How can we extract all the data including this from 2017-04-18?
< /p>
php code
<?php
$q = isset($_GET["q"]) ? intval($_GET["q"]) : '';
if(empty($q)) {
echo 'Please select a date';
exit;
}
$con = mysql_connect('127.0.0.1', 'root', '');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("rizhifenxi", $con);
mysqli_set_charset($con, "utf8");
#$sql="SELECT * FROM keywords WHERE id = '".$q."'";
$sql="SELECT * FROM keywords WHERE yesterday_str = '".$q."'";
$result = mysql_query($sql);
echo "<table border='10'>
<tr>
<th>Date</th>
<th>Keywords</th>
<th>Number of visits</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['yesterday_str'] . "</td>";
echo "<td>" . $row['keywords'] . "</td>";
echo "<td>" . $row['count'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>html code:
<html>
<head>
<meta charset="utf-8">
<script src="/static/selectuser.js"></script>
</head>
<body>
<form>
Select a User:
<select name="yesterday_str" onchange="showUser(this.value)">
<option value="">Select a date:</option>
<option value="1">2017-04-20</option>
<option value="2">2017-04-21</option>
<option value="3">2017-04-22</option>
<option value="4">2017-04-23</option>
</select>
</form>
<p>
<p id="txtHint"><b>yesterday_str info will be listed here.</b></p>
</p>
</body>
</html>
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
This only displays the data of the corresponding id value. Remove all the ones after Websttes to display all, or the limit N is N.
Just rewrite it according to your requirements
Pay attention to the date format you upload.
The processing side is written like this. Is it convenient to provide any system or framework used in the backend?
1. Determine whether the passed value is correct;
2. Print and execute the SQL statement to check whether it is correct