3 PHP Questions

[loserWILL]

Well, I've started on my portfolio script. So far, so good. I've run in to three errors so far:
1. Name doesn't appear when adding news
2. Unexpected "t" after the date
3. After the PHP there is a bottom DIV, which doesn't display

Here's my code:

<?php
// Database
include "config.php";

//Variables
$title = ($_POST["title"]);
$news = ($_POST["news"]);
$date = date('F dS h:i: ');

// Some mySQL to fetch your name
$sql = "SELECT * FROM details";
$check = mysql_query("SELECT name FROM details") or die("Onoes! Something is wrong! Please contact loserWILL for assistance (this is an error).");
while ($display = mysql_fetch_array($check)) {
$user = $display['user'];

// If form has been submitted, display this
if ($_GET["action"] == "submit")
{
if ($title == "")
{
echo "Onoes! Please enter a title.";
exit;
}

if ($news == "")
{
echo "Onoes! Please enter some news.";
exit;
}

$addnews = mysql_query("INSERT INTO `news` (`title`, `name`, `date`, `post`) VALUES ('$title','$name','$date', '$post')");

//Details are fine
echo "Your news has been added.";
exit;
}

// Display form
echo ("<form action=\"?action=submit\" method=\"post\">
<strong>Name:</strong> $user<br />
<strong>Title:</strong> <input type=\"text\" name=\"title\"><br />
<strong>News:</strong> <input type=\"text\" name=\"news\"><br />
<input type=\"submit\" name=\"submit\" value=\"Add News\">
</form>");
exit;
}

Moved by Agesilaus (Forum Moderator) from Design and Development: Please post in the correct forum next time. :)

[d17c]

The first problem I can see is that you're missing the ?>

[Blob]

Well, I've started on my portfolio script. So far, so good. I've run in to three errors so far:
1. Name doesn't appear when adding news You have declared '$name', only $user. Try that.
2. Unexpected "t" after the date Date looks fine?
3. After the PHP there is a bottom DIV, which doesn't display Dont use exit;
Try this:

<?php
// Database
include "config.php";

//Variables
$title = ($_POST["title"]);
$news = ($_POST["news"]);
$date = date('F dS h:i: ');

// Some mySQL to fetch your name
$sql = "SELECT * FROM details";
$check = mysql_query("SELECT name FROM details") or die("Onoes! Something is wrong! Please contact loserWILL for assistance (this is an error).");
while ($display = mysql_fetch_array($check)) {
$user = $display['user'];

// If form has been submitted, display this
if ($_GET["action"] == "submit")
{
if ($title == "")
{
echo "Onoes! Please enter a title.";
exit;
}

if ($news == "")
{
echo "Onoes! Please enter some news.";
exit;
}

$addnews = mysql_query("INSERT INTO `news` (`title`, `name`, `date`, `post`) VALUES ('$title','$user','$date', '$post')");

//Details are fine
echo "Your news has been added.";
exit;
}

// Display form
echo ("<form action=\"?action=submit\" method=\"post\">
<strong>Name:</strong> $user<br />
<strong>Title:</strong> <input type=\"text\" name=\"title\"><br />
<strong>News:</strong> <input type=\"text\" name=\"news\"><br />
<input type=\"submit\" name=\"submit\" value=\"Add News\">
</form>");
}

[loserWILL]

The name still doesn't show.

[loserWILL]

Bump - Does anybody know?

Edited by mat64 (Forum Super Moderator): Please do not double post, unless you are adding additional information.

[lolwut]

In the database, is the users name stored as "name" or "user"? I think that would be the cause of the problem.


<?php
// Database
include "config.php";

//Variables
$title = ($_POST["title"]);
$news = ($_POST["news"]);
$date = date('F dS h:i: ');

// Some MySQL to fetch your name
$sql = "SELECT * FROM `details` ;"; //It doesn't look like this line is doing anything?

$check = mysql_query("SELECT `name` FROM `details` ;") or die("Onoes! Something is wrong! Please contact loserWILL for assistance (this is an error).");
while ($display = mysql_fetch_array($check)) {
$user = $display[user];

// If form has been submitted, display this
if ($_GET["action"] == "submit")
{
if ($title == NULL)
{
echo "Onoes! Please enter a title.";
exit;
}

if ($news == NULL)
{
echo "Onoes! Please enter some news.";
exit;
}

$addnews = mysql_query("INSERT INTO `news` (`title`, `name`, `date`, `post`) VALUES ('$title','$user','$date', '$post')");

//Details are fine
echo "Your news has been added.";
exit;
}

// Display form
echo ("<form action=\"?action=submit\" method=\"post\">
<strong>Name:</strong> $user<br />
<strong>Title:</strong> <input type=\"text\" name=\"title\"><br />
<strong>News:</strong> <input type=\"text\" name=\"news\"><br />
<input type=\"submit\" name=\"submit\" value=\"Add News\">
</form>");
}
?>

[loserWILL]

It still doesn't display the name.

[Blob]

<?php
// Database
include "config.php";

//Variables
$title = ($_POST["title"]);
$news = ($_POST["news"]);
$date = date('F dS h:i: ');

// Some mySQL to fetch your name
$sql = "SELECT * FROM details";
$check = mysql_query("SELECT name FROM details") or die("Onoes! Something is wrong! Please contact loserWILL for assistance (this is an error).");
while ($display = mysql_fetch_array($check)) {
$user = $display['name'];

// If form has been submitted, display this
if ($_GET["action"] == "submit")
{
if ($title == "")
{
echo "Onoes! Please enter a title.";
exit;
}

if ($news == "")
{
echo "Onoes! Please enter some news.";
exit;
}

$addnews = mysql_query("INSERT INTO `news` (`title`, `name`, `date`, `post`) VALUES ('$title','$user','$date', '$post')");

//Details are fine
echo "Your news has been added.";
exit;
}

// Display form
echo ("<form action=\"?action=submit\" method=\"post\">
<strong>Name:</strong> $user<br />
<strong>Title:</strong> <input type=\"text\" name=\"title\"><br />
<strong>News:</strong> <input type=\"text\" name=\"news\"><br />
<input type=\"submit\" name=\"submit\" value=\"Add News\">
</form>");
}

[loserWILL]

No worries, I got it. Thanks for all the help.