Query in more than one mysql column with PHP

Question

I do so to make a query in the Mysql database

$keyword = strval($_POST['query']);
    $search_param = "{$keyword}%";
    $conn =new mysqli('xxx', 'xxx', 'xxx' , 'xxx');

    $sql = $conn->prepare("SELECT * FROM empresas WHERE nome LIKE ? or palavras_chave LIKE ?")
    $sql->bind_param("s",$search_param);            
    $sql->execute();
    $result = $sql->get_result();
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
        $countryResult[] = $row["nome"];
        }
        echo json_encode($countryResult);
    }
    $conn->close();

Are you just looking for the name, as I would to also search another column of mysql? For example name and keywords.

Answer 1

You can add the conditions and and or.

Example:

$sql = $conn->prepare("SELECT * FROM empresas WHERE nome  LIKE ? and palavras-chaves LIKE ?");

or

$sql = $conn->prepare("SELECT * FROM empresas WHERE nome  LIKE ? or palavras-chaves LIKE ?");

The choice will depend on your specific case.

Time to replace the ? by the parameters, make sure to be putting % before and after the value of the varieties.

Example:

SELECT * FROM empresas WHERE nome  LIKE "%$nome%"

try this code:

$keyword = strval($_POST['query']);
$search_param = "%$keyword%";
$conn =new mysqli('xxx', 'xxx', 'xxx' , 'xxx');

$sql = $conn->prepare("SELECT * FROM empresas WHERE nome LIKE ? or palavras_chave LIKE ?")
$sql->bind_param("ss",$search_param, $search_param); 

$sql->execute();
$result = $sql->get_result();
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
    $countryResult[] = $row["nome"];
    }
    echo json_encode($countryResult);
}
$conn->close();