how to integrate PHP and mySql in Quark 8

Discuss Interactive Design & Flash® (SWF) Export inside QuarkXPress 7, 8 & 9.
Exchange ideas, share helpful tips and get started with your first interactive design.
Please note that Flash (SWF) authoring is not supported in QuarkXPress 10 anymore.
Odin
Posts: 31
Joined: 20 Apr 2010, 16:08

how to integrate PHP and mySql in Quark 8

Post by Odin » 30 May 2010, 22:21

First question answered fine, thanks :)Second one: in your little "tutorial" you write: "click up" that triggers an action "Internet > Submit Page", method POST, to the URL of my PHP script (e.g. "http://www.yourdomain.com/mailscript.php")"In an earlier post you wrote "Event "click up" execute the action "Text > Post to URL", "All editable Objects", method POST."Well I see that for both POST is used, but for the first version how would it know which editable objects to take, anyway nothing happens if I only do the first one!

Matthias Guenther (Quark)
Quarkian
Quarkian
Posts: 2490
Joined: 04 Jun 2004, 15:06
Contact:

how to integrate PHP and mySql in Quark 8

Post by Matthias Guenther (Quark) » 30 May 2010, 23:17

Hi Odin,
ok, first GET and POST are two methods of postign data to a server. Look in Wikipedia or w3c.org to see the difference.
In Interactive you have several ways of posting text to a URL (with a script listening to it), it shouldn't matterwhich you choose, only the behaviour of your browser might be different (staying on the page versus navigating away from it).
In both cases the data of all editable text objects is posted, so you need editable text objects with data in it.
When you say "nothing happens" are you saying your script doesn't receive any data?
Thanks
Matthias

dutch_dave
Posts: 8
Joined: 19 Jan 2010, 06:15

how to integrate PHP and mySql in Quark 8

Post by dutch_dave » 09 Jun 2010, 22:24

Hi Matthias,
Can you help me with the following: I need to built in an action script in a flashfile to activate an overlay screen from the CMS we work in. This action script I got from the webmaster:
getURL("javascriptofferte();")
So I created a text button called 'calculate price' with this event:
click up, internet/submit_page, POST, active page, URL (action script above). When I click on the text button it doesn't work (I can click, but no action). Any idea?
And how can I activate an emaillink? Doesn't work either.
Regards,
David

Matthias Guenther (Quark)
Quarkian
Quarkian
Posts: 2490
Joined: 04 Jun 2004, 15:06
Contact:

how to integrate PHP and mySql in Quark 8

Post by Matthias Guenther (Quark) » 09 Jun 2010, 22:45

Hi Dave,
you cannot put ActionScript into QuarkXPress. If it is a URL call, of course you can.
In your post it says "Blocked Script". Can you please repost (maybe by puttign some spaces in between), so that I can read it?
Thanks
Matthias

dutch_dave
Posts: 8
Joined: 19 Jan 2010, 06:15

how to integrate PHP and mySql in Quark 8

Post by dutch_dave » 09 Jun 2010, 23:46

Image
If you tell me how to insert an email link (this event doesn't work either): click up / internet/sent_page, active page, URL: mailto:quotation@ikwilkaarten.nl. I must do something wrong...
Regards,
David

Matthias Guenther (Quark)
Quarkian
Quarkian
Posts: 2490
Joined: 04 Jun 2004, 15:06
Contact:

how to integrate PHP and mySql in Quark 8

Post by Matthias Guenther (Quark) » 10 Jun 2010, 01:31

Hi Dave,
this envokes a JavaScript that does something. You cannot call JavaScript out of QuarkXPress unless it has a complete URL. Also, I doubt that this woudl work out of Flash even if you could, as I assume the JavaScript will do something with the HTML or URL you are currently displaying.
Out of interest, what does the function actually do?

Thanks
Matthias

dutch_dave
Posts: 8
Joined: 19 Jan 2010, 06:15

how to integrate PHP and mySql in Quark 8

Post by dutch_dave » 10 Jun 2010, 02:02

It shows this quotation module (when customers have logged in). This has been integrated in a CMS system we are working in:
http://www.24x.nl/kaarten2/kaartmailing/A5-41.html
Image http://www.ikwilkaarten.nl/test1in.swf (for customers that have logged in, they will see the overlay screen)
http://www.ikwilkaarten.nl/test1out.swf (for prospects... they cannot log in, this link just should create an email)
Regards,
David

Matthias Guenther (Quark)
Quarkian
Quarkian
Posts: 2490
Joined: 04 Jun 2004, 15:06
Contact:

how to integrate PHP and mySql in Quark 8

Post by Matthias Guenther (Quark) » 10 Jun 2010, 02:07

Hi Dave,
understood.
If it is "just" an HTML window, is there a direct URL you can call to trigger the module?
Inthat case it would be doable.
Regards
Matthias

dutch_dave
Posts: 8
Joined: 19 Jan 2010, 06:15

how to integrate PHP and mySql in Quark 8

Post by dutch_dave » 10 Jun 2010, 02:46

They made this testfile in Flash.
http://www.ikwilkaarten.nl/testflash.fla (CS4)
Maybe you can tell me if this will work in Quark too? Else I need to find another solution. BTW: where can I find info about how to send an email with an event?

Regards,
David

dutch_dave
Posts: 8
Joined: 19 Jan 2010, 06:15

how to integrate PHP and mySql in Quark 8

Post by dutch_dave » 10 Jun 2010, 03:09

I checked the .fla file myself and copy pasted javascript : offerte() in the URL and the overlay popped up (the blank space before and after : I added to avoid this script will be blocked).
http://www.24x.nl/kaarten2/kaartmailing/A5-41.html

So it's indeed a URL we need to post. Any idea what I am doing wrong? The event is linked to the object, added to the script, the script is activated in the page (enter script). So I don't see why it doesn't work. Even the email link doesn't work.
Regards,
David

Locked

Return to “General authoring questions”