<?php
/**
* Created by PhpStorm.
* User: geol
* Date: 6/14/15
* Time: 4:11 AM
*/
error_reporting(E_ALL);
ini_set('display_errors', true);
define('CLASS_DIR', 'classes/');
set_include_path(get_include_path() . PATH_SEPARATOR . CLASS_DIR);
spl_autoload_register();
$connect = new DB('clodo', 'user', 'password');
$db = $connect->db;
$clients = new Clients($db);
if ($_GET['action'] == 'list') {
$filter = array('name' => filter_input(INPUT_GET, 'name', FILTER_SANITIZE_MAGIC_QUOTES), 'ballance' => filter_input(INPUT_GET, 'name', FILTER_SANITIZE_NUMBER_FLOAT), 'hasPhone' => filter_input(INPUT_GET, 'hasPhone', FILTER_VALIDATE_BOOLEAN), 'registerFrom' => filter_input(INPUT_GET, 'registerFrom', FILTER_SANITIZE_MAGIC_QUOTES), 'registerTo' => filter_input(INPUT_GET, 'registerTo', FILTER_SANITIZE_MAGIC_QUOTES), 'from' => filter_input(INPUT_GET, 'from', FILTER_SANITIZE_NUMBER_FLOAT), 'to' => filter_input(INPUT_GET, 'to', FILTER_SANITIZE_NUMBER_FLOAT));
$json = json_encode($clients->getClientList($filter));
print $json;
}
if ($_GET['action'] == 'requestPhone') {
return $clients->requestPhone(filter_input(INPUT_GET, 'email', FILTER_SANITIZE_EMAIL));
}
<?php
$param = !empty($_GET['param']) ? $_GET['param'] : NULL;
$value = !empty($_GET['value']) ? $_GET['value'] : NULL;
$clients = new Clients();
if (is_null($param) || is_null($value)) {
$list = $clients->getClientList($pswd['user']);
} else {
$list = $clients->getClientListFilter($pswd['user'], $param, $value);
}
print "<h1>Klienci</h1><table><form method='GET' action='index.php'><tr><td><input type='checkbox' name='location' value='6' checked /></td><td><select name='param' /><option>Klient</option><option>eMail</option><option>Telefon</option><option>Typ</option></td><td><input type='text' name='value'></td><td><input type='submit' value='Filtruj'></td></tr></form></table><br><table><tr><th>Użytkownik:</th><th>Typ:</th><th>eMail</th><th>Telefon</th><th>Aktywny:</th></tr>";
if (!empty($list)) {
foreach ($list as $row) {
print "<tr><td>{$row['user']}</td><td>{$row['type']}</td><td>{$row['mail']}</td><td>{$row['tel']}</td><td>{$row['active']}</td><td><a href='index.php?location=11&id={$row['id']}'>Edytuj</a></td></tr>";
}
}
