Breaking News: Grepper is joining You.com. Read the official announcement!

simple search code in php with demo

Add Answer

Pleasant Puma answered on August 11, 2022 Popularity 1/10 Helpfulness 1/10

answer simple search code in php with demo

related php search box

related ggplot log axis ticks

simple search code in php with demo

Comment

<form method="GET" action="">
    <input type="text" name="search" placeholder="Search...">
    <input type="submit" value="Search">
</form>

<?php
// Database connection
$host = 'localhost';
$db = 'your_database';
$user = 'your_username';
$pass = 'your_password';
$conn = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Check if search query is submitted
if (isset($_GET['search'])) {
    $searchTerm = $_GET['search'];
    
    // Query with prepared statement to prevent SQL injection
    $stmt = $conn->prepare("SELECT * FROM products WHERE name LIKE :searchTerm");
    $stmt->execute(['searchTerm' => "%$searchTerm%"]);
    
    // Fetch and display results
    $results = $stmt->fetchAll();
    if ($results) {
        foreach ($results as $row) {
            echo "<p>" . htmlspecialchars($row['name']) . "</p>";
        }
    } else {
        echo "<p>No results found.</p>";
    }
}
?>

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: demo php search

Link to this answer
Share Copy Link

Contributed on Oct 27 2024

Pleasant Puma

0 Answers Avg Quality 2/10

Closely Related Answers

php search box

Comment

<?php
$searchErr = '';
$domain_details='';
if(isset($_POST['save']))
{
    if(!empty($_POST['search']))
    {
        $search = $_POST['search'];

        
        $query ="SELECT * FROM tablename where name like '$search'";
        $result = $link->query($query);
        if($result){
        if($result->num_rows> 0){
          $domain_details= mysqli_fetch_all($result, MYSQLI_ASSOC);
        }else{ 
          echo "No record found";
        } 
       
    }
         
    }
    else
    {
        $searchErr = "Please enter the information";
    }
    
}
?>

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: php

Link to this answer
Share Copy Link

Contributed on Aug 11 2022

TC. MOHD AMIN HASSAN

0 Answers Avg Quality 2/10

ggplot log axis ticks

Comment

annotation_logticks(sizes='b')
#`sides=` any of "trbl", for top, right, bottom, and left.

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: axis whatever

Link to this answer
Share Copy Link

Contributed on Oct 26 2024

Scary Swan

0 Answers Avg Quality 2/10

simple search code in php with demo

Contents

More Related Answers

simple search code in php with demo

Closely Related Answers

php search box

ggplot log axis ticks

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.