Using SQL function from SQL handling class in other functions

Question

I have created an SQL function SQLquery in a class called SQLHandling It looks like this:

 /***********************************************************
    * SQLquery takes a full SQL query and runs it
    * If it fails it will return an error otherwise it will return
    * the SQL query as given.
    ************************************************************/   
    function SQLquery($query)  { 

        $q = mysql_query($query);

        if(!$q) {
            die(mysql_error());
            return false;
        } else {
            return $q;          
        }
    }

Is there anyway I can use this function in other classes functions without adding

$db = new SQLHandling();
$db->SQLquery($sql);

In every function where I will use it.

I know I can run SQLHandling::SQLquery($sql); but I am trying to avoid that.

Mithun Satheesh · Accepted Answer · 2012-06-12 08:24:58Z

2

use inheritance

refer: http://php.net/manual/en/language.oop5.inheritance.php

but still you will need to use parent::fun() or $this->fun() or put it as a public function then use any where.

example:

<?php

function c()
{
        echo "moi";
}    

class b extends a
{       
   public function d(){

    parent::c();//Hai
    $this->c();//Hai
    c();//moi

    }   


}


class a{    



    public function c(){
        echo "Hai";

    }       
} 


$kk = new b();
$kk -> d();

?>

edited Jun 12, 2012 at 8:24

answered Jun 12, 2012 at 8:09

Mithun Satheesh

27.9k14 gold badges80 silver badges103 bronze badges

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

1 Comment

Sherlock Over a year ago

You are suggesting he should extend SQLHandling in other classes? I don't see any reason to do so..

Sherlock · Accepted Answer · 2012-06-12 08:13:49Z

1

You could instantiate SQLHandling on class level, like so:

    private $db;

    public function __construct()
    {
        $this->db = new SQLHandling();
    }

    public function x()
    {
        $this->db->query('X');
    }

answered Jun 12, 2012 at 8:13

Sherlock

7,6356 gold badges42 silver badges83 bronze badges

1 Comment

Morten Hagh Over a year ago

This is exactly what I was looking for! Spot on! Thank you very much! :)

Collectives™ on Stack Overflow

Using SQL function from SQL handling class in other functions

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related