Home • Programming • PHP
In PHP and MySQL it's a common issue of facing problem in sending special characters to mysql from php. To overcome this issue, mysql_real_escape_string() funtion can be a solution.
Syntax of using this function in mysql and mysqli is slightly different.
If mysql:
--------------------------
Function Name :
------------------
mysql_real_escape_string(string $unescaped_string [, resource $link_identifier = NULL ] );
Step 1:
--------
The variable that contains special character e.g. ( ' ) will be placed as the first parameter of the function and the database connection as the second parameter.
$text = mysql_real_escape_string("It's a demo text" , "your database connection variable" );
Step 2:
-------
The mysql_real_escape_string() function will add a "" before every special character. To avoid this slash on output you just have to user another function stripslashes() that will remove the "".
<?php
-------------------------
-------------------------
echo stripslashes($row[0]);
?>
======================================================
======================================================
If mysqli :
---------------------------
Function Name :
------------------
mysqli_real_escape_string ( mysqli $link , string $escapestr );
Step 1:
--------
Put the database connection as the first parameter and the variable that contains special character e.g. ( ' ) as the second parameter of the function.
$text = mysqli_real_escape_string("your database connection variable" , "It's a demo text" );
Step 2:
--------
The mysqli_real_escape_string() function will also add a "" before every special character. To avoid this slash on output you just have to user another function stripslashes() that will remove the "".
<?php
-------------------------
-------------------------
echo stripslashes($row[0]);
?>
For further study you can visit the following sites:
http://php.net/manual/en/function.mysql-real-escape-string.php
http://php.net/manual/en/mysqli.real-escape-string.php
http://php.net/manual/en/function.stripslashes.php
Comments 2