AppML ASP
Agar .NET serverga kirish imkoningiz bo‘lsa, AppML server ilovasini yaratish uchun quyidagi ko‘rsatmalarga amal qiling.
Test sahifasini yarating
Test sahifasini yarating va uni PHP serveringizda customers.htm (yoki istalgan boshqa nom) sifatida saqlang:
customers.htm
<!DOCTYPE html>
<html lang="en">
<title>Customers</title>
<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="customers">
<h1>Customers</h1>
<table class="w3-table-all">
<tr>
<th>Customer</th>
<th>City</th>
<th>Country</th>
</tr>
<tr appml-repeat="records">
<td>{{CustomerName}}</td>
<td>{{City}} </td>
<td>{{Country}} </td>
</tr>
</table>
</div>
<script>
var customers = {
"records":[
{"CustomerName":"Alfreds Futterkiste","City":"Berlin","Country":"Germany"},
{"CustomerName":"Ana Trujillo Emparedados y helados","City":"México D.F.","Country":"Mexico"},
{"CustomerName":"Antonio Moreno Taquería","City":"México D.F.","Country":"Mexico"},
{"CustomerName":"Around the Horn","City":"London","Country":"UK"},
{"CustomerName":"B's Beverages","City":"London","Country":"UK"},
{"CustomerName":"Berglunds snabbköp","City":"Luleå","Country":"Sweden"},
{"CustomerName":"Blauer See Delikatessen","City":"Mannheim","Country":"Germany"},
{"CustomerName":"Blondel père et fils","City":"Strasbourg","Country":"France"},
{"CustomerName":"Bólido Comidas preparadas","City":"Madrid","Country":"Spain"},
{"CustomerName":"Bon app'","City":"Marseille","Country":"France"},
{"CustomerName":"Bottom-Dollar Marketse","City":"Tsawassen","Country":"Canada"},
{"CustomerName":"Cactus Comidas para llevar","City":"Buenos Aires","Country":"Argentina"},
{"CustomerName":"Centro comercial Moctezuma","City":"México D.F.","Country":"Mexico"},
{"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
{"CustomerName":"Comércio Mineiro","City":"São Paulo","Country":"Brazil"}
]};
</script>
</body>
</html>
O‘zingiz sinab ko‘ring »
Veb-sahifani brauzeringizda sinab ko‘ring.
Ma’lumotlar bazasiga ulanishni yarating
Agar SQL Server ma’lumotlar bazasiga yoki boshqa istalgan OLEDB ma’lumotlar bazasiga (masalan, MS Access) kirish imkoningiz bo‘lsa, ma’lumotlar bazasi ulanishlarini belgilang va ularni serverda appml_config.aspx sifatida saqlang:
appml_config.aspx (SQL Server misoli)
<%
Response.write("Access Forbidden")
Response.end
%>
{
"dateformat" : "yyyy-mm-dd",
"databases" : [{
"connection" : "mydatabase",
"provider" : "SQLOLEDB",
"host" : "myserver",
"dbname" : "DemoDB",
"username" : "DemoDBUkbn5",
"password" : "l6|U6=V(*T+P"
}]
}
appml_config.aspx (MS Access misoli)
<%
Response.write("Access Forbidden")
Response.end
%>
{
"dateformat" : "yyyy-mm-dd",
"databases" : [{
"connection" : "mydatabase",
"connectionstring" :
"Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\database\\Northwind.mdb"
}]
}
Yuqoridagi ulanish haqiqiy emas. Nomlar va parollar misol sifatida berilgan.
Konfiguratsiya fayli tushuntirilishi:
| Xususiyat | Tavsif |
|---|---|
| dateformat | Modellaringizda ishlatadigan sana formati |
| connection | Modellaringizda ishlatadigan ulanish nomi |
| connectionstring | Odatda MS Access kabi OLEDB drayverlari uchun ishlatiladi |
| provider | Ma’lumotlar bazasi dasturiy ta’minotining drayveri/provayderi |
| host | Ma’lumotlar bazasining IP manzili yoki xost nomi |
| dbname | Ma’lumotlar bazasi nomi |
| username | Ma’lumotlar bazasi foydalanuvchi nomi |
| password | Ma’lumotlar bazasi paroli |
AppML’ni nusxalang
Faylni yuklab oling: https://www.w3schools.com/appml/2.0.3/appml.aspx.txt.
Faylni veb-saytingizga nusxalang. Uning nomini appml.aspx deb o‘zgartiring.
Ma’lumotlar bazasida jadval yarating
Ma’lumotlar bazasida Customers jadvalini yaratish uchun model yarating.
create_customers.js
{
"database" : {
"connection" : "mydatabase",
"execute" : [
"DROP TABLE IF EXISTS Customers",
"CREATE TABLE IF NOT EXISTS Customers (CustomerID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,(CustomerID),CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255))",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Alfreds Futterkiste\",\"Maria Anders\",\"Obere Str. 57\",\"Berlin\",\"12209\",\"Germany\")",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Around the Horn\",\"Thomas Hardy\",\"120 Hanover Sq.\",\"London\",\"WA1 1DP\",\"UK\")",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Blauer See Delikatessen\",\"Hanna Moos\",\"Forsterstr. 57\",\"Mannheim\",\"68306\",\"Germany\")"
]
}}
create_customers.js modelini ishga tushirish uchun HTML sahifa yarating:
create_customers.htm
<!DOCTYPE html>
<html>
<script src="https://www.w3schools.com/appml/2.0.3/appml.js"></script>
<body>
<div appml-data="appml.aspx?model=create_customers"></div>
</body>
</html>
HTML sahifani brauzeringizda ishga tushiring.
Ilova yarating
Mijozlar ilovasi uchun model yarating. Uni customers.js sifatida saqlang:
customers.js
{
"rowsperpage" : 10,
"database" : {
"connection" : "mydatabase",
"sql" : "SELECT * FROM Customers",
"orderby" : "CustomerName"
}
}
Mijozlar ilovasini ishga tushirish uchun HTML sahifa yarating:
customers.htm
<!DOCTYPE html>
<html lang="en">
<title>Customers</title>
<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.aspx?model=model_customers">
<h1>Customers</h1>
<table class="w3-table-all">
<tr>
<th>Customer</th>
<th>City</th>
<th>Country</th>
</tr>
<tr appml-repeat="records">
<td>{{CustomerName}}</td>
<td>{{City}}</td>
<td>{{Country}}</td>
</tr>
</table>
</div>
</body>
</html>
O‘zingiz sinab ko‘ring »
HTML’ni brauzeringizda ishga tushiring.
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!