Can PAY PAL be integrated in a DB? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


hzarabet -> Can PAY PAL be integrated in a DB? (2/21/2001 20:52:00)

I am starting a paid classified page database. I want people to be able to choose the ad to run for one month or two, to include a "Must Sell" type banner for an extra fee or not.

Building the classifed page itself wasn't difficult. But how can a payment program be integrated so it know how much to charge by reading the submission data to the database. The problem I find is this:

Either I can SUBMIT the input info to the database OR the payment program. How can the same submission hit both?

I felt this is a better spot than the business forum. Thanks again all in advance.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





Bnugent -> RE: Can PAY PAL be integrated in a DB? (2/21/2001 14:29:00)

Wouldnt it be conceptually possible to do either one of the following: (Also I am assuming that you would want to verify that their credit card has been approved before you would allow the info to be displayed/posted in your database/classified).

1- Cant you use and <if> statement to A)verify that card was accepted/authorized and B) if so, post to your databse.

2- I have used authorizenet in the past and they have options that allow the data (once authorized for charges) back to your site so that you can collect the info as needed.

I know this doesnt really help you but thought I would throw it out. Keep us posted.

-------------
Brian---

[This message has been edited by Bnugent (edited 02-21-2001).]





Mojo -> RE: Can PAY PAL be integrated in a DB? (2/22/2001 20:37:00)

Brian,

Pay Pal is cool. They email the funds to your account. Either they have the money to email or they don't. My wife uses it all the time (she makes and sellsquilts online). It seemed a little strange to me at first, but it works great.

I am curious about this posted topic myself...
Joe





Spooky -> RE: Can PAY PAL be integrated in a DB? (2/22/2001 20:11:00)

How does the pay pal code look / work?

Ive not used it yet, but thought about it before Tom went with Authorize





Mojo -> RE: Can PAY PAL be integrated in a DB? (2/22/2001 20:13:00)

I have never seen it. I think everything is done through their site. My wife uses it, but she does not have a web site she just goes there.




hzarabet -> RE: Can PAY PAL be integrated in a DB? (2/22/2001 20:28:00)

Seems like a I struck a nerve with a lot of folks.

Yes it does seem good. It is NOT a shopping cart, so only 1 item can be purchased at a time, I BELIEVE. I have not yet signed up so I can't be sure.

Spooky, after I sign up, I will send you the code or you could see a bit of sample by going to www.paypal.com and going through their demo (or go to link below). It seems like good ole HTML which leads me to believe you could use ASP to pull in a dollar amount (you would normally hard code the dollar amount).

http://www.paypal.com/cgi-bin/webscr?cmd=p/web/index-outside

I am going "on the road" in the few days so this may not get done for a couple of weeks. In either case, this sounds interesting.


------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

[This message has been edited by hzarabet (edited 02-22-2001).]





hzarabet -> RE: Can PAY PAL be integrated in a DB? (2/23/2001 23:31:00)

Here you go Sppoky. I got the HTML:<P><!-- Begin PayPal Logo --><BR><FORM ACTION="https://secure.paypal.com/cgi-bin/webscr" METHOD="POST"><BR><INPUT TYPE="hidden" NAME="cmd" VALUE="_xclick"><BR><INPUT TYPE="hidden" NAME="business" VALUE=""><INPUT TYPE="hidden" NAME="return" VALUE="http://www.signingshotline.com"><INPUT TYPE="hidden" NAME="undefined_quantity" VALUE="1"><BR><INPUT TYPE="hidden" NAME="item_name" VALUE="One Month Classified Ad - Basic"><INPUT TYPE="hidden" NAME="item_number" VALUE="SHLCAB"><INPUT TYPE="hidden" NAME="amount" VALUE="9.99"><INPUT TYPE="image" SRC="http://images.paypal.com/images/x-click-but3.gif" NAME="submit" ALT="Make payments with PayPal - it's fast, free and secure!"><BR></FORM><BR><!-- End PayPal Logo --><P><BR>The <INPUT TYPE="hidden" NAME="amount" VALUE="9.99"> portion is my pricing. Can I pop some ASP code in here to pull the price in?<P><BR>There you go.<P><BR>------------------<BR> <A HREF="http://www.Signingshotline.com" TARGET=_blank>www.Signingshotline.com</A> lists EVERY upcoming athlete autograph appearance in the US and Canada<p>[This message has been edited by hzarabet (edited 02-23-2001).]




