Jump to content

Archived

This topic is now archived and is closed to further replies.

Backspace

mysql and $_GET

Recommended Posts

i cant get it to work if i try to use $_GET. heres the code that does.

$query = 'SELECT * FROM codes WHERE code = \'code_data\'';


now when i tried

$query = 'SELECT * FROM codes WHERE code = '.addslashes($_GET['code'])'';

it says that it cannot find that row.

Share this post


Link to post
Share on other sites
It looks like the quoting is all wrong for the second query -- what the query look like when you echo it in PHP?

Share this post


Link to post
Share on other sites
This is what it echos as the mysql error.

Query failed: Unknown column 'something' in 'where clause'

Share this post


Link to post
Share on other sites
Is magic_quotes on? If so, the addslashes() will mess up your query.

Use get_magic_quotes_gpc() to find out if they are turned on.

Share this post


Link to post
Share on other sites
shouldn't it look like below with the trailing period ?

[code]
$query = 'SELECT * FROM codes WHERE code = '.addslashes($_GET['code']).'';
[/code]

Share this post


Link to post
Share on other sites
Not sure why you're concatenating an empty string -- does it work without the addslashes()?

Share this post


Link to post
Share on other sites
I turned off magic quotes and tried that, it dident work. and withought the addslashes it still gives the same error

Query failed: Unknown column 'something' in 'where clause'

is there anyway to get it to look like the one that did work
\'code_data\''

i also tried to use $str = $_GET['code'] and it used $str as the name lol.

also it works with just $_GET when i add this into the URL

[a href=\"http://localhost/codelist.php?code='pso'\" target=\"_blank\"]http://localhost/codelist.php?code='code'[/a]

the ' ', is there syntax for this so i can place into that code without error.

edit: nm i got it to work by adding that into the url thanks.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.