AlliedModders - SQL_EscapeString help

AlliedModders (https://forums.alliedmods.net/index.php)

- Scripting (https://forums.alliedmods.net/forumdisplay.php?f=107)

- - SQL_EscapeString help (https://forums.alliedmods.net/showthread.php?t=265426)

SQL_EscapeString help

Hello,

I need help for my MySQL query: when i want to save a sentence with ' , there is a problem with SQL_EscapeString (and i must use this to protect query).

PHP Code:


		
			
Format(sentence, sizeof(sentence), "Hello! I'm a man!");



SQL_EscapeString(H_Database, sentence, sentence, sizeof(sentence)); 



new String:query[512]; 

Format(query, sizeof(query), "INSERT INTO bdd_sentence(ID, Sentences) VALUES ('%d', '%s')", ID, sentence); 



SQL_TQuery(H_Database, T_CheckSQLCallback, query);

In my database, i have: Hello! I///////////////

Thank you in advance

Re: SQL_EscapeString help

You can't use the same buffer as both input and output, the output buffer also needs to be at least twice the size of the input.

Re: SQL_EscapeString help

Quote:

Originally Posted by asherkin (Post 2312789)

You can't use the same buffer as both input and output, the output buffer also needs to be at least twice the size of the input.

It's fix thank you again