PHP flight Flight::db Examples

Example #1

File: Show.php Project: hduwzy/test

 public function showsqlkey()
 {
     $sk = Flight::request()->getQuery('sk', '');
     $sk = '%' . implode('%', explode('|', $sk)) . '%';
     $sqlkey = Flight::db()->fetchAll('sql.sqldoc.sqlkey.select.sqlkey', array('sk' => $sk));
     $this->app->json($sqlkey);
 }

Example #2

File: build_sqldoc_dbinfo.php Project: hduwzy/test

function insert_param($param_info, $sk_id, $pname)
{
    $is_exsists = Flight::db()->fetchOne('sql.sqldoc.params.select.param', array('sk_id' => $sk_id, 'pname' => $pname));
    if (false === $is_exsists) {
        echo Flight::db()->errorMsg();
    }
    if (empty($is_exsists)) {
        $insert_data = array('sk_id' => $sk_id, 'param_name' => $pname, 'param_comments' => $param_info['comment'], 'required' => $param_info['required'], 'eg_val' => isset($param_info['eg_val']) ? $param_info['eg_val'] : '');
        $ret = Flight::db()->insert('sql.sqldoc.params.insert.param', $insert_data);
        if (false === $ret) {
            echo Flight::db()->errorMsg();
        }
        return Flight::db()->lastInsertId();
    }
    return 0;
}