StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSubmit PayPal form & Update Database at same time
primarykey
Id
7304453
data
AcceptedAnswerId
7304476
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-09-05T06:19:24.853
FavoriteCount
2
LastActivityDate
2017-08-26T07:49:49.693
LastEditDate
2011-09-05T06:24:29.567
LastEditorUserId
718359
OwnerUserId
718359
ParentId
0
PostTypeId
1
Score
2
ViewCount
8778
LastEditorDisplayName
text
Body
<p>If I use the standard PayPal form for payments can I also update my db at the same time, by changing the code slightly to include the update details?</p> <p>This is the standard PayPal payment form I want to use - Will change as necessary..</p> <pre><code> <form action="https://www.paypal.com/cgi-bin/webscr" method="post" id="payPalForm"> <input type="hidden" name="item_number" value="01 - General Payment to FreelanceSwitch.com"> <input type="hidden" name="cmd" value="_xclick"> <input type="hidden" name="no_note" value="1"> <input type="hidden" name="business" value="your@paypalaccount.com"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="return" value="http://freelanceswitch.com/payment-complete/"> Item Details:<br /><input name="item_name" type="text" id="item_name" size="45"> <br /><br /> Amount: <br /><input name="amount" type="text" id="amount" size="45"> <br /><br /> <input type="submit" name="Submit" value="Submit"> </form> </code></pre> <p>This is my update coding in my page:</p> <pre><code> $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form")) { $updateSQL = sprintf("UPDATE db SET payment_page_completed=%s WHERE id=%s", GetSQLValueString($_POST['payment_page_completed'], "text"), GetSQLValueString($_POST['id'], "int")); mysql_select_db($database_connAdmin, $connAdmin); $Result1 = mysql_query($updateSQL, $connAdmin) or die(mysql_error()); //$updateGoTo = "confirmation"; WILL NEED TO CHANGE AS NEEDS TO GO TO PAYPAL if (isset($_SERVER['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?"; $updateGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $updateGoTo)); } </code></pre> <p>This is my current form</p> <pre><code> <form action="<?php echo $editFormAction; ?>" name="form" class="" id="form" method="POST" enctype="multipart/form-data"> <input type="hidden" name="id" value="<?php echo $_SESSION['id']; ?>" readonly="readonly"> <input type="hidden" name="payment_page_completed" value="yes" readonly="readonly"> </form> </code></pre> <p>Thank you</p>
Tags
<php><mysql><paypal>
Title
Submit PayPal form & Update Database at same time
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser718359
UserOwnerUserId
1. USuser718359
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POSubmit PayPal form & Update Database at same time
  UserUserId
  USKyleVan
  VoteTypeVoteTypeId
  VTFavorite
2. VO
  singulars
  PostPostId
  POSubmit PayPal form & Update Database at same time
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POSubmit PayPal form & Update Database at same time
  UserUserId
  USChristophe Geers
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId
1. This table or related slice is empty.

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.