We help IT Professionals succeed at work.

php error - no database selected

CAE5942
CAE5942 asked
on
894 Views
Last Modified: 2013-12-13
Hi everyone,

I'm trying to test out a php registration system up on my remote server. I uploaded all the files but when I go to the rego page, I get the following error:

No database selected

Below is the code I have in my connection file.

I don't know if it's because I've put the files into a subdirectory within the root folder of my site. Would this be causing the problem and do I need to have this reflected in the file path somehow?

Really appreciate any help.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost:/tmp/mysql5.sock";
$database_localhost = "olink_stm_site";
$username_localhost = "stmEvents";
$password_localhost = "mypassword";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Open in new window

Comment
Watch Question

does this also give you an error?
<?php
 
//Database constants
define("DB_SERVER", "localhost:/tmp/mysql5.sock");
define("DB_USER", "olink_stm_site");
define("DB_PASS", "stmEvents");
define("DB_NAME", "Tm2_mypassword");
 
	
	global $connection;
	$connection = mysql_pconnect(DB_SERVER,DB_USER,DB_PASS);
	if (!$connection) {
		die("Database connection failed: " . mysql_error());
	}
	
	
	$db_select = mysql_select_db(DB_NAME, $connection);  
	if(!$db_select) {
		die("Database selection failed: " . mysql_error());
	}
?>

Open in new window

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
The connection files can be anywhere...just make sure they are relative to where they are being called..no relative from where they are being kept.

And obviously use this to call it..

<?php require_once("youdir/connection.php");?>
yeah...agree with olly on the p_connect

use mysql_connect if possible...
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.