Newbie in Trying php

[nephsuperman]

I have agreed to create a website for a band. They know nothing about computer shtuff and I want to make it to where they themselves can add the news and the tour dates and such. So, for some reason I bought a template flash site that gives you all of this, the problem is that they do not tell you how to change the code to get it to work on your server.

 

I have already changed the $dbhost, $dbUser, $dbPass, $dbName to the correct server information.

 

A flash addnews.swf is used to get the information and it is passed into addnews.php. The flash file runs down the php code in addnews, and it states this error. "Couldn't add news item."

 

Here is the code for addnews.php the server info is removed from the pasted file.

 

Thanks

 

<?

/*********************************************************

** Modern Red Website **

*********************************************************/

// Define Database connection details

$dbHost = "";

$dbUser = "";

$dbPass = "";

$dbName = "";

$table = "news";

 

// Check username and password

if ($username != "modern" || $password != "modern2003") {

print "&result=Fail";

print "&errorMsg=" . urlencode("Incorrect username and/or password");

exit;

}

 

 

// Attempt to connect to MySQL server

$link = @mysql_connect($dbHost, $dbUser, $dbPass);

 

// If the connection was unsuccessful...

if (!$link)

{

// Report error to Flash and exit

print "&result=Fail";

print "&errorMsg=" . urlencode("Could not connect to server");

exit;

}

 

// Attempt to connect to MySQL server

$link = @mysql_connect($dbHost, $dbUser, $dbPass);

 

// If the connection was unsuccessful...

if (!$link)

{

// Report error to Flash and exit

print "&result=Fail";

print "&errorMsg=" . urlencode("Could not connect to database");

exit;

}

 

// Attempt to select database. If unsuccessfull...

if (!@mysql_select_db($dbName))

{

// Report error to Flash and exit

print "&result=Fail";

print "&errorMsg=" . urlencode("Could not select $dbName database");

exit;

}

 

// Fetch the current time

$posted = time();

 

// Build Query

$query = "INSERT INTO news (title, author, body, posted)

VALUES('$newsTitle', '$newsAuthor', '$newsBody', $posted)";

 

// Execute Query

$result = @mysql_query($query);

 

// If query was successful

if ($result)

{

// Report success back to Flash movie

print "&result=Okay";

}

else

{

// Otherwise, tell Flash we fucked up

print "&result=Fail";

print "&errorMsg=" . urlencode("Couldn't add news item");

}

 

// Close the connection

mysql_close($link);

 

?>

 

[nephsuperman]

Sorry these are the two additional files that are needed to show whats up.

I think both of these are needed so that the database is set up. But what do i know, it still doesnt work.

 

setup.php

<?

/*********************************************************

** Modern Red Website **

*********************************************************/

 

/*########################################################

// MAKE SURE YOU EDIT common.php BEFORE running this file!

//######################################################*/

 

// setup.php

 

// Include config file

include('common.php');

 

// Attempt to connect to database server

$link = @mysql_connect($dbHost, $dbUser, $dbPass);

 

// If connection failed...

if (!$link) {

// Inform user of error and quit

print "Couldn't connect to database server - Did you edit the common.php properly?";

exit;

}

 

// Attempt to create database

print "Attempting to create database $dbName <br>\n";

if(!@mysql_create_db($dbName)) {

// Inform user of error

print "# Couldn't create database <br>\n";

} else {

// Inform user of success

print "# Database created successfully <br>\n";

}

 

// Attempt to select database

print "Attempting to select database $dbName <br>\n";

if(!@mysql_select_db($dbName)) {

// Inform user of error and exit

print "# Couldn't select database <br>\n";

exit;

} else {

// Inform user of success

print "# Database selected successfully <br>\n";

}

 

print "Attempting to create tables<br>\n";

 

// Attempt to create tour table

$query = "CREATE TABLE tour (

tourID INTEGER AUTO_INCREMENT PRIMARY KEY,

dates VARCHAR(100),

location VARCHAR(100),

posted INTEGER,

venue MEDIUMTEXT)";

$query = "INSERT INTO tour (tourID, dates, location, posted, venue) VALUES (1, 'Sample Tour', 'Dec 20th - 23rd', 1070296156, 'This is a sample Tour Post to show this items functionality.')";

 

$result = @mysql_query($query);

 

if (!$result) {

// Inform user of error

print "# Error creating tour table<br>\n";

print mysql_error();

} else {

// Inform user of euccess

print "# tour table created<br>\n";

}

 

// Attempt to create news table

$query = "CREATE TABLE news (

newsID INTEGER AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(100),

author VARCHAR(30),

posted INTEGER,

body MEDIUMTEXT)";

$query = "INSERT INTO news (newsID, title, author, posted, body) VALUES (1, 'Sample News', 'XISNET', 1070296156, 'This is a sample News Post to show this items functionality.')";

 

$result = @mysql_query($query);

 

if (!$result) {

// Inform user of error

print "# Error creating news table<br>\n";

print mysql_error();

} else {

// Inform user of euccess

print "# news table created<br>\n";

}

 

print "End of setup";

?>

 

 

 

 

common.php

 

 

<?

/*********************************************************

** Modern Red Website **

*********************************************************/

// common.php

// Database details

$dbHost = "";

$dbUser = "";

$dbPass = "";

$dbName = "";

 

// Common functions

 

/*********************************************************

** Function: dbconnect() **

** Desc: Perform database server connection and **

** database selection operations **

*********************************************************/

function dbConnect() {

// Access global variables

global $dbHost;

global $dbUser;

global $dbPass;

global $dbName;

 

// Attempt to connect to database server

$link = @mysql_connect($dbHost, $dbUser, $dbPass);

 

// If connection failed...

if (!$link) {

// Inform Flash of error and quit

fail("Couldn't connect to database server");

}

 

// Attempt to select our database. If failed...

if (!@mysql_select_db($dbName)) {

// Inform Flash of error and quit

fail("Couldn't find database $dbName");

}

 

return $link;

}

 

 

/*********************************************************

** Function: fail() **

** Params: $errorMsg - Custom error information **

** Desc: Report error information back to Flash **

** movie and exit the script. **

*********************************************************/

function fail($errorMsg) {

// URL-Encode error message

$errorMsg = urlencode($errorMsg);

 

// Output error information and exit

print "&result=Fail&errormsg=$errorMsg";

exit;

}

 

 

 

/*********************************************************

** Function: auth() **

** Params: $username - Name of user to authenticate **

** $password - Passwd of user to authenticate **

** Desc: Authenticates a given user. Involves a **

** check that the given username and passwd **

** exists in users table. **

*********************************************************/

function auth($username, $password) {

 

$crypt = md5($password);

 

$query = "SELECT userID FROM forumUsers WHERE username = '$username' AND password = '$crypt'";

 

// Execute the query

$result = mysql_query($query);

 

// If we found a match...

if (mysql_num_rows($result) == 1) {

// Extract user ID from the results

$user = mysql_fetch_array($result);

$userID = $user['userID'];

} else {

// Otherwise set username to -1

$userID = -1;

}

 

// Return user ID

return $userID;

}

 

 

function checkEmail($email)

{

// Define regular expression

$regexp = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";

 

if (eregi($regexp, $email)) {

return true;

}

else

{

return false;

}

}

?>

 

 

[nephsuperman]

Sorry one more thing, Do I have to run the setup file to instantiate the tables in the database? If so, how?

 

Thanks