creating a separate file to connect to mysql with php

Question

I want to use a single file for my php application to connect to a database when the user register for the first time or login in

what is the code is it same as below is good:

$username="root";
$password="root";
$database="test";



    function Save($name)
    {
        global $username;
        global $password;
        global $database;

        $link = mysql_connect('localhost', $username, $password);
        if (!$link) {
            die('Could not connect: ' . mysql_error());
        }
        @mysql_select_db($database) or die( "Unable to select database");
        $query = "INSERT INTO test (name)" .
                 "VALUES ('" . $name . "')";
        mysql_query($query);
        mysql_close();
    }

Also, how can i do the require for that file? it is located in the root of the application folder should but i back slash first after require '/filename.php' or should i put double dots first?

Akhilesh B Chandran · Accepted Answer · 2012-09-01 04:44:50Z

2

If the file is in the same directory, you could simply use: include_once "db.php";

If it is in parent directory(ie, one level up), then use: include_once "../db.php";

Another one is to append the global DOCUMENT_ROOT with the filename(like others have given examples below).

And also, avoid mysql_* functions. Use PDO or mysqli instead.

Wish you good luck. :)

answered Sep 1, 2012 at 4:44

Akhilesh B Chandran

6,6087 gold badges33 silver badges60 bronze badges

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

Comments

Niet the Dark Absol · Accepted Answer · 2012-09-01 04:42:03Z

1

Your question essentailly boils down to "how can I include a file that is in the root from anywhere". Well, there's two answers.

The first answer is to just use inlude($_SERVER['DOCUMENT_ROOT']."/connect.php");, but that's a lot to type, especially if you have a lot of includes.

Personally, I like to start my script with chdir($_SERVER['DOCUMENT_ROOT']); Then I don't have to worry about where I am anymore - I will always be in the root folder.

answered Sep 1, 2012 at 4:42

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

Comments

Danil Speransky · Accepted Answer · 2012-09-01 04:42:52Z

0

Probably it is not good that you open mysql connection on every save, if there will be many such calls per request.
inlude($_SERVER['DOCUMENT_ROOT'] . '/db.php');

answered Sep 1, 2012 at 4:42

Danil Speransky

30.5k6 gold badges70 silver badges78 bronze badges

Comments

alanmanderson · Accepted Answer · 2012-09-01 04:45:08Z

0

A few comments: First, if you don't need to use the password and username and database elsewhere, you should just define them in the function.

Second, If I'm not mistaken if you put the "/" in front of the path that will take you all the way down to the root of the filesystem, which I'm guessing this user wouldn't have access to. That being said, I would use ".." to navigate up the hierarchy. So use: require_once("../path/to/file.php")

answered Sep 1, 2012 at 4:45

alanmanderson

8,31012 gold badges56 silver badges89 bronze badges

Comments

Barmar · Accepted Answer · 2012-09-01 04:47:30Z

0

Rather that putting the include file in the document root, you should create a directory for common include files, and add it to the include_path setting in php.ini. Then you can just do include 'connect.php';.

answered Sep 1, 2012 at 4:47

Barmar

789k57 gold badges555 silver badges669 bronze badges

Collectives™ on Stack Overflow

creating a separate file to connect to mysql with php

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related