Questions tagged as 'prepared-statement'

For example, I did a search of all the user data in the bank to echo echoes in different columns through the site: $stmt = $conexao->prepare("SELECT * FROM esc_usuarios WHERE usu_codigo = ?"); $stmt->bind_param("s", $usu_codigo);...

I have a problem with using preparedStatement. I have a very large SQL query (very large String), so it gives syntax error. However, when I remove some parts of the code, the error is different by increasing exactly how much I removed from the s...

I would like to know if there is any problem in using the "parameter" variable after the "AND", because when I tested putting the column name directly in SQL worked and when I try to pass the column name with the parameter does not return anythi...

Hello. I'm trying to make a CRUD using PHP OO. But when I run I get error in prepare of the PDO class. I have only for the moment the registration code in the bank and the connection code to the bank: Banco.php <?php class Banco{...

I am creating a CRUD system for practices, and my code is giving error in my prepare() . Index.php <?php require_once 'core/init.php'; // Abre a conexao com o banco de dados $pdo = db_connect(); // SQL para contar o total de reg...