simple database connection issue....

[sucralose]

Hi everyone,

Here's my newbie issue:

in phpmyadmin i created the following database:

user: firebox_firebox
pass: my pass
database: firebox_manual
table: blog

after skimming through a dummies book, i wrote this code:

<?php
$host="localhost";
$user="firebox_firebox";
$password="MYPASSWORD";
$database="firebox_manual";

$connection=mysql_pconnect ($host,$user,$password) or die ("couldn't connect to server");

$db=mysql_select_db ($database,$connection) or die ("can't connect to database");

and that's where i'll stop, because that's where the script chokes....

browser returns string "can't connect to database"....

i've tried a number of variations of this string, to no effect:

$database,$connection
$database
"firebox_manual", $connection
"firebox_manual"

i checked in phpmyadmin to make sure i had everything named correctly, and the database/user/password/table is all correct....

this is making my brain hurt, and i've only just started : (

EDIT: for all you fellow newbies out there, remember when you're creating your mysql databases that a username has to be attached to a database.... otherwise mysql has no idea that your user is supposed to have access.... in my case, it resulted in me being able to connect to the server, but not to the specific database, because my user/pass was rejected.

[bpat1434]

So is your issue solved? Was the addition of the user to the database the solution? If so, mark the thread resolved (Thread Tools --> Mark Resolved). Otherwise, please state your question.

~Brett

[slweb]

other than that i have never seen a p in connect before

$connection=mysql_pconnect ($host,$user,$password) or die ("couldn't connect to server"); 

[bpat1434]

If you read up on it, he is using a persistent connection. It's just another type of mySQL connection that stays open rather than closing. It has its advantages & disadvantages.

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

~Brett

[slweb]

Thak you, I learn a new thing most days.