/    Sign up×
Community /Pin to ProfileBookmark

Need help! T_DNUMBER

Hey guys we’ll I just need some help here… I’m trying upload somthing to my site it’s PhP and MySQL is in it as well.
Here’s the file that I’m getting a error with.

[QUOTE]

<?php
/**
* Database.php
*

* The Database class is meant to simplify the task of accessing
*
information from the website’s database.
*
*
Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
* Last Updated: August 17, 2004
*
/
include(“constants.php”);

class MySQLDB
{
var $connection; //The MySQL database connection
var $num_active_users; //Number of active users viewing site
var $num_active_guests; //Number of active guests viewing site
var $num_members; //Number of signed-up users
/* Note: call getNumMembers() to access $num_members! */

/* Class constructor */
function MySQLDB(){
/* Make connection to database */
[COLOR=”Red”]Line 24—>[/COLOR][COLOR=”DarkOrange”]$this->connection = mysql_connect (sql9.000webhost.com, a8238318_2, ******) or die(mysql_error());[/COLOR]
mysql_select_db(DB_NAME, $this->connection) or die(mysql_error());

/**
* Only query database to find out number of members
* when getNumMembers() is called for the first time,
* until then, default value set.
*/
$this->num_members = -1;

if(TRACK_VISITORS){
/* Calculate number of users at site */
$this->calcNumActiveUsers();

/* Calculate number of guests at site */
$this->calcNumActiveGuests();
}

}

/**
* confirmUserPass – Checks whether or not the given
*
username is in the database, if so it checks if the
* given password is the same password in the database
*
for that user. If the user doesn’t exist or if the
* passwords don’t match up, it returns an error code
*
(1 or 2). On success it returns 0.
*/
function confirmUserPass($username, $password){
/*
Add slashes if necessary (for query) */
if(!get_magic_quotes_gpc()) {
$username = addslashes($username);
}

/* Verify that user is in database */
$q = “SELECT password FROM “.TBL_USERS.” WHERE username = ‘$username'”;
$result = mysql_query($q, $this->connection);
if(!$result || (mysql_numrows($result) < 1)){
return 1; //Indicates username failure
}

/* Retrieve password from result, strip slashes */
$dbarray = mysql_fetch_array($result);
$dbarray[‘password’] = stripslashes($dbarray[‘password’]);
$password = stripslashes($password);

/* Validate that password is correct */
if($password == $dbarray[‘password’]){
return 0; //Success! Username and password confirmed
}
else{
return 2; //Indicates password failure
}

}

/**
* confirmUserID – Checks whether or not the given
*
username is in the database, if so it checks if the
* given userid is the same userid in the database
*
for that user. If the user doesn’t exist or if the
* userids don’t match up, it returns an error code
*
(1 or 2). On success it returns 0.
*/
function confirmUserID($username, $userid){
/*
Add slashes if necessary (for query) */
if(!get_magic_quotes_gpc()) {
$username = addslashes($username);
}

/* Verify that user is in database */
$q = “SELECT userid FROM “.TBL_USERS.” WHERE username = ‘$username'”;
$result = mysql_query($q, $this->connection);
if(!$result || (mysql_numrows($result) < 1)){
return 1; //Indicates username failure
}

/* Retrieve userid from result, strip slashes */
$dbarray = mysql_fetch_array($result);
$dbarray[‘userid’] = stripslashes($dbarray[‘userid’]);
$userid = stripslashes($userid);

/* Validate that userid is correct */
if($userid == $dbarray[‘userid’]){
return 0; //Success! Username and userid confirmed
}
else{

?>

[/QUOTE]

And this is the error:

[QUOTE]

Parse error: syntax error, unexpected T_DNUMBER in /home/a8238318/public_html/include/database.php on line 24

[/QUOTE]

P.S: I deleted alot of stuff when in the file that I showed u like I took off then end but not on my real file of course!?

to post a comment
PHP

2 Comments(s)

Copy linkTweet thisAlerts:
@fr2_dbauthorJun 13.2009 — And if line 24 = [COLOR="Orange"]$this->connection = mysql_connect ("sql9.000webhost.com", "a8238318_2", "******") or die(mysql_error());[/COLOR][/QUOTE]
I get error:
[COLOR="Red"]Warning: mysql_connect() [function.mysql-connect]: Host '216.108.239.136' is not allowed to connect to this MySQL server in /home/a8238318/public_html/include/database.php on line 24





Host '216.108.239.136' is not allowed to connect to this MySQL server[/COLOR]
[/QUOTE]
Copy linkTweet thisAlerts:
@MindzaiJun 13.2009 — That is the correct syntax, strings must be in quotes. The second error is relating to your MySQL server configuration, it is not a PHP problem. You need to allow connections as this user from your IP. Normally you would be using a local MySQL server and connect via localhost, but I assume from the domain name that you are using a dedicated MySQL box?
×

Success!

Help @fr2_db spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.27,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...