Firstly cheers MstrBob for that, it's far simpler than wot i was gonna do. I'm now on to my next problem...
I've tried to create an article submission page to upload articles to the database. I've created the following code but can't work out why it doesn't work....<?php
//connect to the database
require_once ('../../db_connect.php');
//include the external function page
include ('functions.php');
if (isset($_POST['submit']))
{
//check that the title has been filled in
if (!empty($_POST['title']))
{
$title = escape_data($title);
}
else
{
$title = FALSE;
echo '<script type="text/javascript">alert("Please enter a title for the article");</script>';
}
//check the content has been entered
if (!empty($_POST['content']))
{
$content = escape_data($content);
}
else
{
$content = FALSE;
echo '<script type="text/javascript">alert("Please enter the main body of the article");</script>';
}
//check that the user has entered his/her name
if (!empty($_POST['author']))
{
$author = escape_data($author);
}
else
{
$author = FALSE;
echo '<script type="text/javascript">alert("Please enter your name");</script>';
}
//check a type has been selected
if (!empty($_POST['type']))
{
$type = escape_data($type);
}
else
{
$type = FALSE;
echo '<script type="text/javascript">alert("Please select the type of the article");</script>';
}
//continue if the form has been filled out correctly
if ($title && $content && $author && type)
{
//add the article to the database
$query = "INSERT INTO article (title, content, author, upload_date, type, images) VALUES ('$title', '$content', '$author', NOW(), '$type', '$images');"
$results = @mysql_query ($query);
//if the article was succesfully uploaded to the database
//say thank you, and stop the script from loading the form again
if ($results)
{
echo '<p class="cheers">That you for your submission $author.</p>'
exit();
}
//if did not apologies and show the mysql error message
//also email the site admin with information on the error
else
{
$error = mysql_error();
echo '<p class="error">The article was unable to be uploaded due to technical difficulties.
The site admin has been notified of the problem.<br />' . $error . '</p>';
//sets the strings to be used in the email
//$error_date = date('D d-m-Y', microtime());
//$admin_email = "admin@ugmfc.com";
//$error_subject = "Error uploading to database"
//$error_body = "An error has occured when" . $author . "was attemping to upload an article to the database. The following error code was produced: " . $error;
//mail ($admin_email, $error_subject, $error_body);
}
//close the database
mysql_close();
}
}
$php_self = $_SERVER['PHP_SELF'];
$form = <<< AAF
<div class="form">
<form action="$php_self" method="post">
Title\:<br />
<input type="text" name="title" size="40" value="$title" /><br /><br />
Please place the article in here:<br />
<textarea rows="20" cols="68" name="article" value="$article"></textarea><br /><br />
<div class="form_author">
<label>Authors name:
<input type="text" name="author" size="25" value="$author" />
</label>
</div>
<div class="form_type">
<label>Type of article:
<select name="type" value="$type">
<option value="1">General News</option>
<option value="2">Match Report</option>
<option value="3">Event</option>
<option value="4">Team Sheet</option>
</select>
</label>
</div>
<div class="form_images">
<input type="button" value="Add Images" onclick="window.open('add_image.php', 'Add image', 'width=100, height=120, toolbar=0, menubar=0, status=0');" />
</div>
<div class="form_submit">
<input type="submit" value="Submit" />
</div>
</form>
</div>
AAF;
?>I'm only just learning php and have pieced the above code together from several books, and a little bit of my own ingenuity (I suspect the latter may be my undoing). There's a lot there, and i know it's a big ask, but if any body can shed some light on my errors, and help me progress to a php god (ok may be just a competent programmer) it would be much appreciated.
Cheers,
Durbs