/PHP/Search function using php for database entries

Search function using php for database entries

Php mysql search database and display results

<?php
    $con= new mysqli("localhost","root","","Employee");
    $name = $_post['search'];
    //$query = "SELECT * FROM employees
   // WHERE first_name LIKE '%{$name}%' OR last_name LIKE '%{$name}%'";

    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

$result = mysqli_query($con, "SELECT * FROM employees
    WHERE first_name LIKE '%{$name}%' OR last_name LIKE '%{$name}%'");

while ($row = mysqli_fetch_array($result))
{
        echo $row['first_name'] . " " . $row['last_name'];
        echo "<br>";
}
    mysqli_close($con);
    ?>

Source: stackoverflow.com

Search function using php for database entries

$result = mysqli_query($con, "SELECT * FROM employees
    WHERE first_name LIKE '%{$name}%' OR last_name LIKE '%{$name}%'");

while ($row = mysqli_fetch_array($result))
{
        echo $row['first_name'] . " " . $row['last_name'];
        echo "<br>";
}
    mysqli_close($con);
    ?>

Similar codes

0 vote104 views1 answer
Laravel replace white space with dash
PHP Laravel
12 votes104 views4 answers
Laravel get second last record
PHP
12 votes126 views1 answer
Laravel model without timestamps
PHP Laravel
0 vote97 views1 answer
Undefined index: gross_wt in C:\xampp\htdocs\aezaz\Dev\login\pdf_export\gb1.php on line 34
PHP
6 votes132 views4 answers
Install php 7.1 on ubuntu 18.04
PHP
0 vote111 views2 answers
Update user role wordpress
PHP Wordpress
18 votes135 views4 answers
Protected table laravel
PHP
0 vote104 views1 answer
Php isset and test
PHP
1 vote89 views2 answers
Extract date from datetime object in php
PHP
1 vote152 views1 answer
Php mess detector
PHP