我在一个我想要存储的表单中使用选择值，在提交表单时，一个表显示了我的sql查询的结果，但使用选择值来查询数据库。我当前的html在这里:
<body>
<div id="top-menu">
<ul>
<li><a class="active" href="">Profile</a></li>
<li><a href="">Favourites</a></li>
<li><a href="">Messages</a></li>
<li id="mainheading" style="align left"><a href="Home.html"><strong>BookSmart</strong></a></li>
</div>
<div id ="search_elements">
<form method="post" action="test.php">
<img src="UniSelect.jpeg">
<select name ="university">
<option selected disabled>Select a university</option>
<option value="ucl">UCL</option>
<option value="kings">Kings College</option>
<option value="imperial">Imperial College</option>
<option value="lse">London School of Economics</option>
</select>
<img height="250px", width="600px" src="PriceSelect.jpeg">
<select name="rent">
<option selected disabled>Select a weekly rent price</option>
<option value="50">0-£50</option>
<option value="100"> £100-£150</option>
<option value="150">£150-200</option>
<option value="200"> £200+</option>
</select>
<img height="250px", width="600px" src="RoomSelect.jpeg">
<select name="roomtype">
<option selected disabled>Room Type</option>
<option value="50">University Halls</option>
<option value="100"> Studio</option>
<option value="150">Flat</option>
<option value="200"> Shared Accomodation</option>
</select>
<img height="250px", width="600px" src="DistanceSelect.jpeg">
<select name="distance">
<option selected disabled> Selecet a distance from the university</option>
<option value="1">0-1 miles</option>
<option value="3"> 1-3 miles</option>
<option value="5">3-5 miles</option>
<option value="6"> 5+ miles</option>
</select>
<input type="submit" name="submit" value="Search">
</form>
</div>
</body>
我目前用来查询数据库并在表中显示结果的代码是:
<p style ="text-align: center" id="php_style">
<?php
error_reporting(E_ERROR | E_PARSE);
session_start();
$counter_name = "counter.txt";
// Check if a text file exists. If not create one and initialize it to zero.
if (!file_exists($counter_name)) {
$f = fopen($counter_name, "w");
fwrite($f,"0");
fclose($f);
}
// Read the current value of our counter file
$f = fopen($counter_name,"r");
$counterVal = fread($f, filesize($counter_name));
fclose($f);
// Has visitor been counted in this session?
// If not, increase counter value by one
if(!isset($_SESSION['hasVisited'])){
$_SESSION['hasVisited']="yes";
$counterVal++;
$f = fopen($counter_name, "w");
fwrite($f, $counterVal);
fclose($f);
}
echo nl2br ("You are visitor number ".$counterVal. " to this site 'n Today's date is ". date("d/m/Y"));
$con=mysqli_connect("localhost:8889","root","root","booksmart_properties");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else
{
echo "we connected";
}
if(isset($_POST['submit']
{
$university = $_POST['university'];
$rent = $_POST['rent'];
$roomtype = $_POST['roomtype'];
$distance = $_POST['distance'];
//Now you can do anything with variables , you can put them inside query like this : //
// $result=mysqli_query($con,"SELECT * FROM Table WHERE Field = '$universit' "); //
// Note : this is dangrous way to do a query in PHP you should prevent something called SQL Injection , search for it //
// Perform queries
$result=mysqli_query($con,"SELECT * FROM ListedProperties
WHERE PropertyType = '.$roomtype' ");
echo "<table border='1'>
<tr>
<th>PropertyType</th>
<th>Description</th>
<th>Rent Price</th>
<th>Location</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['PropertyType'] . "</td>";
echo "<td>" . $row['Description'] . "</td>";
echo "<td>" . $row['RentPrice'] . "</td>";
echo "<td>" . $row['Location'] . "</td>";
echo "</tr>";
}
echo "</table>";
}))
mysqli_close($con);
?>
我想知道如何从选择表的值可以存储为php变量，并插入到查询使用时，搜索按钮按下
这很简单，首先你必须给每个选择标签一个名字，像这样:我为一个人做，你为其他人做:
<select name="university">
<option selected disabled>Select a university</option>
<option value="ucl">UCL</option>
<option value="kings">Kings College</option>
<option value="imperial">Imperial College</option>
<option value="lse">London School of Economics</option>
</select>
在你给每个SELECT标签一个名字之后，现在给你的输入一个像这样的名字:
<input type="submit" name="submit" value="Search">
现在是时候接收来自表单的值并将它们保存在PHP变量中。
$con=mysqli_connect("localhost:8889","root","root","booksmart_properties");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else
{
echo "we connected";
}
if(isset($_POST['submit')
{
$university = $_POST['university'];
$rent = $_POST['rent']; // i assumed that you name the second Select tag RENT and the Third ROOMTYPE and the last DISTANCE
$roomtype = $_POST['roomtype'];
$distance = $_POST['distance'];
//Now you can do anything with variables , you can put them inside query like this : //
// $result=mysqli_query($con,"SELECT * FROM Table WHERE Field = '$universit' "); //
// Note : this is dangrous way to do a query in PHP you should prevent something called SQL Injection , search for it //
// Perform queries
$result=mysqli_query($con,"SELECT * FROM ListedProperties");
echo "<table border='1'>
<tr>
<th>PropertyType</th>
<th>Description</th>
<th>Rent Price</th>
<th>Location</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['PropertyType'] . "</td>";
echo "<td>" . $row['Description'] . "</td>";
echo "<td>" . $row['RentPrice'] . "</td>";
echo "<td>" . $row['Location'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
mysqli_close($con);
?>
将来对你有帮助的重要链接和主题:
- PDO你可能想看看这个 sql注入
您可以使用这样的表单方法链接http://www.w3schools.com/tags/att_form_method.asp
并使用此链接插入我的sql数据库http://www.w3schools.com/php/php_mysql_insert.asp