Parkplatz verwalten

<?php include(“data/db_connect.php”);mysql_query(“SET NAMES ‘utf8′”) or die(mysql_error());mysql_query(“SET CHARACTER SET ‘utf8′”) or die(mysql_error()); setlocale(‘LC_ALL’,’de_DE’);$userid =& JFactory::getUser();$user =& JFactory::getUser();?>

<?php $query = “SELECT distinct startdate, nfxbg_icagenda_events.ID as EventID FROM `nfxbg_icagenda_events` left JOIN nfxbg_icagenda_registration ON nfxbg_icagenda_events.ID = nfxbg_icagenda_registration.eventid WHERE catid = 5 and nfxbg_icagenda_events.state = 1 and startdate >= (select sysdate()) order by startdate”;

$res = mysql_query($query); ?>

Hallo <?php echo $user->name;

echo “<br /><b>Vorsicht!!!!</b> Diese Formular löscht einen ausgewählten Parkplatz sofort! Ohne nachfragen!!!”;

echo “<p></p>”;

echo “<form action=’parkplatz-verwalten.html’ method=’post’>”;

echo “<b>Bitte eine Datum auswählen: </b>”;

echo “<br />”;

echo “<select name=\”Parkplatz\”>”;

while($row = mysql_fetch_array($res)){

echo “<option value=\””.$row[‘EventID’].”\”>”.date(“d.m.Y”, strtotime($row[‘startdate’])).”</option>”;

}

echo “</select> “;

echo “<input type=\”submit\” value=\”anzeigen\” />”;

echo “<br />”;

$id = $_POST[‘Parkplatz’];

$query1 = “SELECT title, startdate, nfxbg_icagenda_events.id as ID, nfxbg_icagenda_registration.name as name, nfxbg_icagenda_registration.id as RegID FROM `nfxbg_icagenda_events` left JOIN nfxbg_icagenda_registration ON nfxbg_icagenda_events.ID = nfxbg_icagenda_registration.eventid WHERE nfxbg_icagenda_registration.eventid = ‘$id'”;

$res = mysql_query($query1);?>

<?php

//ausgabe Array in tabelle

echo “<table>”;

echo “<tr style=’font-weigth: bold;’>”;

echo “<th width=\”33%\”>Name</th>”;

echo “<th width=\”33%\”>Datum</th>”;

echo “<th width=\”33%\”>Löschen</th>”;

echo “<tr>”;

while ($row = mysql_fetch_array($res))

{

echo “<tr>”;

echo “<td>”. $row[‘name’] .”</td>”;$_POST[‘name’];

echo “<td>”.date(“d.m.Y”, strtotime($row[‘startdate’])).”</td>”;

echo “<td><a href=\”parkplatz-verwalten/geloescht.html?RegId=”.$row[‘RegID’].”\”>diesen Parkplatz löschen</a></td>”;$_POST[“RegId”];

echo “</tr>”;

}

echo “</form>”;

echo “</table>”;

echo “<p></p>”;

/*$loesch = “DELETE FROM nfxbg_icagenda_registration WHERE eventid = ‘$id'”;*/

$lo= mysql_query($loesch);

?>

= (select sysdate()) order by startdate”;
$res->setQuery($query);
echo ‘

Hallo ‘ . $user->name . ‘,
‘;
?>

Vorsicht!!!! Dieses Formular löscht einen ausgewählten Parkplatz sofort! Ohne nachfragen!!!