function signup($first_name, $last_name, $age, $email, $password) { $sql = sprintf("SELECT user_id FROM user WHERE email = '%s'", $email); $exists = executeSql($sql); if (mysql_num_rows($exists) == 1) { return "exists"; } else { $sql = sprintf("INSERT INTO user (first_name, last_name, age, email, password, receive_notifications, is_new, lang_id) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $first_name, $last_name, $age, $email, md5($password), "0", "1", "1"); return executeSql($sql); } }
/** * [createTable 创建按天分表的表格 若不存在则新建 $table_yyyymmdd] * @param [type] $tableName [description] * @param [type] $prefix [description] * @return [type] [description] */ public function createTable($tableName, $prefix) { //默认已经创建基表直接复制 $basic = $tableName . "_basic"; $tableName = $tableName . "_" . $prefix; $sql = "CREATE TABLE if not exists `" . $tableName . "` like {$basic}"; // $this->mysqlConnect(); // $ret = mysql_query($sql); $ret = executeSql($sql, false); return $tableName; }
function setModuleUserProgress($user_id, $module_id, $progress, $is_complete, $date_completed) { $module_already_added = isModuleAlreadyAdded($user_id, $module_id); if ($module_already_added) { return '{"status": "error", "message": "The user has already selected this module"}'; } else { $sql = sprintf("INSERT INTO user_module (user_id, module_id, progress, is_complete, date_completed) VALUE ('%s', '%s', '%s', '%s', '%s')", $user_id, $module_id, $progress, $is_complete, $date_completed); $done = executeSql($sql); if ($done) { return '{"status": "ok", "message": "Module has been added successfully!", "module_id": ' . $module_id . '}'; } else { return '{"status": "error", "message": "There was a problem while adding this module. Please try again later"}'; } } }
function saveBeaconData($uuid = null) { $conf = new Conf(); global $dbConnection; //db credentials $dbInfo['host'] = $conf->dbhost; $dbInfo['username'] = $conf->dbuser; $dbInfo['password'] = $conf->dbpass; $dbInfo['database'] = $conf->dbname; $dbInfo['port'] = $conf->dbport; $dbConnection = createDbConnection($dbInfo['host'], $dbInfo['username'], $dbInfo['password'], $dbInfo['database'], $dbInfo['port']); executeSql("UPDATE `hs_hr_config` SET `value` = '{$uuid}' WHERE `key` = 'beacon.uuid'"); executeSql("UPDATE `hs_hr_config` SET `value` = 'on' WHERE `key` = 'beacon.activiation_status'"); mysqli_close($dbConnection); return true; }
function saveBeaconData() { include_once 'lib/confs/Conf.php'; $conf = new Conf(); global $dbConnection; //db credentials $dbInfo['host'] = $conf->dbhost; $dbInfo['username'] = $conf->dbuser; $dbInfo['password'] = $conf->dbpass; $dbInfo['database'] = $conf->dbname; $dbInfo['port'] = $conf->dbport; $dbConnection = createDbConnection($dbInfo['host'], $dbInfo['username'], $dbInfo['password'], $dbInfo['database'], $dbInfo['port']); if ($_POST['hearbeatSelect'] == 'on') { executeSql("UPDATE `hs_hr_config` SET `value` = 'on' WHERE `key` = 'beacon.activation_acceptance_status'"); } $companyName = trim(addslashes($_POST['registerCompanyName'])); executeSql("INSERT INTO `ohrm_organization_gen_info`(`name`) VALUES ('" . $companyName . "') "); mysqli_close($dbConnection); return true; }
function main() { // Cria BD e tabela $db = new PDO("sqlite:teste.db"); executeSql($db, "create table cadastro(nome varchar(80) not null primary key, nascimento text not null)"); // Limpa a tabela eliminando registros existentes executeSql($db, "delete from cadastro"); // Inclui linhas na tabela executeSql($db, "insert into cadastro values('Maria', '2010-01-21')"); executeSql($db, "insert into cadastro values('José', '1995-10-09')"); executeSql($db, "insert into cadastro values('Ada', '2011-07-15')"); // Tentativa de incluir chave primária duplicada executeSql($db, "insert into cadastro values('Ada', '2011-11-12')"); // Inclusão de valor de tipo diferente do configurado para a coluna executeSql($db, "insert into cadastro values('Eliseu', 3.1415)"); // Atualiza dado de uma linha executeSql($db, "update cadastro set nome='Maria José' where nome='Maria'"); // Mostra conteúdo da tabela imprimir($db); }
JOIN faq_response AS fr ON fr.FAQ_QuestionId = fq.Id WHERE MATCH(fr.Text) AGAINST(:searchQuery) ORDER BY fq.Text ASC ', ['searchQuery' => $searchQuery]); foreach ($answers as $answer) { if (!isset($resultQuestions[$answer->id])) { $resultQuestions[$answer->id] = ['id' => $answer->id, 'name' => $answer->text]; } } $result = ['questions' => array_values($resultQuestions)]; $app->response->headers->set('Content-Type', 'application/json'); $app->response->write(json_encode($result)); }); $app->get('/questions/:id/answers', function ($id) use($app) { $answers = executeSql(' SELECT fr.Id AS id, fr.Text AS text FROM faq_response AS fr WHERE fr.FAQ_QuestionId = :questionId ', ['questionId' => $id]); $result = []; foreach ($answers as $answer) { $result[] = ['id' => $answer->id, 'text' => $answer->text]; } $app->response->headers->set('Content-Type', 'application/json'); $app->response->write(json_encode($result)); }); include_once 'expert_operations.php'; $app->run();
?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Zen Cart™ Installer</title> <link rel="stylesheet" type="text/css" href="includes/templates/template_default/css/stylesheet.css"> </head> <div id="wrap"> <div id="header"> <img src="includes/templates/template_default/images/zen_header_bg.jpg"> </div> <div class="progress" align="center">Installation In Progress...<br /><br /> <?php } executeSql($_POST['db_type'] . '_zencart.sql', $_POST['db_name'], $_POST['db_prefix']); //update the cache folder setting: $sql = "update " . $_POST['db_prefix'] . "configuration set configuration_value='" . $_POST['sql_cache_dir'] . "' where configuration_key='SESSION_WRITE_DIRECTORY'"; $db->Execute($sql); //update the phpbb setting: $sql = "update " . $_POST['db_prefix'] . "configuration set configuration_value='" . $_GET['use_phpbb'] . "' where configuration_key='PHPBB_LINKS_ENABLED'"; $db->Execute($sql); $db->Close(); // done - now onto next page for Store Setup (entries into database) if ($zc_show_progress == 'yes') { $linkto = 'index.php?main_page=store_setup&language=' . $language; $link = '<a href="' . $linkto . '">' . '<br /><br />Done!<br />Click Here To Continue<br /><br />' . '</a>'; echo "\n<script type=\"text/javascript\">\nwindow.location=\"{$linkto}\";\n</script>\n"; echo '<noscript>' . $link . '</noscript><br /><br />'; echo '<div id="footer"><p>Copyright © 2003, 2004, 2005 <a href="http://www.zen-cart.com" target="_blank">Zen Cart</a></p></div></div></body></html>'; }
if (!$zc_install->fatal_error && isset($_POST['adminid']) && isset($_POST['adminpwd'])) { $zc_install->fileExists('sql/' . DB_TYPE . $sniffer_file, DB_TYPE . $sniffer_file . ' ' . ERROR_TEXT_DB_SQL_NOTEXIST, ERROR_CODE_DB_SQL_NOTEXIST); $zc_install->functionExists(DB_TYPE, ERROR_TEXT_DB_NOTSUPPORTED, ERROR_CODE_DB_NOTSUPPORTED); $zc_install->dbConnect(DB_TYPE, DB_SERVER, DB_DATABASE, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, ERROR_TEXT_DB_CONNECTION_FAILED, ERROR_CODE_DB_CONNECTION_FAILED, ERROR_TEXT_DB_NOTEXIST, ERROR_CODE_DB_NOTEXIST); $zc_install->verifyAdminCredentials($_POST['adminid'], $_POST['adminpwd']); } //end if !fatal_error if (ZC_UPG_DEBUG2 == true) { echo 'Processing [' . $sniffer_file . ']...<br />'; } if ($zc_install->error == false && $nothing_to_process == false) { //open database connection to run queries against it $db = new queryFactory(); $db->Connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE) or die("Unable to connect to database"); // load the upgrade.sql file(s) relative to the required step(s) $query_results = executeSql('sql/' . DB_TYPE . $sniffer_file, DB_DATABASE, DB_PREFIX); if ($query_results['queries'] > 0 && $query_results['queries'] != $query_results['ignored']) { $messageStack->add('upgrade', $query_results['queries'] . '条指令成功执行。', 'success'); } else { $messageStack->add('upgrade', '失败: ' . $query_results['queries'], 'error'); } if (zen_not_null($query_results['errors'])) { foreach ($query_results['errors'] as $value) { $messageStack->add('upgrade-error-details', '忽略: ' . $value, 'error'); } } if ($query_results['ignored'] != 0) { $messageStack->add('upgrade', '说明: ' . $query_results['ignored'] . '条指令未执行。详情查看 "upgrade_exceptions" 数据表。', 'caution'); } /* if (zen_not_null($query_results['output'])) { foreach ($query_results['output'] as $value) {
$messageStack->add('INFO: ' . $value, 'caution'); } } } } else { $messageStack->add(ERROR_NOTHING_TO_DO, 'error'); } break; case 'uploadquery': $upload_query = file($_FILES['sql_file']['tmp_name']); $query_string = $upload_query; if (@get_magic_quotes_runtime() > 0) { $query_string = zen_db_prepare_input($upload_query); } if ($query_string != '') { $query_results = executeSql($query_string, DB_DATABASE, DB_PREFIX); if ($query_results['queries'] > 0 && $query_results['queries'] != $query_results['ignored']) { $messageStack->add($query_results['queries'] . ' statements processed.', 'success'); } else { $messageStack->add('Failed: ' . $query_results['queries'], 'error'); } if (zen_not_null($query_results['errors'])) { foreach ($query_results['errors'] as $value) { $messageStack->add('ERROR: ' . $value, 'error'); } } if ($query_results['ignored'] != 0) { $messageStack->add('Note: ' . $query_results['ignored'] . ' statements ignored. See "upgrade_exceptions" table for additional details.', 'caution'); } if (zen_not_null($query_results['output'])) { foreach ($query_results['output'] as $value) {
function dbDemoDataInstall() { $this->dbActivate(); // can likely remove this line for v1.4 global $db; $db = $this->db; executeSql('demo/' . DB_TYPE . '_demo.sql', DB_DATABASE, DB_PREFIX); }
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'twitter'"))) { executeSql("plugins/tw/db.sql"); } $sql = mysql_query("SELECT twiter FROM users"); if (!$sql) { mysql_query("ALTER TABLE users ADD twitter varchar(255) NOT NULL"); } register_filter('index_icons', 'twitter_icon'); function twitter_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/twitter.png" alt="Get Twitter Followers"><br><b>Twitter Followers</b></td>'; } register_filter('settings', 'twitter_settings'); function twitter_settings($settings) { $user = mysql_query("SELECT twitter FROM `users` WHERE `username`='{$_SESSION['username']}'"); $data = mysql_fetch_object($user); return $settings . 'Twitter<br/><input name="twitter" type="text" value="' . $data->twitter . '"><br/><br/>'; } register_filter('settings_sumbit', 'twitter_settings_submit'); function twitter_settings_submit($settings) { return $settings . ", `twitter` = '{$_POST['twitter']}'"; } register_filter('top_menu_earn', 'twitter_top_menu'); function twitter_top_menu($menu) { return $menu . "<li><a href='xchange.php?p=tw'>Twitter</a></li>"; }
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'surf'"))) { executeSql("plugins/surf/db.sql"); } $sql = mysql_query("SELECT surftime FROM settings"); if (!$sql) { mysql_query("ALTER TABLE settings ADD surftime varchar(50) NOT NULL DEFAULT '10'"); } register_filter('admin_settings', 'surf_settings'); function surf_settings($settings) { $site = mysql_fetch_object(mysql_query("SELECT surftime FROM `settings`")); return $settings . 'Surf Time (2 - infinite)<br/><input name="surftime" type="text" value="' . $site->surftime . '"/><br/><br/>'; } register_filter('admin_settings_post', 'surf_settings_post'); function surf_settings_post($settings) { return $settings . ", `surftime`='{$_POST['surftime']}'"; } register_filter('index_icons', 'surf_icon'); function surf_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/yelp.png" alt="Get Website Traffic"><br><b>Website Traffic</b></td>'; } register_filter('top_menu_earn', 'surf_top_menu'); function surf_top_menu($menu) { return $menu . "<li><a target='_blank' href='p.php?p=surf'>Surf</a></li>"; } register_filter('site_menu', 'surf_site_menu');
function getUserById($user_id) { $sql = sprintf("SELECT user_id, first_name, last_name, age, email, receive_notifications, is_new, lang_id FROM user WHERE user_id = '%d'", $user_id); return executeSql($sql); }
function removeStepProgress($step_id, $user_id) { $sql = sprintf("DELETE FROM user_step WHERE user_id = '%d' AND step_id = '%d'", $user_id, $step_id); return executeSql($sql); }
/** * 删除数据库 * * @param resource $con 数据库连接 * @param string $dbname 数据库名 * @return array array($result, $info, $target) * $result 创建结果 * $info 出错信息 * $target 出错目标 */ function dropDB($con, $dbname) { $result = true; $info = ''; $target = 'alert'; $sql = 'DROP DATABASE `' . $dbname . '`'; list($result, $infos) = executeSql($con, $sql); $info = implode("\n", $infos); $result = $result ? 0 : 1; return array($result, $info, $target); }
* * @param int $e_id id of the expert, e.g. 5023. * * @return json composed by questions sorted by most recent. */ $app->get('/get_recent_questions/:e_id', function ($e_id) use($app) { $recentQuestions = executeSql(' SELECT faq_question.Id, faq_question.Text, faq_question.OccupationId, faq_question.DateCreated FROM faq_question INNER JOIN faq_questionassignment ON faq_questionassignment.FAQ_QuestionID = faq_question.Id WHERE faq_questionassignment.FAQ_ExpertID=:e_id ORDER BY DateCreated DESC; ', ['e_id' => $e_id]); $app->response->headers->set('Content-Type', 'application/json'); $app->response->write(json_encode($recentQuestions)); }); /** * A function that will accept a like to to a specific response. (Ruben) * * @param int $e_id id of the expert, e.g. 5023. * @param int $r_id id of the response of another expert, e.g. 633491. * * @return none */ $app->get('/add_like_response/:e_id/:r_id', function ($e_id, $r_id) use($app) { executeSql(' INSERT INTO faq_responserating (`FAQ_ResponseId`, `FAQ_ExpertId`) VALUES (:r_id, :e_id) ', ['e_id' => $e_id, 'r_id' => $r_id]); });
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'linkedin'"))) { executeSql("plugins/li/db.sql"); } register_filter('index_icons', 'linkedin_icon'); function linkedin_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/linkedin.png" alt="Get Linkedin Shares"><br><b>Linkedin Shares</b></td>'; } register_filter('top_menu_earn', 'linkedin_top_menu'); function linkedin_top_menu($menu) { return $menu . "<li><a href='xchange.php?p=li'>Linkedin</a></li>"; } register_filter('site_menu', 'linkedin_site_menu'); function linkedin_site_menu($menu) { $selected = ""; if (isset($_GET["p"]) && $_GET["p"] == "li") { $selected = "class='selected'"; } else { $selected = "href='sites.php?p=li'"; } return $menu . "<a {$selected}>Linkedin</a>"; } register_filter('li_info', 'linkedin_info'); function linkedin_info($type) { if ($type == "db") { return "linkedin";
} } } // 安装演示数据 if (isset($_SESSION['extData']) && $_SESSION['extData'] == md5('extData')) { $sqlData = file_get_contents(PATH_ROOT . './install/data/installExtra.sql'); $search = array('{time}', '{time1}', '{time2}', '{date}', '{date+1}'); $replace = array(time(), strtotime('-1 hour'), strtotime('+1 hour'), strtotime(date('Y-m-d')), strtotime('-1 day', strtotime(date('Y-m-d')))); $sql = str_replace($search, $replace, $sqlData); executeSql($sql); unset($_SESSION['extData']); } // 安装工作流数据 if (getIsInstall('workflow')) { $sqlFlowData = file_get_contents(PATH_ROOT . './install/data/installFlow.sql'); executeSql($sqlFlowData); } session_destroy(); $cacheArr = array('AuthItem', 'CreditRule', 'Department', 'Ipbanned', 'Nav', 'NotifyNode', 'Position', 'PositionCategory', 'Setting', 'UserGroup'); foreach ($cacheArr as $cache) { CacheUtil::update($cache); } CacheUtil::load('usergroup'); // 要注意小写 CacheUtil::update('Users'); // 因为用户缓存要依赖usergroup缓存,所以放在最后单独更新 file_put_contents(PATH_ROOT . 'data/install.lock', ''); $configfile = CONFIG_PATH . 'config.php'; $config = (require $configfile); include 'extInfo.php'; exit;
function isTaskAlreadyAdded($user_id, $task_id) { $sql = sprintf("SELECT user_task_id FROM user_task WHERE user_id = %d AND task_id = %d", $user_id, $task_id); $exists = executeSql($sql); return mysql_num_rows($exists); }
/** * 执行模块安装 * @param string $moduleName 模块名 * @return boolean 安装成功与否 */ function install($moduleName) { global $coreModules, $sysDependModule; defined('IN_MODULE_ACTION') or define('IN_MODULE_ACTION', true); $installPath = getInstallPath($moduleName); // 安装模块模型(如果有) $modelSqlFile = $installPath . 'model.sql'; if (file_exists($modelSqlFile)) { $modelSql = file_get_contents($modelSqlFile); executeSql($modelSql); } // 处理模块配置,写入数据 $config = (require $installPath . 'config.php'); $icon = MODULE_PATH . $moduleName . '/static/image/icon.png'; if (is_file($icon)) { $config['param']['icon'] = 1; } else { $config['param']['icon'] = 0; } if (!isset($config['param']['category'])) { $config['param']['category'] = ''; } if (isset($config['param']['indexShow']) && isset($config['param']['indexShow']['link'])) { $config['param']['url'] = $config['param']['indexShow']['link']; } else { $config['param']['url'] = ''; } $configs = json_encode($config); $record = array('module' => $moduleName, 'name' => $config['param']['name'], 'url' => $config['param']['url'], 'category' => $config['param']['category'], 'version' => $config['param']['version'], 'description' => $config['param']['description'], 'icon' => $config['param']['icon'], 'config' => $configs, 'installdate' => time()); if (in_array($moduleName, $coreModules)) { $record['iscore'] = 1; } elseif (in_array($moduleName, $sysDependModule)) { $record['iscore'] = 2; } else { $record['iscore'] = 0; } $insertStatus = Yii::app()->db->createCommand()->insert('{{module}}', $record); return $insertStatus; }
function saveSKRHistory($indicator, $prevdata, $nextdata, $remark, $rlogID, $table, $id) { $sql1 = "INSERT INTO skr_history (sh_indicator, sh_prev_data, sh_new_data, sh_remark, sh_rlog_id, sh_table, sh_table_id, sh_tkh_upd)\n\tVALUES('{$indicator}', '{$prevdata}', '{$nextdata}', '{$remark}', '{$rlogID}', '{$table}', '{$id}', now())"; echo executeSql($sql1); }
$store_country = zen_db_prepare_input($_POST['store_country']); $store_zone = zen_db_prepare_input($_POST['store_zone']); $store_address = zen_db_prepare_input($_POST['store_address']); $store_default_language = zen_db_prepare_input($_POST['store_default_language']); $store_default_currency = zen_db_prepare_input($_POST['store_default_currency']); $zc_install->isEmpty($store_name, ERROR_TEXT_STORE_NAME_ISEMPTY, ERROR_CODE_STORE_NAME_ISEMPTY); $zc_install->isEmpty($store_owner, ERROR_TEXT_STORE_OWNER_ISEMPTY, ERROR_CODE_STORE_OWNER_ISEMPTY); $zc_install->isEmpty($store_owner_email, ERROR_TEXT_STORE_OWNER_EMAIL_ISEMPTY, ERROR_CODE_STORE_OWNER_EMAIL_ISEMPTY); $zc_install->isEmail($store_owner_email, ERROR_TEXT_STORE_OWNER_EMAIL_NOTEMAIL, ERROR_CODE_STORE_OWNER_EMAIL_NOTEMAIL); $zc_install->isEmpty($store_address, ERROR_TEXT_STORE_ADDRESS_ISEMPTY, ERROR_CODE_STORE_ADDRESS_ISEMPTY); if ($_POST['demo_install'] == 'true') { $zc_install->fileExists('demo/' . DB_TYPE . '_demo.sql', ERROR_TEXT_DEMO_SQL_NOTEXIST, ERROR_CODE_DEMO_SQL_NOTEXIST); } if ($zc_install->error == false) { if ($_POST['demo_install'] == 'true') { executeSql('demo/' . DB_TYPE . '_demo.sql', DB_DATABASE, DB_PREFIX); } $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_name) . "' where configuration_key = 'STORE_NAME'"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_owner) . "' where configuration_key = 'STORE_OWNER'"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_owner_email) . "' where configuration_key in \r\n ('STORE_OWNER_EMAIL_ADDRESS','EMAIL_FROM','SEND_EXTRA_ORDER_EMAILS_TO','SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO','SEND_EXTRA_LOW_STOCK_EMAILS_TO',\r\n 'SEND_EXTRA_GV_CUSTOMER_EMAILS_TO','SEND_EXTRA_GV_ADMIN_EMAILS_TO','SEND_EXTRA_DISCOUNT_COUPON_ADMIN_EMAILS_TO','SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO', 'SEND_EXTRA_TELL_A_FRIEND_EMAILS_TO', 'SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO')"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_country) . "' where configuration_key = 'STORE_COUNTRY'"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_zone) . "' where configuration_key = 'STORE_ZONE'"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_address) . "' where configuration_key = 'STORE_NAME_ADDRESS'"; $db->Execute($sql); $sql = "update " . DB_PREFIX . "configuration set configuration_value = '" . $db->prepare_input($store_default_language) . "' where configuration_key = 'DEFAULT_LANGUAGE'"; $db->Execute($sql);
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'youtube'"))) { executeSql("plugins/yt/db.sql"); } register_filter('index_icons', 'youtube_icon'); function youtube_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/youtube.png" alt="Get Youtube Views"><br><b>Youtube Views</b></td>'; } register_filter('top_menu_earn', 'youtube_top_menu'); function youtube_top_menu($menu) { return $menu . "<li><a href='xchange.php?p=yt'>Youtube</a></li>"; } register_filter('site_menu', 'youtube_site_menu'); function youtube_site_menu($menu) { $selected = ""; if (isset($_GET["p"]) && $_GET["p"] == "yt") { $selected = "class='selected'"; } else { $selected = "href='sites.php?p=yt'"; } return $menu . "<a {$selected}>Youtube</a>"; } register_filter('yt_info', 'youtube_info'); function youtube_info($type) { if ($type == "db") { return "youtube";
function updateProfile($user_id, $first_name, $last_name, $age) { $sql = sprintf("UPDATE user SET first_name = '%s', last_name = '%s', age = '%s' WHERE user_id = %d", $first_name, $last_name, $age, $user_id); return executeSql($sql); }
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'googleplus'"))) { executeSql("plugins/gp/db.sql"); } register_filter('index_icons', 'googleplus_icon'); function googleplus_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/google.png" alt="Get Google Plus"><br><b>Google Plus</b></td>'; } register_filter('top_menu_earn', 'googleplus_top_menu'); function googleplus_top_menu($menu) { return $menu . "<li><a href='xchange.php?p=gp'>Google Plus</a></li>"; } register_filter('site_menu', 'googleplus_site_menu'); function googleplus_site_menu($menu) { $selected = ""; if (isset($_GET["p"]) && $_GET["p"] == "gp") { $selected = "class='selected'"; } else { $selected = "href='sites.php?p=gp'"; } return $menu . "<a {$selected}>Google Plus</a>"; } register_filter('gp_info', 'googleplus_info'); function googleplus_info($type) { if ($type == "db") { return "googleplus";
WHERE MATCH(fr.Text) AGAINST(:searchQuery) HAVING isAnswered = 1 ORDER BY fq.Text ASC ', ['searchQuery' => $searchQuery]); foreach ($answers as $answer) { if (!isset($resultQuestions[$answer->id])) { $resultQuestions[$answer->id] = ['id' => $answer->id, 'name' => $answer->text]; } } $result = ['questions' => array_values($resultQuestions)]; $app->response->headers->set('Content-Type', 'application/json'); $app->response->write(json_encode($result)); }); $app->get('/questions/:id/answers', function ($id) use($app) { $answers = executeSql(' SELECT fr.Id AS id, fr.Text AS text FROM faq_response AS fr JOIN faq_responsefaq_question AS frq ON frq.FAQ_Response_Id = fr.Id WHERE frq.FAQ_Question_Id = :questionId ', ['questionId' => $id]); $result = []; foreach ($answers as $answer) { $result[] = ['id' => $answer->id, 'text' => $answer->text]; } $app->response->headers->set('Content-Type', 'application/json'); $app->response->write(json_encode($result)); }); $app->run();
<?php if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'facebook'"))) { executeSql("plugins/fb/db.sql"); } register_filter('index_icons', 'facebook_icon'); function facebook_icon($icons) { return $icons . '<td align="center" width="14%" valign="top"><img src="60/facebook.png" alt="Get Facebook Likes"><br><b>Facebook Likes</b></td>'; } register_filter('top_menu_earn', 'facebook_top_menu'); function facebook_top_menu($menu) { return $menu . "<li><a href='xchange.php?p=fb'>Facebook</a></li>"; } register_filter('site_menu', 'facebook_site_menu'); function facebook_site_menu($menu) { $selected = ""; if (isset($_GET["p"]) && $_GET["p"] == "fb") { $selected = "class='selected'"; } else { $selected = "href='sites.php?p=fb'"; } return $menu . "<a {$selected}>Facebook</a>"; } register_filter('fb_info', 'facebook_info'); function facebook_info($type) { if ($type == "db") { return "facebook";
function transferReviewsToOhrm() { $sql = "SELECT * FROM `hs_hr_performance_review`"; $result = executeSql($sql); while ($row = mysqli_fetch_array($result)) { $reviewId = $row['id']; $employeeId = $row['employee_id']; $reviewerId = $row['reviewer_id']; $jobTitleCode = $row['job_title_code']; $subDivisionId = $row['sub_division_id']; $creationDate = $row['creation_date']; $periodFrom = $row['period_from']; $periodTo = $row['period_to']; $dueDate = $row['due_date']; $state = $row['state']; $kpis = $row['kpis']; $stateId = getStateId($state); if ($stateId == 4) { $completedDate = $dueDate; } else { $completedDate = 'NULL'; } if ($stateId >= 2) { $activatedDate = $creationDate; } else { $activatedDate = 'NULL'; } executeSql("INSERT INTO `ohrm_performance_review`(`id`, `status_id`, `employee_number`, `work_period_start`, `work_period_end`, `job_title_code`, `department_id`, `due_date`, `completed_date`, `activated_date`) VALUES" . "(" . escapeString($reviewId) . ", " . escapeString($stateId) . "," . escapeString($employeeId) . "," . escapeString($periodFrom) . "," . escapeString($periodTo) . "," . escapeString($jobTitleCode) . "," . escapeString($subDivisionId) . "," . escapeString($dueDate) . "," . escapeString($completedDate) . "," . escapeString($activatedDate) . ")"); if ($stateId >= 2) { transferKpisToReviewer($reviewId, $reviewerId, $state, $completedDate, $kpis); } } }
function main() { $requisicao = json_decode(file_get_contents("php://input")); $sql = ""; $resposta = ""; $num_elementos = 0; switch ($_SERVER["REQUEST_METHOD"]) { case "DELETE": case "POST": case "PUT": $is_logged = isLogged(); if (!$is_logged[0]) { // print encode(false, null, "É necessário se logar no Facebook!"); print encode(false, null, $is_logged[1]); return; } } switch ($_SERVER["REQUEST_METHOD"]) { case "DELETE": $sql = "delete from t_notas_2 where id = :par1"; $resposta = executeSql($sql, $_SERVER["REQUEST_METHOD"], $requisicao->id); break; case "GET": $pagina = 1; $elementosPorPagina = 1; if (isset($_GET["pagina"])) { $pagina = $_GET["pagina"]; } if (isset($_GET["elementosPorPagina"])) { $elementosPorPagina = $_GET["elementosPorPagina"]; } $inicio = $elementosPorPagina * ($pagina - 1); $sql = "select * from t_notas_2 order by tstamp desc\n offset :par1 limit :par2"; $dados = executeSql($sql, $_SERVER["REQUEST_METHOD"], $inicio, $elementosPorPagina); if ($dados[0]) { $rows = $dados[1]; $msg = $dados[2]; $sql = "select count(id) from t_notas_2"; $dados = executeSql($sql, $_SERVER["REQUEST_METHOD"]); if ($dados[0]) { $resposta = array(true, $rows, $msg); $num_elementos = $dados[1][0]["count"]; break; } } $resposta = array(false, array(), $dados[2], 0); break; case "POST": $sql = "insert into t_notas_2(texto) values(:par1)"; $resposta = executeSql($sql, $_SERVER["REQUEST_METHOD"], $requisicao->texto); break; case "PUT": $sql = "update t_notas_2 set texto = :par1 where id = :par2"; $resposta = executeSql($sql, $_SERVER["REQUEST_METHOD"], $requisicao->texto, $requisicao->id); break; default: print encode(false, null, "Requisição inválida: " . $_SERVER["REQUEST_METHOD"]); return; } print encode($resposta[0], $resposta[1], $resposta[2], $num_elementos); }