How to use "mysql_real_escape_string" in a Module

[Chrims]

Hello,

 

how do i use mysql_real_escape_string in my AdminController?

 

mysql_real_escape_string($string) returns nothing ;-/

	public function makeStringSave($string)
	{
		$string = mysql_real_escape_string(utf8_decode($string));
		return $string;
	}

Is there a public PrestaShop Method?

 

Thaaannks

[Chrims]

	public function makeStringSave($string)
	{
		$string = pSQL(utf8_decode($string));
		return $string;
	}

That seems to work. Is pSQL the same as mysq_real_escape_string?

[DanielRomanMartinez]

Hello!

 

You can use...

 

$string=mysql_real_escape_string($string); 

 

Oh sorry, i didn't read. Seems a bit strange, because in my scripts i use it:

 

require_once ('config/settings.inc.php');

// DB CONNECTION (CUSTOMIZE YOURDBHOSTNAME AND YOURDBPORT)

 

$db = new PDO("mysql:host=10.6.64.25;port=3306;dbname="._DB_NAME_."", _DB_USER_, _DB_PASSWD_);

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

 

And then

 

$sql="Sentence SQL";

$res = $db->prepare($sql);

$res->execute();

$row = $res->fetch();

 

What version are you using? I am using 1.6

Edited December 14, 2015 by DanielRomanMartinez (see edit history)

[webprog]

	public function makeStringSave($string)
	{
		$string = pSQL(utf8_decode($string));
		return $string;
	}

That seems to work. Is pSQL the same as mysq_real_escape_string?

 

 

Yes. pSQL is the same as mysq_real_escape_string