[eluser]Unknown[/eluser]
I've resorted to using PDO for this. I was hoping CI had a more simple and elegant solution. Is there a better way to do this?
e.g.
Code:
try
{
$dbh = new PDO(DB_CONN, DB_USER, DB_PASS);
$stmt = $dbh->prepare("CALL Accounts_Insert(
@account_id,
:email,
:username)");
$stmt->bindParam(':email', $email, PDO::PARAM_STR);
$stmt->bindParam(':username', $username, PDO::PARAM_STR);
$stmt->execute() or die (implode(':',$stmt->errorInfo()));
//get output parameter
foreach($dbh->query("SELECT @account_id as 'account_id'") as $row)
{
$account_id = $row['account_id'];
}
}
catch(PDOException $e)
{
exit();
}
$dbh = NULL;