 KoolGrid
|
| | |
 MySQLDataSource Class [PHP]
DeleteCommandTop string DeleteCommand
Get or set the delete command for datasource. MySQLDataSource will use this command to delete data from database. Those field name which is preceded by "@" will be relaced with value.
 Show/Hide Code
<?php
$ds = new MySQLDataSource();
$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
$ds->UpdateCommand = "update customers set customerName='@customerName' where customerNumber=@customerNumber";
$ds->DeleteCommand = "delete from customers where customerNumber=@customerNumber";
$ds->InsertCommand = "insert into customers (customerNumber,customerName) values (@customerNumber,'@customerName');";
?> Supported from version: 1.0.0.0 InsertCommandTop string InsertCommand
Get or set the insert command for datasource. MySQLDataSource will use this command to insert new data to database. Those field name which is preceded by "@" will be relaced with value.
Show/Hide Code <?php
$ds = new MySQLDataSource();
$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
$ds->UpdateCommand = "update customers set customerName='@customerName' where customerNumber=@customerNumber";
$ds->DeleteCommand = "delete from customers where customerNumber=@customerNumber";
$ds->InsertCommand = "insert into customers (customerNumber,customerName) values (@customerNumber,'@customerName');";
?> Supported from version: 1.0.0.0 SelectCommandTop string SelectCommand
Get or set the select command for datasource. MySQLDataSource will use this command to select data from database.
Show/Hide Code <?php
$ds = new MySQLDataSource();
$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
$ds->UpdateCommand = "update customers set customerName='@customerName' where customerNumber=@customerNumber";
$ds->DeleteCommand = "delete from customers where customerNumber=@customerNumber";
$ds->InsertCommand = "insert into customers (customerNumber,customerName) values (@customerNumber,'@customerName');";
?> Supported from version: 1.0.0.0 UpdateCommandTop string UpdateCommand
Get or set the update command for datasource. MySQLDataSource will use this command to update data. Those field name which is preceded by "@" will be relaced with value.
Show/Hide Code <?php
$ds = new MySQLDataSource();
$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
$ds->UpdateCommand = "update customers set customerName='@customerName' where customerNumber=@customerNumber";
$ds->DeleteCommand = "delete from customers where customerNumber=@customerNumber";
$ds->InsertCommand = "insert into customers (customerNumber,customerName) values (@customerNumber,'@customerName');";
?> Supported from version: 1.0.0.0
| | |
|
