Connecting to MySQL database with PHP

Question

I have this little function do connect to a MySQL database:

function connectSugarCRM()
{
    $connectorSugarCRM = mysql_connect ("localhost", "123", "123")
    or die ("Connection failed");
    mysql_select_db("sugar5") or die ("Failed attempt to connect to database");
    return $connectorSugarCRM;
}

And then, to run a query, I'm doing something like this, but I allways get an "PHP Fatal error: Cannot redeclare connectSugarCRM() (previously declared in ...", which points to the definition of my function "connectSugarCRM" (line 1).

$ExecuteSQL = mysql_query ($sqlSTR, connectSugarCRM()) or die ("Query Failed!");

What is wrong with my code? Thanks

Matt · Accepted Answer · 2009-04-07 13:59:08Z

2

Always use include_once or require_once when including other files.

answered Apr 7, 2009 at 13:59

Matt

2,23012 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Quassnoi · Accepted Answer · 2009-04-07 13:55:23Z

Check your code for recursive includes.

The module that contains connectSugarCRM() seems to be included twice:

<?php
function connectSugarCRM()
{
    $connectorSugarCRM = mysql_connect ("myserver", "myname", "mypass") or die ("Connection failed\n");
    mysql_select_db("test") or die ("Failed attempt to connect to database\n");
    return $connectorSugarCRM;
}

function connectSugarCRM()
{
    $connectorSugarCRM = mysql_connect ("myserver", "myname", "mypass") or die ("Connection failed\n");
    mysql_select_db("test") or die ("Failed attempt to connect to database\n");
    return $connectorSugarCRM;
}

$ExecuteSQL = mysql_query ("SELECT 1", connectSugarCRM()) or die ("Query Failed!\n");
?>

[~]# php test.php

PHP Fatal error:  Cannot redeclare connectsugarcrm() (previously declared in /root/test/sugar/test.php:4) in /root/test/sugar/test.php on line 14

Scott Saunders · Accepted Answer · 2009-04-07 15:44:43Z

1

First, search all of your code for 'function connectSugarCRM()' and make sure it appears once and only once. If it's there more than once, that's your problem.

Otherwise, try changing your query line to this:

$sugarConnection = connectSugarCRM();
$ExecuteSQL = mysql_query($sqlSTR, $sugarConnection) or die ("Query Failed!");

And in the future, the line numbers and full error messages are really helpful for debugging this stuff.

edited Apr 7, 2009 at 15:44

answered Apr 7, 2009 at 13:55

Scott Saunders

30.5k14 gold badges60 silver badges66 bronze badges

2 Comments

RSilva Over a year ago

Scott: 1-I'm totally sure that the function is only defined once and there is no recursive includes. 2-I need to identify the database connector, because I'm using more than one database in the same procedure. 3 - Line Error - fixed

Scott Saunders Over a year ago

I've changed my code suggestion to handle your #2. It really looks like that function is defined or included more than once. Maybe you can post more of your code so we can check for multiple includes. I've been "totally sure" and wrong so many times...

Collectives™ on Stack Overflow

Connecting to MySQL database with PHP

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related