Completed

php search form for filtering data on a mysql database

I have a mysql database with a table called sms_in. the structure for sms_in is:

CREATE TABLE sms_in (id int NOT NULL auto_increment,

sms_text varchar(1600),

sender_number varchar(50),

sent_dt datetime,

PRIMARY KEY (id)) default charset=utf8;

The table is constantly receiving data after every hour. This data comes from mobile phones in form of an sms and is saved in the table sms_in. sample data can be found in the attached database

The time the message was received is stored in the field sender_number, the time it was received is stored in the field sent_dt and the SMS message itself is stored in the fields sms_text

Only two kinds of sms data are received. The one starting with DAILYREPORT and the one starting with TRIPSUMMARY. Each SMS message has parameters with different values

You are needed to create two php webforms to be able to filter the data in the table for a user and for an administrator.

For the user, you first filter the data by a date range, then by a keyword to be input by the user. Once the user enters the date range and the keyword, he will press the update button and data filtered in that criteria is displayed. Now for the filtered data, you should display the sum of individual variables as indicated in the user interface. He can also download the filtered data to his computer

For the Administrator, you also filter the data by a date range, then by a keyword. The only difference here is that the keyword is preset and the administrator does not type it on the form. The keyword is preset as DAILYREPORT. So once administrator enters the date range, the form filters the data in sms_in table based on the date range and the keyword DAILYREPORT. The filtered data is then displayed on the form. Now for the filtered data, the sum of all the individual parameters is displayed as shown in the Admin user interface attached. he can also download the filtered data

The administrator can also add/remove another administrator, add/remove another user and view the audit trail of who logged in/out and when

Deliverable: all files and any scripts for the database that I can upload to my subdomain to display the two search forms

A sample of the two kinds of SMS is as below

SMS 1:

TRIPSUMMARY, KBM920Y, TripNo=8, Destination=thika,nakuru, Begin=14:23, End=19:39, TripCardTickets=0, TripCashTickets=21, TripTotalTickets=21, TripCashSales=1200, TripCardSales=700, TripGrossSales=1900, TripFuel&Other=8000, TripCardTopUp=3000

SMS 2:

DAILYREPORT, KBM920Y, DailyFuel&Other=3000, DailyCardTickets=60, DailyCashTickets=90, DailyTotalTickets=150, DailyCardSales=300, DailyCashSales=5000, DailyGrossSales=7000, DailyCardTopUp=40000

Skills: AJAX, Javascript, MySQL, PHP

See more: php search form select mysql, send form data mysql database using php, web form collects data mysql database, php parse email data mysql database, save xml data mysql database php, perl script write form data mysql database, export data mysql database xls php, appending data mysql database php forms, form data mysql database phpmyadmin, php search form mysql, php search form database arabic, php send email writing data mysql database form, display last data mysql database php, send form data mysql database php, php script import access data mysql database, wordpress form post data mysql database

About the Employer:
( 3 reviews ) nairobi, Kenya

Project ID: #18174113

Awarded to:

graccasoft

Hello I believe I am the guy for this task. Your requirements are very clear and straightforward and so this will not take me time to deliver. I can deliver to you the scripts and extra database tables all working a More

$77 USD in 1 day
(80 Reviews)
6.4

27 freelancers are bidding on average $139 for this job

mingxiao2008

Hi I have read your requirements carefully. I am high skilled and rich experienced in PHP and MySQL. If you share more details,I can start work. Best Regards.

$200 USD in 3 days
(92 Reviews)
8.0
xiqian88

Dear, sir. How are you? I saw your project description in detail with curiosity. I have experiences in web field using JavaScript frameworks and PHP frameworks, python frameworks Also, I can develop mobile apps usin More

$120 USD in 3 days
(43 Reviews)
7.1
widadsaghir1993

Hi there. I think, I can help you perfectly with your PHP Search form development project as a serious professional PHP developer. As you can see my profile, long history of working on this area, so I can be the suit More

$200 USD in 2 days
(95 Reviews)
7.2
KashirinA

