close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

send an email on record update through subdomain

Thread began 10/07/2020 10:15 am by illbe322016 | Last modified 10/07/2020 6:41 pm by Ray Borduin | 26 views | 6 replies |

illbe322016

send an email on record update through subdomain

I have a form a user fills out, upon submit it inputs a record to a mySQL db and sends a summary to the user. The site uses an outdated version of PHP (5.1) and this scheme was created with an older version of Universal Email 5 years ago, my new Universal Email does not work with this old version on the site. I have a subdomain for this site that has a current version of PHP running and my new UE works just fine on this site. I want to send an email with the latest record info out once a new record is created on the main domain, using the subdomain to do it. Attempting to create a seperate email using the code from the old UE is way too much brain damage. Is there a way to trigger an email from the subdomain once a new record is added to the db? I can access the db from both the domain and subdomain sites. Thank you in advance - Tom

Sign in to reply to this post

Ray BorduinWebAssist

You could hand code a curl() call to execute code on another domain. It would require some hand coding, but wouldn't be too difficult. This is something I could help with in a premier support ticket if you aren't comfortable writing php code.

Sign in to reply to this post
Did this help? Tips are appreciated...

illbe322016

Originally Said By: Ray Borduin
  You could hand code a curl() call to execute code on another domain. It would require some hand coding, but wouldn't be too difficult. This is something I could help with in a premier support ticket if you aren't comfortable writing php code.  
Sign in to reply to this post

illbe322016

Originally Said By: Ray Borduin
  You could hand code a curl() call to execute code on another domain. It would require some hand coding, but wouldn't be too difficult. This is something I could help with in a premier support ticket if you aren't comfortable writing php code.  



One thing I wondered about is mySQL triggers, isn't there a way to notify a domain (or subdomain) that a record has been created on a db that domain (or subdomain) has access to?

Just thinking out loud, I may be off base.

Tom

Sign in to reply to this post

Ray BorduinWebAssist

Maybe... I've never done that. You could google it and see. I know you can do things in the database based on triggers, but I've never initiated an email.

Sign in to reply to this post
Did this help? Tips are appreciated...

illbe322016

OK, maybe I'm making this more complex than it needs to be. My main issue it that I want to send two differently formatted emails using the old version of UE, one to the user and one to our sales team. First of all can this be done? The old email template is a nightmare of code defining every line and comma but I have no way to edit it except by hand (I used to be able to edit the body in the older version and that was discontinued I assume because now you can send an email as an html file). If I were to create another email template by hand how would I add that to my current (old) code so both were sent to the proper place? I have attached the old code blocks as a reference.

Sign in to reply to this post

Ray BorduinWebAssist

The new version of universal email should work on the old php version your site runs. You should be able to open the old server behavior with the new one and it would update the old code to add it to a .php page.

You can send two emails from the same page. Just make sure the first one doesn't have a redirect specified or it won't have a chance to send the second.

Sign in to reply to this post
Did this help? Tips are appreciated...

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...