DML functions
-
- Posts: 6
- Joined: 2013-01-22 06:40
DML functions
Like sqlvalue function, which function shall i use for search, insert and update in the table (please share samples if you can) ?
Re: DML functions
sql() is the function to use for this purpose. Here are some examples:
To delete/edit/insert:
To retrieve (select) records:
To delete/edit/insert:
Code: Select all
sql("update table `customers` set phone='123456789' where customerID=22", $eo);
Code: Select all
$records = sql("select * from `customers` where state='NY' order by customerID", $eo);
while($customer = mysql_fetch_assoc($records)){
echo "{$customer['firstName']} {$customer['lastName']} <br/>";
}
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.