AppML WebMatrix

If you don't have a web server, you can make one, utilizing WebMatrix.


WebMatrix is a free web improvement instrument that gives a simple method to fabricate websites.

WebMatrix contains:

  • Web models and templates
  • Support for various web dialects (PHP, ASP.NET, Node.js)
  • A web server
  • Database servers (mySQL and SQL Server Compact)

With WebMatrix you can begin with a vacant site, or expand on existing formats utilizing PHP, ASP, Umbraco, DotNetNuke, Drupal, Joomla, WordPress and more.

WebMatrix additionally has worked in devices for databases, security, website improvement, and web publishing.

To introduce WebMatrix, pursue this connection: http://www.microsoft.com/web/webmatrix

Create an Empty PHP Site

In WebMatrix, select Template Gallery. Select PHP. Select Void Site.

Change Site name to DemoAppml (or anything you like), and click Next.

Create Website

As should be obvious from the delineation, WebMatrix will give you a chance to make numerous distinctive sorts of sites.

Create a HTML Test Page

In the WebMatrix window, select New. Select New File. Select record type HTML.

Change the document name to customers.htm (or anything you like). Snap OK.

Create HTML File

Replace the HTML in the new document with this:


<!DOCTYPE html>
<html lang="en">
<link rel="stylesheet" href=
<script src="http://www.welookups.com/appml/2.0.3/appml.js"></script>

<div class="container" appml-data="customers">
<table class="table table-striped table-bordered">
<tr appml-repeat="records">
  <td>{{City}}    </td>
  <td>{{Country}} </td>

var clients = {
{"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"}

Try It Yourself »

To run the test page: Right-click the page in WebMatrix, what's more, select Launch in browser.

Create a Database

In the WebMatrix window select Databases. Select New Database. Select MySQL Database.

Change the Database name to DemoDB (or anything you like), what's more, click OK.

Create database

In WebMatrix, select Files, and open the web.config file.

( If you can't see the web.config document, invigorate WebMatrix)

Web Configuration

Configure AppML

Use the data, from the association string in web.config, to make a setup record for AppML.

Name the record appml_config.php:


<?php echo("Access Forbidden");exit();?>
"dateformat" : "yyyy-mm-dd",
"databases" : [{
    "association" : "mydatabase",
    "have" : "localhost",
    "dbname" : "DemoDB",
    "username" : "DemoDBUkbn5",
    "secret key" : "l6|U6=V(*T+P"

Setup File Explained:

Property Description
dateformat The date group you will use in your models
connection The association name you will use in your models
host The IP or hostname found in server=
dbname The database name found in Database=
username The client name found in uid=
password The secret phrase found in pwd=

Copy AppML

Download the record: http://www.welookups.com/appml/2.0.3/appml.php.txt.

Copy the record to your site. Rename it to appml.php:

Copy appml.php

Create a Database Table 

Create a model for making a Customers table in the database.


"database" : {
"connection" : "mydatabase",
"execute" : [
"CREATE TABLE IF NOT EXISTS Customers (CustomerID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (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 a HTML page for running the Create_Customers model:


<!DOCTYPE html>
<html lang="en-US">
<script src="http://www.welookups.com/appml/2.0.3/appml.js"></script>

<div appml-data="appml.php?model=Create_Customers"></div>


To run the HTML page: Right-click the page in WebMatrix, what's more, select Launch in browser.

Create an Application 

Create a model for the clients application. Spare it as customers.js:


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

Create a HTML page for running the clients application:


<!DOCTYPE html>
<html lang="en">
<link rel="stylesheet" href= "http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="http://www.welookups.com/appml/2.0.3/appml.js"></script>

<div class="container" appml-data="appml.php?mode
Welookups is optimized for learning.© kumar aditya singh .
All Right Reserved and you agree to have read and accepted our term and condition.
All Rights Reserved.

Spring - Bean Definition