1.下载DHTMLX:https://dhtmlx.com/docs/download.shtml
2.解压到laravel的public目录下
3.主要使用的是codebase/dhtmlx.css和codebase/dhtmlx.js,在页面引用这两个文件即可
4.创建一个DHTMLX表格
页面代码如下
5.编写接口,返回xml格式数据
public function xx(){
$res = QrModel::select(‘id’,‘public_code’,‘upc’)->limit(9)->get();
$xml = “<?xml version='1.0' encoding='utf-8' ?>”;
header(“Content-Type:text/xml”);
x
m
l
.
=
′
<
r
o
w
s
>
′
;
f
o
r
(
xml .= '<rows>'; for(
xml.=′<rows>′;for(i=0;
i
<
c
o
u
n
t
(
i<count(
i<count(res);$i++){
x
m
l
.
=
′
<
r
o
w
i
d
=
"
′
.
(
xml.= '<row id="'.(
xml.=′<rowid="′.(i+1).’"> //行id
‘.
r
e
s
[
res[
res[i]->id.’ //第一列数据
‘.
r
e
s
[
res[
res[i]->public_code.’ //第二列数据
‘.
r
e
s
[
res[
res[i]->upc.’
';
}
$xml .= ‘’;
echo $xml;
exit;
}
6.最终效果