ajax example

MySQL LIKE Operator

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

• The percent sign (%) represents zero, one, or multiple characters
• The underscore sign (_) represents one, single character

The percent sign and the underscore can also be used in combinations!

LIKE Syntax

Tip: You can also combine any number of conditions using AND or OR operators.

Here are some examples showing different LIKE operators with ‘%’ and ‘_’ wildcards:

Demo Database

The table below shows the complete «Customers» table from the Northwind sample database:

SQL LIKE Examples

The following SQL statement selects all customers with a CustomerName starting with «a»:

Источник

PHP MySQL search database and display results

Hi friends, in this tutorial you will learn how to perform a PHP MySQL search database and display results in a step-by-step process from scratch. We must know that database searching is very useful in any kind of application or in any dynamic website. Therefore, we can do this with the help of a PHP script and get the desired results based on the search input from HTML forms.

Steps to perform PHP MySQL search database and display results

Step 1:- Create a database in PHP Myadmin as shown in the below screenshot.

Step 2:- Create a table in the database as shown in the below screenshot.

Step 3:- Insert data in the table.

In this step, we will insert some data with the help of an SQL query so that we can search from these data and show the results later as shown below

Query example for inserting data:- INSERT INTO employee_info (id, name, phone_no, age, department, created_at, updated_at) VALUES (NULL, 'ABC', '1234567891', '25', 'IT', current_timestamp(), '0000-00-00 00:00:00.000000');

Now, you can see the inserted data as shown below

Step 4:- Create a PHP file and Make an HTML form

In this step, we will create an HTML form with a search element so that we can enter the search input as shown below

Step 5:- Create a PHP file and establish the database connection as shown below

coonnect_test_db.php:-

setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); //echo 'connected'; > catch(PDOException $e) < echo '
'.$e->getMessage(); > ?>

Step 6:- Write a PHP script based on the search input.

prepare("select * from employee_info where department like '%$search%' or name like '%$search%'"); $stmt->execute(); $employee_details = $stmt->fetchAll(PDO::FETCH_ASSOC); > else < $searchErr = "Please enter the information"; >> ?>

Below are the two examples of searching data from the database

• If the search input is matched with the column value and the column has the single value then it will return the single row as shown in the below screenshot.

• If the search input is matched with the column value and the column has more than one value then it will return multiple rows as shown in the below screenshot.

Complete Code:- phpsearch.php

prepare("select * from employee_info where department like '%$search%' or name like '%$search%'"); $stmt->execute(); $employee_details = $stmt->fetchAll(PDO::FETCH_ASSOC); //print_r($employee_details); > else < $searchErr = "Please enter the information"; >> ?>      .container 
 
 
 
Search Employee Information:: 
Submit 
 
 
*
 
  
 
Search Result
 
 
 # Employee Name Phone No Age Department   No data found'; > else< foreach($employee_details as $key=>$value) < ?>      > ?>