StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7304492
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-09-05T06:24:43
FavoriteCount
0
LastActivityDate
2011-09-05T06:24:43
LastEditDate
LastEditorUserId
0
OwnerUserId
614766
ParentId
7304453
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
An identical question was posed <a href="http://www.webmasterworld.com/forum88/5375.htm" rel="nofollow">here</a> and should give you the answers you need. If you need clarification please comment. To quote that answer, it involves submitting data to your PHP, then using a socket request to send that data to PayPal: <pre><code>function post($host, $path, $data) { $http_response = ''; $content_length = strlen($data); $fp = fsockopen($host, 80); fputs($fp, "POST $path HTTP/1.1\r\n"); fputs($fp, "Host: $host\r\n"); fputs($fp, "Content-Type: application/x-www-form-urlencoded\r\n"); fputs($fp, "Content-Length: $content_length\r\n"); fputs($fp, "Connection: close\r\n\r\n"); fputs($fp, $data); while (!feof($fp)) $http_response .= fgets($fp, 28); fclose($fp); return $http_response; } $postdata = '?foo=bar'; foreach($_POST as $key => $val) $postdata .= '&'.$key.'='.$val; </code></pre> Important Notes: I copied that code from the thread I linked, so check it out for more information. Also, this will submit to your PHP. You'll need to redirect the user to that POST request if you want them to actually view the PayPal page. Moreover, it seems like you might benefit from using PayPal's Instant Payment Notification feature. This essentially calls back a URL of your choosing with all of the payment information. I found <a href="http://net.tutsplus.com/tutorials/php/using-paypals-instant-payment-notification-with-php/" rel="nofollow">this tutorial</a> immensely helpful in learning how to do this in PHP.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSubmit PayPal form & Update Database at same time
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USShaneC
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COTo add to this, I would use the call back feature of paypal. Do you really want to save data in the event the transaction fails? Submit the data, if it goes through successfully via Paypal, THEN save the data to your DB.
 singulars
 PostPostId
 PO
 UserUserId
 USluckytaxi
2. COI very much agree with @luckytaxi. The only time where you may want to implement the method you've asked about is if you want to save information on orders, regardless of if they've been cancelled or not.
 singulars
 PostPostId
 PO
 UserUserId
 USShaneC

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.