Find Jobs
Hire Freelancers

AJAX display of MySQL data

$30-100 USD

Completed
Posted over 18 years ago

$30-100 USD

Paid on delivery
I currently have a MySQL table with 5554 records in it. The table is defined as: -- Table structure for table `arquizzes` -- CREATE TABLE `arquizzes` ( `quiznum` int(8) unsigned NOT NULL default '0', `lang` char(2) NOT NULL default 'EN', `title` varchar(100) NOT NULL default '', `author` varchar(100) NOT NULL default '', `level` decimal(2,1) NOT NULL default '0.0', `points` decimal(2,1) NOT NULL default '0.0', PRIMARY KEY (`quiznum`), KEY `title` (`title`,`author`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='accelerated reader'; Sample data: INSERT INTO `arquizzes` VALUES (26986, 'EN', 'Milton Hershey: Chocolate King T', 'Charnan Simon', 4.8, 0.5); INSERT INTO `arquizzes` VALUES (26994, 'EN', 'The Tenth Good Thing about Barne', 'Judith Viorst', 2.8, 0.5); I need an elegant way to limit the amount of data displayed based on user entered criteria. The page should load with some reasonable defaults (100 records perhaps) so the web user does not have to wait for 700KB of data to download. Above this default display of data there should be column headers, and a way to refine the 'search'. So, the user may want to sort a column ascending or descending, or may want to list books beginning with J or W, or might want to see books with a level between 4.1 and 6.9 only, or maybe ones with points over 12.0. In addition to being able to sort and select criteria on the fly, the user should be able to search in author or title by entering a search string. There should also be a configurable setting for number of results per page, and pagination for results sets larger than the max result per page. I could do all this with PHP and forms, but it's clunky and old-school. I want something slick using AJAX, XMLHttpRequest, web 2.0, in order to be fully buzz word compliant. Examples of things that feel the way I want are: Google Suggest (beta) Google Groups (where you 'unhide' options to print, etc.) see also deliverables ## Deliverables [login to view URL] More examples of sites using AJAX are listed here. I am a demanding software buyer. a. Work needs to be XHTML compliant and pass validation at [login to view URL] . b. Source code should be clean and well-formatted, using tabs and indenting as appropriate. Ugly code will not be accepted. c. Source code should be commented d. Presentation should be done with XHTML & CSS and a valid stylesheet will be provided by me to you for your use - no font tags. e. php must use long tags,
Project ID: 3168573

About the project

9 proposals
Remote project
Active 18 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
See private message.
$85 USD in 16 days
5.0 (23 reviews)
4.9
4.9
9 freelancers are bidding on average $75 USD for this job
User Avatar
See private message.
$85 USD in 16 days
4.8 (12 reviews)
5.0
5.0
User Avatar
See private message.
$55.25 USD in 16 days
5.0 (15 reviews)
4.5
4.5
User Avatar
See private message.
$85 USD in 16 days
5.0 (24 reviews)
3.8
3.8
User Avatar
See private message.
$51 USD in 16 days
4.0 (9 reviews)
3.2
3.2
User Avatar
See private message.
$85 USD in 16 days
4.1 (3 reviews)
0.6
0.6
User Avatar
See private message.
$59.50 USD in 16 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 16 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$84.15 USD in 16 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
15
Member since Aug 8, 2002

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.