CodeIgniter Forums
prepared statements - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: prepared statements (/thread-47516.html)



prepared statements - El Forum - 12-12-2011

[eluser]1cookie[/eluser]
hi

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

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

Code:
$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?