Jump to content


Photo

Newbie in Trying php


  • Please log in to reply
2 replies to this topic

#1 nephsuperman

nephsuperman
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 24 March 2005 - 04:48 AM

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);

?>


#2 nephsuperman

nephsuperman
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 24 March 2005 - 05:04 AM

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;
}
}
?>



#3 nephsuperman

nephsuperman
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 24 March 2005 - 05:16 AM

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

Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users