/**
* @param Database $db
* @param array $runRows: one or more rows from the `runs` table.
* @return array with properties 'runs' and 'userAgents'
*/
public static function getDataFromRunRows(Database $db, $runRows)
{
$userAgentIDs = array();
$runs = array();
foreach ($runRows as $runRow) {
$runInfo = array('id' => $runRow->id, 'name' => $runRow->name, 'url' => $runRow->url);
$runUaRuns = array();
// Get list of useragents that this run is scheduled for
$runUaRows = $db->getRows(str_queryf('SELECT
status,
useragent_id,
results_id
FROM
run_useragent
WHERE run_useragent.run_id = %u;', $runRow->id));
if ($runUaRows) {
foreach ($runUaRows as $runUaRow) {
// Add UA ID to the list. After we've collected
// all the UA IDs we'll perform one query for all of them
// to gather the info from the useragents table
$userAgentIDs[] = $runUaRow->useragent_id;
if (!$runUaRow->results_id) {
$runUaRuns[$runUaRow->useragent_id] = array('runStatus' => 'new');
} else {
$runresultsRow = $db->getRow(str_queryf('SELECT
client_id,
status,
total,
fail,
error
FROM runresults
WHERE id = %u;', $runUaRow->results_id));
if (!$runresultsRow) {
$this->setError('data-corrupt');
return;
}
$runUaRuns[$runUaRow->useragent_id] = array('useragentID' => $runUaRow->useragent_id, 'clientID' => $runresultsRow->client_id, 'failedTests' => $runresultsRow->fail, 'totalTests' => $runresultsRow->total, 'errors' => $runresultsRow->error, 'runStatus' => self::getRunresultsStatus($runresultsRow), 'runResultsUrl' => swarmpath('result/' . $runUaRow->results_id), 'runResultsLabel' => $runresultsRow->status != ResultAction::$STATE_FINISHED ? '' : ($runresultsRow->error > 0 ? $runresultsRow->error : ($runresultsRow->fail > 0 ? $runresultsRow->fail : $runresultsRow->total)));
}
}
natcaseksort($runUaRuns);
$runs[] = array('info' => $runInfo, 'uaRuns' => $runUaRuns);
}
}
// Get information for all encounted useragents
$swarmUaIndex = BrowserInfo::getSwarmUAIndex();
$userAgents = array();
foreach ($userAgentIDs as $userAgentID) {
if (!isset($swarmUaIndex->{$userAgentID})) {
throw new SwarmException("Job {$jobID} has runs for unknown brower ID `{$userAgentID}`.");
} else {
$userAgents[$userAgentID] = (array) $swarmUaIndex->{$userAgentID};
}
}
natcaseksort($userAgents);
return array('runs' => $runs, 'userAgents' => $userAgents);
}
<?php
require_once 'Database.php';
function die_r($value)
{
foreach ($value as $c) {
echo "<tr>";
echo "<td>" . $c["id"] . "</td>";
echo "<td>" . $c["titulo"] . "</td>";
echo "<td>" . $c["tamanho"] . "</td>";
echo "<td>" . $c["preco"] . "</td>";
echo "<td>\n <a href='alterar-colchao.php?id={$c['id']}&titulo={$c['titulo']}&tamanho={$c['tamanho']}&preco={$c['preco']}'><img src='img/icons/editar.png'></a>\n <a onClick='deleta(" . $c['id'] . ")'><img src='img/icons/delete.png'</a>\n </td>";
echo "</tr>";
}
}
$db = new Database();
$getRows = $db->getRows("SELECT * FROM colchoes");
die_r($getRows);
?>
<!-- Confirmação da exclusão -->
<script type="text/javascript">
function deleta(id) {
var apagar = confirm('Você deseja excluir esse colchão?');
if (apagar) {location.href = 'core/delete-colchao.php?id=' + id;}
}
</script>
<!-- end -->
$sql .= " AND date BETWEEN '" . escape(Input::get('fromDate')) . "' AND '" . escape(Input::get('toDate')) . "'";
}
if (!empty(Input::get('ip_address'))) {
$sql .= " AND ip_address LIKE '" . escape(Input::get('ip_address')) . "'";
}
if (!empty(Input::get('websiteUrl'))) {
$sql .= " AND url LIKE '" . escape(Input::get('websiteUrl')) . "'";
}
if (!empty(Input::get('userAgent'))) {
$sql .= " AND user_agent LIKE '" . escape(Input::get('userAgent')) . "'";
}
if (!empty(Input::get('os'))) {
$sql .= " AND os LIKE '" . escape(Input::get('os')) . "'";
}
}
$result = $db->getRows($sql);
?>
<main class="mainContainer">
<form action="" method="post" class="sort">
<legend>מיין תוצאות</legend>
<fieldset>
<label>מתאריך</label>
<input type="text" name="fromDate" value="<?php
echo Input::get('fromDate');
?>
">
<label>עד</label>
<input type="text" name="toDate" value="<?php
echo Input::get('toDate');
?>
">
<?php
include_once 'core/init.php';
$db = new Database();
!isset($GLOBALS['config']['db']['dbhost']) ? Redirect::to('install.php') : '';
if (Session::exists('loggedUser') === TRUE) {
Redirect::to('index.php');
}
if (Input::exists()) {
if (Token::check(Input::get('hash'))) {
$username = escape(Input::get('username'));
$password = escape(Input::get('password'));
$result = $db->getRows('SELECT * FROM users WHERE username = ? LIMIT 1', [$username]);
$selectedUser = isset($result[0]) ? $result[0] : NULL;
if ($selectedUser['password'] == Hash::make($password, $selectedUser['salt'])) {
Session::put('loggedUser', Input::get('hash'));
Redirect::to('index.php');
}
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>התחבר למערכת</title>
<style>
body{
direction: rtl;
width: 300px;
<?php
require_once 'Database.php';
function die_r($value)
{
foreach ($value as $u) {
echo "<tr>";
echo "<td>" . $u["id"] . "</td>";
echo "<td>" . $u["usuario"] . "</td>";
echo "<td>" . $u["email"] . "</td>";
echo "<td>" . $u["senha"] . "</td>";
echo "<td>\n <a href='alterar-user.php?id={$u['id']}&user={$u['usuario']}&email={$u['email']}&senha={$u['senha']}'><img src='img/icons/editar.png'></a>\n <a onClick='deleta(" . $u['id'] . ")'><img src='img/icons/delete.png'</a>\n </td>";
echo "</tr>";
}
}
$db = new Database();
$getRows = $db->getRows("SELECT * FROM admin");
die_r($getRows);
?>
<!-- Confirmação da exclusão -->
<script type="text/javascript">
function deleta(id) {
var apagar = confirm('Você deseja excluir esse usuário?');
if (apagar) {location.href = 'core/delete-registered.php?id=' + id;}
}
</script>
<!-- end -->
<?php
include '../../functions.php';
$db = new Database('theproject');
$from = 'Item';
$where = array(array($db::BETWEEN => array('StoreID' => array('0', '1'))));
$result = $db->getRows($from, $where, array(), true);
echo '<hr>';
foreach ($result as $index => $row) {
echo $index . ' ' . $row['id'] . '<br>';
}
echo '<br/>';
echo $db->insert('Player', array('a' => 'b', 'c' => 'd'));
<?php
require_once 'Database.php';
function die_r($value)
{
foreach ($value as $m) {
echo "\n <div class='msg'>\n <div class='msg-title'>\n <h4> {$m['nome']} </h4>\n </div>\n\n <div class='msg-body'>\n <p> {$m['mensagem']} </p>\n </div>\n\n <div class='msg-info'>\n <p>\n Nome: {$m['nome']} <br>\n E-mail: {$m['email']}<br>\n Telefone: {$m['telefone']}\n </p>\n </div>\n\n <div class='msg-footer'>\n <h6> {$m['data']} </h6>\n </div>\n </div>";
}
}
$db = new Database();
$getRows = $db->getRows("SELECT * FROM mensagens");
die_r($getRows);
