Trouble connecting to MySQL

djd@n · #1 25-Oct-2005, 12:02

i have tried to make a login code and members area that i found in a teach php book but everytime i upload it it comes up with unexpected T_STRING on either line 13 or 14 this is the code i am using

PHP Code:


<html>
<p>create a new user
<?php
  $dbhost = "hab-globe.com";
  $dbname = "userdetails";
  $dbuser = "user";
  $dbpass = "habbo250";
  $username = $_POST['newusername'];
  $userpass = $POST_['newpassword'];
  $useremail = $_POST['email'];
  $today = date("y-m-d");
  if ($username = "" $userpass = "" or $useremail = "")
   die ("<p>sorry you left a field empty please click the back butto to check your details")
   $query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
  $connection  mysql_connect(dbhost, $dbuser, $dbpass)
   or die ("<br>sorry couldnt connect to hab-globe.com");
  $db = mysql_select_db($dbname, $dbconnection)
    or die("<br>sorry the hab-globe database is offline, please check back later!");
  $result = mysql_query($query)
   or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
<p>thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.<p>
</html>

Paramesh · #2 25-Oct-2005, 19:49

Hi,

Use an appropriate title for your post.
Dont post new threads for the same question.

I dont know anything about PHP but here is my guess:

PHP Code:


$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";

the error is that there is an extra single quote ' after the email.

In this line,

PHP Code:


die ("<p>sorry you left a field empty please click the back butto to check your details")

You missed a semicolon in the end.

so,
Add a semicolon at the end of the statement.
and remove that single quote.
I hope this helps a little bit.
Here is the updated one:

PHP Code:


die ("<p>sorry you left a field empty please click the back butto to check your details");
 $query = "INSERT INTO user (username, password, joindate, email) VALUES ('$username', '$userpass', '$today', '$useremail')";

Regards,
Paramesh.

djd@n · #3 26-Oct-2005, 09:39

I have done that but now when i go to register a new user it says sorry you left a field blank when i havent

Imatate · #4 27-Oct-2005, 07:13

well, im no genius but i have edited a new one and i have forund this

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

Imatate · #5 27-Oct-2005, 07:14

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

Imatate · #6 27-Oct-2005, 07:15

Quote:

Originally Posted by Imatate

well, im no genius but i have edited a new one and i have forund this

<html>
create a new user
<?php
$dbhost = "hab-globe.com";
$dbname = "userdetails";
$dbuser = "user";
$dbpass = "habbo250";
$username = $_POST['newusername'];
$userpass = $POST_['newpassword'];
$useremail = $_POST['email'];
$today = date("y-m-d");
if ($username = "" $userpass = " or $useremail = ")
die ("sorry you left a field empty please click the back butto to check your details")
$query = "INSERT INTO user (username, password, joindate, email') VALUES ('$username', '$userpass', '$today', '$useremail')";
$connection mysql_connect(dbhost, $dbuser, $dbpass)
or die (" sorry couldnt connect to hab-globe.com");
$db = mysql_select_db($dbname, $dbconnection)
or die(" Sorry http://www.hab-globe.com Is Not Allowing Logins Today!!");
$result = mysql_query($query)
or die ("sorry that user has been taken");

$_SESSION['login'] = 'yes';
?>
thank you, your new user has been created. Please click <ahref="login.php"> here</a> to log into your hab-globe user account.
</html>

Also The Datbase Connection String Should Be Formatted in a way which it is easy to view

phrygianphreak · #7 27-Oct-2005, 11:10

You haven't gotten there yet, but on line 15:
$connection mysql_connect(dbhost, $dbuser, $dbpass)
the 'dbhost' needs a '$' in front of it to be a valid variable.

Here's the corrected code:
$connection mysql_connect($dbhost, $dbuser, $dbpass)

Hope that helps.

admin · #8 28-Oct-2005, 08:10

There are so many syntax errors, I don't know where to start

PHP Code:


// if ($username = "" $userpass = " or $useremail = ")
// can be replaced with... 
if( !$username or !$userpass or !$useremail )

When user-supplied data/input is inserted within your SQL statement, you really should screen the data first.

PHP Code:


// a really simple (but unrelated to your script) example...
if( !$username=trim($_POST['username']) ) // trim to remove whitespace...
{
  die( "Please fill-in your username." );
}
else
{ // the field was filled-in (with something)...
 
  // escape special characters in the SQL statement.
  $sql .= " WHERE `username`= '" . mysql_escape_string( $username ) . "'";
}

From your example code:

PHP Code:


$connection  mysql_connect(dbhost, $dbuser, $dbpass)
   or die ("<br>sorry couldnt connect to hab-globe.com");
  $db = mysql_select_db($dbname, $dbconnection)

Line 1 : where is the assignment (=) operator in this line? Somebody already mentioned the missing $ in dbhost.
Line 3 : Where did $dbconnection come from? I thought it was $connection?

PHP Code:


// possible fix...
$connection =  mysql_connect( $dbhost, $dbuser, $dbpass );
   or die ("<br>sorry couldnt connect to hab-globe.com");
if( !@mysql_select_db($dbname, $connection) )
 trigger_error( "Cannot select database: $dbname", E_USER_ERROR );

I appreciate that you're experimenting (and learning) but you'll understand new PHP stuff (like connecting to MySQL) a lot faster if you revisit a page like: basic PHP syntax (Expressions) and understand the basics about the language. Really, it's not complicated at all.

While I am replying to this post of yours, may I suggest that you do NOT use titles like "Please Help!!!!!!!" in forums. It's considered bad form.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
php and mysql	vladimy	MySQL / PHP Forum	2	28-May-2005 05:17
Error connecting to MySQL	Kilgayne	MySQL / PHP Forum	4	27-May-2005 13:45
Trouble connecting to most of the internet	jrobbio	Web Hosting Forum	7	18-Jan-2004 10:11
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More	EyotaHosts	Web Hosting Advertisements & Offers	0	28-Jun-2003 13:54

Trouble connecting to MySQL

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!

Re: Please Help!!!!!!!