[sjems]

I have got error while displaying the data having single quote "'". for example "I am some one. I don't know anything." while showing the data either only shows "I am some one. I don" or nothing shown except error. Please help me to solve the problem. i am using Php 4 or later and latest mysql verson at myisam tables

[arstanj]

Originally Posted by sjems

I have got error while displaying the data having single quote "'". for example "I am some one. I don't know anything." while showing the data either only shows "I am some one. I don" or nothing shown except error. Please help me to solve the problem. i am using Php 4 or later and latest mysql verson at myisam tables

PHP Code:

<?php

// Connect

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')

   OR die(mysql_error());



// Query

$query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",

           mysql_real_escape_string($user),

           mysql_real_escape_string($password));

?>

Happy coding!

[sjems]

Originally Posted by arstanj

PHP Code:

<?php

// Connect

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')

   OR die(mysql_error());



// Query

$query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",

           mysql_real_escape_string($user),

           mysql_real_escape_string($password));

?>

Happy coding!

is this code work in insert query too?

[arstanj]

It should work but.... the best way to learn is to TRY.

Happy coding!

[mkovach159]

you have disabled magic quotes. You can:

1. change in php.ini from magic_quotes_runtime = Off
   to magic_quotes_runtime = On
2. write this line of code at the beggining of your php script :
   
   PHP Code:

   
   set_magic_quotes_runtime(1); 
   
   
   
   

3. the best solution - use mysql_escape_string function before insterting of value to the database.