/** * @param $transactionId * @param $post * @return mixed */ public function updateTransactionStatus($transactionId, $status) { $sql = 'UPDATE ' . self::TRANSACTIONS_TABLE_NAME . ' SET payment_status = ? WHERE txn_id = ?'; $params = [&$status, $transactionId]; $db = new DatabaseService(); $data = $db->execSQL($sql, $params, 'ss'); return count($data) ? $data[0] : null; }
public function __construct() { // get db connection $db = new DatabaseService(); $this->sql_con = $db->getConnection(); if (!$this->sql_con) { HttpService::return_service_unavailable(); } }
function insert($fname, $lname, $email, $pass) { $DatabaseService = new DatabaseService(); $DatabaseService->connect(); $con = $DatabaseService->con; $con->query("insert into users (f-name,l-name,email,password) values ('{$fname}','{$lname}','{$email}','{$pass}')"); echo json_encode(array("OK" => "signup sucess")); exit; }
/** * Returns default driver name. * * @return string * @since 0.1.0 */ protected static function getDefaultDriver() { if (self::$driver === null) { self::$driver = \Yii::app()->db->getDriverName(); } return self::$driver; }
public static function getDatabaseService() { if (!self::$databaseService) { self::$databaseService = new DatabaseService(); } return self::$databaseService; }
static function getSpecificOrAllKetegories() { $kategorien = DatabaseService::getDatabaseService()->findAllKategorie(); $output = ""; foreach ($kategorien as $key => $value) { $output .= "<li><a href=\"produkte.php?kategorieid=" . $value->getKategorieid() . "\">" . $value->getKategoriename() . "</a></li>"; } return $output; }
public function delete() { $statement1 = 'DELETE FROM thread WHERE id=:id'; //To delete all messages posted to thread $statement2 = 'DELETE FROM message WHERE thread_id=:id'; $statement3 = 'DELETE FROM thread_user WHERE thread_id=:id'; $values = array('id' => $this->id); DatabaseService::execute($statement3, $values); DatabaseService::execute($statement2, $values); DatabaseService::execute($statement1, $values); }
/** * @param $data * @param null $myPost */ public static function log($data, $myPost = null) { //@TODO refactor if ($myPost) { if (!isset($data['txn_id'])) { $data['txn_id'] = $myPost['txn_id']; } if (!isset($data['subscr_id'])) { $data['subscr_id'] = isset($myPost['subscr_id']) ? $myPost['subscr_id'] : null; } if (!isset($data['user_id'])) { $data['user_id'] = (string) $myPost['customData']['user_id']; } if (!isset($data['data'])) { $data['data'] = json_encode($myPost); } } $data['created'] = date('Y-m-d H:i:s'); $db = new DatabaseService(); $db->insertData(self::LOG_TABLE_NAME, $data); }
/** * @return array * @throws Exception */ public function getSubscriptionPlanOptions() { $planId = $this->id; $db = new DatabaseService(); $sql = 'SELECT * FROM ' . self::TABLE_NAME_OPTIONS . ' WHERE plan_id = ? '; $params = [&$planId]; $data = $db->execSQL($sql, $params, 'i'); $res = []; foreach ($data as $option) { $res[$option['name']] = $option['value']; } return $res; }
/** * login * @param $username string * @param $password string */ public static function login($username, $password) { // Delete Mocking behavior // get db connection $db = new DatabaseService(); $sql_con = $db->getConnection(); //connection failed if (!$sql_con) { HttpService::return_service_unavailable(); } //get hash algos $algos = hash_algos(); //take the 3rd algo $algo = $algos[2]; $pw_hash = hash($algo, $password); //get user from db $query = "SELECT * FROM user WHERE alias = '{$username}' AND password = '******'"; $result = $sql_con->query($query); $row = mysqli_fetch_assoc($result); //login data correct? if (!isset($row)) { HttpService::redirect_to('/login/fail'); } //add alias to session $_SESSION['username'] = $row['alias']; $_SESSION['user_id'] = $row['id']; $roles = array(); //add user role switch ($row['role']) { case 1: array_push($roles, 'admin'); break; case 2: array_push($roles, 'author'); break; case 3: array_push($roles, 'user'); break; } //add roles to session $_SESSION['roles'] = $roles; }
$result->dispose(); } catch (MySQLQuerierException $e) { $tpl->assign_block_vars('line', array()); $tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => '')); } } elseif (substr($lower_query, 0, 11) == 'insert into' || substr($lower_query, 0, 6) == 'update' || substr($lower_query, 0, 11) == 'delete from' || substr($lower_query, 0, 11) == 'alter table' || substr($lower_query, 0, 8) == 'truncate' || substr($lower_query, 0, 10) == 'drop table') { try { $result = PersistenceContext::get_querier()->inject(str_replace('phpboost_', PREFIX, $query)); $affected_rows = $result->get_affected_rows(); } catch (MySQLQuerierException $e) { $tpl->assign_block_vars('line', array()); $tpl->assign_block_vars('line.field', array('FIELD_NAME' => $e->GetMessage(), 'STYLE' => '')); } } } $tpl->put_all(array('QUERY' => DatabaseService::indent_query($query), 'QUERY_HIGHLIGHT' => DatabaseService::highlight_query(str_replace('phpboost_', PREFIX, $query)), 'L_REQUIRE' => LangLoader::get_message('form.explain_required_fields', 'status-messages-common'), 'L_EXPLAIN_QUERY' => $LANG['db_query_explain'], 'L_CONFIRM_QUERY' => $LANG['db_confirm_query'], 'L_EXECUTE' => $LANG['db_submit_query'], 'L_RESULT' => $LANG['db_query_result'], 'L_EXECUTED_QUERY' => $LANG['db_executed_query'])); } elseif ($action == 'restore') { //Suppression d'un fichier if (!empty($del)) { AppContext::get_session()->csrf_get_protect(); //Protection csrf $file = TextHelper::strprotect($del); $file_path = PATH_TO_ROOT . '/cache/backup/' . $file; //Si le fichier existe if (preg_match('`[^/]+\\.sql$`', $file) && is_file($file_path)) { if (@unlink($file_path)) { AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_success', '', '&')); } else { AppContext::get_response()->redirect(HOST . DIR . url('/database/admin_database.php?action=restore&error=unlink_failure', '', '&')); } } else {
public function delete() { $statement = 'DELETE FROM message WHERE id=:id'; $values = array('id' => $this->id); DatabaseService::execute($statement, $values); }
<?php require_once 'include/class.database.php'; $DatabaseService = new DatabaseService(); $DatabaseService->connect(); $con = $DatabaseService->con; $result = $con->query("SELECT * FROM ourserv "); while ($row = mysqli_fetch_array($result)) { $title = $row['title']; $des = $row['description']; }
/** * @return array */ public function getUsers() { $db = new DatabaseService(); $data = $db->getTableData(self::TABLE_NAME, '*', ''); return $data; }
private static function deleteParticipation($user_id, $thread_id) { $statement = 'DELETE FROM thread_user WHERE user_id = :user_id AND thread_id = :thread_id'; $values = array('user_id' => $user_id, 'thread_id' => $thread_id); DatabaseService::execute($statement, $values); }
public function checkModuleRestrictions($action) { $restrictionError = -1; $tf = new DatabaseService(); if (isset($_SESSION['subscriptionPlanOptions'])) { $subscriptionPlanOptions = $_SESSION['subscriptionPlanOptions']; } else { $subscriptionPlanOptions = $this->getOptions(); $_SESSION['subscriptionPlanOptions'] = $subscriptionPlanOptions; } $records = $tf->getTableData($action, '*', ''); if (isset($subscriptionPlanOptions['options'][$action]) && $subscriptionPlanOptions['options'][$action] !== '-1' && count($records) >= $subscriptionPlanOptions['options'][$action]) { echo $restrictionError; die; } }
/** * @param $userId * @param $serviceProvider * @return bool|mixed|mysqli_result * @throws Exception */ public static function getSubscriptionsArchive($userId, $serviceProvider) { $db = new DatabaseService(); $sql = 'SELECT *,s.id as subId FROM ' . self::TABLE_NAME . ' s INNER JOIN ' . SubscriptionPlan::TABLE_NAME . ' sp ON sp.id = s.plan_id WHERE sp.service_provider = ? AND s.user_id = ?'; $params = [&$serviceProvider, &$userId]; $data = $db->execSQL($sql, $params, 'ss'); return $data; }
/** * @param $id * @return mixed * @throws Exception */ public function getLastActiveTransactionBySubscription($id) { //@TODO refactor it $db = new DatabaseService(); $relationType = PaypalTransaction::TRANSACTION_RELATION_SUBSCRIPTION; $paymentStatus = 'Completed'; $sql = 'SELECT * FROM ' . PaypalTransaction::TRANSACTIONS_TABLE_NAME . ' WHERE relation_id = ? AND relation_type = ? AND payment_status = ? ORDER BY created_date'; $params = [&$id, &$relationType, &$paymentStatus]; $data = $db->execSQL($sql, $params, 'sss'); return $data[0]; }
/** * @param $userId * @return bool|mixed|mysqli_result * @throws Exception */ public static function getPaymentHistory($userId) { $db = new DatabaseService(); $sql = 'SELECT * FROM ' . self::TABLE_NAME . ' eu INNER JOIN ' . PaypalTransaction::TRANSACTIONS_TABLE_NAME . ' pt ON eu.id = pt.relation_id INNER JOIN ' . ExtraService::TABLE_NAME . ' es ON es.id = eu.service_id WHERE eu.user_id = ? AND pt.relation_type = ? ORDER BY pt.payment_date'; $relationType = PaypalTransaction::TRANSACTION_RELATION_EXTRA_SERVICE; $params = [&$userId, &$relationType]; $data = $db->execSQL($sql, $params, 'is'); return $data; }
/** * Tests failures on incorrect driver names. * * @param string $incorrectDriver Invalid driver name. * * @dataProvider invalidDriverNamesProvider * @expectedException \BadMethodCallException * * @return void * @since 0.1.0 */ public function testInvalidDriverNameException($incorrectDriver) { \DatabaseService::getNowExpression($incorrectDriver); }