Help with my class - Dev Articles

Dev Articles Community Forums Sponsor:

SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!

May 12th, 2003, 12:53 AM

lido

Junior Member

Join Date: Sep 2002

Posts: 6

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

Help with my class

I have just recently started trying to use classes and one of the first scripts i made was a class to connect to a database. I have made a few scrpts now that rely on that script and I thought it was working fine but now i have found that it isnt working at all. actually i dont even think its doing anything. Can someone have a look and see if they can find anything wrong with what im doing or with teh class itself.

I use this code to initiate it.

PHP Code:


		
			
 $conx = new Connection;

$conx->conx()

PHP Code:


		
			
<?



Class Connection

{



var $dbhost;

var $dbuser;

var $dbpass;

var $dbase;



function Connection()

{

$this->dbhost = "localhost";

$this->dbuser = "epic";

$this->dbpass = "easy11";

$this->dbase = "phpnation_net";

}



function conx()

{

$result = mysql_connect("$this->dbhost", "$this->dbuser", "$this->dbpass");

if (!$result)

return "Unable to connect to MySQL Database";

if (!mysql_select_db("$this->dbase"))

return "Unable to select Database";



return $result;

}

}

?>

May 12th, 2003, 01:48 AM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

PHP Code:


		
			
class Connection

{

    var $dbhost;

    var $dbuser;

    var $dbpass;

    var $dbase;

    var $error;



    function Connection( $cfg )

    {

        /*--------------------------------------------

        Set Att's

        --------------------------------------------*/

        $this->dbhost = $cfg['host'];

        $this->dbuser = $cfg['user'];

        $this->dbpass = $cfg['pass'];

        $this->dbase = $cfg['dbase'];

    }



    function conx()

    {

        $result = @mysql_connect( $this->dbhost, $this->dbuser, $this->dbpass ) or $this->error( mysql_error() );

        @mysql_select_db( $this->dbase ) or $this->error( 'unable to select db' );

    }



    function error( $string )

    {

        $this->error[] = $string;

    }



    function check_connection()

    {

        return( $this->error );

    }

}



/*--------------------------------------------

Set Vars

--------------------------------------------*/

$cfg['host'] = "localhost";

$cfg['user'] = "epic";

$cfg['pass'] = "easy11";

$cfg['dbase'] = "phpnation_net";

/*--------------------------------------------

Initiate Object - pass connection vars

--------------------------------------------*/

$conx = new Connection( $cfg );

/*--------------------------------------------

Connect To DB

--------------------------------------------*/

$conx->conx();

/*--------------------------------------------

Check Connection State

--------------------------------------------*/

if ( $conx->check_connection() )

{

    exit( print_r( $conx->check_connection() ) );

}

__________________
~ Joe Penn

We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set?

Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you.

May 12th, 2003, 03:22 AM

lido

Junior Member

Join Date: Sep 2002

Posts: 6

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

Thanks joe

May 12th, 2003, 01:05 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

Lol - forgot to explain it.

I changed it around a little so you can define your connection params outside of the class - like in a require()'d file or something - makes it a little more transportable. Also, the error supression (@) will suppress any connection errors so they don't output to the screen - the errors in return will be send to the error method which will place them in a array. You can then use that array to see if any errors occured and adjust accordingly...

May 12th, 2003, 03:43 PM

Vince

LordNitrous

Join Date: May 2003

Location: England

Posts: 137

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

woa, this forum certainly ranks high as a support community

you guys are great! - also are PHP classes a good thing to learn for a PHP beginner (me) and if not wat is the next thing I shud learn? considering I dont know much...

__________________
You don't deserve to read my signature...yeah! That's it, keep walking...yeah walk away from me! That's it! Get out of my pub, you're barred!

May 12th, 2003, 04:26 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

Well - OO is a great thing to learn as OO in practice can be used in other languages also. As for beginers, the best thing would be to get a grip or feel on all the built in functions php has to offer, build applications with funtions first - then once you get the hang of functions, you will have te basics to creating methods in OO. Once you have the basics down and are able to be effecient, then it is time to step to the next level...

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: