Tweet
<html>
<head>
<?php
error_reporting(E_ALL);
include "config.php";
@mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS) OR die(mysql_error());
mysql_select_db(MYSQL_DATABASE) OR die(mysql_error());
?>
<title>
<?php
$sql = "SELECT Titel, Beschreibung FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Titel'];
echo " - ";
echo $row['Beschreibung'];
}} else {
echo "Kein Titel Vorhanden";
}
?>
</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
Homepage Name:
<form name="titel_form" action="{$_SERVER['REQUEST_URI']}" method="post">
<input type="text" name="title" size="40" value="
<?php
$sql = "SELECT Titel FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Titel'];?>" />
<input type="submit" name="set_title" value="Ändern" />
</form>
Homepage Beschreibung:
<form name="beschreibung_form" action="{$_SERVER['REQUEST_URI']}" method="post">
<input type="text" name="beschreibung" size="100" value="
<?php
$sql = "SELECT Beschreibung FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Beschreibung'];?>" />
<input type="submit" name="set_beschreibung" value="Ändern" />
</form>
<?php
$sql = "
UPDATE
`Info`
SET
`Titel` = '".$_POST['set_title']."',
`Beschreibung` = '".$_POST['set_beschreibung']."'
WHERE
`id` = ".intval($_POST['edit'])."
";
mysql_query($sql);
echo "Die Einstellungen wurden geändert";
mysql_close($verbindung);
?>
</body>
</html>
<html>
<head>
<?php
error_reporting(E_ALL);
include "config.php";
@mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS) OR die(mysql_error());
mysql_select_db(MYSQL_DATABASE) OR die(mysql_error());
?>
<title>
<?php
$sql = "SELECT Titel, Beschreibung FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Titel'];
echo " - ";
echo $row['Beschreibung'];
}} else {
echo "Kein Titel Vorhanden";
}
?>
</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
<div id="place" ></div>
<div id="pagewidth" >
<div id="header" >Admin Testscript</div>
<div id="maincol" >
<br>
Homepage Name:
<form name="titel_form" action="<?php echo $_SERVER['REQUEST_URI'];?>" method="post">
<input type="text" name="title" size="40" value="
<?php
$sql = "SELECT Titel FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Titel'];}}
?>
" />
<input type="submit" name="set_title" value="Ändern" />
</form>
Homepage Beschreibung:
<form name="beschreibung_form" action="<?php echo $_SERVER['REQUEST_URI'];?>" method="post">
<input type="text" name="beschreibung" size="100" value="
<?php
$sql = "SELECT Beschreibung FROM Info";
$result = mysql_query($sql) OR die(mysql_error());
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
echo $row['Beschreibung'];}}
?>
" />
<input type="submit" name="set_bes" value="Ändern" />
</form>
<?php
if($_POST['set_title'])
{
$title = $_POST['set_title'];
}
else
{
if($_POST['set_bes'])
{
$bes = $_POST['set_bes'];
};
};
$sql = 'UPDATE `Info` SET `Titel` = \'$title\', `Beschreibung` = \'$bes\' WHERE `ID` = 1 LIMIT 1;';
mysql_query($sql);
echo "Die Einstellungen wurden geändert";
?>
</div>
</div>
</body>
</html>
Kommentar