Welcome Guest, Not a member yet? Register   Sign In
Mysql Stored Procedure: INOUT / OUT Paramter Support
#2

[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;


Messages In This Thread
Mysql Stored Procedure: INOUT / OUT Paramter Support - by El Forum - 07-22-2010, 04:44 PM
Mysql Stored Procedure: INOUT / OUT Paramter Support - by El Forum - 01-28-2011, 12:42 PM



Theme © iAndrew 2016 - Forum software by © MyBB