$this->dbfield help - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

June 20th, 2003, 02:32 AM

fakker

The calm b4 the storm

Join Date: Jul 2002

Location: Manchester, UK

Posts: 404

Time spent in forums: < 1 sec
Reputation Power: 7

$this->dbfield help

hey,

in all my PHP apps, I use the following (sort of) code to get my results...

PHP Code:


		
			
 $SQL = "SELECT * FROM xx WHERE yy = 'z';";

    $result = @mysql_query($SQL,$connection) or die("Couldn't execute query 2.");

    if ($result)

    { 

        while ($row = mysql_fetch_array($result)) {

            $a = $row['a'];

            $b = $row['b'];

            $c = $row['c'];

            $d = $row['d'];

        }

    }

but since I learnt to use that a few years ago, I have seen people using things like:

PHP Code:


		
			
 $sql = "SELECT * FROM xx WHERE y = 'z'";

$result = mysql_query($sql, $this->db);

I wondered.... what is this method of connecting, and how does it differ from my first example... any suggestions or examples will be much appreciated!!

__________________
Matt 'Fakker' Facer

mattfacer.com

June 20th, 2003, 08:42 AM

Taelo

5B's

Join Date: Oct 2002

Location: PC, FL

Posts: 364

Time spent in forums: 1 h 48 m 26 sec
Reputation Power: 6

OOP

PHP Code:


		
			
class DB

{

    function DB()

    {

        $this->host = '';

        $this->username = '';

        $this->password = '';

        $this->db = '';

    }

    

    function connect()

    {

        if( mysql_connect( <!-- params --> ) )

        {

        }

    }

}

__________________
-- Jason

June 20th, 2003, 08:53 AM

fakker

The calm b4 the storm

Join Date: Jul 2002

Location: Manchester, UK

Posts: 404

Time spent in forums: < 1 sec
Reputation Power: 7

cheers jason!!

another question.... how is that then used?
If I had the following in the db...

- name
- username
- password
- age

if that connection is in another file, say connection.php.... but then in "getuser.php" I wanted to get the username and password.... how do I access the connection?

$this->username

?? thanks!!

June 20th, 2003, 10:41 AM

Taelo

5B's

Join Date: Oct 2002

Location: PC, FL

Posts: 364

Time spent in forums: 1 h 48 m 26 sec
Reputation Power: 6

well,....keep in mind that what I have shown you is meerly for setting up connectivity to the db.

PHP Code:


		
			
class DB

{

    function DB()

    {

        /********************************

        | This is the class contructor.  

        | Since it is the same name as the

        | class, this function will execute

        | when you call the class

        *********************************/

        $this->host = 'localhost';

        $this->username = 'user';

        $this->password = 'pass';

        $this->db = 'mydb';

        $this->conn_type = 'mysql_pconnect';

    }

    

    function connect()

    {

        $this->connection = $this->conn_type( $this->host, $this->username, $this->password ) or die( "Connection Error" );

    }

}

To make this work.

PHP Code:


		
			
include_once( "this_code_above.php" ); // Or just paste in every page.

$DB = new DB;

$DB->connect();

What you want to do is access your database connection and your sessions at the same time. Check out Jpenn's Session handler, it is very nice. It should give you some ideas on how to manage your db connections.
http://www.cheetah-soft.com/csh/

Last edited by Taelo : June 20th, 2003 at 10:46 AM.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: