AppML PHP

如果您可以访问 PHP 服务端，请按照以下说明创建 AppML 服务器应用程序。

创建一个测试页面

创建一个测试页面，并在 PHP 服务器上保存为 customer.html:

customers.html

<!DOCTYPE html>
<html>
<head>
<title>Customers</title>
<link rel="stylesheet" href="https://cankaoshouce.com/css/w3.css">
<script src="https://cankaoshouce.com/js/appml/appml.js"></script>
</head>
<body>
<div class="w3-container" appml-data="customers">
<h2>Customers</h2>
<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>

运行一下

在浏览器上测试这个页面。

创建一个数据库连接

如果您要访问数据库，请按照以下说明创建 AppML 数据库连接。

定义一个数据库连接，并将其保存在服务器上为 appml_config.php:

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"
 }]}

上述连接并不真实，比如用户名和密码。

配置文件解释:

属性	描述
dateformat	您将在模型中使用的日期格式
connection	您将在模型中使用的连接名称
host	数据库的 IP 或主机名
dbname	数据库名称
username	数据库用户名
password	数据库密码

复制 AppML

下载文件: https://cankaoshouce.com/example/appml/appml.php.txt。

将文件复制到您的网站，并重命名为 appml.php。

创建数据库表

创建用于在数据库中创建 Customers 表的模型，将其另存为 create_customers.js:

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\")"
]
}}

创建一个 HTML 页面 来运行 create_customers.js 模型:

create_customers.html

<!DOCTYPE html>
<html>
<script src="https://cankaoshouce.com/js/appml/appml.js"></script>
<body>
<div appml-data="appml.php?model=create_customers"></div>
</body>
</html>

在浏览器中运行 HTML 页面。

创建一个应用程序模型

为 customer 应用程序创建一个模型，并另存为 model_customers.js:

model_customers.js

{
"rowsperpage" : 10,
"database" : {
    "connection" : "mydatabase",
    "sql" : "SELECT * FROM Customers",
    "orderby" : "CustomerName"
}
}

创建用于运行 customer 应用程序的 HTML 页面:

customers.html

<!DOCTYPE html>
<html>
<title>Customers</title>
<link rel="stylesheet" href="https://cankaoshouce.com/css/w3.css">
<script src="https://cankaoshouce.com/js/appml/appml.js"></script>
<body>
<div class="w3-container" appml-data="appml.php?model=model_customers">
<h2>Customers</h2>
<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>

运行一下

在浏览器中运行 HTML。

AppML PHP

创建一个测试页面

customers.html

创建一个数据库连接

appml_config.php

配置文件解释:

复制 AppML

创建数据库表

create_customers.js

create_customers.html

创建一个应用程序模型

model_customers.js

customers.html

分类导航