Completed

I need 2 PHP pages and script that will send an email

Step 1) I need a php webpage that will run a SQL query on a MySQL DB: “Leads table” and populate columns on the webpage, I don’t need design, just info. Also we will need a column for an audio file that the user can click to stream the mp3 audio. This audio file will be obtained by running a 2nd SQL query that will take the parameter “ID” from the results of the first query. There will be a final column to the right that will be a link with the text “Approve Lead”. When the user clicks this link, Step 2 will be invoked.

Step 2) I need a script created that will take the Lead “ID” parameter from the last step. This ID will be used to run a lookup on the “Leads table” and find the “Lead-Owner ID”. This Lead-Owner ID will be used to look up the email address in another table in the same DB and you can use this to send the email. This email will be html with a subject, my logo, a footer, simple message and a link with parameters. By clicking this link, the user will go to step 3).

Step 3) The link will open a PHP webpage that, based on the link parameters, will show the lead information for the specific lead based on the “Lead ID”/link parameters and pulled from the Leads table. The audio will also need to be shown (refer to Step 2). I would like my logo and a simple footer so the page looks “presentable”. Also I would like some kind of security so that the user cant modify the link manually and get other leads. When the link clicked and webpage opened, I want to INSERT into a table, the link, lead id, Lead-Owner ID, email address, Public IP that clicked the link and the web browser used and a datetime stamp to record the time the page was opened.

Additional requirement: Once the PHP page is opened in step 3, the link and page should expire after 72 hours. After Expiration, I will want a static page that has my logo, footer and text like “we are sorry, this page has expired. Please contact your account representative for help.”

Skills: Linux, MySQL, PHP, Software Architecture

See more: php send email script, php send email script mysql, send email script php mysql, unix send email script, add email script admin area php, send email script web page, send email script, send email alerts post made php mysql, flash send email script, flash auto send email script, send email multiple users time php, send email message inside loop php mysql, send email script exchange, sql backup php zip sql send email script, using smtp php send email script, send email script procmail, can send email time form submit php, perl send email script database

About the Employer:
( 78 reviews ) Medellín, Colombia

Project ID: #12946827

Awarded to:

mahamadali

I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I have w More

$133 USD in 3 days
(542 Reviews)
7.8

33 freelancers are bidding on average $183 for this job

contact2phpsl

Greetings We have gone through your given details. Please interact with us have completed 300+ projects in PHP/MYSQL. Please check my reviews on freelancer to get an idea of quality of my work. Thanks Shiv

$100 USD in 3 days
(836 Reviews)
9.1
coolguyinus2004

i know what you need and i can do it for you as you need. Expert in PHP/MYSQL programming. Expert in stripe gateway work. Check my reviews and message me online then we can start work now. let me know thanks

$283 USD in 3 days
(356 Reviews)
7.7
saagark22

Hi, I exactly got flow of this lead script. So basically in first step we have all available leads, second setup is about fetching user email from table used in first setup and send email. Third setup is about lead inf More

$250 USD in 2 days
(382 Reviews)
7.3
cmitexperts

Hi there! Did go through your Job Description and glad to share that I have experience in working with wordpress platform. I have more than four years of industry experience and have been the part of diverse industr More

$155 USD in 3 days
(305 Reviews)
7.5
usuf001

A proposal has not yet been provided

$200 USD in 3 days
(620 Reviews)
7.5
celalaybar

Hello. Thank you very much for taking time to read my proposal. I can do it. You can check my portfolio and reviews. We can discuss further details. Hopefully, both of us will be happy after the job i More

$155 USD in 3 days
(221 Reviews)
7.5
$55 USD in 1 day
(149 Reviews)
6.8
SHIHABSHARAR

hi,I have read your requirements for the projects. I have developed a lots of email sending scripts [login to view URL] contact me so that I can show you my [login to view URL]

$200 USD in 0 days
(105 Reviews)
6.7
mobiletech1604

Dear there Thank you for posting this project. I'm Hoang and I'm experience developer. I could start working immediately, and I could finish all 3 steps within 2 days (with your supervisor) Waiting for your respond More

$200 USD in 1 day
(78 Reviews)
7.3
innovation

This is very simple task, which I may have did for many project in my 10 year career. I would love to take this project and complete it using clean and professional coding. I would be there for any updates or fixes in More

$155 USD in 2 days
(48 Reviews)
6.4
itpathsolutions

As you are looking for iOS development, iOS related technologies we offer are: - iOS: Swift, Objective-C, Cocoa-Touch (iPhone, iPad & Apple Watch) - iPhone/iPad Device Compatibility - Fast mobile UI programmi More

$300 USD in 3 days
(36 Reviews)
6.5
mcfarhat

Hey there, I am a highly experienced developer, with 13+ years of professional experience and excellent English communication skills. I have dealt with developing complex web solutions, specifically using PHP and MyS More

$500 USD in 3 days
(29 Reviews)
6.1
laxmanpatel46

hello, i have great knowledge in magento and wordpress also in create PSD, PSD to HTML Convert. sir, your job caught my attention. i check and review your job. i am abel to do your task. i have 2+ year exper More

$111 USD in 3 days
(83 Reviews)
5.8
ervivekit

Hello, I have 6 + year's of working experience in Web Development industry, and I have worked on various type's of project's like E-commerce, Music , Sports, Web-Services and etc. In various php plateform like Opencart More

$155 USD in 3 days
(56 Reviews)
4.9
saqibsaeedkhan

Hi, i am php , mysql developer. i have seen your requirement and i am interested in job. please let me know if you have any question. looking forward working with you. Regards,

$111 USD in 3 days
(32 Reviews)
4.7
aadilahlawat42

Hello Dear, I am a professional Web developer with an experience of more than 6 years in creating and customizing Web themes, extensions, application and plugins and framework like codeigniter . My expertise is in p More

$180 USD in 3 days
(18 Reviews)
4.2
hossaincse2

Hello/ Hello Sir, I have read your job description and understand your requirements. I have proper experience about many web design, html, CSS, ajax,Bootstrap,html5,CSS3, landing Page design, wordpress, Laravel,PHP More

$155 USD in 3 days
(39 Reviews)
4.4
npispas

Hello my name is Nickolas and I can help you with your project. I'm an experienced developer despite the fact that it may seem I'm new in freelancing. A sample of my work may be seen in my profile's portfolio. For More

$250 USD in 1 day
(7 Reviews)
4.1
kunjandetroja

hi sir, I am senior PHP developer, I have extensive experience of filtering data from MySQL using PHP scripts. I can do the required backend coding for you. Thanks.

$166 USD in 5 days
(5 Reviews)
3.3
developersworld7

Hi, I have more than 6 years experience of Website Development. Since now i have developed many websites on different categories with my web programming skills. Please have a look at my profile to check reviews and rat More

$400 USD in 12 days
(13 Reviews)
3.9