Help!!!!!!!!!!!!!!

[topgun]

I am just trying to write a php code to connect to a database that I have. Every way I can think of is giving me this error,,,,,

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/ecstasys/public_html/chatregister.php on line 2

Parse error: parse error, unexpected T_STRING in /home/ecstasys/public_html/chatregister.php on line 2

I am a idiot when it comes to php and this little warning tells me even less of what I am doing wrong.

Someone please help me out.

here is my files that are supposed to work together and make a connection and make a new database.

common.php:

<?
// common.php
$dbHost = “localhost”;
$dbUser = “ecstasy_Topgun”;
$dbPass = “mypass”;
$dbName = “ecstasy_squad2”;

function fail($errorMsg = “”) {
print “&result=Fail&errorMsg=”” . urlencode($errorMsg);
exit;
}
?>

db.php (downloaded to help me out from advancedphpforflash site)

<?
// db.php
// Chapter 11 - Advanced PHP for Flash

// Class: DB
// MySQL database connection wrapper
class DB
{
// connection parameters
var $host = 'localhost';
var $user = 'ecstasy_Topgun';
var $pass = 'mypass';
var $database = 'ecstasy_squad2';
var $persistent = false;
var $link = NULL;
var $result = false;

// Constructor
// Initializes member variables
function DB($host, $user, $pass, $database='', $persistent = false) {
    $this->host = $host;
    $this->user = $user;
    $this->pass = $pass;
    $this->database = $database;
    $this->persistent = $persistent;
}

// Method: connect()
// Establishes a connection to the database server. Returns true or false
// depending on whether the operation was successful or not.
function connect() {
    // Choose the appropriate connect function 
    if ($this->persistent) {
        $func = 'mysql_pconnect';
    } else {
        $func = 'mysql_connect';
    }

    // Connect to the MySQL server and report any errors
    $this->link = $func($this->host, $this->user, $this->pass);
    if (!$this->link) {
        return false;
    }

    // If a database has been specified then attempt to seelct it 
    if ($this->database != "") {
        if (!@mysql_select_db($this->database, $this->link)) {
            return false;
        }
    }

    // Return success to calling function
    return true;
}

// Method: close()
// Terminates the connection to the database. Returns true if the
// connection was terminated successfully, and false otherwise.
function close() {
    return (@mysql_close($this->link));
}

// Method: error()
// Returns the error message, is any, from the last database operation
// performed.
function error() {
    return (mysql_error());
}

// Method: query()
// Standard query function which returns true if the query was successfully
// executed and false otherwise.
function query($sql = '') {
    $this->result = @mysql_query($sql, $this->link);

    return ($this->result != false);
}

// Method: queryFirst()
// A specialised query function that executes the query and then returns
// the first row from the result set. Used for SELECT queries only.
function queryFirst($sql) {
    // Execute query
	$this->result = @mysql_query($sql, $this->link);

    // If query failed then exit
    if (!$this->result) {
		return false;
	}

    // Fetch first row from result set as an associative array
    $returnArray = mysql_fetch_array($this->result, MYSQL_ASSOC);

    // Return array to calling function
    return $returnArray;
}

// Method: affectedRows()
// Invokes the standard mysql_affected_rows() function to find out the
// number of rows affected by the previous query.
function affectedRows() {
    return (@mysql_affected_rows($this->link));
}

// Method: numRows()
// Invokes the standard mysql_num_rows() function and returns the number of
// rows returned by the previous SELECT query.
function numRows() {
    return (@mysql_num_rows($this->result));
}

// Method: fetchObject()
// Returns the next row from the result set as an object
function fetchObject() {
    return (@mysql_fetch_object($this->result, MYSQL_ASSOC));
}

// Method: fetchArray()
// Returns the next row from the result set as a numerically indexed array
function fetchArray() {
    return (@mysql_fetch_array($this->result, MYSQL_NUM));
}

// Method: fetchAssoc()
// Returns the next row from the result set as an associative array
function fetchAssoc() {
    return (@mysql_fetch_assoc($this->result));
}

// Method: freeResult()
// Uses the standard mysql_free_result() function to free the current
// result set.
function freeResult() {
    return (@mysql_free_result($this->result));
}

// Method: insertID()
// Returns the AUTO_INCREMENT column value for the row added by the 
// previous query.
function insertID() {
    return (@mysql_insert_id($this->link));
}

}

?>

and last my setup.php

<?
// setup.php
require ("common.php");
require ("db.php");
$myDB = new DB($dbHost, $dbUser, $Pass);
$myDB->connect();
print "Attempting to create $dbName database<br>";

// Attempt to create database
if($myDB->query("CREATE DATABASE $dbName")){
print "Database $dbName created<br>";
}else{
print "Warning - Failed to create database $dbName<br>";
}

// Select database
if (!mysql_select_db($dbName)) {
print "Error selecting $dbName database";
exit
}

print "<br>Setting up database structure<br>";

// Create chatUsers table
$query = "CREATE TABLE chatUsers {
userID INTEGER AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30),
email VARCHAR(255),
password VARCHAR(30))";
if (!$myDB->query($query)) {
print "error creating chatUsers table<br>";
}