Spooky -> RE: Can PAY PAL be integrated in a DB? (2/23/2001 14:42:00)

Yep, all you need is

<%
Dim ValPrice
ValPrice = "9.99"
%>


<INPUT TYPE="hidden" NAME="amount" VALUE="<%=ValPrice%>">


Obviously you would fill ValPrice from database or some other input





hzarabet -> RE: Can PAY PAL be integrated in a DB? (2/23/2001 15:34:00)

Or I JUST had another idea...

In the HTML is a "return" URL to go to after the PayPal process is done. Depending on which of the four options they paid for, they will be directed to one of 4 different submit forms, only giving them the options that are coordinated with the price they just paid!!

VOILA!!!

I will try both ways and see how they go.

Thanks again for your expertise Spooky!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





hzarabet -> RE: Can PAY PAL be integrated in a DB? (2/23/2001 16:05:00)

Just thought of a snag. The page that the buyer is "returned" to CANNOT have a complte URL show up anywhere, otherwise they can just copy the URL and submit a listing and bypass the PayPal. So now the question is, how can I have the customer "return" to a form, but NOT have the complete URL show up in the address bar nor the source code? Can I place the form in a _private folder? I have never intentionally used this before? Is it just as easy as doing something like "return" to www.signingshotline.com/_private/submitform1.asp?

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





hzarabet -> RE: Can PAY PAL be integrated in a DB? (3/23/2001 23:49:00)

Hi Spooky. I think I'm close on this one, but new concepts are flying at me quickly and I need a hand.

I am passing a database result through to PayPal. Per your response above:

<%
Dim ValPrice
ValPrice = FP_FieldVal(fp_rs,"Price")
%>

VALUE="<%=ValPrice%>"

Here is the error message I get:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/_fpclass/fpdblib.inc, line 12

Thanks for your help.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





Spooky -> RE: Can PAY PAL be integrated in a DB? (3/24/2001 20:32:00)

FP_FieldVal(fp_rs,"Price") is a valid field?
Is it also within the DRW region?




hzarabet -> RE: Can PAY PAL be integrated in a DB? (3/24/2001 23:28:00)

Yes, FP_FieldVal(fp_rs,"Price") is a valid field and the DRW is on a diet.

SELECT ad_data.AdName, ad_data.Target, ad_data.DateStart, ad_data.DateEnd, ad_data.ImpressionsPurchased, ad_proposal.guarantee, ad_proposal.price, ad_proposal.email, Users.x_email, Companies.ContactEmail, Companies.CustomerID, ad_data.CustomerID FROM (ad_proposal INNER JOIN Users ON ad_proposal.email = Users.x_email) INNER JOIN (ad_data INNER JOIN Companies ON ad_data.CustomerID = Companies.CustomerID) ON Users.x_email = Companies.ContactEmail WHERE ad_data.status='hold' AND ad_proposal.email=Users.x_email AND Users.x_email = Companies.ContactEmail AND Users.UserName='"&Session("UserName")&"'

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





hzarabet -> RE: Can PAY PAL be integrated in a DB? (3/25/2001 13:08:00)

Couple of things...

Instead of using DIM, I tried to insert the following <%=FP_FieldVal(fp_rs,"999")%> (this is my Price field) directly into the PayPal and I get a PayPal error message leading me to believe that the price field ONLY accepts numeric values. I tried this with the item name field and it did work (this field does not require numeric values). I will call PayPAl and report back.

BTW, I got rid of the RS problem by placing the final gray "Include" code after the PAyPAl HTML.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





hzarabet -> RE: Can PAY PAL be integrated in a DB? (3/26/2001 22:21:00)

It works. You can include FP Database results directly into PayPal. The key is to make sure that your price field in yor database is set to numeric and NOT text!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375