private function doSave($item, $value, $environment, $group, $namespace = null) { $connection = $this->getConnection(); $query = $connection->createQueryBuilder(); if (is_array($value)) { foreach ($value as $key => $val) { $key = ($item ? $item . '.' : '') . $key; $this->doSave($key, $val, $environment, $group, $namespace); } return; } $query->update('Config', 'c')->set('configValue', $query->expr()->literal($value))->where($query->expr()->comparison('configGroup', '=', $query->expr()->literal($group))); if ($item) { $query->andWhere($query->expr()->comparison('configItem', '=', $query->expr()->literal($item))); } $query->andWhere($query->expr()->comparison('configNamespace', '=', $query->expr()->literal($namespace ?: ''))); if (!$query->execute()) { try { $query = "INSERT INTO Config (configItem, configValue, configGroup, configNamespace) VALUES (?, ?, ?, ?)"; \Database::executeQuery($query, array($item, $value, $group, $namespace ?: '')); } catch (\Exception $e) { // This happens when the update succeeded, but didn't actually change anything on the row. } } }
/** * Commit current tracking data. * @param $groupId */ public function commit($groupId) { $sql = "UPDATE dbtrack_actions SET groupid = :groupid WHERE groupid = 0"; $this->dbms->executeQuery($sql, array('groupid' => $groupId)); // Count new actions. $count = $this->dbms->getResult('SELECT COALESCE(COUNT(id), 0) AS actions FROM dbtrack_actions WHERE groupid = :groupid', array('groupid' => $groupId)); return $count->actions; }
public static function getInstance() { if (!self::$instance) { if (!file_exists(DB_DIR . "driver_db")) { $db = new Database(ROOT_DATABASE); $db->executeQuery("CREATE DATABASE driver_db"); } self::$instance = new Database("driver_db"); } return self::$instance; }
public function getDataFromDb2() { $db = new Database(); $db->executeQuery("SELECT * FROM cars"); return $db->getAllRows(); // $a = NULL; // $a = 100; // if (isset($a)) { // echo "set"; // } else { // echo 'not set'; // } // return $a; }
public function getEntitiesFromList($listId, $return, $offset) { // for now, ignoring return & offset - will return all products in list $query = 'call getProductsByEntityListIdEx(' . $listId . ',' . $this->tenantid . ',' . $offset . ',' . $return . ')'; $data = Database::executeQuery($query); $entity = ''; if ($data->num_rows == 0) { return array(); } while ($r = mysqli_fetch_assoc($data)) { $entities[] = $r; } return $entities; }
public function Yflatfile($url) { $url = parse_url($url); // Decode url-encoded information in the db connection string $url['path'] = urldecode($url['path']); //Check if the database exists $dbname = substr($url['path'], 1); if (!file_exists(DB_DIR . $dbname)) { $db = new Database(ROOT_DATABASE); $create_db_sql = "CREATE DATABASE {$dbname}"; if (!$db->executeQuery($create_db_sql)) { die(txtdbapi_get_last_error()); } } $this->lnk = new Database($dbname); }
public function getAvailableChildren($fieldname) { if ($fieldname == "pageCollections") { $query = "select id, name from pageCollection where tenantid=" . $this->tenantid; $results = Database::executeQuery($query); if ($results->num_rows == 0) { return array(); } else { $entities = array(); while ($r = mysqli_fetch_assoc($results)) { $entities[] = $r; } return $entities; } return $results->fetch; } else { return parent::getAvailableChildren($fieldname); } }
static function perform() { $db = new Database(); $rows = $db->executeQuery("SELECT * FROM MailQueue WHERE sent = 0"); if (is_array($rows) && count($rows) > 0) { foreach ($rows as $data) { $result = Emailer::send([$data['senderEmail'] => $data['senderName']], [$data['receiverEmail']], $data['subject'], $data['body']); if ($result) { $params = ['id' => $data['id'], 'sent' => 1, 'now' => date('Y-m-d H:i:s')]; $r = $db->executeUpdate("UPDATE MailQueue SET sentAt=:now, sent=:sent WHERE id = :id", $params); if ($r) { print "[{$data['subject']}] Email sent to: " . $data['receiverEmail'] . PHP_EOL; } else { print "[{$data['subject']}] Failed to send email for: " . $data['receiverEmail'] . PHP_EOL; } } } } }
public function generateKE_1($elementObj) { $db = new Database(); $query = "SELECT `E` FROM `ba_mat` WHERE `rcdNo`="; if ($elementObj->PK4ba_mat == 2) { $query .= "22"; } elseif ($elementObj->PK4ba_mat == 0) { $query .= "23"; } $dataset = $db->executeQuery($query); $r = $dataset->fetch_assoc(); $E = $r['E']; $I = $elementObj->PK4ba_g; $EI = $E * $I; $le = $elementObj->getLength(); $v1 = $EI * 12 / pow($le, 3); $v2 = $EI * 6 / pow($le, 2); $v3 = $EI * 4 / $le; $v4 = pow($EI, 2) / $le; $k_e = array(array($v1, $v2, -$v1, $v2), array($v2, $v3, -$v2, $v4), array(-$v1, -$v2, $v1, -$v2), array($v2, $v4, -$v2, $v3)); return $k_e; }
public static function executeQueryReturnArray($query) { // executes the specified query and returns a multidimensional associative array with the results $data = Database::executeQuery($query); $resultSet = array(); while ($row = mysqli_fetch_assoc($data)) { array_push($resultSet, $row); } return $resultSet; }
public function updatepassword($pass) { $secure_pass = generateHash($pass); $query = "UPDATE user SET password = " . Database::queryString($secure_pass) . ' WHERE id = ' . Database::queryNumber($this->id); return Database::executeQuery($query); }
<?php include "./db-api/txt-db-api.php"; $db = new Database("database_EAM"); $a = 0; $username = $_POST['name']; $password = $_POST['password']; $er1 = "    <font color=red>Invalid username/password</font>"; $redirect = "./index.php?er={$er1}"; $rs = $db->executeQuery("SELECT * FROM user;"); //get all rows while ($rs->next()) { //read next line list($usernam, $passwor) = $rs->getCurrentValues(); //do whatever you wish... if ($username == $usernam && $a != 2) { $a = 55; /*exei username apo thn vash user*/ if ($password == $passwor) { $a = 2; /*vrhkame ton xrhsth*/ session_start(); /*if (!isset($_SESSION['count'])) { $_SESSION['count'] = 0; } else { $_SESSION['count']++; }*/ unset($_SESSION["login_message"]); $_SESSION["isLoggedIn"] = 1; $_SESSION["uname"] = $username; $_SESSION["type"] = "user";
echo " Δώσατε λάθος πόλη. \n<br>"; $a = 1; } if (preg_match($regex1, $dieu8unsh)) { # valid name } else { echo " Δώσατε λάθος διεύθυνση. \n<br>"; $a = 1; } if (is_numeric($tk)) { } else { echo " Δώσατε λάθος ταχυδρομικό κώδικα.\n<br>"; $a = 1; } if ($oroi_xrhshs != NULL and $oroi_xrhshs1 != NULL and $sign_up == 'user' and $a != 1) { $resultset = $db->executeQuery("INSERT INTO user VALUES ('" . $username . "','" . $password . "','" . $ar_taut . "','" . $onoma . "','" . $epitheto . "','" . $nomos . "','" . $polh . "','" . $dieu8unsh . "','" . $tk . "','" . $mail . "') "); } if ($oroi_xrhshs != NULL and $oroi_xrhshs1 != NULL and $sign_up == 'doctor' and $a != 1) { /*$resultset1=$db->executeQuery("SELECT COUNT(*) FROM doctor"); (username, password, ar_taut, onoma, epitheto, nomos, polh, dieu8unsh, tk,email) (username, password, ar_taut, onoma, epitheto, nomos, polh, dieu8unsh, tk,email, eidikothta, dieu8_iatreiou) printf("resultset1= %d ",$resultset1);*/ $resultset = $db->executeQuery("INSERT INTO doctor VALUES ('" . $username . "','" . $password . "','" . $ar_taut . "','" . $onoma . "','" . $epitheto . "','" . $nomos . "','" . $polh . "','" . $dieu8unsh . "','" . $tk . "','" . $mail . "','" . $ar_ad . "','" . $eidikothta . "','" . $dieu8_iatreiou . "') "); } if ($oroi_xrhshs == NULL || $oroi_xrhshs1 == NULL) { printf("Δεν έχετε συμφωνήσει με τους όρους χρήσης\n"); $a = 1; } if ($a != 1) { echo "<br/><br/><br/>DOCTORS<br/>"; $rs = $db->executeQuery("SELECT * FROM doctor;");
include "../_includes/SSDA_librarydatabase.php"; //SSDA_menubar.php has the menu code for da_catalog, da_catalog_fielder(fielder collection) and 'archive reources' // class for database connections include "../_classes/class.Database.php"; $query = "select title.StudyNum, title.Title FROM title where title.Restricted <> '*' ORDER BY title.StudyNum"; // sql query statement // NOTE: original query did not exclude the Restricted items // $query = "select title.Title, title.StudyNum, shfull.subject, Left(shfull.subject,1) AS firstLetterIndex, count(*) as titlePerSubjectCount FROM (title INNER JOIN shcode ON title.tisort = shcode.tisort) INNER JOIN shfull ON shcode.subjectcode = shfull.subjectcode group by shfull.subject ORDER BY shfull.subject"; // echo "<br>$query<br>"; // class.Database.php is the class to make PDO connections // initialize new db connection instance $db = new Database(); // prepare query $db->prepareQuery($query); // execute query $result = $db->executeQuery(); //$result = $db->resultset(); // execute the query if (!$result) { die("Could not query the database: <br />"); } // else { echo "Successfully queried the database.<br>"; } // for debugging // the index term list $studynumberList = array(); echo "<form action='da_catalog_titleRecord.php' method='put' name='studynumber' target='_self'>"; echo "<select name='studynumber' class='alphaTitleList'>"; $row_index = 0; while ($row = $db->getRow()) { $title = $row['Title']; $tempStudynumber = $row['StudyNum']; // code to insure that the studynumbers sort correctly $numeric_only = preg_replace('/[a-zA-Z]/', '', $tempStudynumber);
$query = $_POST['sql']; } else { $query = "SELECT * FROM " . $_GET['tbl'] . " LIMIT " . $_POST['o'] . "," . $_POST['l']; } if (stristr($query, "limit")) { $use_limit = true; } else { $use_limit = false; } $singleQueries = splitSql($query); $num_queries = count($singleQueries); $total = 0; $tbl_view_rows = ""; for ($j = 0; $j < $num_queries; $j++) { $localTotal = 0; $res = $db->executeQuery($singleQueries[$j]); $phase = "{tablec}"; $tbl_view_cols = ""; $list_colnames = $res->getColumnNames(); $numfields = count($list_colnames); for ($i = 0; $i < $numfields; $i++) { $field = $list_colnames[$i]; eval("\$tbl_view_cols .= \"" . gettemplate("table_view_colbit") . "\";"); } eval("\$tbl_view_rows .= \"" . gettemplate("table_view_start_table") . "\";"); eval("\$tbl_view_rows .= \"" . gettemplate("table_view_rowbit") . "\";"); $phase = "{tablea}"; while ($res->next()) { $tbl_view_cols = ""; $row = $res->getCurrentValues(); for ($i = 0; $i < count($row); $i++) {
// version is too old, must fall back to system functions instead of SQL if (create_database($_POST['new_db'])) { $_GET['show'] = "database_details"; $_GET['db'] = $_POST['new_db']; } } } if (isset($_GET['delete_db'])) { // DB is to be deleted, approach depends on version of API if (isset($_POST['confirm'])) { if ($_POST['confirm'] == "OK") { if (min_version("0.1.2-Beta-02")) { // version is new enough to handle action by SQL $db = new Database(ROOT_DATABASE); $query = "DROP DATABASE " . $_GET['delete_db']; if ($db->executeQuery($query)) { eval("\$gui_message .= \"" . gettemplate("message_db_deleted_sql") . "\";"); } unset($db); } else { // version is too old, must fall back to system functions instead of SQL $file = $DB_DIR . $_GET['delete_db']; $handle = opendir($file); while ($filename = readdir($handle)) { if ($filename != "." && $filename != "..") { unlink($file . "/" . $filename); } } closedir($handle); if (rmdir($DB_DIR . $_GET['delete_db'])) { eval("\$gui_message .= \"" . gettemplate("message_db_deleted") . "\";");
* get parameters are: * collection: name of the pageCollection to update (e.g. 'home') * pageid: id of the page * sort: new sort/sequence number for the page */ include_once dirname(__FILE__) . '/../partials/pageCheck.php'; include_once dirname(__FILE__) . '/../classes/utility.php'; include_once dirname(__FILE__) . '/../classes/service.php'; if ($_SERVER['REQUEST_METHOD'] == "POST") { $collection = Utility::getRequestVariable("collection", ""); $pageid = Utility::getRequestVariable("pageid", ""); $sort = Utility::getRequestVariable("sort", ""); if ($collection == "") { Service::returnError('collection parameter is required.'); } if ($pageid == "") { Service::returnError('pageid parameter is required.'); } if ($sort == "") { Service::returnError('sort parameter is required.'); } if (!$user->hasRole('admin', $tenantID)) { Service::returnError('Access denied.', 403); } $query = "call setPageSortOrderForCollection(" . Database::queryString($collection) . "," . Database::queryNumber($pageid) . "," . Database::queryNumber($sort) . "," . Database::queryNumber($tenantID) . ");"; Database::executeQuery($query); $json = '{"success":true}'; Service::returnJSON($json); } else { Service::returnError('Unsupported HTTP method.'); }
public function findAll() { $db = new Database(); return $db->executeQuery('SELECT * FROM User'); }
/** * Delete a person from a database. * @param $id * @return array|bool */ public function deletePerson($id) { $db = new Database(); $sql = "DELETE FROM " . self::TABLE . " WHERE id=:id"; return $db->executeQuery($sql, false, [':id' => $id]); }
<div class="modalinner"> <form id="frmAddEndorsement" action="service/endorsement.php" method="post"> <p>Add New Endorsement: </p> <input type="hidden" name="type" value="location" /> <input type="hidden" name="locationid" value="<?php echo $location->id; ?> " /> <input type="hidden" name="id" value="0" /> <div class="row"> <span class="label">Endorsed by: </span> <span class="input"> <select name="userid"> <?php $query = "call getEndorsers(" . $tenantID . ")"; $categories = Database::executeQuery($query); if (!$categories) { Utility::errorRedirect('Error retrieving endorsing users: ' . mysql_error()); } else { while ($r = mysqli_fetch_array($categories)) { echo '<option value="' . $r[0] . '">' . $r[1] . '</option>'; } } ?> </select> </span> </div> <div class="row"> <span class="label">Date:</span> <span class="date_input"><input name="date" id="date" type="text" value="<?php echo date('Y-m-d H:i:s');
<?php require_once $_SERVER["DOCUMENT_ROOT"] . "/common/includes/classes.inc"; $name = $_REQUEST['name']; $email = $_REQUEST['email']; $comments = $_REQUEST['comments']; $myFile = "testFile.txt"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $name; fwrite($fh, "\n" . $stringData); $stringData = " " . $email; fwrite($fh, $stringData); $stringData = " " . $comments; fwrite($fh, $stringData); fclose($fh); $myFile = "email.txt"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $email; fwrite($fh, "\n" . $stringData); fclose($fh); $db = new Database(); $db->connect(); $query = sprintf("INSERT INTO log_email_signup VALUES('%s', '%s', '%s', NOW())", mysql_real_escape_string($name), mysql_real_escape_string($email), mysql_real_escape_string($comments)); $db->executeQuery($query); $db->closeConnection();
print "<a href=\"?lang=" . $lang . "&char=" . $chars[$i] . "\">" . lang('all') . "</a></td>\n"; } else { print "<a href=\"?lang=" . $lang . "&char=" . $chars[$i] . "\">" . $chars[$i] . "</a></td>\n"; } } ?> </tr> <tr><td colspan="<?php echo strlen($chars); ?> "> <?php // print all addresses which fits to the filter rule $db = new Database("txtdbapi-examples"); if ($char == '*') { $result = $db->executeQuery("SELECT * FROM addressbook ORDER BY familyname"); } else { $result = $db->executeQuery("SELECT * FROM addressbook WHERE familyname LIKE '" . $char . "%' ORDER BY familyname, surname"); } print "<br>\n"; if ($result->getRowCount() == 0) { print "<center><i>" . lang('no-data', $char) . "</i></center><br>"; } else { print "<table border=\"0\" style=\"width: 540px;\">"; $help = 0; while ($result->next()) { if ($help) { print "<tr><td colspan=\"2\"><hr></td></tr>\n"; } print "<tr><td>"; $help = 1;
<?php $db = new Database($_GET['db']); $tbl_list_fields = ""; $gui_message2 = ""; $phase = "{tablea}"; $result = $db->executeQuery("SELECT * FROM " . $_GET['tbl']); $colnames = $result->getColumnNames(); $coltypes = $result->getColumnTypes(); $numf = count($colnames); for ($i = 0; $i < count($colnames); $i++) { $colname = $colnames[$i]; $coltype = $coltypes[$i]; $fieldname = "in_field" . $i; eval("\$tbl_list_fields .= \"" . gettemplate("table_insert_bit") . "\";"); $phase = nextPhase($phase); } eval("dooutput(\"" . gettemplate("table_insert") . "\");");
$epg = $_POST['epg']; $yy = $_GET['yy']; if ($_GET['mm'] < 10) { $mm = '0' . $_GET['mm']; } else { $mm = $_GET['mm']; } if ($_GET['dd'] < 10) { $dd = '0' . $_GET['dd']; } else { $dd = $_GET['dd']; } $time_from = $yy . '-' . $mm . '-' . $dd . ' 00:00:00'; $time_to = $yy . '-' . $mm . '-' . $dd . ' 24:00:00'; $query = "delete from epg where ch_id=" . $_GET['id'] . " and time > '" . $time_from . "' and time < '" . $time_to . "'"; $rs = $db->executeQuery($query); $tmp_epg = preg_split("/\n/", stripslashes(trim($epg))); $date = $yy . '-' . $mm . '-' . $dd; for ($i = 0; $i < count($tmp_epg); $i++) { $epg_line = trim($tmp_epg[$i]); $line_arr = get_line($date, $tmp_epg, $i); if (empty($line_arr)) { continue; } $query = "insert into epg (ch_id, name, time, time_to, duration) values ('" . $_GET['id'] . "', '" . mysql_real_escape_string($line_arr['name']) . "', '" . $line_arr['time'] . "', '" . $line_arr['time_to'] . "', '" . $line_arr['duration'] . "')"; //var_dump($query); $rs = $db->executeQuery($query); } header("Location: add_epg.php?id=" . $_GET['id'] . "&mm=" . $_GET['mm'] . "&dd=" . $_GET['dd'] . "&yy=" . $_GET['yy'] . "&saved=1"); exit; }
</li> <li id="anakoinwseis"> <a href="#">Ανακοινώσεις</a> </li> </ul> </div> <!--div for main page--> <div id="doctor_information_main"> <?php include "./db-api/txt-db-api.php"; $db = new Database("database_EAM"); $e_mail = $_GET['mail']; $result = $db->executeQuery("SELECT onoma,epitheto,nomos,polh,tk,email,eidikothta,dieu8_iatreiou FROM doctor WHERE email='{$e_mail}';"); $result->next(); list($onoma, $epitheto, $nomos, $polh, $tk, $mail, $eidikothta, $dieu8_iatreiou) = $result->getCurrentValues(); echo '<div id="doctor_details"> <p id="p_doctor_details">Παρακάτω εμφανίζονται τα στοιχεία του γιατρού:<br/> κ. ' . $epitheto . ' ' . $onoma . '</p><hr/> <table id="table_details" border="1" cellspacing="0" bordercolor="#666666"> <tr> <th id="result_header_style" colspan="2">Στοιχεία Ιατρού</th> </tr> <tr> <td>Όνομα</td> <td>', $onoma, '</td> </tr> <tr> <td>Επίθετο</td> <td>', $epitheto, '</td>
<input type="submit" value="Αναζήτηση"><br> </fieldset> </form> </div><!--end of search_doctors_form div--> <div id="results_doctors"> <?php include "./db-api/txt-db-api.php"; $db = new Database("database_EAM"); $a = 0; if (sizeof($_POST) != 0) { $nomos = $_POST['nomos']; if ($nomos != "no") { $polh = $_POST['polh']; $eidikothta = $_POST['eidikothta']; $result = $db->executeQuery("SELECT onoma,epitheto,nomos,polh,tk,email,eidikothta,dieu8_iatreiou FROM doctor WHERE nomos='{$nomos}' AND polh='{$polh}' AND eidikothta = '{$eidikothta}';"); if ($result->next()) { $a = 1; $result = $db->executeQuery("SELECT onoma,epitheto,nomos,polh,tk,email,eidikothta,dieu8_iatreiou FROM doctor WHERE nomos='{$nomos}' AND polh='{$polh}' AND eidikothta = '{$eidikothta}';"); } if ($a != 0) { echo '<h3 style="width:200px; margin-left:auto; margin-right:auto;">', "~ΑΠΟΤΕΛΕΣΜΑΤΑ~", '</h3>'; echo '<table cellpadding="4" cellspacing="0" border="1" style="margin-left:auto; margin-right:auto;">'; echo '<tr id="result_header_style"><th>Όνομα</th><th>Επίθετο</th><th>Νομός</th><th>Πόλη</th><th>Ταχυδρομικός κώδικας</th><th>email</th><th>Ειδικότητα</th><th>Διεύθυνση ιατρείου</th><th>Εμφάνιση Αναλυτικής Καρτέλας</th></tr>'; while ($result->next()) { $a = 1; //doctor.php?mail=$username echo '<tr>'; list($onoma, $epitheto, $nomos, $polh, $tk, $mail, $eidikothta, $dieu8_iatreiou) = $result->getCurrentValues(); $output = '<a href=doctor_information.php?mail=' . $mail . '>Πατήστε εδώ</a>'; echo '<td>', $onoma, '</td>';
public function getTenants() { $tenants = array(); if ($this->id > 0) { $query = "call getRolesByUserId(" . Database::queryNumber($this->id) . ");"; $results = Database::executeQuery($query); $i = 0; while ($arr = mysqli_fetch_assoc($results)) { $arr["index"] = $i; $i++; array_push($tenants, $arr); } } return $tenants; }
<?php // txt-db-api library: http://www.c-worker.ch/txtdbapi/index_eng.php require_once "php-txt-db/txt-db-api.php"; require_once "login.php"; require_once "includes/auth.php"; require_once "includes/navigation.php"; // Init global variables $db = new Database("pancoin"); $user = new User($db); if (validate_user($user)) { ?> var myPanCoins = <?php $sql = "SELECT PanCoins FROM Person WHERE PersonID={$user->id}"; $rs = $db->executeQuery($sql); $balance = $rs->getValueByNr(0, 0); echo $balance > 0 ? $balance : 0; ?> ; var div = document.getElementById("myPanCoins"); if (div != null) { div.innerHTML = myPanCoins; } <?php }
<?php $_POST['sql'] = stripslashes($_POST['sql']); if (strtoupper(substr($_POST['sql'], 0, 6)) == "SELECT") { include 'table_view.php'; } else { $db = new Database($_GET['db']); $query = $_POST['sql']; $singleQueries = splitSql($query); $num_queries = count($singleQueries); for ($i = 0; $i < $num_queries; $i++) { $query = $singleQueries[$i]; $result = $db->executeQuery($query); if ($result) { eval("\$gui_message2 .= \"" . gettemplate("message_sql_execute_success") . "\";"); } else { eval("\$gui_message2 .= \"" . gettemplate("message_sql_execute_failure") . "\";"); } } unset($db); include "{$_POST['referto']}"; }
public function linkMediaToLocation($mediaid, $locationid) { $query = "call AddLocationMedia(" . Database::queryNumber($mediaid) . "," . Database::queryNumber($locationid) . "," . Database::queryNumber($this->tenantid) . "," . Database::queryNumber($this->userid) . ");"; Database::executeQuery($query); }