/PHP/Php mysql search database and display results

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 vote310 views1 answer
Url images in CSS file link not working on PHP page|
PHP
-1 vote319 views2 answers
Php how to connect to db using PDO
PHP
1 vote326 views1 answer
Check if input file is set codeigniter
PHP
10 votes333 views4 answers
Import session laravel
PHP Laravel
10 votes289 views2 answers
Laravel migration default value not working
PHP Laravel
0 vote303 views1 answer
Php get variable by string name
PHP
0 vote309 views1 answer
Current tab active on page reload in php
PHP
0 vote360 views1 answer
Password required wp
PHP Wordpress
0 vote370 views4 answers
Get_adjacent_post wordpress
PHP Wordpress
0 vote326 views1 answer
Show all DB Tables in php
PHP