我该如何让一个包含SQL查询和JQuery的PHP文件一起工作?最终目标是获得多个表格,就像这个http://jsfiddle.net/96Lhog5g/3/演示一样,但使用以下PHP代码。类似于这样但是用PHP
-PHP代码:
![enter image description here](https://istack.dev59.com/yuX7B.webp)
<?php
$dbconn = pg_connect(
$sql1 = "SELECT unaccent(name) from base1;";
$sql2 = "select id from servic;";
$name = pg_query($sql1);
$ident= pg_query($sql2);
$data1 = pg_fetch_all_columns($name);
$data2 = pg_fetch_all_columns($ident);
$count = count($data1);
echo '<table id="mainTable" border="1" style="width:450px;position:relative;left:80px;">';
echo '<tr >';
echo '<th style="background: #3498db; width:5px;text-align: center ;font-size:12px;font-family:Arial Narrow">ID</th>';
echo '<th style="background: #3498db; width:10px;text-align: center ;font-size:12px;font-family:Arial Narrow">NAME</th>';
echo '</tr>';
for ($i = 0; $i < $count; $i++) {
$data1[$i];
$data2[$i];
echo '<tr ><td>' . $data2[$i] . '</td>';
echo '<td>' . $data1[$i] . '</td></tr>';
}
echo '</table>';
pg_free_result($name);
pg_close($dbconn);
?>
JQuery code:
var $main = $('#mainTable'), $head = $main.find('tr:first'), $extraRows = $main.find('tr:gt(2)'); for( var i = 0; i < $extraRows.length; i = i+4){ $('<table>').append($head.clone(), $extraRows.slice(i,i+2)).appendTo($main.parent()); }
来自http://jsfiddle.net/96Lhog5g/3/。我尝试将此代码适应于PHP,但我的知识有限。