AppML Case Study - Text Files
The HTML Page
This is the HTML source:
<!DOCTYPE html>
<html lang="en-US">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<script src="https://www.w3schools.com/appml/2.0.3/appml.js"></script>
<body>
<div class="w3-container" appml-data="appml.php?model=model_cd_from_txt">
<h1>CD Collection</h1>
<h3>Extracted from a comma separated text
file</h3>
<div
appml-include-html="inc_listcommands_nofilter.htm"></div>
<table class="w3-table-all">
<tr>
<th>Title</th>
<th>Artist</th>
<th>Price</th>
</tr>
<tr
appml-repeat="records">
<td>{{Title}}</td>
<td>{{Artist}}</td>
<td>{{Price}}</td>
</tr>
</table>
</div>
</body>
</html>
PHP »
.NET »
The Model
This is the model used in the application:
Model
{
"rowsperpage" : 7,
"data" : {
"type" : "csvfile",
"filename" : "cd_catalog.txt",
"items" : [
{"name" :
"Title", "index" : 1},
{"name" : "Artist", "index" : 2},
{"name" : "Price", "index" : 5}
]
}
}
The File
This is the comma separated text file:
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
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
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
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