可以在FF下运行,但是不能运行在IE和chrome jquery+ajax+php+mysql
多厘 2010-01-16 11:23:35 我附上代码。。。。
test.html
-------------------------------------------------------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>jQuery Autocomplete Plugin</title>
<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
var i=0;
add_one_row();
$('#add_row').click(function(){
add_one_row();
});
$('#del_row').click(function(){
del_row();
})
function add_one_row(){
$('#tbl_form').append('<tr><td class="tbl_index"></td>'
+'<td><select class="class_td" name="category[]" ></select></td>'
+'<td><select class="goods_td" name="goods[]" ></select></td></tr>');
i++;
add_index(i);
//size++;
//$('#class_td').autocomplete(["yb","bl","stm"]);
}
function del_row(){
if($('.class_td').size()>1){
$('#tbl_form').find('tr:last').remove();
i--;
}else{
alert('至少保留一条有效数据!');
}
}
function add_index(i){
$('.tbl_index:last').html(i);
$('.class_td').eq(i-1).load('data_info.php?queryString=allclass')
.attr('onchange','goods('+i+',this.value)');
$('.goods_td').eq(i-1).attr('id','good_'+i);
}
});
function goods(id,value){
//alert(value);
$.get('data_info.php',{class_id:value},function(data){
$('#good_'+id).html(data);
})
}
</script>
</head>
<body>
<form id="form" method="post" action="getinfo.php">
<span id="add_row">++++</span><span id="del_row">----</span>
<table id="tbl_form">
<tr>
<td>序号</td>
<td>类别</td>
<td>名称</td>
</tr>
</table>
<input type="submit"/>
</form>
</body>
</html>
----------------------------------------------------------------
data_info.php
-----------------------------------------------------------------
<?php
$conn = mysql_connect('localhost', 'root' ,'33023', 'test');
$db = mysql_select_db('bear');
if(!$db)
{
echo 'ERROR: Could not connect to the database.';
}
else
{
if(isset($_GET['queryString'])) {
$queryString = $_GET['queryString'];
if ($queryString=='allclass')
{
echo '<option value="">请选择</option>';
$query = mysql_query("SELECT class_name,class_id FROM class ");
if($query)
{
while ($result = mysql_fetch_array($query)) {
echo '<option value="'.$result["class_id"].'">'.$result["class_name"].'</option>';
}
}
else
{
echo '<option value="请选择">请选择</option>';
}
}
}
if(isset($_GET['class_id']))
{
$class_id = $_GET['class_id'];
$query = mysql_query("SELECT good_name FROM good where class_id = ".$class_id."");
if($query) {
while ($result = mysql_fetch_array($query)) {
echo '<option value="'.$result["good_name"].'">'.$result["good_name"].'</option>';
}
}
else
{
echo '<option value="请选择">请选择</option>';
}
}
}
?>
---------------------------------------------------------------
sql文件
bear.sql
--------------------------------------------------------------
-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2010 年 01 月 16 日 23:18
-- 服务器版本: 5.1.41
-- PHP 版本: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 数据库: `bear`
--
-- --------------------------------------------------------
--
-- 表的结构 `class`
--
CREATE TABLE IF NOT EXISTS `class` (
`class_id` int(5) NOT NULL AUTO_INCREMENT,
`class_name` char(20) NOT NULL,
`class_description` char(100) NOT NULL,
PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- 转存表中的数据 `class`
--
INSERT INTO `class` (`class_id`, `class_name`, `class_description`) VALUES
(4, '生态木', '博为生态木'),
(5, '友邦', '友邦集成吊顶');
-- --------------------------------------------------------
--
-- 表的结构 `good`
--
CREATE TABLE IF NOT EXISTS `good` (
`good_id` int(5) NOT NULL AUTO_INCREMENT,
`class_id` char(20) NOT NULL,
`good_name` char(20) NOT NULL,
`good_area` char(100) NOT NULL,
PRIMARY KEY (`good_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18446744073709551615 ;
--
-- 转存表中的数据 `good`
--
INSERT INTO `good` (`good_id`, `class_id`, `good_name`, `good_area`) VALUES
(1, '4', '95红木', '规格'),
(2, '4', '137红木', '批次'),
(3, '5', '001润玉白', '');