http://michael.github.com/multiselect/

It depends on jQuery 1.3 and jQuery UI 1.7. The widget is styleable using Themeroller. It works in an unobtrusive fashion, by just turning html multiple select inputs into a sexier equivalent. There’s no extra markup needed.

•For installation instructions please have a look at the corresponding blogpost
•Source code is available at Github
•In case you are looking for the original version, it has been moved here
•Bleeding Edge Demo is always available here (thanks to Github Pages)

http://haineault.com/media/jquery/ui-timepickr/page/

感覺還不錯的 時間選擇

Jquery Autocomplete 自動輸入

使用者只要輸入 『台』 就會自動去資料庫找 『台灣』, 『台xxxx』 的資料

一開始測時找了很多版本,還是有一些小Bug

後來請學長幫忙後果然找出問題..

1
2
3
4
5

<script type="text/javascript">		
$(document).ready(function(){
$("#w_ezone").autocomplete('rpc3.php',{delay: 100});
});
</script>

rpc3.php 檔案

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

<?php
$q=$_GET["q"];
if (!$q) return;
$con = mysql_connect('localhost', 'root', 'xxxx');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("db_gps", $con);
$sql="SELECT * FROM tb_map WHERE p_map LIKE '$q%'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
  {
  echo $row['p_map']."|".$row['p_x']."|".$row['p_y']."\n";
  }
mysql_close($con);
?>