/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 vote279 views1 answer
ERROR: Module mpm_event is enabled - cannot proceed due to conflicts. It needs to be disabled first! Considering conflict mpm_worker for mpm_prefork: ERROR: Could not enable dependency mpm_prefork for php7.2, aborting
PHP
0 vote310 views6 answers
Hash password decrypt laravel
PHP
6 votes296 views1 answer
Wordpres get_posttype
PHP
16 votes342 views5 answers
Laravel one command for model table and controller
PHP Laravel
18 votes299 views10 answers
Stackoverflow
PHP
0 vote398 views1 answer
Yii2 GridView Filtering on Relational Column
PHP Yii
1 vote278 views1 answer
Php check if parameter exists
PHP
0 vote296 views1 answer
Type error: Argument 1 passed to App\Http\Controllers\Controller::validate() must be an instance of Illv
PHP
0 vote290 views10 answers
Laravel sanctum
PHP
0 vote330 views1 answer
Object of class stdclass could not be converted to string php laravel
PHP Laravel