a little paypal action

[deckerjohnc]

<input type="hidden" name="item_name" value=<? echo "row->item_name" ?>>
<input type="hidden" name="item_number" value=<"? echo "row->item_id" ?">
<input type="hidden" name="amount" value="11.99">

Hey guys, here is the retard question of the day, is there a way to take the standard paypal cart code from the site and stick some database values in it, I think the pasting might have messed up the braces, but does anyone get what I am trying to do, it keeps returning the literal string...not the correct value(even if I think I have formatted it correctly. Anyone have a guess as to whether this is possible? How should I change the standard line? The paypal stock code looks like this

<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="business" value="[e-mail]">
<input type="hidden" name="item_name" value="CHILDRENS HORSE T-SHIRT">
<input type="hidden" name="item_number" value="CT-HRS">
<input type="hidden" name="amount" value="11.99">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="currency_code" value="USD">
<input type="image" src="https://www.paypal.com/images/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<input type="hidden" name="add" value="1">
</form>

[jkohns]

Don't quote your calls to your object. ie:

<input type="hidden" name="item_name" value=<? echo $row->item_name ?>>

[deckerjohnc]

<input type="hidden" name="item_name" value=<? echo "$row->item_name" ?>>

I tried that before, it doesn't seem to work. There is the eact line I used, It simply spits a literal string, and I would like it to return the database value

Thanks for everyones help

[jkohns]

again, watch your quotes in the $object->method call

<input type="hidden" name="item_name" value=<? echo $row->"item_name" ?>>

not

<input type="hidden" name="item_name" value=<? echo "$row->item_name" ?>>

[deckerjohnc]

Thanks for your help, I am just starting off with all this, and you've been great one more question

When I make the call to the database (MySQL) It only returns the first word of the Item name (Boys Horse T-Shirt) within the shopping cart, is this a MySQL problem or a PHP formatting problem. Curently I have tryed makin the column varchar and text. Is there some sort of trimming or concatination I have to do?

[deckerjohnc]

update, I tried your method and it doesnt seem to work,(gets a parse error) but I stumbled across the solution: This line returns the proper data, but I have that little problem with formatting the result as stated above. If I make item_name all one word, its fine but when its two or more, it only grabs the first.

<input type="hidden" name="item_name" value=<? echo "$row->item_name" ?>

Notice I took off the > that one would think should be there to close the input tag.....but hey, who said HTML is logical....any explanation for that??

[jkohns]

make sure that you're not using an un-escaped apostrophe in the name:

Boy's Horse T-Shirt

would cut the insert inton the DB to 'boy'

[jkohns]

Sorry, my mistake, I missed somethign the first time 'round:

should be:
<input type="hidden" name="item_name" value="<? echo $row->"item_name" ?>">

the quotes before around the value output from php tell html that it's all part of the value of item_name.

sometimes, it helps if you take all the variables out, and write in what you expect in the html, then go back and insert the variables as needed. ie:

you want to see:

<input type="hidden" name="item_name" value="boy\'s horse t-shirt">

so if you replace the boy\'s horse t-shirt with the php section, you get the end result, which is what you want in your php code