close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Updating a record when landing on a page

Thread began 3/21/2014 6:33 pm by iainmacdonald331081 | Last modified 3/25/2014 2:51 pm by iainmacdonald331081 | 166 views | 4 replies |

iainmacdonald331081

Updating a record when landing on a page

I'm used to the normal way of updating a record when a form is submitted, but have a requirement to update a record simply by landing on a page.

The context is basically updating a 'paid' field to yes if a payment on PayPal has been successful.

So the idea is that people click to make a payment for a property, which is listed in a table of properties, and includes a field 'paid'. They go to the Paypal site, and if the payment is successful they are returned to a 'success' page.

And the action of arriving on that success page is enough to update 'paid' to 'yes'.

Is there any way something like this could easily be achieved?

I'm not sure it would be and that it would need some sort of workaround eg a simple form with a button to continue, which would update the field.

Which would work, but only if people actually did click on the button.

Hope that makes sense, thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

What paypal system are you using? it would sound like you are using paypal standard.

what you propose has a number of flaws:
what is to stop a person from simply going to the checkout success page and triggering the update?

with paypal standard you would set up an IPN page to do the update. when the transaction is processed, paypal will make an ipn post to a [page you set up, on the IPN page, you can do the update. see here for more details on IPN:
https://developer.paypal.com/docs/classic/ipn/integration-guide/IPNIntro/

instead of using paypal standard and IPN, I would suggest using Express Checkout, it is a real time payment method, it is also free like Paypal Express and gives the same checkout experience.

Unlike payments standard, the order insert can happen on successful transaction so there is no need for an update.

Sign in to reply to this post

iainmacdonald331081

Thanks Jason - I will have a look at that. I agree about the flaws, but the client wants to automate as much of a process as possible. At the moment people have the choice of requesting an invoice, or going to Paypal to pay. Its a very simple set up just using a Paypal button rather than any cart to speak of.

Sign in to reply to this post

Jason ByrnesWebAssist

on the surface it may seem simple, but you will find that the lifting you need to do from the development side is not so simple.

it would be much simpler to use paypal express.

Sign in to reply to this post

iainmacdonald331081

Hi Jason - sorry - I didn't mean to suggest this was simple to implement. I just meant that the current set up is just a simple Paypal button.

The client sent me a link for Actinec to look at. At the moment they only sell the odd subscription, but are at the stage where they might be considering some sort of cart, in which case I may end up dusting down my eCart extension.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...