AppML PHP
Agar PHP 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">
<head>
<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>
</head>
<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 ma’lumotlar bazasiga kirish imkoningiz bo‘lsa, AppML ma’lumotlar bazasi ulanishini yaratish uchun quyidagi ko‘rsatmalarga amal qiling.
Ma’lumotlar bazasi ulanishini belgilang va uni serverda appml_config.php sifatida saqlang:
appml_config.php
<?php echo("Access Forbidden");exit();?>
{
"dateformat" : "yyyy-mm-dd",
"databases" : [{
"connection" : "mydatabase",
"host" : "localhost",
"dbname" : "DemoDB",
"username" : "DemoDBUkbn5",
"password" : "l6|U6=V(*T+P"
}]
}
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 |
| 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.php.txt.
Faylni veb-saytingizga nusxalang. Uning nomini appml.php deb o‘zgartiring.
Ma’lumotlar bazasida jadval yarating
Ma’lumotlar bazasida Customers jadvalini yaratish uchun model yarating. Uni create_customers.js sifatida saqlang:
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.php?model=create_customers"></div>
</body>
</html>
HTML sahifani brauzeringizda ishga tushiring.
Ilova modelini yarating
Mijozlar ilovasi uchun model yarating. Uni model_customers.js sifatida saqlang:
model_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.php?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!