119 lines
3.4 KiB
PHP
Executable File
119 lines
3.4 KiB
PHP
Executable File
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
<html xmlns="http://www.w3.org/1999/xhtml">
|
||
<head>
|
||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
<title>Sternwarte Welzheim</title>
|
||
<!--[if IE 5]>
|
||
<link href="css/ie5.css" rel="stylesheet" type="text/css" />
|
||
<![endif]--><!--[if IE]>
|
||
<style type="text/css">
|
||
<link href="css/ie.css" rel="stylesheet" type="text/css" />
|
||
</style>
|
||
<![endif]-->
|
||
<link href="../css/sternwarte1.css" rel="stylesheet" type="text/css" />
|
||
</head>
|
||
|
||
<body class="thrColFixHdr">
|
||
|
||
<div id="container">
|
||
<div id="header"><img src="../bilder/header1.jpg" width="960" height="150" alt="Sternwarte Welzheim"/><!-- end #header --></div>
|
||
<?php include '../navi.php'; ?>
|
||
<div id="sidebar2">
|
||
|
||
|
||
<h3>Aktuell</h3>
|
||
<p class="textklein90"><strong>Sternwarte Welzheim –<br />
|
||
Das Weltall erleben!</strong><br />
|
||
<span class="textklein">Ausstellung im Rathaus der Landeshauptstadt Stuttgart 20. Mai bis 10. Juni 2009<br />
|
||
<a href="../ausstellung.php">weitere Infos</a></span> </p>
|
||
<p> </p> <p><a href="http://www.astronomy2009.de/" target="_blank" style="text-decoration:none;"> <img src="../bilder/astro2009.jpg" width="182" height="342" alt="Astronomisches Jahr 2009" /></a></p>
|
||
|
||
</div>
|
||
<div id="mainContent">
|
||
<h1> Admin-Bereich</h1>
|
||
<p><strong>Bildergalerien-Eingeben von Bildern</strong></p>
|
||
|
||
<?php include '../config_stern.php';
|
||
|
||
$kat = $_REQUEST['kat'];
|
||
$frei = $_REQUEST['frei'];
|
||
$neu = $_REQUEST['neu'];
|
||
$kategorie= $_REQUEST['kategorie'];
|
||
$num = $_REQUEST['num'];
|
||
$titel = $_REQUEST['titel'];
|
||
$objekt = $_REQUEST['objekt'];
|
||
$datum = $_REQUEST['datum'];
|
||
$instrument = $_REQUEST['instrument'];
|
||
$belichtungszeit = $_REQUEST['belichtungszeit'];
|
||
$beschreibung = $_REQUEST['beschreibung'];
|
||
$filebildk = $_REQUEST['filebildk'];
|
||
$filebildg = $_REQUEST['filebildg'];
|
||
$autor = $_REQUEST['autor'];
|
||
if ($frei!='')
|
||
$frei=1;
|
||
else
|
||
$frei=0;
|
||
echo $filebildk;
|
||
if($neu)
|
||
{
|
||
|
||
$sql_stmt="INSERT INTO galerie (gid,titel, objekt, instrument, autor, bzeit, beschreibung, datum)".
|
||
" values('','$titel', '$objekt', '$instrument', '$autor','$belichtungszeit', '$beschreibung', '$datum') ";
|
||
$ins=mysqli_query($db,$sql_stmt);
|
||
|
||
$last_id=mysqli_insert_id($db);
|
||
|
||
|
||
|
||
|
||
include("uploadbild.php");
|
||
if($fnameg != "")
|
||
{$dateig=$fnameg;
|
||
|
||
}
|
||
else{$dateig="";
|
||
}
|
||
|
||
if($fnamek != "")
|
||
{$dateik=$fnamek;
|
||
|
||
}
|
||
else{$dateik="55555";
|
||
}
|
||
|
||
|
||
|
||
$query="UPDATE galerie SET bildg='$dateig', bildk='$dateik' where gid=$last_id";
|
||
$upd=mysqli_query($db,$query);
|
||
|
||
|
||
|
||
|
||
|
||
$result=count($kategorie);
|
||
|
||
for($i=0;$i<$result;$i++)
|
||
{
|
||
$var = "";
|
||
eval( "\$var = \$kategorie[$i];" );
|
||
|
||
$sql_relaus="INSERT INTO rel_galerie (rid,gid,kid)".
|
||
" values('', '$last_id','$var') ";
|
||
$ins_relaus=mysqli_query($db,$sql_relaus);
|
||
|
||
}
|
||
|
||
echo "<br /><br/>Die Daten wurden eingetragen";
|
||
}
|
||
|
||
?>
|
||
|
||
|
||
|
||
<!-- end #mainContent --></div>
|
||
<!-- Dieses clear-Element sollte direkt auf das #mainContent-div folgen, um das #container-div anzuweisen, alle untergeordneten Floats aufzunehmen. --><br class="clearfloat" />
|
||
|
||
<!-- end #container --></div>
|
||
</body>
|
||
</html>
|