How to insert a keyword into a database search already performed

Question

For example, I did a search of all user data in the database to echo in different columns by the site:

    $stmt = $conexao->prepare("SELECT * FROM esc_usuarios WHERE usu_codigo = ?");
    $stmt->bind_param("s", $usu_codigo);
    $stmt->execute();
    $usu_info_result = $stmt->get_result();
    $usu_info_coluna = $usu_info_result->fetch_assoc();
    $stmt->close();

Elsewhere on the site, I wanted to show this result though, using an ORDER BY or LIMIT, such as:

    $stmt = $conexao->prepare("SELECT * FROM esc_usuarios WHERE usu_codigo = ? ORDER BY usu_datacadastro DESC LIMIT 5");

How can I do this without having to prepare another query, since I already have the result and just want to filter the output?

Answer 1

I don’t have enough reputation to comment, so I ask you: can you confirm that all users have been stored as array in the $usu_info_column variable? And what is the data structure?

print_r($usu_info_coluna);

The normal is to use a while with fetch_assoc to retrieve each result by placing it in an array, thus:

function listaProdutos($conexao) {
    $produtos = array(); // aqui criamos um array vazio
    $resultado = mysqli_query($conexao, "select * from produtos"); // aqui selecionamos todos os produtos do nosso banco

    while($produto = mysqli_fetch_assoc($resultado)) { // aqui dizemos que enquanto houver produtos no nosso resultado realizaremos a logica a seguir
        array_push($produtos, $produto); // finalmente colocamos nosso produto dentro do array de produtos
}

But I believe that your object is already performing this logic and taking all the results to the $usu_info_column variable. On this basis, we will come to the solution:

LIMIT 5 -> When publishing the results, just print out only the amount you need:

for($i = 0; $i <= 5; $i++){
    echo "Data: " . $usu_info_coluna[$i][usu_datacadastro] . "Nome: " . $usu_info_coluna[$i][usu_nome];
}