PivotDataSource class [PHP]

CharSetTop

String CharSet

Get or set the data source's charset.

Show/Hide Code

<?php				
    $ds->CharSet = "utf-8";
?>

Supported from version: 1.0.0.0

MySQLPivotDataSourceTop

Pivot Data Source MySQLPivotDataSource()

Create a MySQLPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new MySQLPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

MySQLiPivotDataSourceTop

Pivot Data Source MySQLiPivotDataSource()

Create a MySQLiPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new MySQLiPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

PdoPivotDataSourceTop

Pivot Data Source PdoPivotDataSource()

Create a PdoPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new PdoPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

PostgreSQLPivotDataSourceTop

Pivot Data Source PostgreSQLPivotDataSource()

Create a PostgreSQLPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new PostgreSQLPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

MSSQLPivotDataSourceTop

Pivot Data Source MSSQLPivotDataSource()

Create a MSSQLPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new MSSQLPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

SQLSRVPivotDataSourceTop

Pivot Data Source SQLSRVPivotDataSource()

Create a SQLSRVPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new SQLSRVPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

OraclePivotDataSourceTop

Pivot Data Source OraclePivotDataSource()

Create an OraclePivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new OraclePivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

ODBCPivotDataSourceTop

Pivot Data Source ODBCPivotDataSource()

Create an ODBCPivotDataSource object.

Show/Hide Code

<?php	               
    $ds = new ODBCPivotDataSource($db_con);
?>

Supported from version: 1.0.0.0

selectTop

self select()

Set the SELECT clause of sql command for the data source.

Show/Hide Code

<?php	               
    $ds->select("products.productLine AS product_Line , "
        . "customerName, "
        . "orderdetails.quantityOrdered * orderdetails.priceEach AS dollar_sales,"
        . "products.productName AS productName");
 
    $ds->from("customers")
        ->join("orders")->on("orders.customerNumber = customers.customerNumber")
        ->join("orderdetails")->on("orders.orderNumber = orderdetails.orderNumber")
        ->join("products")->on("products.productCode = orderdetails.productCode");
?>

Supported from version: 1.0.0.0

fromTop

self from()

Set the FROM clause of sql command for the data source.

Show/Hide Code

<?php	               
    $ds->from("customers")->join("orders")->on("orders.customerNumber = customers.customerNumber");
?>

Supported from version: 1.0.0.0

joinTop

self join()

Set the JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN clause of sql command for the data source.

Show/Hide Code

<?php	               
    $ds->from("customers")->join("orders")->on("orders.customerNumber = customers.customerNumber");
    $ds->from("customers")->fullJoin("orders")->on("orders.customerNumber = customers.customerNumber");
    $ds->from("customers")->leftJoin("orders")->on("orders.customerNumber = customers.customerNumber");
    $ds->from("customers")->rightJoin("orders")->on("orders.customerNumber = customers.customerNumber");
?>

Supported from version: 1.0.0.0

onTop

self on()

Set the ON clause of sql command for the data source.

Show/Hide Code

<?php	               
    $ds->from("customers")->join("orders")->on("orders.customerNumber = customers.customerNumber");
?>

Supported from version: 1.0.0.0

whereTop

self where()

Set the WHERE clause of sql command for the data source.

Show/Hide Code

<?php	               
    $ds->where("products.productCode = orderdetails.productCode");
?>

Supported from version: 1.0.0.0

selectCommandTop

self selectCommand()

Set the entire sql command for the data source.

Show/Hide Code

<?php	               
    $ds->selectCommand('select customers.customerName as "customerName", '
        . 'products.productName AS productName, products.productLine AS product_Line, '
        . '(orderdetails.quantityOrdered * orderdetails.priceEach) AS dollar_sales '
        . 'from customers join orders on orders.customerNumber = customers.customerNumber '
        . 'join orderdetails on orders.orderNumber = orderdetails.orderNumber '
        . 'join products on products.productCode = orderdetails.productCode '
        . 'where products.productLine!=\'Classic Cars\' '
        . 'UNION '
        . 'select customerName, productName, productLine as product_Line, '
        . 'dollar_sales from customer_product_dollarsales where productLine=\'Classic Cars\' '
   );
?>

Supported from version: 1.0.0.0

setQuerySizeTop

self setQuerySize()

Set the maximum size for each returned query results. Large data set would be divided to multiple queries.

Show/Hide Code

<?php	               
    $ds->setQuerySize(80000);
?>

Supported from version: 1.0.0.0

getQuerySizeTop

Number getQuerySize()

Get the maximum size of each returned query results. Large data set would be divided to multiple queries.

Show/Hide Code

<?php	               
    $querySize = $ds->getQuerySize();
?>

Supported from version: 1.0.0.0