Hej,
Jag sökte på "header" och fick en hel del svar, men jag får det bara inte att fungera. Är det något litet jävelskap jag missat eller måste jag göra "output buffering"? Fattar inte riktigt hur jag ska använda det.
Jag är helt blank inom php, har jobbat en del med SQL och ASP innan.
member-formedling.php
<?php
require_once('auth.php');
session_start();
require_once("conn.php");
if(isset($_GET['change'])) {
if(empty($_GET['change'])) {
header("Location: member-formedling.php");
exit;
} else {
$id = $_GET['change'];
$sql = "SELECT * FROM nyheter WHERE id='$id' LIMIT 1";
$result = mysql_query($sql) or die (mysql_error());
while ($result=mysql_fetch_object($result)) {
echo "<form action=\"?changeit=".$result->id."\" method=\"POST\" name=\"change\">";
echo "<b>Rubrik</b><br>";
echo "<input type=\"text\" name=\"titel\" class=\"textfield\" value=\"".$result->titel."\"> Datum: ".$result->datum."<br><br>";
echo "<b>Text</b><br>";
echo "<textarea name=\"text\" cols=\"70\" class=\"textfield\" rows=\"10\">".$result->text."</textarea><br><br>";
echo "<input type=\"submit\" value=\"Ändra\">";
echo "</form>";
}
}
}
else {
echo "<form action=\"?writeit=1\" method=\"POST\">";
echo "<b>Rubrik</b><br>";
echo "<input type=\"text\" class=\"textfield\" name=\"titel\"><br><br>";
echo "<b>Text</b><br>";
echo "<textarea name=\"text\" class=\"textfield\" cols=\"70\" rows=\"10\"></textarea><br><br>";
echo "<input type=\"submit\" name=\"submit\" value=\"Lägg till\">";
echo "</form>";
}
echo "<br><br><br><br>";
echo "<h1>Lista förmedlingar</h1>";
$sql = "SELECT * FROM nyheter ORDER BY id";
$result = mysql_query($sql) or die (mysql_error());
while ($rad=mysql_fetch_array($result)) {
echo "<table border=\"0\"><th><td width=\"380\"><a href=\"?change=".$rad['id']."\">".$rad['titel']."</a></td><td width=\"70\"><a href=\"?delete=".$rad['id']."\">Radera</a></td></th></table>";
}
?>
Conn.php
<?
/**********************
Mysql
**********************/
$server = "********"; //Default
$user = "********";
$password = "********";
$db = "********";
$table = "********";
$lank = mysql_connect ($server, $user, $password) or die ("couldnt connect!");
mysql_select_db($db, $lank) or die ("cant find database!");
/**********************
General
**********************/
if(isset($_GET['changeit'])) {
if($_GET['changeit'] == "") {
header("Location: member-formedling.php");
exit;
} else {
$id = $_GET['changeit'];
$titel = $_POST['titel'];
$datum = date("Y-m-d H:i:s");
$text = $_POST['text'];
$sql = "UPDATE $table SET titel='$titel', datum='$datum', text='$text' WHERE id='$id'";
mysql_query($sql) or die (mysql_error());
header("Location: member-formedling.php");
exit;
}
}
if(isset($_GET['delete'])) {
if(empty($_GET['delete'])) {
header("Location: member-formedling.php");
exit;
} else {
$id = $_GET['delete'];
$sql = "DELETE FROM $table WHERE id='$id' LIMIT 1";
mysql_query($sql) or die (mysql_error());
header("Location: member-formedling.php");
exit;
}
}
if(isset($_GET['writeit'])) {
if(isset($_POST['submit'])) {
$titel = $_POST['titel'];
$text = $_POST['text'];
$date = date("Y-m-d H:i:s");
$sql = "INSERT INTO $table (titel, text, datum)
VALUES ('$titel', '$text', '$date')";
mysql_query($sql) or die (mysql_error());
header("Location: member-formedling.php");
exit;
} else {
header("Location: member-formedling.php");
exit;
}
}
?>