CodeIgniter Forums

Full Version: prepared statements
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum


I have active record enabled in config.
$active_record = TRUE;

I can do it natively in PHP. But can someone show me how to:

$q = "SELECT username FROM users WHERE (email=? AND pass=?)";

$stmt = mysqli_prepare($dbc, $q);

if(! $stmt) echo mysqli_stmt_error($stmt);

mysqli_stmt_bind_param( $stmt, 'ss', $email, $pass );

mysqli_stmt_execute( $stmt );

in CI using the active record. Or offer an alternative solution the CI way?