PHP dao_query::addの例

コード例 #1

ファイル: queries.php プロジェクト: RA2WP/RA2WP

}
?>

<?php 
/***********************/
/***  COPY ACTION    ***/
/***********************/
/*** SINGLE ***/
if ($_GET[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['copy'] && isset($_GET[$wpbi_settings['parameter']['qy_id']])) {
    $selected_query = $_GET[$wpbi_settings['parameter']['qy_id']];
    $vo_query = new vo_query($selected_query, NULL, NULL, NULL);
    $dao_query = new dao_query($wpdb, $wpbi_sql['tname']['queries']);
    $vo_query = $dao_query->select($vo_query);
    $vo_query = $vo_query[0];
    $vo_query->set_name($wpbi_dialog['item']['name']['copy'] . $vo_query->name);
    $dao_query->add($vo_query);
}
?>

<?php 
/***********************/
/***   TEST ACTION   ***/
/***********************/
/**** Test new query ***/
if (($_POST[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['test'] || $_POST[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['edit-test']) && isset($_POST[$wpbi_settings['parameter']['qy_db']]) && isset($_POST[$wpbi_settings['parameter']['qy_statement']])) {
    $test_output = '';
    //Store the test output to be displayed at the bottom of the page
    if (strpos(ltrim(strtoupper($_POST[$wpbi_settings['parameter']['qy_statement']])), 'SELECT') === 0) {
        //Query has to be a select statement
        //Get database connection
        $dao_database = new dao_database($wpdb, $wpbi_sql['tname']['databases']);