Dear client I can make your job perfectly I have good skills about php I can make your job perfectly I think that your job is not diffcult for me My main style is code quality and rocket speed I think that More

$200 USD in 1 day
(99 Reviews)
7.0
yuriyes43

Hello. I just read your job description. Your job really attracts me. As you can see, I am a individual full stack developer who has rich experience in web developing. I have been working as full stack developer mo More

$200 USD in 7 days
(72 Reviews)
6.4
ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on with more than 5 years experience. Please feel free to contact me. I am looking forward to hear from you. More

$80 USD in 2 days
(102 Reviews)
6.4
Mickelson

Hi Nice to meet you. I have same site using Twilio. If you want, I can share login and instructions. Let me know if you are interested in me. Regards. Lian

$250 USD in 3 days
(76 Reviews)
6.3
naravila

Hello I am senior web developer. With my skills and experiences, I will implement php search form for filtering data on a mysql database. I look forward to hearing from you. Thanks.

$155 USD in 3 days
(34 Reviews)
5.8
sky930320

""Programming is my passion. I am well organized, can work along or within a team. I prefer small and medium projects, but large is also good"" please check my work below:- Wordpress: [login to view URL] More

$222 USD in 3 days
(35 Reviews)
6.7
srflipmedia

Hi, We will provide you Browsers-Compatible; Responsive[PC/ iPad/ iPhone/ MAC-Compatible]; SEO-friendly; Wordpress-Website. We believe in Prompt Communication; Value Your Money; Quality Assurance; Friendly GUI within More

$30 USD in 3 days
(72 Reviews)
6.1
brightstar928

Hi sir my name is DongJun. I am an experienced web developer. I have read the project requirements and I am very interested in your project. I can start work right now. I will make your website look very nice, modern More

$100 USD in 3 days
(35 Reviews)
5.7
shingjin

Hello. After reviewing your post, I am very interested in that due to my experience. I’d like to be considered for your project position. I am an expert php, My sql developer. i can make your filtering function. More

$222 USD in 3 days
(53 Reviews)
5.8
fadata

Hi, I can complete your SMS filtering project today in 10 hours. I have 14 years of experience in Php. I propose a %100 guarantee, you do not pay if you are not satisfied with the result. Feel free to ask anything. More

$170 USD in 1 day
(15 Reviews)
5.2
C3guru

dear you! I have reviewed your project description and it's easy to complete it. I'm senior Sql developer I've great experience with Web especially SQL development for more than 3 years. If you give me a chance, i w More

$155 USD in 3 days
(31 Reviews)
5.7
fastwebsoft

Hello Sir, I have great knowledge in core and Laravel. More than 5 year experience.. I have read your requirement carefully.. I can do this job easily.. I have already developed many web application. More

$55 USD in 3 days
(21 Reviews)
5.1
amjadali4888

Hi i have read project description and i am interested to do interesting project please give me chance to work on this project

$35 USD in 3 days
(69 Reviews)
5.2
alkajain2906

Greetings,
Thank you for posting a Job. I WILL DO THIS AS PER YOUR REQUIREMENT AND EXPECTATIONS. With the experience of over 300+web development projects including ANDROID, IOS, WEBSITES, WEB APPLICATIONS AND SOFTWARE More

$155 USD in 3 days
(24 Reviews)
5.0
AndreiVldmrvch

Hello client. I read carefully your proposal. I am a professional web and full stack developer. * No Upfront-Amount needed to Begin your Project * Ready to Start as Immediate, Unlimited Revisions & Proper Testing More

$300 USD in 3 days
(7 Reviews)
4.8
rubal45

hi.. you can check my latest feedback which i got for same kind of job.. i can do this task. i read your requirement also. you wan to show your table data according to date ranage with keyword. pls ping me More

$55 USD in 3 days
(45 Reviews)
4.4
sifisolutions

We Believe in Delivering Perfect Work and Providing Full Satisfaction to Our Client . We also Insure to Deliver the Work in the given Time Frame . we have highly Qualified Professionals in our team

$100 USD in 5 days
(11 Reviews)
3.0