prepared statements - Printable Version

prepared statements - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: prepared statements (/showthread.php?tid=47516)

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?