CodeIgniter Forums
prepared statements - Printable Version

+- CodeIgniter Forums (
+-- Forum: Archived Discussions (
+--- Forum: Archived Development & Programming (
+--- Thread: prepared statements (/thread-47516.html)

prepared statements - El Forum - 12-12-2011


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?