Does this PHP code look OK? - GoFuckYourself.com

Steen2 · 04-24-2005, 11:29 AM

PHP Code:


			
    function mysqlconn() {

         $user = "DB_DB";

         $pass = "pass";

         $db = "DB_DB";

         $newconnect = mysql_pconnect(localhost, $user,$pass) or die(mysql_error());

         mysql_select_db($db) or die(mysql_error());

         if(mysql_error()) { echo mysql_error(); }

    }

It's causing this error in my error logs and looks to be hurting the server: PHP Warning: mysql_pconnect(): Link to server lost, unable to reconnect in ...

The line the error references is
$user = "DB_DB";

But I included the lines around it for better insight.

ssp · 04-24-2005, 11:38 AM

Have you tried using all lower cases in your username?

Steen2 · 04-24-2005, 11:42 AM

Quote:

Originally Posted by ssp

Have you tried using all lower cases in your username?

Sorry?

"DB_DB" is to edit out information that's "sensitive".

ssp · 04-24-2005, 11:44 AM

Perhaps it's because there is a space in this line:

mysql_pconnect(localhost, $user,$pass)

Calvinguy · 04-24-2005, 11:52 AM

Try to use single qoutes ' rather then doubleqoutes "

or put qoutes around localhost also...

Steen2 · 04-24-2005, 12:14 PM

Quote:

Originally Posted by ssp

Perhaps it's because there is a space in this line:

mysql_pconnect(localhost, $user,$pass)

Quote:

Try to use single qoutes ' rather then doubleqoutes "

or put qoutes around localhost also...

Thanks, but would this crash the server's mysql?

Serge Litehead · 04-24-2005, 12:23 PM

put localhost in single qoutes
whitespace such as spaces, tabs, etc in code is ignored

seems there s a prob with connection rather than anything else at this point
i've never used mysql_pconnect, see if mysql_connect works better for you.

Nysus · 04-24-2005, 12:26 PM

Hope you're putting that function in an include file as opposed to on a page, or have multiple DBs at different locations to use... you only need to connect to a mySQL server once each load.

Matt

who · 04-24-2005, 12:28 PM

Is your username the same as the database name?

Serge Litehead · 04-24-2005, 12:28 PM

here is a good sample for you from php manual:

Code:

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password') or die (mysql_error());
db_selected = mysql_select_db('db_name', $link) or die (mysql_error());

or die() is not recommended for use in live production.

Serge Litehead · 04-24-2005, 12:34 PM

err in above post

db_selected = $db_selected

04-24-2005, 11:29 AM	#1
Steen2 Confirmed User Join Date: Feb 2004 Location: Vancouver, Canada Posts: 7,662	Does this PHP code look OK? PHP Code: `function mysqlconn() { $user = "DB_DB"; $pass = "pass"; $db = "DB_DB"; $newconnect = mysql_pconnect(localhost, $user,$pass) or die(mysql_error()); mysql_select_db($db) or die(mysql_error()); if(mysql_error()) { echo mysql_error(); } }` It's causing this error in my error logs and looks to be hurting the server: PHP Warning: mysql_pconnect(): Link to server lost, unable to reconnect in ... The line the error references is $user = "DB_DB"; But I included the lines around it for better insight. __________________ ICQ: 2262.73945

04-24-2005, 12:23 PM	#7
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	put localhost in single qoutes whitespace such as spaces, tabs, etc in code is ignored seems there s a prob with connection rather than anything else at this point i've never used mysql_pconnect, see if mysql_connect works better for you. __________________ SilverCrocodile.com Adult web design since '05

04-24-2005, 12:26 PM	#8
Nysus Confirmed User Industry Role: Join Date: Aug 2001 Posts: 7,817	Hope you're putting that function in an include file as opposed to on a page, or have multiple DBs at different locations to use... you only need to connect to a mySQL server once each load. Matt __________________ What name is pr0 / Untouched Markets using these days? Untouched Markets - pr0 - Refund My Money Now Someone owes me $2,000 because they didn't do any work that was paid for pointing at pr0 / William / UntouchedMarkets See https://gfy.com/fucking-around-and-business-discussion/948258-untouchedmarkets-pr0-refund-money-post16744521.html and for more detailed see https://gfy.com/fucking-around-and-business-discussion/948645-re-recent-bullshit-drama-explained-detail-pr0-untouched-markets.html

04-24-2005, 12:28 PM	#10
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	here is a good sample for you from php manual: Code: $link = mysql_connect('localhost', 'mysql_user', 'mysql_password') or die (mysql_error()); db_selected = mysql_select_db('db_name', $link) or die (mysql_error()); or die() is not recommended for use in live production. __________________ SilverCrocodile.com Adult web design since '05

04-24-2005, 12:34 PM	#11
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	err in above post db_selected = $db_selected __________________ SilverCrocodile.com Adult web design since '05

04-24-2005, 11:38 AM	#2
ssp Confirmed User Join Date: Jan 2005 Location: United Kingdom Posts: 7,990	Have you tried using all lower cases in your username?

04-24-2005, 11:44 AM	#4
ssp Confirmed User Join Date: Jan 2005 Location: United Kingdom Posts: 7,990	Perhaps it's because there is a space in this line: mysql_pconnect(localhost, $user,$pass)

04-24-2005, 11:52 AM	#5
Calvinguy Confirmed User Join Date: Oct 2002 Location: European Union Posts: 1,752	Try to use single qoutes ' rather then doubleqoutes " or put qoutes around localhost also...

04-24-2005, 12:28 PM	#9
who So Fucking Banned Join Date: Aug 2003 Location: ICQ #23642053 Posts: 19,593	Is your username the same as the database name?