PHP getting exhausted ?

beef-

Umm, i was just coding (hurray fo nuub's) and i came across this error that i have never seen before, and worse yet, i have no clue how to fix it, heres the error:

Fatal error: Allowed memory size of 4194304 bytes exhausted (tried to allocate 11520 bytes) in /usr/home/ghettopile/public_html/cc/login.php on line 14

the code that causes this error:

$query = 'SELECT * FROM ccusers';
$query .= ' WHERE username=\'' . $_POST['user'] . '\'';
$query .= ' AND password=\'' . $_POST['pass'] . '\'';
$result = mysql_query($query, $mysql_link) or die ("<br>Invalid query to database, please contact the webmaster. The error returned was " . mysql_error() . "From the query " . $query);

The error only happens when i log in correctly, when i login using bad username/combo,

else {
die("Invalid Username/Password Combination");
 }

kicks in 😃

herve

Hi,

very strange error indeed !

Try to escape your ' character in the query, like that :

$query = 'SELECT * FROM ccusers';
$query .= ' WHERE username = \ ' ' . $POST['user'] . ' \ ' ';
$query .= ' AND password= \ ' ' . $POST['pass'] . ' \ ' ';

PS : I have put extra space character between the \ and the '
but you shouldn't, it's just for here, otherwise it won't be displayed correctly here in the forum.

Hervé.

beef-

Thanks man, the above code didnt work tho :/

Heres the code i used agian, accept i placed it in one line:

$query = 'SELECT * FROM ccusers WHERE username = \'' . $_POST['user'] . '\' AND password= \'' . $_POST['pass'] . '\'';

and the error is:

Fatal error: Allowed memory size of 4194304 bytes exhausted (tried to allocate 11520 bytes) in /usr/home/ghettopile/public_html/cc/login.php on line 12

[deleted]

PHP has many safety features, and on of those is the memory-usage limit.

You can only use as much RAM as the config allows. This is stop scripts from hogging all the memory and crashing the system.

There is something in your script that apparently takes lots of ram. It does ofcourse not have to be that piece of the code where the error occurs.

If you create a var that takes 4194250 bytes, and you try to create a new var that takes 60 bytes, then you go over the 4194304 limit and get an error at the point where you created the alst var, but the cause of the problem lies at the first var.