頁:
[1]
請教各PHP高手
請各高手指教一下自學的我$query在mysql運行到,不過小弟不懂如何於php內執行,求教,謝謝。
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; char=utf-8" />
<title>Search Engine - Search</title>
</head>
<body>
<h2>Search Engine</h2>
<form action='./search.php' method='get'>
<input type='text' name='k' size='50' value='<?php echo $_GET['k']; ?>' />
<input type='submit' value='Search'>
</form>
<hr />
<?php
$k = $_GET['k'];
$terms = explode(" ", $k);
$query = “SELECT * FROM tickertalk.tutorial WHERE MATCH (title,description)against($k)order by match(title,description) against ($k)”;
foreach ($terms as $each){
$i++;
if ($i == 1)
$query .= "title,description LIKE '%$each%'";
else
$query .= "OR title,description LIKE '%$each%'";
}
// Create connection
$conn = new mysqli("localhost", "root", "800709chan");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = $query;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$id = $row['id'];
$title = $row['title'];
$description = $row['description'];
$keywords = $row['keywords'];
$link = $row['link'];
echo "<h2><div class='locked'>下載: <em>訪客無法瀏覽下載點,請先 <a href='member.php?mod=register'>註冊</a> 或 <a href='javascript:;' onclick="lsSubmit()">登入會員</a></em></div></h2>
$description<br /><br />";
}
} else {
echo "No results found for \"<b>$k</b>\"";
}
$conn->close();
?>
</body>
</html>...<div class='locked'><em>瀏覽完整內容,請先 <a href='member.php?mod=register'>註冊</a> 或 <a href='javascript:;' onclick="lsSubmit()">登入會員</a></em></div><div></div> 你的網址有沒有search.php?k=xxx 的顯示?
GET的意思是從網址上拿資料。
或者說你php有支持mysqli嗎?你可以用phpinfo() 找看有沒有 Mysqli的支持?因為mysql 有兩種不一樣的 Mysql & Mysqli的支持
頁:
[1]