我正在建立一個包含三個元件的網站。 (我将添加JQuery和CSS,但是現在我隻是想解決一些基本的機制)
我的結構是:
表示層的HTML檔案。
用于用戶端處理的JAVASCRIPT檔案
用于伺服器端處理的PHP檔案。
以下是我的代碼:
HTML:
/p>
"http://www.w3.org/TR/html4/loose.dtd">
CD Riplist Query
CD Riplist Query
使用Javascript:
function getArtists() {
xmlhttp = new XMLHttpRequest();
xmlhttp.open("GET","dataAccess.php",false);
xmlhttp.send();
document.getElementById("divArtists").innerHTML=xmlhttp.responseText;
}
PHP:
$con = mysql_connect('myServerAddress', 'ainsworthremote', 'myPassword');
if (!$con) {
die("Could not connect: " . mysql_error());
}
$response =
"
mysql_select_db("ainsworthremote", $con);
$sql="SELECT artist, COUNT(*) AS albums FROM CD_RipList GROUP BY artist ORDER BY artist ";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$response = $response . "
" .
"
" . $row['artist'] . "" .
"
" . $row['albums'] . "" .
"
";
}
$response = $response . "
";
mysql_close($con);
echo $response;
?>
我得到以下内容,而不是像預期的那樣得到一個充滿藝術家名字的表格。
CD Riplist查詢
ArtistAlbums"; mysql_select_db("ainsworthremote", $con); $sql="SELECT artist, COUNT(*) AS albums FROM CD_RipList GROUP BY artist ORDER BY artist "; $result=mysql_query($sql); while ($row = mysql_fetch_array($result)) { $response = $response . "" . "" . $row['artist'] . "" . "" . $row['albums'] . "" . ""; } $response = $response . ""; mysql_close($con); echo $response; ?>
我想知道的(除了我做錯了)是:我的标簽發生了什麼?