function findReplies($a) { $commentsReplies = Db::queryAll('SELECT * FROM comments_table WHERE item_id=? && reply_to=?', $_GET['item'], $a); for ($i = 0; $i < count($commentsReplies); $i++) { $date = date('d.m Y', strtotime($commentsReplies[$i]['comment_date'])); echo ' <li class="comment"> <figure> <div class="image"> <img alt="" src="' . $commentsReplies[$i]['image'] . '"> </div> </figure> <div class="comment-wrapper"> <div class="name pull-left">' . $commentsReplies[$i]['author_name'] . '</div> <span class="date pull-right"><span class="fa fa-calendar"></span>' . $date . '</span> <div class="rating rating-individual" data-score="' . $commentsReplies[$i]['rating'] . '"></div> <p>' . $commentsReplies[$i]['comment_content'] . '</p> <a href="#" class="reply"><span class="fa fa-reply"></span>Reply</a> <hr> <ul class="comment-reply">'; findReplies($commentsReplies[$i]['comment_id']); echo '</ul> </div> </li> '; } }
private function checkBrute($login) { $timeOfAttempt = date('Y-m-d H:i:s', time() - BRUTEFORCE_LOCKED_TIME); $attempts = Db::queryAll('SELECT `login`, `timestamp` FROM `login_attempts` WHERE `login` = ? && `timestamp` > ? && `success` = 0', [$login, $timeOfAttempt]); if (BRUTEFORCE_NUMBER_OF_ATTEMPTS < count($attempts)) { return true; } return false; }
public function getMembers($adminId, $lang) { $placesIds = $this->returnAdminPlacesIds($adminId); $members = []; foreach ($placesIds as $placeID) { $tariffMembers = Db::queryAll('SELECT `id_user`,`first_name`,`last_name`,`telephone`,`active`,`email`,`tariffCZE`,`name`,`places`.`id` AS `id_of_place` FROM `users` JOIN `tariffs` ON `user_tariff` = `id_tariff` JOIN `places` ON `tariffs`.`place_id` = `places`.`id` WHERE `place_id` = ? ORDER BY `active` DESC, `invoicing_start_date` ASC', [$placeID]); //for equvivalent position between members foreach ($tariffMembers as $tm) { $members[] = $tm; } } //add first payment date to each member foreach ($members as &$m) { $m['firstPaymentDate'] = $this->getFirstPaymentDate($m['id_user'], $lang); $m['paymentFlag'] = $this->getPaymentFlag($m['id_user']); } return $members; }
<?php if (isset($_POST['sorting'])) { $includePath = ''; include_once 'connect_db.php'; $sorting = Db::queryAll('SELECT sorting_option, sorting_option_title FROM sorting_options_table'); $querySorting = $_GET; $querySorting['sort_by'] = $_POST['sorting']; header('Location: index.php?' . http_build_query($querySorting)); } else { $sorting = Db::queryAll('SELECT sorting_option, sorting_option_title FROM sorting_options_table'); } ?> <form role="form" id="form-sorting" method="post" action=""> <div class="form-group"> <select name="sorting" id="item-sorting"> <?php for ($i = 0; $i < count($sorting); $i++) { ?> <?php if (isset($_GET['sort_by'])) { ?> <?php if ($_GET['sort_by'] == $sorting[$i]['sorting_option']) { ?> <option value="<?php echo $sorting[$i]['sorting_option']; ?> "> <?php echo $sorting[$i]['sorting_option_title']; ?>
<?php $item = Db::queryAll('SELECT item_id, title, city, price, image FROM items_table ORDER BY date_created DESC LIMIT ?', $config['footer_items_number']); $footerLinks = Db::queryAll('SELECT url, title FROM footer_links_table'); ?> <!-- Page Footer --> <footer id="page-footer"> <div class="inner"> <section id="footer-main"> <div class="container"> <div class="row"> <div class="col-md-3 col-sm-3"> <article> <h3>About Us</h3> <p><?php echo $config['about_us']; ?> </p> <!--<hr>--> <!--<a href="#" class="link-arrow">Read More</a>--> </article> </div><!-- /.col-sm-3 --> <div class="col-md-3 col-sm-3"> <article> <h3>Recent Properties</h3> <?php for ($i = 0; $i < count($item); $i++) { ?> <?php if (!empty($item)) { ?>
private function getPaymentData($paymentId) { $payment = Db::queryOne('SELECT `id_payer`,`email`,`priceCZK`,`invoice_fakturoid_number` FROM `payments` JOIN `users` ON `users`.`id_user` = `payments`.`id_payer` JOIN `tariffs` ON `users`.`user_tariff` = `tariffs`.`id_tariff` WHERE `id_payment` = ?', [$paymentId]); //add sum of all extras $extras = Db::queryAll('SELECT `priceCZK` FROM `extras` WHERE `payment_id` = ?', [$paymentId]); $extrasSum = 0; foreach ($extras as $e) { $extrasSum += $e['priceCZK']; } $payment['priceCZK'] += $extrasSum; return $payment; }
<?php require './init.php'; $set_id = intval($_GET['id']); $rows = Db::queryAll('SELECT * FROM key_to_values WHERE set_id=?', $set_id); if (empty($rows)) { header('Location: ../index.php'); exit; } $array_to_encode = []; foreach ($rows as $keyvaluepair) { $array_to_encode[$keyvaluepair['key']] = json_decode($keyvaluepair['values']); } echo json_encode($array_to_encode);
?> "> <select name="district_id" id="district"> <?php if (isset($_GET['district_id'])) { ?> <option value="<?php echo $_GET['district_id']; ?> "><?php echo Db::querySingle('SELECT district_title FROM search_districts_table WHERE district_id=?', $_GET['district_id']); ?> </option> <option value="">- District -</option> <?php $districts = Db::queryAll('SELECT * FROM search_districts_table WHERE parent=?', $_GET['city_id']); ?> <?php for ($i = 0; $i < count($districts); $i++) { ?> <?php if ($districts[$i]['district_id'] != $_GET['district_id']) { ?> <option value="<?php echo $districts[$i]['district_id']; ?> "><?php echo $districts[$i]['district_title']; ?> </option> <?php
><li><?php echo $set['set_name']; ?> </li></a> <?php } ?> </ul> </section> <section class="outline"> <div class="heading"> <h1>memorize the outline</h1> </div> <ul> <?php $set_names = Db::queryAll("SELECT * FROM outlines"); foreach ($set_names as $set) { ?> <a class='set-tile' href=<?php echo "'outline.php?id=" . urlencode($set['id']) . "'"; ?> ><li><?php echo $set['name']; ?> </li></a> <?php } ?> </ul> </section> <div class="subheading">
<?php $item = Db::queryAll('SELECT item_id, title, city, price, image FROM items_table ORDER BY date_created DESC LIMIT 3'); ?> <!-- sidebar --> <div class="col-md-3 col-sm-3"> <section id="sidebar"> <aside id="edit-search"> <header><h3>Search Properties</h3></header> <?php include_once $includePath . 'views/search_form.php'; ?> </aside><!-- /#edit-search --> <aside id="recent-properties"> <header><h3>Recent Properties</h3></header> <?php for ($i = 0; $i < $config['sidebar_items_number']; $i++) { ?> <?php if ($item) { ?> <?php include $includePath . 'views/single_item_small.php'; ?> <?php } ?> <?php } ?> </aside><!-- /#featured-properties -->
public function getLastAttempts($numberOfAtetmpts) { $attempts = Db::queryAll('SELECT `id`, `uid_key` FROM `lock_attempts` ORDER BY `timestamp` DESC LIMIT ?', [$numberOfAtetmpts]); return $attempts; }
public static function getAll() { $db = new Db(); $query = "SELECT * FROM photos"; return $db->queryAll($query); }
public function getExpiredPayments($toleranceDays) { $dbResults = Db::queryAll('SELECT `price_CZK`, `email`, `id_user` FROM `payments` JOIN `users` ON `users`.`id_user` = `payments`.`id_payer` WHERE `status` != (? || ?)', ['confirmed', 'received']); $result = []; foreach ($dbResults as $r) { $result[] = ['id_user' => $r['id_user'], 'email' => $r['email'], 'price_CZK' => $r['price_CZK']]; } return $result; }
public function getBlankExtras($id_user) { return Db::queryAll('SELECT `id_extra`,`description`,`priceCZK` FROM `extras` WHERE `blank_user_id` = ? AND `payment_id` IS NULL', [$id_user]); }
for ($c = 0; $c < count($tempCountry); $c++) { Db::query('DELETE FROM search_countries_table WHERE country_id=?', $tempCountry[$c]['country_id']); $tempCity = Db::queryAll('SELECT * FROM search_cities_table WHERE parent=?', $tempCountry[$c]['country_id']); for ($ct = 0; $ct < count($tempCity); $ct++) { Db::query('DELETE FROM search_cities_table WHERE city_id=?', $tempCity[$ct]['city_id']); $tempDistrict = Db::queryAll('SELECT * FROM search_districts_table WHERE parent=?', $tempCity[$ct]['city_id']); for ($d = 0; $d < count($tempDistrict); $d++) { Db::query('DELETE FROM search_districts_table WHERE district_id=?', $tempDistrict[$d]['district_id']); } } } } elseif ($_POST['itemType'] == 'country') { Db::query('DELETE FROM search_countries_table WHERE country_id=?', $_POST['id']); $tempCity = Db::queryAll('SELECT * FROM search_cities_table WHERE parent=?', $_POST['id']); for ($ct = 0; $ct < count($tempCity); $ct++) { Db::query('DELETE FROM search_cities_table WHERE city_id=?', $tempCity[$ct]['city_id']); $tempDistrict = Db::queryAll('SELECT * FROM search_districts_table WHERE parent=?', $tempCity[$ct]['city_id']); for ($d = 0; $d < count($tempDistrict); $d++) { Db::query('DELETE FROM search_districts_table WHERE district_id=?', $tempDistrict[$d]['district_id']); } } } elseif ($_POST['itemType'] == 'city') { Db::query('DELETE FROM search_cities_table WHERE city_id=?', $_POST['id']); $tempDistrict = Db::queryAll('SELECT * FROM search_districts_table WHERE parent=?', $_POST['id']); for ($d = 0; $d < count($tempDistrict); $d++) { Db::query('DELETE FROM search_districts_table WHERE district_id=?', $tempDistrict[$d]['district_id']); } } elseif ($_POST['itemType'] == 'district') { Db::query('DELETE FROM search_districts_table WHERE district_id=?', $_POST['id']); } }
<?php $includePath = ''; include_once 'Db.php'; include_once 'connect_db.php'; if ($_POST['action'] == 'find_persons') { $person = Db::queryAll('SELECT person_name, person_id, account_type, assigned_company FROM persons_table WHERE account_type=? AND assigned_company=? ORDER BY person_name', 'agent', $_POST['company_id']); } ?> <select name="assigned_person" id="assigned_person" class="selectpicker"> <option value="">- Select Agent -</option> <?php for ($i = 0; $i < count($person); $i++) { ?> <option value="<?php echo $person[$i]['person_id']; ?> "><?php echo $person[$i]['person_name']; ?> </option> <?php } ?> </select>
$tempCountryVar = -1; $tempCityVar = -1; $tempDistrictVar = -1; for ($s = 0; $s < count($_POST['state_title']); $s++) { // echo '<br><br>'; // echo $searchStates[$s]['state_title'] . ' '; // echo '<br>'; Db::query('UPDATE search_states_table SET state_title=? WHERE state_id=?', $_POST['state_title'][$s], $searchStates[$s]['state_id']); $searchCountries = Db::queryAll('SELECT * FROM search_countries_table WHERE parent=?', $searchStates[$s]['state_id']); for ($c = 0; $c < count($searchCountries); $c++) { $tempCountryVar++; // echo '<br>'; // echo '- ' . $searchCountries[$c]['country_title'] . ' ' . $searchCountries[$c]['country_id'] . ' / '. $_POST['country_title'][$tempCountryVar]; // echo '<br>'; Db::query('UPDATE search_countries_table SET country_title=? WHERE country_id=?', $_POST['country_title'][$tempCountryVar], $searchCountries[$c]['country_id']); $searchCities = Db::queryAll('SELECT * FROM search_cities_table WHERE parent=?', $searchCountries[$c]['country_id']); for ($ct = 0; $ct < count($searchCities); $ct++) { // echo '--- ' . $searchCities[$ct]['city_title'] . ' '; // echo '<br>'; $tempCityVar++; Db::query('UPDATE search_cities_table SET city_title=? WHERE city_id=?', $_POST['city_title'][$tempCityVar], $searchCities[$ct]['city_id']); $searchDistricts = Db::queryAll('SELECT * FROM search_districts_table WHERE parent=?', $searchCities[$ct]['city_id']); for ($d = 0; $d < count($searchDistricts); $d++) { // echo '------- ' . $searchDistricts[$d]['district_title'] . ' '; // echo '<br>'; $tempDistrictVar++; Db::query('UPDATE search_districts_table SET district_title=? WHERE district_id=?', $_POST['district_title'][$tempDistrictVar], $searchDistricts[$d]['district_id']); } } } }
<?php require './init.php'; $outline_id = intval($_GET['id']); $rows = Db::queryAll('SELECT * FROM outline_texts WHERE outline_id=?', $outline_id); if (empty($rows)) { header('Location: ../index.php'); exit; } //do stuff $array_to_encode = []; foreach ($rows as $outline_text) { $array_to_encode[$outline_text['parent_id']] = $outline_text['text']; } echo json_encode($array_to_encode);
public function returnTariffsData($lang) { if ($lang == 'cs') { return Db::queryAll('SELECT `id_tariff`, `tariffCZE`, `priceCZK`, `name` FROM `tariffs` JOIN places ON places.id = tariffs.place_id', []); } if ($lang == 'en') { return Db::queryAll('SELECT `id_tariff`, `tariffENG`, `priceCZK`, `name` FROM `tariffs` JOIN places ON places.id = tariffs.place_id', []); } return false; }
</li></a> <?php } ?> </ul> <div class="subheading"> <h2>create your own set</h2> <a href="set.php?add_set"> <span class="plus-set"></span> </a> </div> <?php } elseif (!empty($_GET['view_id'])) { $set_id = $_GET['view_id']; $set = Db::queryOne("SELECT * FROM set_names WHERE id=?", $set_id); $pairs = Db::queryAll("SELECT * FROM key_to_values WHERE set_id=?", $set_id); ?> <div class='heading'> <h1><?php echo $set['set_name']; ?> </h1> </div> <table id='pair-table'> <thead> <tr> <th>Key</th> <th>Values</th> </tr> </thead> <tbody>
public static function getAll() { $db = new Db(); $query = "SELECT * FROM " . static::$table; return $db->queryAll($query, static::$class); }