<?php
require('../../../dmxConnectLib/dmxConnect.php');
$app = new \lib\App();
$app->define(<<<'JSON'
{
"meta": {
"options": {
"linkedFile": "/test.php",
"linkedForm": "addemailandpass"
},
"$_POST": [
{
"type": "text",
"fieldName": "email",
"name": "email"
},
{
"type": "text",
"fieldName": "selectcity",
"name": "selectcity"
},
{
"type": "text",
"name": "city_name"
}
]
},
"exec": {
"steps": {
"name": "insert",
"module": "dbupdater",
"action": "insert",
"options": {
"connection": "dbConnect",
"sql": {
"type": "insert",
"values": [
{
"table": "cred",
"column": "email",
"type": "text",
"value": "{{$_POST.email}}"
},
{
"table": "cred",
"column": "city_name",
"type": "text",
"value": "{{$_POST.city_name}}"
}
],
"table": "cred",
"query": "INSERT INTO cred\n(email, city_name) VALUES (:P1 /* {{$_POST.email}} */, :P2 /* {{$_POST.city_name}} */)",
"params": [
{
"name": ":P1",
"type": "expression",
"value": "{{$_POST.email}}",
"test": ""
},
{
"name": ":P2",
"type": "expression",
"value": "{{$_POST.city_name}}",
"test": ""
}
]
}
},
"meta": [
{
"name": "identity",
"type": "text"
},
{
"name": "affected",
"type": "number"
}
]
}
}
}
JSON
);
?>
That’s the API code