[e-mail]

[raymog06]

Hi. Im getting this error:

Notice: Undefined index: message in /admin/admin.php on line 5

Notice: Undefined index: author in /admin/admin.php on line 6

Notice: Undefined index: submit in /admin/admin.php on line 7

This is my php code:

<?php

include 'database.php';

$message = $POST['message'];
$author = $POST['author'];
$submit = $_POST['submit'];

if ($submit)
submit($message,$author);

// mysql_query will send a sql query into the database. It will return either the data found, or FALSE if something went wrong with the query
function submit($message,$author)
{ $date = date("d.m.Y");
$resultat = mysql_query("INSERT INTO news (message, date, author) VALUES
('$message'), '$date', '$author', ");
if (!$resultat)
echo "Error: Nyhet ble ikke lagt til";
else
{ include 'admin.htm';
echo "Nyhet lagt til!<br>";
retrieve(); // show all posting, including the last one, stored now
}

$submit = false;
}

function retrieve()
{
// Get all the data from the "news" table
$retrieved = mysql_query("SELECT * FROM news ORDER BY date DESC") or die(mysql_error());

while($row = mysql_fetch_array( $retrieved ))
{
echo $row['message'];
echo "<br>";
echo $row['date'];
echo " - ";
echo $row['author'];
echo "<br>";
}
}
?>

Im pretty new with this, and i dont understand what can be wrong.
Would appreciate any help 🙂

[garblar]

its basically telling you that there is nothing stored in those post fields. i would assume its happening the first time you load the page. maybe try checking if they are set before using them.

if(isset($_POST['message'])){
   $message = $_POST['message'];
}

[raymog06]

thank you so much!

[raymog06]

Thank you so much for helping me earlier,
i ran into another problem when im trying to send data to the database

i dont get any specific error message, except for the error-message i made myself if the query returns FALSE.

<?php

include 'database.php';

if(isset($_POST['title']))
{
   $title = $_POST['title'];
} 
if(isset($_POST['message']))
{
   $message = $_POST['message'];
} 
if(isset($_POST['author']))
{
   $author = $_POST['author'];
} 

if(isset($_POST['submit']))
   $submit = $_POST['submit'];
else
   $submit = false;


if ($submit) 
	submit($title,$message,$author);

// mysql_query will send a sql query into the database. It will return either the data found, or FALSE if something went wrong with the query	 
function submit($title,$message,$author)
{ $date = gmdate("d.m.Y");
  $resultat = mysql_query("INSERT INTO news (title, message, date, author) VALUES 
  ('$title', '$message', '$date', '$author', "); 
	if (!$resultat)
				echo "Error: Input was not added";
	else			
		{ include 'admin.htm';

	}  
$submit = false;	
}
?>

If anyone could help me, i would really appreciate it!

[mark_kccs]

hi

I think you need to remove the last comma and white space and move the " so line should be

('$title', '$message', '$date', '$author')"; 

sorry forgot last )

so

('$title', '$message', '$date', '$author'))"; 

[garblar]

$resultat = mysql_query("INSERT INTO news (title, message, date, author) VALUES
  ('$title', '$message', '$date', '$author')"); 

[raymog06]

awsome. thanx!

php is a strict language, starting to understand things now

[mark_kccs]

nice one garblar