Best way to prevent SQL Injection?

Question

4.00/5 (1 vote)

See more:

Hi guys... i was just wondering what will be the best approach to prevent SQL Injection? Some suggested to use addslashes and some suggested to use mysql_real_escape_string() now i just want to know what is the best function to use?

Posted 15-Feb-12 22:01pm

Madzmar25

Add a Solution

5 solutions

Solution 1

use stored procedures with parameters

Posted 15-Feb-12 22:03pm

Herman<T>.Instance

Comments

AmitGajjar 16-Feb-12 5:29am

ofcourse 5+

Solution 2

XKCD[^].

Posted 15-Feb-12 22:19pm

CPallini

Comments

Herman<T>.Instance 16-Feb-12 4:20am

cool!

CPallini 17-Feb-12 5:48am

Thanks.

thatraja 16-Feb-12 22:19pm

5! :)

CPallini 17-Feb-12 5:48am

Thank you.

Solution 4

SQL Injection is a one kind of attack where the attacker generates malicious code and send into SQL query to access database or system.

For more please visit..
http://cybarlab.blogspot.com/2013/02/what-is-sql-injection.html

Posted 5-Feb-13 0:10am

Rasadul Alam Rashed

Solution 5

SQL Injection is a one kind of attack where the attacker generates malicious code and send into SQL query to access database or system.

For more please visit..

http://cybarlab.blogspot.com/2013/02/what-is-sql-injection.html

Posted 5-Feb-13 0:22am

Rasadul Alam Rashed

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CRDave1988 · Accepted Answer · 2012-02-15T22:23:00

In security u can not relay on only 1 mechanism u should have more so if intruder break one u have second ready.

The following link will help u to develop some good security against SQL Injection.

Preventing SQL Injection with PHP[^]

SQL Injection Attacks and Some Tips on How to Prevent Them[^]

Best way to stop SQL Injection in PHP[^]

Best way to prevent SQL Injection?

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Best way to prevent SQL Injection?

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us