Re: [PHP-DB] SQL Injection attack

2005-08-25 Thread Vicente
Estimado veditio, you wrote: > I've got a ton of forms that use the $_POST variable to send > information into the database [...] > Any suggestions on how to tighten up the form security, or does > magic_quotes help enough? I'm not a security expert but after some attacks I have implemented this

Re: [PHP-DB] SQL Injection attack

2005-08-25 Thread tg-php
Haha.. what the hell? Ok, I know this is an older copy of the script I wrote because I know I took out the "All this does is escape the data" comment and I KNOW I saw the thing about mysql_escape_string() being deprecated... don't know why it's still in there. Hah Thanks for pointing that out

Re: [PHP-DB] SQL Injection attack

2005-08-25 Thread Jordan Miller
NOTE: http://www.php.net/mysql_escape_string "Version: 4.3.0 Description: This function became deprecated, do not use this function. Instead, use mysql_real_escape_string()." Jordan On Aug 25, 2005, at 2:15 PM, <[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: Using mysql_escape_string shoul

Re: [PHP-DB] SQL Injection attack

2005-08-25 Thread tg-php
I'm pretty amateur at this too, but have done a little reading on the subject. Here's some nuggets to ponder while the real experts write their responses: :) 1. Magic quotes + mysql_escape_string = double escaped stuff. I think the general opinion is the magic quotes is evil, but I'm sure some

[PHP-DB] SQL Injection attack

2005-08-25 Thread veditio
Greetings all: Using PHP 4.3.xx and MySQL 4.1 (and 3.xxx sometimes). I've got a ton of forms that use the $_POST variable to send information into the database, and I'm worried about injection attacks. My server has magic_quotes enabled, which I thought would handle most things, but am wonderi

RE: [PHP-DB] sql injection attack, protection from

2005-05-17 Thread Juffermans, Jos
e from injections, I still verify the data. Jos -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: 16 May 2005 23:55 To: php-db@lists.php.net Subject: [PHP-DB] sql injection attack, protection from I'm new to PHP and would like to make certain that I have the basic prote

[PHP-DB] sql injection attack, protection from

2005-05-16 Thread mayo
I'm new to PHP and would like to make certain that I have the basic protection for the site: Use double quotes to contain variable Use mysql_escape_string so that query is considered part of the WHERE clause. $result=mysql_query('SELECT * FROM users WHERE username="'.mysql_escape_string($_GET['