Kipkip
November 25th, 2004, 01:23 AM
some more details such as the code in question and/or a link to the page would really help us help you..
I really don't know what part of the code is messed up because of lack of data in the error message. Here's the source code:
<html>
<head>
<title>New News Module</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<?php
////////////////////////////////////////////////////////////////////////
//New News Module
//I think...
////////////////////////////////////////////////////////////////////////
require('../includes/dbconnect.php);
// Info varibles
$title = $HTTP_POST_VARS['title'];
$intro = $HTTP_POST_VARS['intro'];
$catergory = $HTTP_POST_VARS['catergory'];
$news = $HTTP_POST_VARS['news'];
//Connection
$connection = new Database();
if ($HTTP_POST_VARS){
$insert = "INSERT INTO news (title,intro,news,catergory) VALUES ('$title', '$intro', '$news', '$catergory')";
if ($result = $connection->db = mysql_query($insert)){
// It worked! You don't suck like the guy below you!
echo 'This piece of news is now added to the database.';
}else{
// You suck. You failed. You'll never be anything.
exit('Sorry, but there was an error when adding this piece of news.<br />');
}
}
?>
<body>
<form name="form1" method="post" action="news.php">
<p> Title:<br />
<input name="title" type="text" id="title">
</p>
<p> Intro:<br />
<input name="intro" type="text" id="intro">
</p>
<p> Catergory:<br />
<select name="catergory" id="catergory">
<?php
$games = $connection->db = mysql_query('SELECT ID,name FROM catergories ORDER BY name');
while ($list = $connection->db = mysql_fetch_array($games)){
echo '<option value="'.$list['ID'].'">'.$list['name'].'</option>';
}
?>
</select>
</p>
<p> Body:<br />
<textarea name="news" cols="50" rows="6" id="news"></textarea>
</p>
<p align="center">
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
Here's the dbconnect file:
<?php
/////////////////////////////////////////////
//Database Connection
/////////////////////////////////////////////
//require('/*Edited out for sercurity measures*/');
class Database extends /*Same as above*/ {
var $Query;
var $db;
function Database(){
$config = /*Same as above two*/::Settings();
$dbhost = $config['dbhost'];
$dbname = $config['dbname'];
$dbuser = $config['dbuser'];
$dbpass = $config['dbpass'];
// Connect to the database
$connect->db = mysql_connect ($dbhost, $dbuser, $dbpass) or die('Could not connect to database for the following reason: ' . mysql_error());
mysql_select_db ($dbname) or die('Could not select database for the following reason: ' . mysql_error());
register_shutdown_function(array(&$connect, 'close'));
}
//Execute Query
function mysql_query($query) {
$connect->Query = $query;
return mysql_query($query, $connect->db);
}
//Get Results
function mysql_fetch_array($result) {
return mysql_fetch_array($result);
}
//Bob: Close connection
//Linda: Closing...
function mysql_close() {
mysql_close($connect->db);
}
}
?>
You can see it here:
http://www.secretgamers.com/CMS/admin/news.php
Works fine. It's just that there is that weird error.