W3.JS W3Data
什麼是 W3Data?
W3Data 是一種將伺服器資料引入 HTML 應用程式的工具。
W3Data 的目的是為 w3.js 提供來自 Web 伺服器的資料。
應用程式模型
W3Data 使用應用程式模型 (以 JSON 編寫) 來描述伺服器應用程式。
這個簡單的模型描述了一個從資料庫檢索資料的完整應用程式
model_customers.js
{
"database" : {
"connection" : "localmysql",
"sql" : "SELECT * FROM Customers"}
}
這些模型儲存在伺服器上，不能被 Web 使用者編輯。
你必須是伺服器管理員，或被授予伺服器檔案編輯許可權的使用者。
使用應用程式模型很簡單，只需在呼叫 w3Http() 時將模型名稱新增到 w3data.php 即可
示例
<script>
w3.getHttpObject("w3data.php?model=model_customers", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
自己試試 »
從文字檔案顯示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_txt", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
自己試試 »
這是應用程式中使用的模型
model_cd_from_txt
{
"data" : {
"type" : "csvfile",
"filename" : "cd_catalog.txt",
"items" : [
{"name" : "title", "index" : 1},
{"name" : "artist", "index" : 2},
{"name" : "price", "index" : 5}
]
}
}
這是逗號分隔的文字檔案
cd_catalog.txt
Empire Burlesque,Bob Dylan,USA,Columbia,10.90,1985
Hide your heart,Bonnie Tyler,UK,CBS Records,9.90,1988
Greatest Hits,Dolly Parton,USA,RCA,9.90,1982
Still got the blues,Gary Moore,UK,Virgin records,10.20,1990
Eros,Eros Ramazzotti,EU,BMG,9.90,1997
One night only,Bee Gees,UK,Polydor,10.90,1998
Sylvias Mother,Dr.Hook,UK,CBS,8.10,1973
Maggie May,Rod Stewart,UK,Pickwick,8.50,1990
從 JSON 檔案顯示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_json", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
自己試試 »
這是應用程式中使用的模型
model_cd_from_json.js
{
"data" : {
"type" : "jsonfile",
"filename" : "cd_catalog.js",
"record" : "cd"
"items" : [
{"name" : "title", "nodename" : "title"},
{"name" : "artist", "nodename" : "artist"},
{"name" : "price", "nodename" : "price"}
]
}
}
這是 JSON 檔案
cd_catalog.js
{
"cd" : [
{ "title" : "Empire Burlesque", "artist" : "Bob Dylan", "price" : "10.90" },
{ "title" : "Hide your heart", "artist" : "Bonnie Tyler", "price" : "9.90" },
{ "title" : "Greatest Hits", "artist" : "Dolly Parton", "price" : "9.90" },
{ "title" : "Still got the blues", "artist" : "Gary Moore", "price" : "10.20" },
{ "title" : "Eros", "artist" : "Eros Ramazzotti", "price" : "9.90" },
{ "title" : "One night only", "artist" : "Bee Gees", "price" : "10.90" },
{ "title" : "Sylvias Mother", "artist" : "Dr.Hook", "price" : "8.10" }
]
}
從 XML 檔案顯示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_xml", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
自己試試 »
這是應用程式中使用的模型
model_cd_from_xml
{
"data" : {
"type" : "xmlfile",
"filename" : "cd_catalog.xml",
"record" : "CD",
"items" : [
{"name" : "artist", "nodename" : "ARTIST"},
{"name" : "title", "nodename" : "TITLE"},
{"name" : "country", "nodename" : "COUNTRY"}
]
}
}
這是 XML 檔案
cd_catalog.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<PUBLISHED>1985</PUBLISHED>
</CD>
<CD>
<TITLE>Hide your heart</TITLE>
<ARTIST>Bonnie Tyler</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS Records</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1988</PUBLISHED>
</CD>
<CD>
<TITLE>Greatest Hits</TITLE>
<ARTIST>Dolly Parton</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>RCA</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1982</PUBLISHED>
</CD>
<CD>
<TITLE>Still got the blues</TITLE>
<ARTIST>Gary Moore</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>Virgin records</COMPANY>
<PRICE>10.20</PRICE>
<PUBLISHED>1990</PUBLISHED>
</CD>
<CD>
<TITLE>Eros</TITLE>
<ARTIST>Eros Ramazzotti</ARTIST>
<COUNTRY>EU</COUNTRY>
<COMPANY>BMG</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1997</PUBLISHED>
</CD>
<CD>
<TITLE>One night only</TITLE>
<ARTIST>Bee Gees</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>Polydor</COMPANY>
<PRICE>10.90</PRICE>
<PUBLISHED>1998</PUBLISHED>
</CD>
<CD>
<TITLE>Sylvias Mother</TITLE>
<ARTIST>Dr.Hook</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS</COMPANY>
<PRICE>8.10</PRICE>
<PUBLISHED>1973</PUBLISHED>
</CD>
</CATALOG>
下載
下載檔案: https://w3schools.tw/w3js/w3data.php.txt。
將檔案複製到你的網站並重命名為w3data.php。
