Find Jobs
Hire Freelancers

Mysql query with php and bash

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I need a mysql query that will select from 1 table. it will run once every day on the server (centos 7) query must compare server date, with a date on the table, and if date is 2 weeks or less prior to the database date field, it will send email to myself and the user who is about to expire. (this field is on the same table) as always once i have tested funds will be released
Project ID: 12227260

About the project

34 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hola estoy interesado en tu proyecto tienes ya los queries que hay que ejecutar? como quieres enviar los emails? a traves de sendmail? o de otra manera? saludos [login to view URL]
$50 USD in 1 day
5.0 (42 reviews)
5.9
5.9
34 freelancers are bidding on average $90 USD for this job
User Avatar
Hello, can do this work for you. No problem with write script and setup cron for this script. Regards Denis.
$50 USD in 3 days
5.0 (83 reviews)
7.5
7.5
User Avatar
Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. i have recently also earned my preferred freelancer badge. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality. My skill-set includes... -PHP -HTML5 -CSS -AJAX -Responsive Design -Joomla -Wordpress -Magento -Drupal -Photoshop -Illustrator -Video Editing -Data entry -Iphone -Android I look forward to hearing from you and hopefully we will have the opportunity to work together. Thank you, Coasif
$222 USD in 3 days
4.8 (204 reviews)
7.1
7.1
User Avatar
Hello, I have used MySQL and email sending in Bash. Can do your project in 1h. I will need the db schema and a few rows. Thanks
$30 USD in 1 day
4.9 (149 reviews)
6.3
6.3
User Avatar
Hello. I would like to help you with MySQL query issue. I have experience. please read my feedbacks. thank you.
$40 USD in 1 day
4.9 (368 reviews)
6.5
6.5
User Avatar
Hi there I will achieve this via Cron job that should be available on your server "Centos", I mean if you already have cPanel there, have you? Let me know if you have so we will discuss more if required. Best Regards, Kashif (coder786sl).
$50 USD in 3 days
5.0 (33 reviews)
6.0
6.0
User Avatar
I have read your project. I'm sure i can help you to do it. I have 7 years of experience in Web development, System administrator and Security researcher. Choose me then you will work with a Professional Devops, you won't be disappointed. Thanks.
$50 USD in 1 day
5.0 (13 reviews)
4.4
4.4
User Avatar
Hi, i can help you create the scipt that you want. You can always contact me if you need any assistance. Thank you.
$66 USD in 3 days
5.0 (21 reviews)
4.3
4.3
User Avatar
Hello Sir, We have checked your job detail and as per that we are able to do your job and we have very good experience in WordPress, Wordpress custom plugin, Joomla, Joomla modual and component, Shopifi, PSD to CMS, PHP, HTML, Magento, TYPO3, Cubecart etc. As well knowledge on Mobile app screen Designing logo, layout, mock up and HTML, Android, Yii, Amazon webservices. We will sure give you our best work and complete your job as soon as possible. If you have any query please send me message in here. We will reply you as soon as possible. Waiting for your reply Thanks, Pinakin
$70 USD in 3 days
4.9 (33 reviews)
4.2
4.2
User Avatar
Hi I have been in this industry for 10 years and such jobs are my daily practice.I can assure you that if you work with me once, you will always work with me for these kind of projects.
$140 USD in 7 days
5.0 (1 review)
3.1
3.1
User Avatar
hi, i can help you with your project. send me more information about via freelancer.com chat. regards
$200 USD in 3 days
5.0 (7 reviews)
3.1
3.1
User Avatar
Hi, I have a lot of experience with sql as well as mysql, Contact me so we can discuss, Thank you, Juan
$155 USD in 3 days
4.5 (2 reviews)
3.0
3.0
User Avatar
Hi, Im interested to work with you, I will create a cron job so I certain script will run everyday to check each table. Feel free to contact me if you have questions
$155 USD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
Hello, I am a PHP developer. i have 3 years of experience in php development. I have experience in PHP(codeigniter,yii),mysql,bootstrap,jquery,ajax,html,css,webservices. I have my demo hosting server. Thanks.
$50 USD in 1 day
4.5 (6 reviews)
1.9
1.9
User Avatar
Hi, I'm new to freelance, but I have about 20 years of linux sysadmin experience. I think a bash script is the fastest solution to your need. It would be shorter and lighter than a php solution, unless you want to reuse it somewhere else... The script will need a user with rights to select from the table and a working MTA. I will be a pleasure to work with you.
$50 USD in 3 days
5.0 (2 reviews)
1.0
1.0
User Avatar
I am an experienced MySQL and webI will develop your project which will run CentOS. Feel free to contact me for further discussion. Regards, Moeen Ahmed
$100 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Hello I understand your requirements. I am able to do this work according to your needs. I have 2 year hand on experience in web development and one year as front end developer. I know how to optimize the images using different optimize tools. I know how to get good rating from google page speed using images optimization. I have sound knowledge of Wordpress themes, Plugin and Wordpress development. I have Knowledge about design pattern and methodology. I have knowledge about frameworks and responsive designs. I have done some projects in javascript, jquery, angular js etc and I know about backend technologies like php and mysql etc. I have done project for brlcad USA Army research labs under Google. If you like to work with me then drop a message.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to work on this module and I am pretty sure that you will be satisfied with the work. thank you and regards.
$30 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I gather your server can run Coron jobs?
$55 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can provide the necessary query script which will perform the operation defined in the requirement. I have dealt with such requirements in our product development.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Will schedule a cron to run a php script at the basic level. Will need a SMTP service like SendGrid or can send mail from php itself(but in this case the mail might end up in spam so a known service like SendGrid is recommended). Since you mentioned user, it might mean multiple emails, and will use MySQL as a queue and have a multithreaded program read off the queue and dispatch the email. All services that will be setup, will pipe info to statsd and will provide a Grafana dashboard for monitoring(this can be simplified also)
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MEXICO
Hidalgo, Mexico
5.0
17
Payment method verified
Member since Dec 7, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.