Example #1
0
<?php

include 'access.php';
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'GroupDAO.class.php';
$response = array('status' => '1', 'message' => '');
$isAjax = isAjaxRequest();
$action = from_post_or_get('action', '');
if (!isset($action)) {
    die('accio no informada');
    exit;
}
$id = -1;
if ($action !== 'new' && $action !== 'update' && $action !== 'delete') {
    die('accio incorrecta: ' . $action);
}
switch ($action) {
    case 'delete':
        $id = $_GET['id'] or die('id de grup no informat');
        break;
    case 'update':
        $id = $_POST['id'] or die('id de grup no informat');
    case 'new':
        $name = $_POST['name'] or die('nom de grup no informat');
        $age = $_POST['age'] or die('edat no informada');
        $date_start = $_POST['date_start'] or die('data inici informada');
        $date_end = $_POST['date_end'] or die('data fi informada');
        $location = $_POST['location'] or die('ubicaciĆ³ no informada');
Example #2
0
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'GroupPaginator.class.php';
$c = new Connection();
$conn = $c->getConnection();
/*$limit      = ( isset( $_GET['limit'] ) ) ? $_GET['limit'] : 10;
$page       = ( isset( $_GET['page'] ) ) ? $_GET['page'] : 1;
$links      = ( isset( $_GET['links'] ) ) ? $_GET['links'] : 7;
$expanded   = ( isset( $_GET['expanded'] ) ) ? $_GET['expanded'] : 'on';*/
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_date = from_post_or_get('search_date', '');
$query = "SELECT DISTINCT A.id, A.name, A.age, A.date_start, A.date_end, A.location, A.observations, A.comments, A.timestamp FROM wp_musicteach_group A ";
$conn->set_charset("utf8");
$groupPaginator = new GroupPaginator($conn, $query, $search_date);
$results = $groupPaginator->getData($limit, $page);
include 'head.php';
?>

<h1 class="text-center">Grups</h1>

<h2>Cerca</h2>
<div>
  <form action="group_list.php" class="search" method="get">
    <div class="row">
      <div class="col-xs-2">
        <div>