Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once('search.php');
- ?>
- <head>
- <title>Search</title>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <link rel="stylesheet" type="text/css" href="style.css"/>
- </head>
- <body>
- <form method="POST" action="search.php">
- <input type="text" name="q" placeholder="Enter query"/>
- <input type="submit" name="search" value="Search" />
- </form>
- </body>
- <?php
- include_once('db.php'); //Connect to database
- if(isset($_POST['search'])){
- $q = $_POST['q'];
- $query = mysqli_query($conn, "SELECT * FROM 'words' WHERE 'englishWord' LIKE '%$q%'");
- $count = mysqli_num_rows($query);
- if($count == "0"){
- $output = '<h2>No result found</h2>';
- }else{
- while($row = mysqli_fetch_array($query)){
- $s = $row['yupikWord']; //column of results
- $output .= '<h2>'.$s.'</h2><br>';
- }
- }
- }
- echo $output;
- mysqli_close($conn);
- ?>
- <?php
- $servername = "localhost";
- $username = "qaneryararvik";
- $password = "yupik9lang";
- $database = "yupik";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $database);
- $dbcon = mysqli_select_db($conn,$database);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- echo "Connected successfully<br>";
- "SELECT * FROM `words` WHERE `englishWord` LIKE '%$q%'"
- <?php
- // comment these two line when page started working fine
- error_reporting(E_ALL);
- ini_set('display_errors',1);
- include_once('db.php');
- if(isset($_POST['search'])){
- $q = $_POST['q'];
- $query = mysqli_query($conn, "SELECT yupikWord FROM 'words' WHERE 'englishWord' LIKE '%$q%'") or die(mysqli_error($conn));
- $count = mysqli_num_rows($query);
- if($count == "0"){
- $output = '<h2>No result found</h2>';
- }else{
- while($row = mysqli_fetch_assoc($query)){
- $s = $row['yupikWord']; //column of results
- $output .= '<h2>'.$s.'</h2><br>';
- }
- }
- }
- echo $output;
- mysqli_close($conn);
- ?>
- <?php
- $servername = "localhost";
- $username = "qaneryararvik";
- $password = "yupik9lang";
- $database = "yupik";
- // Create connection
- $conn = mysqli_connect($servername, $username, $password, $database) or die(mysqli_connect_error()); // use either procedural or object-oriented approach
Add Comment
Please, Sign In to add comment