Cod: Selectaţi tot
--
-- Table structure for table `tabel`
--
CREATE TABLE IF NOT EXISTS `tabel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Nume_Referent` text,
`Telefon_Referent` text,
`Data_Si_Ora_Rezervarii` text,
`Numar_De_Locuri_Rezervate` text,
`De_Unde_Vine_Clientul` text,
`Data_Plecarii` text,
`Locul_Plecarii` text,
`Locul_Sosirii` text,
`Ora_Decolare_Avion` text,
`Ora_Aterizare_Avion` text,
`Nume_Client` text,
`Telefon_Client` text,
`Email_Client` text,
`Observatii_Client` text,
`Metoda_De_Plata` text,
`Modalitate_De_Plata` text,
`Rest_De_Plata` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `Numar_De_Locuri_Rezervate` (`Numar_De_Locuri_Rezervate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
--
-- Dumping data for table `tabel`
--
INSERT INTO `EMH_rezervari` (`id`, `Nume_Referent`, `Telefon_Referent`, `Data_Si_Ora_Rezervarii`, `Numar_De_Locuri_Rezervate`, `De_Unde_Vine_Clientul`, `Data_Plecarii`, `Locul_Plecarii`, `Locul_Sosirii`, `Ora_Decolare_Avion`, `Ora_Aterizare_Avion`, `Nume_Client`, `Telefon_Client`, `Email_Client`, `Observatii_Client`, `Metoda_De_Plata`, `Modalitate_De_Plata`, `Rest_De_Plata`) VALUES
(62, '1', '075xxxxxxx', '09/09/14 16:11:32', '1', NULL, '09/09/2014', 'Tulcea Ora 22:00', 'Otopeni Ora 04:00', '10:00', NULL, 'cucu bau', '0756565656', 'fara@email.com', '', 'Sofer', 'Nimic', '70'),
(59, '2', '075xxxxxxx', '09/09/14 15:54:32', '1', NULL, '09/09/2014', 'Tulcea Ora 22:00', 'Otopeni Ora 04:00', '10:00', NULL, 'cucu bau', '0756565656', 'fara@email.com', '', 'Agentie', 'Taxa Rezervare', '60'),
(60, '3', '075xxxxxxx', '09/09/14 15:54:50', '1', NULL, '10/09/2014', 'Babadag Ora 22:00', 'Otopeni Ora 04:00', '10:00', NULL, 'cucu bau', '0756565656', 'fara@email.com', '', 'Sofer', 'Nimic', '100'),
(61, '4', '075xxxxxxx', '09/09/14 15:59:46', '1', NULL, '09/09/2014', 'Constanta Ora 00:30', 'Otopeni Ora 04:00', '10:00', NULL, 'cucu bau', '0756565656', 'fara@email.com', '', 'Sofer', 'Nimic', '70');
si urmatorul index.php
Cod: Selectaţi tot
<head>
<link rel="stylesheet" type="text/css" href="tcal.css" />
<script type="text/javascript" src="tcal.js"></script>
</head>
<form action="index.php" method="get">
Data Plecarii : <input type="text" name="d1" class="tcal" value="" /><input type="submit" value="Cautare">
</form>
<table id="resultTable" data-responsive="table" style="text-align: left; width: 469px;" border="1" cellspacing="0" cellpadding="4">
<thead>
<tr>
<th style="text-align: center" valign="middle"> Data Plecarii</th>
<th style="text-align: center" valign="middle"> Locul Plecarii </th>
<th style="text-align: center" valign="middle"> Nr De Locuri Rezervate </th>
</tr>
</thead>
<tbody>
<?php
include('connect.php');
if (isset($_GET["d1"])) { $d1 = $_GET["d1"]; } else { $d1=0; };
if (isset($_GET["d1"])) { $d1 = $_GET["d1"]; } else { $d1=0; };
$result = $db->prepare("SELECT * FROM EMH_rezervari WHERE Data_Plecarii BETWEEN :a AND :b");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d1);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
<tr class="record">
<td style="text-align: center" valign="middle"><?php echo $row['Data_Plecarii']; ?></td>
<td style="text-align: center" valign="middle"><?php echo $row['Locul_Plecarii']; ?></td>
<td style="text-align: center" valign="middle"><?php echo $row['Numar_De_Locuri_Rezervate']; ?></td>
</tr>
<?php
}
?>
</tbody>
Intrebarea mea este cum pot afisa grupat in funtie de data Locul_Plecarii si Suma Numar_De_Locuri_rezervate
acum se afiseaza asa :
iar eu doresc sa se afiseze asa
