本文整理汇总了PHP中execSQL函数的典型用法代码示例。如果您正苦于以下问题:PHP execSQL函数的具体用法?PHP execSQL怎么用?PHP execSQL使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了execSQL函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: load
function load($file)
{
try {
execSQL($file, $this->db, PRE);
} catch (PDOException $e) {
throw new Exception($e->getMessage() . '<pre>' . $e . '</pre>');
}
}
开发者ID:BGCX067,项目名称:f3site-svn-to-git,代码行数:8,代码来源:install.php
示例2: chgPwdphpBBuser
function chgPwdphpBBuser($nick, $pwd)
{
$cryptpass = phpbb_hash($pwd);
$sql = "UPDATE `" . $_SESSION['Application_host'] . "`.`forum_users` ";
$sql .= "SET `user_password` = '" . $cryptpass . "' ";
$sql .= "WHERE `username` = '" . $nick . "'";
echo "<!--" . $sql . "-->";
$req = execSQL($sql, "function", __FILE__, __FUNCTION__);
}
开发者ID:GrottoCenter,项目名称:GrottoCenter,代码行数:9,代码来源:phpBBinterface.php
示例3: getVersionForModule
function getVersionForModule($dbh, $name)
{
$stmt = execSQL($dbh, "SELECT version FROM updates WHERE modulename='{$name}'");
$row = $stmt->fetch();
if ($row) {
return $row["version"];
} else {
return 0;
}
}
开发者ID:Naghasan,项目名称:Volumio-WebUI,代码行数:10,代码来源:cmn_updates.php
示例4: runMatching
function runMatching($contacts)
{
// Read data from jva_contacts table and store it in a object
$jva_data = array();
$jvaQuery = "SELECT * FROM jva_contacts";
$DBResource = getDBConnection();
$jva_resultSet = $resultSet = execSQL($DBResource, $jvaQuery);
if (mysqli_num_rows($jva_resultSet) > 0) {
while ($jva_r = mysqli_fetch_row($jva_resultSet)) {
$jva_row = new TempContact();
$jva_row->jva_id = $jva_r[0];
$jva_row->jva_first_name = $jva_r[1];
$jva_row->jva_middle_name = $jva_r[2];
$jva_row->jva_last_name = $jva_r[3];
$jva_row->jva_salutation = $jva_r[4];
$jva_row->jva_phone_no = $jva_r[5];
$jva_row->jva_fax_no = $jva_r[6];
$jva_row->jva_country = $jva_r[7];
$jva_row->jva_zipcode = $jva_r[8];
$jva_row->jva_email = $jva_r[9];
array_push($jva_data, $jva_row);
}
closeDBConnection($DBResource);
// To compare each record in jva_contacts with all records in the file
foreach ($jva_data as $jva_row) {
foreach ($contacts as $contacts_row) {
$c_last = $contacts_row->con_last_name;
$j_last = $jva_row->jva_last_name;
$DBResource = getDBConnection();
if ($jva_row->jva_last_name == $contacts_row->con_last_name && $jva_row->jva_country == $contacts_row->con_country && $jva_row->jva_email == $contacts_row->con_email) {
$nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "'," . $jva_row->jva_id . ",'Perfect',1)";
$resultSet = execSQL($DBResource, $nQuery);
} else {
if ($jva_row->jva_country == $contacts_row->con_country && $jva_row->jva_email == $contacts_row->con_email) {
if (strpos($j_last, $c_last) !== FALSE || strpos($c_last, $j_last) !== FALSE) {
$nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "'," . $jva_row->jva_id . ",'Partial',1)";
$resultSet = execSQL($DBResource, $nQuery);
}
} else {
$nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "',0,'New',1)";
$resultSet = execSQL($DBResource, $nQuery);
}
}
closeDBConnection($DBResource);
}
// end of inner for each loop
}
// end of outer for each loop
} else {
foreach ($contacts as $contacts_row) {
$nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "',0,'New',1)";
execSQL($DBResource, $nQuery);
}
}
}
开发者ID:ppatwa1,项目名称:cs_546_Project,代码行数:55,代码来源:Matching.php
示例5: db_page_delete
function db_page_delete($page_id)
{
$param_arr = _init_db_params();
LOG_MSG('INFO', "db_page_delete(): START { page_id=[{$page_id}]");
// For the where clause
$where_clause = " WHERE page_id=? AND shop_id=" . SHOP_ID;
$param_arr = _db_prepare_param($param_arr, "i", "page_id", $page_id, true);
$resp = execSQL("DELETE FROM \n\t\t\t\t\t\t\ttPage" . $where_clause, $param_arr['params'], true);
LOG_MSG('INFO', "db_page_delete(): END");
return $resp;
}
开发者ID:abkiran,项目名称:reddy,代码行数:11,代码来源:Admin_model.php
示例6: getUser
function getUser($username)
{
$result = execSQL("SELECT * FROM users WHERE username='" . strtolower($username) . "'");
$user = array("id" => 0, "username" => "", "about" => "", "profileimage" => "");
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$user = array("id" => $row["id"], "username" => $row["username"], "about" => $row["about"], "profileimage" => $row["profileimage"]);
}
}
return $user;
}
开发者ID:jaflo,项目名称:hackme,代码行数:11,代码来源:header.php
示例7: db_room_select
function db_room_select($room_id = "", $room_name = "")
{
LOG_MSG('INFO', "db_wallet_select: START { \n\t\t\t\t\t\t\troom_id=[{$room_id}],\n\t\t\t\t\t\t\troom_name=[{$room_name}] \n}");
$param_arr = _init_db_params();
$where_clause = "WHERE room_name={$room_name} AND room_id = {$room_id}";
$param_arr['params'] = array();
LOG_MSG('INFO', "db_room_select(): WHERE CLAUSE = [{$where_clause}]");
$resp = execSQL("SELECT \n\t\t\t\t\t\troom_name,\n\t\t\t\t\t\troom_id,\n\t\t\t\t\t\tis_booked\n\t\t\t\t\tFROM \n\t\t\t\t\t\tbookrooms\n\t\t\t\t\t" . $where_clause, $param_arr['params'], false);
LOG_MSG('INFO', "db_room_select(): END");
return $resp;
}
开发者ID:teju,项目名称:Android,代码行数:11,代码来源:db.php
示例8: db_do_login
function db_do_login($email_id, $password)
{
LOG_MSG('INFO', "db_do_login(): START {\n\t\t\t\t\t\t\t\t\t\temail_id=[{$email_id}],\n\t\t\t\t\t\t\t\t\t\tpassword=[{$password}]\n}");
$param_arr = _init_db_params();
$param_arr = _db_prepare_param($param_arr, "s", "email_id", $email_id, true);
$param_arr = _db_prepare_param($param_arr, "s", "password", $password, true);
// Create Query
$resp = execSQL("SELECT \n\t\t\t\t\t\tu.user_id,\n\t\t\t\t\t\tu.name,\n\t\t\t\t\t\tu.email_id,\n\t\t\t\t\t\tu.password,\n\t\t\t\t\t\tu.phone_no,\n\t\t\t\t\t\tu.address,\n\t\t\t\t\t\tu.type,\n\t\t\t\t\t\tu.is_active,\n\t\t\t\t\t\tu.created_dt,\n\t\t\t\t\t\ts.supervisor_id,\n\t\t\t\t\t\tt.travel_id,\n\t\t\t\t\t\tt.name travel_name,\n\t\t\t\t\t\tt.domain\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttUser u\n\t\t\t\t\t\tLEFT OUTER JOIN tSupervisor s ON(s.user_id=u.user_id)\n\t\t\t\t\t\tLEFT OUTER JOIN tTravel t ON(u.travel_id=t.travel_id)\n\t\t\t\t\tWHERE \n\t\t\t\t\t\tu.email_id=? \n\t\t\t\t\t\tAND u.password=? AND\n\t\t\t\t\t\tt.travel_id=" . TRAVEL_ID, $param_arr['params'], false);
LOG_MSG('INFO', "db_do_login(): END");
return $resp;
}
开发者ID:teju,项目名称:Android,代码行数:11,代码来源:db.php
示例9: login
function login()
{
if (empty($_POST['username'])) {
echo "Username is empty";
return false;
}
if (empty($_POST['password'])) {
echo "Password is empty";
return false;
}
$username = trim($_POST['username']);
$password = trim($_POST['password']);
$conn = getDBConnection();
$query = "select password from login_details where username = '{$username}'";
$res = execSQL($conn, $query);
while ($row = $res->fetch_assoc()) {
$pwdhash = $row['password'];
}
return password_verify($password, $pwdhash);
}
开发者ID:ppatwa1,项目名称:cs_546_Project,代码行数:20,代码来源:Login.php
示例10: get_unique_field
function get_unique_field($table)
{
LOG_MSG("INFO", "####### GETTING UNIQUE KEY COLUMN NAME : for " . DB_NAME . $table);
$row = execSQL("\n\t\t\t\tSELECT \n\t\t\t\t\tcolumn_name\n\t\t\t\tFROM \n\t\t\t\t\tinformation_schema.COLUMNS\n\t\t\t\tWHERE \n\t\t\t\t\ttable_name = '" . $table . "' AND\n\t\t\t\t\ttable_schema = '" . DB_NAME . "' AND\n\t\t\t\t\tcolumn_key='UNI';", array(), false);
// If no unique key was found above
if (!isset($row[0]['column_name'])) {
LOG_MSG("INFO", "####### GETTING PRIMARY KEY COLUMN NAME : for " . DB_NAME . $table);
$row = execSQL("\n\t\t\t\tSELECT \n\t\t\t\t\tcolumn_name\n\t\t\t\tFROM \n\t\t\t\t\tinformation_schema.COLUMNS\n\t\t\t\tWHERE \n\t\t\t\t\ttable_name = '" . $table . "' AND\n\t\t\t\t\ttable_schema = '" . DB_NAME . "' AND\n\t\t\t\t\tcolumn_key='PRI';", array(), false);
}
return $row[0]['column_name'];
}
开发者ID:teju,项目名称:Android,代码行数:11,代码来源:db.php
示例11: execSplit
//.........这里部分代码省略.........
CREATE VIEW cs4 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 8;
DROP VIEW IF EXISTS cs5_core; DROP VIEW IF EXISTS cs5;
CREATE VIEW cs5 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 9;
DROP VIEW IF EXISTS ac6_core; DROP VIEW IF EXISTS ac6;
CREATE VIEW ac6 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 10;
DROP VIEW IF EXISTS ac7_core; DROP VIEW IF EXISTS ac7;
CREATE VIEW ac7 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 11;
DROP VIEW IF EXISTS cs6_core; DROP VIEW IF EXISTS cs6;
CREATE VIEW cs6 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 12;
DROP VIEW IF EXISTS ac8_core; DROP VIEW IF EXISTS ac8;
CREATE VIEW ac8 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 13;
DROP VIEW IF EXISTS ac9_core; DROP VIEW IF EXISTS ac9;
CREATE VIEW ac9 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 14;
DROP VIEW IF EXISTS ac10_core; DROP VIEW IF EXISTS ac10;
CREATE VIEW ac10 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 15;
DROP VIEW IF EXISTS cs7_core; DROP VIEW IF EXISTS cs7;
CREATE VIEW cs7 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 16;
DROP VIEW IF EXISTS ac11_core; DROP VIEW IF EXISTS ac11;
CREATE VIEW ac11 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 17;
DROP VIEW IF EXISTS cs8_core; DROP VIEW IF EXISTS cs8;
CREATE VIEW cs8 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 18;
DROP VIEW IF EXISTS cs9_core; DROP VIEW IF EXISTS cs9;
CREATE VIEW cs9 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 19;
DROP VIEW IF EXISTS ac12_core; DROP VIEW IF EXISTS ac12;
CREATE VIEW ac12 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 20;
DROP VIEW IF EXISTS cs10_core; DROP VIEW IF EXISTS cs10;
CREATE VIEW cs10 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 21;
DROP VIEW IF EXISTS ac13_core; DROP VIEW IF EXISTS ac13;
CREATE VIEW ac13 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 22;
DROP VIEW IF EXISTS cs11_core; DROP VIEW IF EXISTS cs11;
CREATE VIEW cs11 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 23;
DROP VIEW IF EXISTS cs12_core; DROP VIEW IF EXISTS cs12;
CREATE VIEW cs12 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 24;
DROP VIEW IF EXISTS ac14_core; DROP VIEW IF EXISTS ac14;
CREATE VIEW ac14 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 25;
DROP VIEW IF EXISTS cs13_core; DROP VIEW IF EXISTS cs13;
CREATE VIEW cs13 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 26;
DROP VIEW IF EXISTS ac15_core; DROP VIEW IF EXISTS ac15;
CREATE VIEW ac15 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 27;
DROP VIEW IF EXISTS cs14_core; DROP VIEW IF EXISTS cs14;
CREATE VIEW cs14 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 28;
DROP VIEW IF EXISTS ac16_core; DROP VIEW IF EXISTS ac16;
CREATE VIEW ac16 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 29;
DROP VIEW IF EXISTS cs15_core; DROP VIEW IF EXISTS cs15;
CREATE VIEW cs15 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 30;
DROP VIEW IF EXISTS cs16_core; DROP VIEW IF EXISTS cs16;
CREATE VIEW cs16 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 31;
DROP VIEW IF EXISTS cs16_2_core; DROP VIEW IF EXISTS cs16_2;
CREATE VIEW cs16_2 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 32;
DROP VIEW IF EXISTS ac17_core; DROP VIEW IF EXISTS ac17;
CREATE VIEW ac17 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 33;
DROP VIEW IF EXISTS ac18_core; DROP VIEW IF EXISTS ac18;
CREATE VIEW ac18 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 34;
DROP VIEW IF EXISTS ac19_core; DROP VIEW IF EXISTS ac19;
CREATE VIEW ac19 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 35;
DROP VIEW IF EXISTS ac20_core; DROP VIEW IF EXISTS ac20;
CREATE VIEW ac20 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 36;
DROP VIEW IF EXISTS ac21_core; DROP VIEW IF EXISTS ac21;
CREATE VIEW ac21 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 37;
DROP VIEW IF EXISTS alldata;
CREATE VIEW alldata AS
SELECT music_id, music_no, music_name, music_name_sort, music_battle, music_folder_ver,
genre_id, genre_name, artist_id, artist_name, data_id, dif, dif_id, bpm_min, bpm_max,
notes, scratch, chargenotes, bss, data_date
FROM (notesdata JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id))
SQL;
execSQL($EXEC_SQL);
echo "data splited";
}
开发者ID:sacrifs,项目名称:iidxsd,代码行数:101,代码来源:dbimport-sample.php
示例12: modulesetting_db_get
function modulesetting_db_get($name, $category = '')
{
LOG_MSG('INFO', "modulesetting_db_get(): START { name=[{$name}] category=[{$category}] \n}");
$param_arr = _init_db_params();
// Where Clause
$where_clause = "WHERE name = ? AND travel_id=" . TRAVEL_ID;
$param_arr = _db_prepare_param($param_arr, "s", "name", $name, true);
if ($category != '') {
$where_clause .= " AND category=? ";
$param_arr = _db_prepare_param($param_arr, "s", "category", $category, true);
}
$resp = execSQL("SELECT \n\t\t\t\t\t\tvalue\n\t\t\t\t\tFROM \n\t\t\t\t\t\ttSetting \n\t\t\t\t\t{$where_clause} ", $param_arr['params'], false);
LOG_MSG('INFO', "modulesetting_db_get(): END");
if ($resp[0]['STATUS'] != 'OK') {
LOG_MSG('ERROR', "modulesetting_db_get(): There was an error loading name=[{$name}]");
return false;
}
if ($resp[0]['NROWS'] != 1) {
LOG_MSG('INFO', "modulesetting_get(): No value found for [{$name}]");
return false;
}
return $resp[0]['value'];
}
开发者ID:teju,项目名称:Android,代码行数:23,代码来源:settings.php
示例13: isset
if (isset($_POST['send_pwd'])) {
$login = isset($_POST['f_caver_login']) ? $_POST['f_caver_login'] : '';
$contact = isset($_POST['f_caver_contact']) ? $_POST['f_caver_contact'] : '';
$password = generatePassword(10, 8);
$string = isset($_POST['f_caver_check']) ? $_POST['f_caver_check'] : '';
$user_check = isset($_SESSION['userCheck']) ? $_SESSION['userCheck'] : '';
if (!$_SESSION['do_check'] || md5(getIp() . strtolower($string)) == $user_check) {
$sql = "SELECT * FROM `" . $_SESSION['Application_host'] . "`.`T_caver`";
$sql .= " WHERE Login = '" . $login . "' AND Contact ='" . $contact . "'";
$data = getDataFromSQL($sql, __FILE__, $frame, __FUNCTION__);
if ($data['Count'] > 0) {
if ($data[0]['Activated'] == 'YES') {
$sql = "UPDATE `" . $_SESSION['Application_host'] . "`.`T_caver`";
$sql .= " SET Password ='" . getCryptedPwd($login, $password) . "'";
$sql .= " WHERE Id = " . $data[0]['Id'];
$req = execSQL($sql, $frame, __FILE__, __FUNCTION__);
if (!defined('NO_PHPBB_INSTALLED')) {
chgPwdphpBBuser($login, $password);
}
sendNewPwdMail($data[0], $password);
//echo $password;
trackAction("pwd_user", $data[0]['Id'], "T_caver");
$_SESSION['user_pwd_sent'] = true;
} else {
$activated = false;
$_SESSION['user_pwd_sent'] = false;
}
} else {
$_SESSION['user_pwd_sent'] = false;
$_SESSION['send_retry'] += 1;
}
开发者ID:GrottoCenter,项目名称:GrottoCenter,代码行数:31,代码来源:connection.php
示例14: updateReportSchedule
/**
*
*
* @param mixed $colNames
* @param mixed $recID
* @param mixed $rt
*/
function updateReportSchedule($colNames, $recID, $values)
{
global $db, $sys_usrReportSchedule_ColumnNames;
$ret = null;
if (count($colNames) && count($values)) {
$db = mysqli_connection_overwrite(DATABASE);
$isInsert = $recID < 0;
$query = "";
$fieldNames = "";
$parameters = array("");
$fieldNames = join(",", $colNames);
foreach ($colNames as $colName) {
$val = array_shift($values);
if (array_key_exists($colName, $sys_usrReportSchedule_ColumnNames)) {
if ($query != "") {
$query = $query . ",";
}
if ($isInsert) {
$query = $query . "?";
} else {
$query = $query . "{$colName} = ?";
}
$parameters[0] = $parameters[0] . $sys_usrReportSchedule_ColumnNames[$colName];
//take datatype from array
array_push($parameters, $val);
}
}
//for columns
if ($query != "") {
if ($isInsert) {
$query = "insert into usrReportSchedule (" . $fieldNames . ") values (" . $query . ")";
} else {
$query = "update usrReportSchedule set " . $query . " where rps_ID = {$recID}";
}
$rows = execSQL($db, $query, $parameters, true);
if ($rows == 0 || is_string($rows)) {
$oper = $isInsert ? "inserting" : "updating";
$ret = "error {$oper} in updateReportSchedule - " . $rows;
//$msqli->error;
} else {
if ($isInsert) {
$recID = $db->insert_id;
$ret = -$recID;
} else {
$ret = $recID;
}
}
}
$db->close();
}
//if column names
if ($ret == null) {
$ret = "no data supplied for updating report - {$recID}";
}
return $ret;
}
开发者ID:beoutsports,项目名称:heurist-v3-1,代码行数:63,代码来源:loadReports.php
示例15: _module_runscripts
/** Run the module install/uninstall scripts
* @param string The name of the module
* @param string The action to perform, either 'install' or 'uninstall'
* @return boolean If the action was succesful
*/
function _module_runscripts($modulename, $type)
{
global $amp_conf;
$db_engine = $amp_conf["AMPDBENGINE"];
$moduledir = $amp_conf["AMPWEBROOT"] . "/admin/modules/" . $modulename;
if (!is_dir($moduledir)) {
return false;
}
switch ($type) {
case 'install':
// install sql files
$sqlfilename = "install.sql";
$rc = true;
if (is_file($moduledir . '/' . $sqlfilename)) {
$rc = execSQL($moduledir . '/' . $sqlfilename);
}
// then run .php scripts
return _modules_doinclude($moduledir . '/install.php', $modulename) && $rc;
break;
case 'uninstall':
// run uninstall .php scripts first
$rc = _modules_doinclude($moduledir . '/uninstall.php', $modulename);
$sqlfilename = "uninstall.sql";
// then uninstall sql files
if (is_file($moduledir . '/' . $sqlfilename)) {
return $rc && execSQL($moduledir . '/' . $sqlfilename);
} else {
return $rc;
}
break;
default:
return false;
}
return true;
}
开发者ID:hardikk,项目名称:HNH,代码行数:40,代码来源:functions.inc.php
示例16: day
`pabrik02`, `pabrik03`, `pabrik04`, `pabrik05`, `satuan_kirim`, `jenis_obat`, `kategori_obat`, `golongan`,
`kode_guna`, `kode_persediaan`, `kode_pendapatan`, `kode_reduksi`, `kode_biaya`, `kode_ppn_k`, `kode_ppn_m`,
`expire_date`, `ex_date`, `ex_month`, `ex_year`, `tipe_obat`, `obat_tunai`, `hna`, `harga_dosp`, `discount`,
`ppn`, `averange_sale`, `stok_max`, `stok_min`, `stok`, `isi`, `kemasan`, `status`, `flags`,
`created_datetime`, `created_user`, `update_datetime`, `update_user`, `no_batch`, `no_rak`, `fld01`, `fld02`,
`fld03`) SELECT a.group_barang, a.kd_barang, a.nama, a.satuan, $suppID,
a.pabrik02, a.pabrik03, a.pabrik04, a.pabrik05, b.satuan_po, a.jenis_obat, a.kategori_obat, a.golongan,
a.kode_guna, a.kode_persediaan, a.kode_pendapatan, a.kode_reduksi, a.kode_biaya, a.kode_ppn_k, a.kode_ppn_m,
b.fld05, day(b.fld05), month(b.fld05), year(b.fld05), a.tipe_obat, a.obat_tunai, a.hna, b.harga_po, b.discount,
(b.harga_po *0.1), a.averange_sale, a.stok_max, a.stok_min, b.qty_po, a.isi, a.kemasan, 'Aktif', 1,
now(), '$userLoged', now(), '$userLoged', a.fld06, a.no_rak, b.no_po, b.no_spb, b.id FROM ms_barang a
INNER JOIN purchase_orderdetail b on a.id = b.barang_id WHERE b.id =$val ";
execSQL($strSQLUpMs);
//print $strSQLUpMs;
$strSQLUpFlags = "UPDATE ms_barang set flags = 1 where id = $val";
execSQL ($strSQLUpFlags);
}
}
die("<meta http-equiv='refresh' content='0;url=home.php?hal=content/list_po'>");
break;
case 3:
//die(print "$noPO :: $noReq :: $lastNO :: $items :: $dbPO :: $flags :: $suppID :: 3");
/* CHANGED PO STATUS TO (APPROVED) */
/* IF IT's ALREADY ON (APPROVED) STATUS THEN CHANGED TO (RECEIVING) */
$items = $_POST['param'];
if(empty($noPO)){$noPO = $_POST['pono'];}
if(empty($noReq)){$noReq = $_POST['no_req'];}
if(empty($suppID)){$suppID = $_POST['posupplier'];}
if(empty($poID)){$poID = $_POST['idPO'];}
/*for($i=0;$i<=$items;$i++){
$toDBDetSatuan = $_POST['txtSat'.$i];
开发者ID:reekoheek,项目名称:srmis,代码行数:31,代码来源:generate_po.php
示例17: execSQL
<?php
include "header.php";
if ($loggedin) {
if (isset($_POST["username"]) && isset($_POST["about"])) {
// Modify existing profile
$result = execSQL("UPDATE users SET about='" . $_POST["about"] . "', profileimage='" . $_POST["profileimage"] . "' WHERE username='" . strtolower($_POST["username"]) . "'");
redirect("profile.php?u=" . $_POST["username"]);
} else {
redirect("");
}
}
include "footer.php";
开发者ID:jaflo,项目名称:hackme,代码行数:13,代码来源:updateprofile.php
示例18: updateRelConstraint
/**
* put your comment there...
*
* @param mixed $rcons - array that contains data for on record in defRelationshipConstraints
*/
function updateRelConstraint($srcID, $trgID, $terms)
{
global $mysqli, $rcsColumnNames;
$ret = null;
if ($terms == null) {
$terms = array("null", '', "null", '');
}
if (intval($terms[2]) < 1) {
//if($terms[2]==null || $terms[2]=="" || $terms[2]=="0"){
$terms[2] = "null";
}
$where = " where ";
if (intval($srcID) < 1) {
$srcID = "null";
$where = $where . " rcs_SourceRectypeID is null";
} else {
$where = $where . " rcs_SourceRectypeID=" . $srcID;
}
if (intval($trgID) < 1) {
$trgID = "null";
$where = $where . " and rcs_TargetRectypeID is null";
} else {
$where = $where . " and rcs_TargetRectypeID=" . $trgID;
}
if (intval($terms[0]) < 1) {
// $terms[0]==null || $terms[0]==""){
$terms[0] == "null";
$where = $where . " and rcs_TermID is null";
} else {
$where = $where . " and rcs_TermID=" . $terms[0];
}
$query = "select rcs_ID from defRelationshipConstraints " . $where;
$res = $mysqli->query($query);
$parameters = array("s", $terms[3]);
//notes will be parameter
$query = "";
if ($res == null || $res->num_rows < 1) {
//$mysqli->affected_rows<1){
//insert
$query = "insert into def
|
请发表评论