dropping mysql connection with php

[Bastien]

Hi All,

I am having a problem with a php / mysql site. I have a standard conn.php file that holds the host,username, password, and DB name. This was working until yesterday, when the connection started ignoring the php pages.

The message in the logs on mysql indicate that I am not a valid user and that it is ignoring me. I have been using phpmyadmin to administer the DB successfully and can see the need info in the user table.

Has anyone else had a similar problem and how have you resolved it?

TIA
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Broccoli2]

Please could you post:
1. Your

conn.php

file
2. The mysql

user

table
3. The error message you're getting (if any)

This might help identify the problem.

-Rob

 

[Bastien]

Hi All,

I have a conn.php page like this:
$username = "Bastien";
$pwd = "sweden";
$host = "localhost";
$dbname = "Gulfstream";

if (!($conn=mysql_connect($host, $username, $pwd))) {
printf("error connecting to DB by user = $username and pwd=$pwd"
exit;
}
$db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1"

then I have a prod.php which takes a variable in a querystring and tries to hit the DB where I get this:

Fatal error: Failed opening required 'dbconng' (include_path='') in C:\Inetpub\

http://wwwroot\php\gulfstream\products.php

on line 9

yet in the file, it looks like this:
require("commonmn.php"


//header logo
$msg1 = "";
HTMLHeader(); //function to print header
require("dbconng" //is on line 9
$SQLProd = "select * from gulf_products where prod_name = $prod";

$SQLResult = mysql_query($SQLProd, $conn) or die ("Couldn't execute query1"
echo&quot; <table width = 600 valign = top>&quot;;
//pass the info to the screen
$row = mysql_fetch_array($SQLProdGet);

I checked the mySQL error file in the WinMySQLAdmin and get this error

Aborted connection 4 to db: 'unconnected' user: 'Bastien'
host: 'localhost'

This was working for the last few days and has now crapped out on me

any help would be wonderful

TAI
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Broccoli2]

It seems as if the problem is with the

require

statement rather than your database (if I assume correctly that

dbconng

either

require

s or

include

s

conn.php

).

Some things to check:
1. Do

products.php

and

dbconng

reside in the same directory?
2. Try adding a suffix to

dbconng

such as

.php

or

.inc

3. Try specifying the full paths in your

require

statements
4. Check if it really is a database issue by attempting to connect to your database using the native

mysql

client, and the same username/password combination.

-Rob