/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

1 vote93 views1 answer
Boot method laravel
PHP
0 vote116 views1 answer
Laravel after method()
PHP Laravel
2 votes125 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP Laravel
0 vote90 views1 answer
How to read data from serial port in php
PHP
10 votes97 views3 answers
Check count in laravel
PHP
12 votes95 views5 answers
Convert array to object php
PHP
0 vote92 views1 answer
Run a server php terminal
PHP
0 vote172 views1 answer
Laravel get old url
PHP Laravel
0 vote57 views1 answer
Symony type request
PHP
1 vote138 views3 answers
Jump to line phpstorm
PHP