Find Jobs
Hire Freelancers

AJAX display of MySQL data

$30-100 USD

已完成
已发布超过 18 年前

$30-100 USD

货到付款
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,
项目 ID: 3168573

关于此项目

9提案
远程项目
活跃18 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$85 USD 在16天之内
5.0 (23条评论)
4.9
4.9
9威客以平均价$75 USD来参与此工作竞价
用户头像
See private message.
$85 USD 在16天之内
4.8 (12条评论)
5.0
5.0
用户头像
See private message.
$55.25 USD 在16天之内
5.0 (15条评论)
4.5
4.5
用户头像
See private message.
$85 USD 在16天之内
5.0 (24条评论)
3.8
3.8
用户头像
See private message.
$51 USD 在16天之内
4.0 (9条评论)
3.2
3.2
用户头像
See private message.
$85 USD 在16天之内
4.1 (3条评论)
0.6
0.6
用户头像
See private message.
$59.50 USD 在16天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$85 USD 在16天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$84.15 USD 在16天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
15
会员自8月 8, 2002起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。