Search Engine - Find Your Information Quickly
Search Engine
<?php
//check if form has been submitted
if(isset($_GET['search'])){
$search = $_GET['search'];
//connect to database and search for results
$servername = 'localhost';
$username = 'root';
$password = '';
$dbname = 'your_database_name';
//create connection
$conn = new mysqli($servername, $username, $password, $dbname);
//check connection
if ($conn->connect_error) {
die('Connection failed: ' . $conn->connect_error);
}
//search for results
$sql = 'SELECT * FROM your_table_name WHERE column_name LIKE '%'.$search.'%'';
$result = $conn->query($sql);
//display results
if ($result->num_rows > 0) {
echo '<h2>Search Results:</h2>';
echo '<ul>';
while($row = $result->fetch_assoc()) {
echo '<li><a href='' . $row['url'] . ''>' . $row['title'] . '</a></li>';
}
echo '</ul>';
} else {
echo '<p>No search results found.</p>';
}
$conn->close();
}
?>
原文地址: https://www.cveoy.top/t/topic/lLeO 著作权归作者所有。请勿转载和采集!