// Create chatMessages table
$query = "CREATE TABLE chatMessages (
body TEXT,
posted INTEGER);

if (!$myDB->query($query)) {
print "Error creating chatMessages table<br>";
}

// Create chatUserList table
$query = "CREATE TABLE chatUserList (
userID INTEGER NOT NULL UNIQUE,
lastActivity INTEGER)";

if (!$myDB->query($query)) {
print "Error creating chatUserList table<br>";
}

print "All done";

$myDB->close();
?>

PLEASE HELP!!!!!!!

Thanks in advance.

topgun out>>>

[trooper]

The error message tells you what page the error is in yet you have not posted its contents (we only need that page) here!!!

Post chatregister.php in here and we'll try and help ya

HTH

GM

[topgun]

I get the same sort of message from the others too. Here is the chatregister.php info:::

<?
// chatlogin.php
require ("common.php");
require ("db.php");

// check data
if(!isset($username) || empty($username) ||
!isset($password) || empty($password) ||
!isset($email) || empty($email)) {
fail("Necessary details not supplied");
}

// check email validity
$pattern = "^{([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(.[a-zA-Z0-9-+)+$";}
if (!ereg($pattern, $email)) {
fail("Email address is not valid. Please enter a valid email address.");
}

// Connect to database
$myDB = new DB($dbHost, $dbUser, $dbPass, $dbName);
$myDB->connect();

// check for duplicate username
$query = "SELECT userID FROM chatUsers WHERE username='$username'";
$user = $myDB->queryFirst($query);
$userID = $user['userID'];
if ($userID != "") {
fail("Username $username already registered. Please try another.");
}

// create user account
$query = "INSERT INTO chatUsers (username, password, email) VALUES ('$username', '$passwrod', '$email')";
$myDB->query($query);
print "&result=Okay";
$myDB->close();
?>

please help.

[topgun]

I don't have a program to write php. Does this make a difference?? I am using wordpad to type it out.

Probably a stupid ?

[topgun]

I wrote this in php format and when I open the file that is on the server it looks like this::

//setup.php

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{*\generator Msftedit 5.41.15.1503;}\viewkind4\uc1\pard\f0\fs20 <?\par
$myDB = new DB($dbHost, $dbUser, $Pass);\par
$myDB->connect();\par
print "Attempting to create $dbName database<br>";\par
\par
// Attempt to create database\par
if($myDB->query("CREATE DATABASE $dbName")){\par
print "Database $dbName created<br>";\par
}else{\par
print "Warning - Failed to create database $dbName<br>";\par
}\par
\par
// Select database\par
if (!mysql_select_db($dbName)) {\par
print "Error selecting $dbName database";\par
exit\par
}\par
\par
print "<br>Setting up database structure<br>";\par
\par
// Create chatUsers table\par
$query = "CREATE TABLE chatUsers {\par
userID INTEGER AUTO_INCREMENT PRIMARY KEY,\par
username VARCHAR(30),\par
email VARCHAR(255),\par
password VARCHAR(30))";\par
if (!$myDB->query($query)) {\par
print "error creating chatUsers table<br>";\par
}\par
\par
// Create chatMessages table\par
$query = "CREATE TABLE chatMessages (\par
body TEXT,\par
posted INTEGER);\par
\par
if (!$myDB->query($query)) {\par
print "Error creating chatMessages table<br>";\par
}\par
\par
// Create chatUserList table\par
$query = "CREATE TABLE chatUserList (\par
userID INTEGER NOT NULL UNIQUE,\par
lastActivity INTEGER)";\par
\par
if (!$myDB->query($query)) {\par
print "Error creating chatUserList table<br>";\par
}\par
\par
print "All done";\par
\par
$myDB->close();\par
?> \par
}

What is the \par thing???
Is there something wrong with my server?? This isn't how I wrote it...

[jayant]

first save all code using notepad

never ever use Wordpad for coding

program require quotes as "...."

not the ones as: “....”

[topgun]

Thanks for the help, I am getting there slowly but surely.

I really do appreciate your help. When I get my Flash and PHP chatclient working I will post the address here.

[topgun]

I still can't get my db.php to connect to my database. It is just a blank page when I go to http://www.ecstasysquad.com/db.php .

I just don't get it.

here is the db.php code:

<?
// db.php
$myDB = new DB($dbName, $dbUser, $dbPass, $dbHost);
$dbHost = 'localhost';
$dbUser = 'ecstasys_Topgun';
$dbPass = 'mypass';
$dbName = 'ecstasys_chatclient';
$myDB->connect();
?>

this is the error I get::

Fatal error: Cannot instantiate non-existent class: db in /home/ecstasys/public_html/db.php on line 3

Please help.

[topgun]

I still can't get my db.php to connect to my database. It is just a blank page when I go to http://www.ecstasysquad.com/db.php .

I just don't get it.

here is the db.php code:

<?
// db.php
$myDB = new DB($dbName, $dbUser, $dbPass, $dbHost);
$dbHost = 'localhost';
$dbUser = 'ecstasys_Topgun';
$dbPass = 'mypass';
$dbName = 'ecstasys_chatclient';
$myDB->connect();
?>

this is the error I get::

Fatal error: Cannot instantiate non-existent class: db in /home/ecstasys/public_html/db.php on line 3

Please help.

[topgun]

No tables have been made on the database called chatclient. The application is supposed to take a user name and if it isn't there,, it makes a table to place the name,pass,email and such.

Well, I think that is supposed to be the way it goes.

I am attempting this Flash Chatclient from the book of Advanced PHP for Flash. Couldn't find the Foundation of PHP for Flash when I was able to purchase information.

Please Help.

[gloescher]

What happened to the class definition in the previous db.php that you posted?

you need to include that in this db.php, or you'll get the error that you're getting: PHP doesn't know what the class DB is, so it can't instantiate it.

Also, you need to define your input parameters before you call new DB(...).

Gary

[topgun]

here is what I have in my db.php now, but I am still as confused as I started.

<?
// db.php
// Chapter 11 - Advanced PHP for Flash

// Class: DB
// MySQL database connection wrapper
class DB
{
// connection parameters
var $host = 'localhost';
var $user = 'ecstasys_Topgun';
var $pass = 'mypass';
var $database = 'ecstasys_chatclient';
var $persistent = false;
var $link = NULL;
var $result = false;

// Constructor
// Initializes member variables
function DB($host, $user, $pass, $database='', $persistent = false) {
    $this->host = $host;
    $this->user = $user;
    $this->pass = $pass;
    $this->database = $database;
    $this->persistent = $persistent;
}

// Method: connect()
// Establishes a connection to the database server. Returns true or false
// depending on whether the operation was successful or not.
function connect() {
    // Choose the appropriate connect function 
    if ($this->persistent) {
        $func = 'mysql_pconnect';
    } else {
        $func = 'mysql_connect';
    }

    // Connect to the MySQL server and report any errors
    $this->link = $func($this->host, $this->user, $this->pass);
    if (!$this->link) {
        return false;
    }

    // If a database has been specified then attempt to seelct it 
    if ($this->database != "") {
        if (!@mysql_select_db($this->database, $this->link)) {
            return false;
        }
    }

    // Return success to calling function
    return true;
}

// Method: close()
// Terminates the connection to the database. Returns true if the
// connection was terminated successfully, and false otherwise.
function close() {
    return (@mysql_close($this->link));
}

// Method: error()
// Returns the error message, is any, from the last database operation
// performed.
function error() {
    return (mysql_error());
}

// Method: query()
// Standard query function which returns true if the query was successfully
// executed and false otherwise.
function query($sql = '') {
    $this->result = @mysql_query($sql, $this->link);

    return ($this->result != false);
}

// Method: queryFirst()
// A specialised query function that executes the query and then returns
// the first row from the result set. Used for SELECT queries only.
function queryFirst($sql) {
    // Execute query
	$this->result = @mysql_query($sql, $this->link);

    // If query failed then exit
    if (!$this->result) {
		return false;
	}

    // Fetch first row from result set as an associative array
    $returnArray = mysql_fetch_array($this->result, MYSQL_ASSOC);

    // Return array to calling function
    return $returnArray;
}

// Method: affectedRows()
// Invokes the standard mysql_affected_rows() function to find out the
// number of rows affected by the previous query.
function affectedRows() {
    return (@mysql_affected_rows($this->link));
}

// Method: numRows()
// Invokes the standard mysql_num_rows() function and returns the number of
// rows returned by the previous SELECT query.
function numRows() {
    return (@mysql_num_rows($this->result));
}

// Method: fetchObject()
// Returns the next row from the result set as an object
function fetchObject() {
    return (@mysql_fetch_object($this->result, MYSQL_ASSOC));
}

// Method: fetchArray()
// Returns the next row from the result set as a numerically indexed array
function fetchArray() {
    return (@mysql_fetch_array($this->result, MYSQL_NUM));
}

// Method: fetchAssoc()
// Returns the next row from the result set as an associative array
function fetchAssoc() {
    return (@mysql_fetch_assoc($this->result));
}

// Method: freeResult()
// Uses the standard mysql_free_result() function to free the current
// result set.
function freeResult() {
    return (@mysql_free_result($this->result));
}

// Method: insertID()
// Returns the AUTO_INCREMENT column value for the row added by the 
// previous query.
function insertID() {
    return (@mysql_insert_id($this->link));
}

}

?>

Is the $link = NULL parameter supposed to be NULL ??? Am I supposed to put something there??

[trooper]

I have amended the connection code to return an error if it fails

also remove the @ from the mysql_select_db

by putting the @ in front of mysql_select_db you willl not get any error messsages, and you need them to find out why its not working

 // Connect to the MySQL server and report any errors
$this->link = $func($this->host, $this->user, $this->pass)or die (mysql_error());
if (!$this->link) {
return false;
}

// If a database has been specified then attempt to seelct it
if ($this->database != "") {
if (!mysql_select_db($this->database, $this->link)) {
return false;
}