[RESOLVED] connect_db() problem

jose9

Good morning,
I just reformatted my server. Now it is running on phpmyadmin2.6.3, IIS5.1, PHP5.1.2.

When connecting to the portal through this file ppp.php, I get this message:

Fatal error: Cannot redeclare connect_db() (previously declared in d:\inetpub\wwwroot\includes\psgdb.php:13) in d:\inetpub\wwwroot\includes\psgdb.php on line 23

I was told initially to find any extra lines which went like, ' include "psgdb.php" ' in ppp.php.
However in ppp.php, there is no mention of a line like 'include "psgdb.php" ' .

In psgdb.php, $link = mysql_pconnect ("$db_hostname","$db_username","$db_password") or die ("Could not connect".mysql_error ());

Kindly let me know if you can assist with the issue as I'm at my wits end.
Thanks.

Rodney_H_

Hi:

I am not sure if I follow you, so if I am off the mark, please allow some latitude in your forgiveness.

Here is a simple example of the type of problem you are experiencing:

1) a function is defined

2) a function with the same name as the first is defined, OR the same function as the first is being re-defined.

Example:

<?php
function connect_db() {
	echo 'something';
}

function connect_db() {
	echo 'something else...';
}

?>

If you run that script, you will get the dreaded fatal error:

[INDENT]Fatal error: Cannot redeclare connect_db() (previously declared in C:\wamp\www\sandbox\test.php:3) ... [/INDENT]

So, if this is a function that you have created, then an easy fix is to use PHP's function_exists() function .

Hope that helps. If not, please pardon me.... LOOOOONG day... LOL!

jose9

Hi,
Thanks for your advice, greatly appreciated.
I put this in the ppp.php file.

<?php

include 'ppp_protector.php';
if (function_exists('connect_db()')) {
echo "IMAP functions are available.<br />\n";
} else {
echo "IMAP functions are not available.<br />\n";
}

and "IMAP functions are not available" is being echoed out.

Under phpinfo.php, it seems like the MySQL connection is working fine. I use a persistent MySQL connection to my database.

mysql
MySQL Support enabled
Active Persistent Links 1

Active Links 1

Client API version 4.1.7

Unless I overlooked a similar connect_db() statement in the ppp.php file, but am quite sure that I didn't..

FatalError

if (function_exists('connect_db'))

Try that. You don't put parentheses when you use function_exists(). 😛

jose9

Sorry mate, it doesn't work too.
Does this mean something wrong with my coding in ppp.php?
Need me to attach the file?

jose9

Hey people,
IMAP functions are available is being echoed out.
I placed the function_exists() statement in the wrong place initially.

May I know how is it possible for me to proceed given that connect_db() exists?

Rodney_H_

Well, is it possible for you to share some more code? (not attached, but post it in your reply using the [ PHP] bb-code tags, for syntax hightlighting like this:

<?php
echo 'need help?  post code in between the [code=php] PHP BB-tags';
?>

jose9

Hello to all,
I managed to solve the problem by using back the files from the old harddisk.
Thanks alot for your help!

Rodney_H_

Cool:

Remember to => Mark Your Thread Resolved

(Look at thread tools at the top - right)

thanks