[benbacardi]

Use this PHP:

<?php if (isset($_GET['buy'])) {
echo 'Thank you!';
} ?>

[martin leblanc]

benbacardi, on Apr 19 2007, 02:18 PM, said:

What's the search box called? I think they'd have to be seperate querys per table but I'm not sure, for example:

ALBUM RESULTS:
(then list results of "SELECT * FROM music_albums WHERE prod_name LIKE '%".$_POST['seach']."%' OR prod_artist LIKE '%".$_POST['search']."%'" )

SINGLE RESULTS:
etc

Where $_POST['search'] is the reference to whatever the user typed in

'%".$_POST['seach']."%' ... is a security issue bacuse it allows SQL-injection :-/

Also do some checking on a variable like that instead of just placing it in the SQL.

[benbacardi]

Actually, with the latest versions of PHP, PHP automatically escapes any charactors that can be used for SQL injection, so avoiding that issue

[martin leblanc]

benbacardi, on Apr 22 2007, 07:48 AM, said:

Actually, with the latest versions of PHP, PHP automatically escapes any charactors that can be used for SQL injection, so avoiding that issue

I wouldn't rely too much on the security built in PHP!

[Man2u2uk]

<?php if (isset($_GET['buy'])) {
echo 'Thank you!';
} ?>

i am guessing i would put this at the top of each page that i use the "Add" button on?

but i think i will have a problem as i have built my shop using case statements to load each page.

and i have set it to always default to index.php, so would the echo still work?

Thanks.

[Ben Abrams]

Man2u2uk, on Apr 21 2007, 06:55 PM, said:

Woot works like a dream

the following code:

<? echo '<a href ="'.$_SERVER['PHP_SELF'].
'?buy='.$i.'">Add</a>';?> </div>

places the word "Add" next to each procuct, when "Add" is clicked it adds the product to my basket which works fine...

how can i get it so that after clicking on "Add" it will display a message saying "You have just added (item) to you cart"

explain what you mean? the link could simplt link back to a page that says product added, and then refreshes you back to the last page (like how it does on webradiance, when you do a search)

[Man2u2uk]

Well at the moment, when i click add it takes me back to the shops home page. really i would like it to say

"You have just added (Item Name Goes Here) to your shopping cart" and then either take them back to the home page.

or give them the option to carry on shopping or goto the checkout

[benbacardi]

In my shopping cart site, the Add to Basket button links to a page (addbasket.php) which takes a GET arguement of the ID to be added, adds that ID, then redirects to the basket page...

For example:

viewproduct.php?id=12 ---> addbasket.php?id=12 -- > viewbasket.php