I coded a 2-page webform that captures data and inserts into AWS MySQL database. That works fine! Also, I created some DB tables and stored procedures to assign the task to users based on fewest amount of tasks. That works fine!
After inserting the data and having the task assigned to a user, I need to send an email message to the person that filled out the form (To) and (From) the person that was assigned the task.
If I use AWS' [login to view URL] and enter my host, smtp username and password, the email is sent when I specify the recipient, sender, subject and body, but I need it to be dynamic and pull from the database.
There are 3 schema files attached:
crm_users - lists the internal id, username and their email address - these are the only fields in need from this table.
whp - lists the data from the web forms that a potential client enters. I need the following fields from this (wpbestp_home_purchase) table:
fName, lName, assigned_to, property_state, lead_status
28 фрилансеров(-а) готовы выполнить эту работу в среднем за $22/час
Hello I understood your requirement but I have few doubts, text me so I can clear all my doubts right away, I can help you and i am ready for work. Thank you
Hi, I am AWS, MySQL, PHP expert developer. So I can handle your problem perfeclty. Please contact me for our project. I will do my best if you choose me as a developer. Especially PHP and MySQL are my main skills.