Write a php code for getting information from MySQL

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

We have two databases in mysql server. One for products sold and one for experience. The database contains details of Price, Taxes, Discounts and Mode of Payment, Location Code, etc., See screenshot in Attachment 1 and 2

a) We need a code to pull this data together and present the information to us based on date range and detailed or summary report for location. Also based on the user name the access is restricted to one or more locations. See format in Attachment 3 and 4

b) Write a code to SMS once a day sales information to defined numbers. See format in Attachment 5

c) Create a database entry form for product sales and the location is selected based on user logged in automatically. See Attachment 6 for format.

PHP

Project ID: #10262744

About the project

13 proposals Remote project Active 7 years ago

Awarded to:

paulprabhakarand

Hi, This is Paul Devanesan [login to view URL] and [login to view URL] from IIT Mardars, having work experience of 10 years in the software industry. There are 30 members technically strong people could write any piece of code on Java based te More

₹10000 INR in 3 days
(12 Reviews)
4.1

13 freelancers are bidding on average ₹7963 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W More

₹10526 INR in 3 days
(113 Reviews)
7.1
dilshadbukhari

I have experience in PHP programming and well versed in open-sources / Framework like codenigter, opencart, Wordpress and other Web solutions . My strengths are web development, php, ajax, css, html , Web Service etc. More

₹1500 INR in 1 day
(3 Reviews)
2.0
Branpler

I'll write a php code you can install on your server. It will fire once a week or a day or an hour, parse the database and make a report (or present you an admin panel with a report). I won't provide you SMS gateway, y More

₹10000 INR in 10 days
(1 Review)
0.4
ermanjitk

Hi, I'm a Web Developer, and I'm very interested in your job post as i am having related work experience in fulfilling the need for the job posted and also i am having expertise in web based languages from static to More

₹10000 INR in 5 days
(0 Reviews)
0.0
denouezechias

It is true that I am new to the Freelancer.com platform, but you will not be disappointed by my techniques and skills about computers and also its many derivatives. I will be very happy to contact you to gather other r More

₹4444 INR in 3 days
(0 Reviews)
0.0
bidma

Having completed a similar project recently we are confident that we're the best team for your solution. We'll deliver fully documented high standard coe within 5 days.

₹8888 INR in 5 days
(0 Reviews)
0.0