嗨,我在这里使用jquery自动完成插件。我有一些PHP检索数据库值,我想在自动完成插件中使用这些值。为此,我想将PHP值转换为javascript数组。我该怎么做呢?
$(function() {
var availableTags = [
"ActionScript",
"AppleScript",
"Asp",
"BASIC",
"C",
"C++",
"Clojure",
"COBOL",
"ColdFusion",
"Erlang",
"Fortran",
];
$( "#category" ).autocomplete({
source: availableTags
});
});
Php: <?php
require_once "config.php";
$q = strtolower($_GET["q"]);
if (!$q) return;
$sql = "select distinct(category) from completer";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
$fname = $rs['category'];
echo "$fname"
}
?>
如果数据存储在php变量中,那么你可以将这些值添加到javascript变量中,像这样,不需要ajax的东西:
假设php变量中有如下值:
$myPhpVar = [
"ActionScript",
"AppleScript",
"Asp",
"BASIC",
"C",
"C++",
"Clojure",
"COBOL",
"ColdFusion",
"Erlang",
"Fortran",
];
然后在你的js部分应该是:
$(function() {
var availableTags = [];
// start here - populate the data from php variable
<?php foreach($myPhpVar as $key => $val) {?>
availableTags.push('<?php echo $val;?>'); // push data into js variable
<?php }?>
// end here
$( "#category" ).autocomplete({
source: availableTags
});
});
JS script:
$(function() {
$.ajax({
type : 'get',
url : 'urlofmyfile.php',
data : 'q='+q,
dataType : 'json',
success : function(availableTags){
$( "#category" ).autocomplete({
source: availableTags
});
}
});
});
$。Ajax文档:http://api.jquery.com/jquery.ajax/
PHP脚本: <?php
require_once "config.php";
$q = strtolower($_GET["q"]);
if (!$q) return;
$sql = "select distinct(category) from completer";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
$fname[] = $rs['category'];
}
print json_encode($fname);
exit;
?>
json_encode文档:http://php.net/manual/en/function.json-encode.php
有几种方法可以做到这一点。
动态页面生成。
你可以动态地从数据库中获取值,并作为JSON对象插入到HTML中:
$(function() {
var availableTags = <?php
require_once "config.php";
$q = strtolower($_GET["q"]);
if (!$q) die("[]");
$sql = "select distinct(category) from completer";
$rsd = mysql_query($sql);
$row = array();
while($rs = mysql_fetch_assoc($rsd)) {
$row[] = $rs['category'];
}
echo json_encode($row);
?>;
$("#category").autocomplete({
source: availableTags
});
});
AJAX 。
AJAX方法几乎相同,但它被认为是更好的实践。在这种情况下,PHP文件是一个单独的文件,它只返回一个由JS处理的对象。
PHP:<?php
require_once "config.php";
$q = strtolower($_GET["q"]);
if (!$q) die("[]");
$sql = "select distinct(category) from completer";
$rsd = mysql_query($sql);
$row = array();
while($rs = mysql_fetch_assoc($rsd)) {
$row[] = $rs['category'];
}
echo json_encode($row);
?>
JS:
$(function() {
$.ajax({
url: 'yourPhp.php',
data: 'q=' + q,
dataType: 'json'
}).done(function(dt) {
$("#category").autocomplete({
source: dt
});
});
});