0 Favourites

How do I prevent sql injection (POST METHOD)

  • I'm woking in an online game, where I have to logging and manage data from a database, I use the POST method like this:

    My problem is that, in this way, you can access to all the information trough the navigator, so, you can attack the database easily

    How can I prevent this??

    thanks.

  • Don't pass login details via post.

    Please read this Tutorial It will answer your questions.

  • Your most important layer of database protection is not C2 but PHP. I'm not really sure what DUTOIT meant by "Don't pass login details via post. ", the big majority of websites authenticate using POST. It is obvious that plain POST data with no protection is dangerous for your server, but that's why there are number of ways to protect yourself. You can encode data, params, actions etc. You can add the hashKey/ApiKey/token (whatever you call it), You can (and should) use database library whith SQL Injection protection built in... etc.

    There are really uncountable ways you can protect yourself from attacks, I suggest to google something regarding SQL Injection and XSS. This will help you understand how attacks work and you will surely find number of common ways to protect yourself.

  • Construct 3

    Buy Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Buy Now Construct 3 users don't see these ads
  • I meant not to put your database login in the post data string. Rather store those details in config.php.

    You can also add some salt

    and multiple uses for .htaccess to lock it down.

Jump to:
Active Users
There are 1 visitors browsing this topic (0 users and 1 guests)
Similar Topics Posts Views Last Post
Unread sticky
4,517 857,148
Tinimations's avatar
Tinimations
Unread sticky
1,586 437,205
matriax's avatar
matriax
Unread sticky
0 Favourites
Artists post your art
423 423,434
RanKiyomi's avatar
RanKiyomi