仅在1个输入中搜索具有多个列的输入

well i have a search input on my website ( cars website ) and im using that search input to search only the cars by their brand... lets say Audi, BMW, etc... im wondering if there's a way i can type like:

Audi R8 and instead of showing nothing, it will show that car, like SELECT brand, model FROM cars WHERE brand = firstspace, model=secondspace...

Something like that instead of creating two inputs... so i can only type inside that input the full name Audi R8 Spyder or just Audi R8 and it will show only the R8 models...

Thanks,

Use this:

 <?php        
       $input = 'Audi R8';
       $arr = explode(' ', $input); //to separate the input
       $sql = "SELECT * FROM automoviles WHERE marca like '%$arr[0]%' or modelo like '%$arr[1]%'";        
 ?>

Edit 1 with escaping

<?php 
        $input = 'Audi R8';
        $arr = explode(' ', $input);
        $input1 = mysqli_real_escape_string($conn, $arr[0]);
        $input2 = mysqli_real_escape_string($conn, $arr[1]);

        $sql = "SELECT * FROM automoviles WHERE marca like '%$input1%' or modelo like '%$input2%'";  
?>

Hi try to use explode function of php so that you will get two variables.

<?php
$dcs_str = "audi m8";
$dcs_arr = explode(" ",$dcs_str); ?>

You can seperate that input into two. For example like this :

var input = "Audi R8";
var space = input.indexOf(" ");
var firstspace = input.substring(0, space); // Audi
var secondspace = input.substring(space); // R8

So your sql would be like this :

SELECT brand, model FROM cars WHERE brand = firstspace, model=secondspace