Calling another page from the receipt page or the script to call the page

[inkjet]

I am looking to create another page to input the data from the order into a mysql database, i need to call a php page from the Actinics perl script and pass all the Netquotevars for the order over to it so it can be inserted in to mysql. Does anyone have a list of the Netquotevars? The only bits i dont want to pass are the credit card numbers. With Netquotevars would this work in php to display the value?

[pinbrook]

Theres a list of all NETQUOTEVARs at the end of the advanced user guide

[NormanRouxel]

Also look at the templates Act_Order00.html through Act_Order04.html. These are for each phase in the checkout. You'll see the NETQUOTEVARs being used there.

Norman

[inkjet]

Yes i see all the NETQUOTEVARs but if i try to load another page from there it just displays all the NETQUOTEVARs titles not the information that has been put in there from the order

[NormanRouxel]

You'll have to pass those NETQUOTEVAR values to your PHP page (perhaps as arguments in the URL of the calling page).

e.g. <a href=myphppage.php?val1=NETQUOTEVAR:XXX&val2=NETQUOTEVAR:YYY>

It may require JavaScript if those netquotevars contain special characters that need escaped before being passed.

I'm not a PHP user so this may need more work.

Norman

[inkjet]

Where would that line sit as if you put it on the receipt page it does not put all the values in. It will move our company name and address over and a few lines of the order but it does not move any value of the order. eg

<a href="http://www.ourdomain/phporder.php?val1=NETQUOTEVAR:PRICE&val2=NETQUOTEVAR:COMPANYCONTACTNAME&val3=NETQUOTEVAR:INVOICENAME&val4=NETQUOTEVAR:INVOICEADDRESS1&val5=NETQUOTEVAR:PRODUCTNAME&val6=NETQUOTEVAR:QUANTITY&val7=NETQUOTEVAR:TOTAL&val8=NETQUOTEVAR:SHIPPING">phporder.php</a>

displays this

Order Processed.09:59, 20th February
NETQUOTEVAR:PRICE Price
Sales Department NETQUOTEVAR:COMPANYCONTACTNAME
Gavin NETQUOTEVAR:INVOICENAME
Somewhere NETQUOTEVAR:INVOICEADDRESS1
NETQUOTEVAR:PRODUCTNAME NETQUOTEVAR:PRODUCTNAME
NETQUOTEVAR:QUANTITY NETQUOTEVAR:QUANTITY
NETQUOTEVAR:TOTAL NETQUOTEVAR:TOTAL
NETQUOTEVAR:SHIPPING NETQUOTEVAR:SHIPPING

as you can see it passes NETQUOTEVAR:COMPANYCONTACTNAME, NETQUOTEVAR:INVOICENAME and NETQUOTEVAR:INVOICEADDRESS1 but not any order costs etc..

So does it need to be put on the payment page not the reciept page or in the perl script?

[NormanRouxel]

I was only pointing you in the direction that you will have to go if you want to implement this. The actual implementation is up to you (or your programmers). Also there may be other ways to do this (but I can't think of any).

The Advanced Guide will tell you which Netquotevars are available where.

Additionally you will probably need to use JavaScript to escape the parameters as they may contain special characters that are illegal in URLs.

Norman

[inkjet]

sorry just asking if anyone knows, just looking for the best way to do it