• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.