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); }
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; }