jQuery插件advTable
源码下载 在线演示
jQuery插件advTable好的用户表处理程序、可编辑内容、可选行、多选排、源选择(数据库或文件或HTML)、过滤的内容、密码保护的数据库更新超时、调整大小、HTML5日期选择。
<html><head> <link rel="stylesheet" href="css/advtable-1.0.0.min.css"/> <script type="text/javascript" src="js/jquery-1.9.0.1.min.js"></script> <script type="text/javascript" src="js/advtable-1.0.0.min.js"></script></head><body> //if table have children create from this or table dont have children crate from com.php with JSON or uploaded csv file see below. <table id = "yourId"></table> //or load with this example method with my php class <?php require_once('mysql_db.php'); $db = Database::getInstance(); $db->connect(); $sql = "SELECT * FROM yourTable"; $table = $db->getHTMLtable($sql, 'yourId'); echo $table; $db->disconnect(); ?> <script type="text/javascript" charset="utf-8" > $(document).ready(function() { // initialize with default setting $('#yourId').advTable() or add a new settings: // This is default $('#yourId').advTable({ src: 'database', // database is default else your uploaded file. Example 'upload/demo.csv' name: "advTable", // Name required for table association in com.php file (com_mssql or com_mysql) width: 1000, // table inner width numeric height: 300, // table inner height numeric delimiter: ';', // delimiter for csv file (download) datePicker: true, // enable HTML5 date picker. Check field data. If this date or datetime then enable browser HTML5 datepicker. buttons: { // handlers true:display, false:hide addRow: true, dellRow: true, update: true, reload: true, search: true }, php: { id: 0, // unique database column index not editable file: "com.php", // required for database handling (com_mssql or com_mysql) user: "root", // add more user option (not working, yet) timeout: 60000 // entered password timeout } }); }); </script></body></html><?php// com php file configuration (bottom of the com php):function assoc_table($value = '') { $val = array(); if($value == 'advTable') { $val['table'] = 'yourTable'; // configured name in script (name: "advTable") 'yourTable' is a real database table. $val['pass'] ='admin'; // password for this table } return $val;}?><?php// if you want change column name then add tags for this array(name_def.php): $nevek = array( 'date' => 'Date', 'location' => 'Location', 'country_code' => 'Country code', 'country_name' => 'Country name', 'ip' => 'Ip address', 'id' => 'Identity', 'region' => 'Region', 'city' => 'City', 'postal_code' => 'Postal code', 'latitude' => 'Latitude', 'longitude' => 'Longitude' );?>
【jQuery插件advTable】相关文章
2. bookblock:可帮助你生成翻页效果的jQuery插件
3. bookblock:可帮助你生成翻页效果的jQuery插件
5. 另外一款超棒的响应式布局jQuery插件 - Freetile.js
6. Fred Jones in Adventureland
7. Fred Jones in Adventureland
9. CSS3灵活的盒子模型(Flexible Box Module)–1
10. CSS3灵活的盒子模型(Flexible Box Module)–2
本文来源:https://www.51html5.com/a1234.html
﹝jQuery插件advTable﹞相关内容
- CSS3灵活的盒子模型(Flexible Box Module)–1
- CSS3灵活的盒子模型(Flexible Box Module)–2
- jQuery实现的dribbble最受欢迎作品集瀑布流效果
- 一个跨浏览器的数字输入jQuery插件Stepper
- 一个简单的冻结HTML表格标题jQuery插件Freezeheader
- 随机字符变换效果的jQuery插件开发教程
- jQuery插件实现css3效果
- Prompt轻量级提示框弹出层Jquery插件
- 愚人节整蛊专家之jQuery插件
- jQuery插件实现css3效果