Welcome Guest, Not a member yet? Register   Sign In
passing special character to MySQL SP
#1

[eluser]dinomycle[/eluser]
i am calling a stored procedure like below in my CI +MySQL web application

Code:
$id = 3;
        $name = "ABC_(CDE)";
$sql = "call getInfo(?,?);" ;
$query=$this->db->query($sql,array($id,$name));

but i was not getting the any query result, after enabling mysql debug, below code was getting passed to the MySQL SP

Quote:518 Query call getInfo('3','ABC_(CDE)')

so i believe the SP is searching for the string with html encoding. How to pass the variable without html encoding when i call the $this->db->query()

thanks for the help
dino


Messages In This Thread
passing special character to MySQL SP - by El Forum - 08-04-2012, 09:46 PM
passing special character to MySQL SP - by El Forum - 08-04-2012, 11:14 PM
passing special character to MySQL SP - by El Forum - 08-05-2012, 12:25 AM
passing special character to MySQL SP - by El Forum - 08-06-2012, 12:03 AM
passing special character to MySQL SP - by El Forum - 09-17-2012, 06:50 PM



Theme © iAndrew 2016 - Forum software by © MyBB