Include PHP in MYSQL Function?

[Jack Franklin]

This might really confuse you, but I'll try my best.

I'm attempting to very slowly redo my blog into OOP. I'm creating a class that allows you to give it parameters. Those are then inserted into the MySQL query. EG

PHP: Select all

class content {
//START OF CONTENT CLASS
    function connect_db($user, $db) {
        $conn = mysql_connect("localhost", $user, "") or die(mysql_error());
        mysql_select_db($db, $conn) or die(mysql_error());
    }

    function get($table, $selector = "*", $where = "", $limit = "", $orderby = "", $order = "") {... 

Basically I want the variables $where, $limit, $orderby and $order to not be needed. So, as you can see, I have set their defaults to nothing.

I need to check if the user has included them, and if they have, add them to the MySQL statement. My plan was to create functions like:

PHP: Select all

function where() {
if ($where !== '') {
echo 'WHERE ' . $where .'';
}
} 

So if where actually has a value, it ends up as (in this example)

PHP: Select all

echo WHERE id = '1'; 

But if I'm right a function cannot be included in the query? Ideally it would be:

PHP: Select all

$query = mysql_query("SELECT '$selector' FROM '$table' where();"); 

That incorporates the function where. I've tried it and it gave an error. Is it possible? Is there another way round it?

Jack

---

Also,

PHP: Select all

function get($table, $selector = "*", $where = "", $limit = "", $orderby = "", $order = "") {
    if (mysql_query("SELECT '$selector' FROM '$table'")) {
    echo 'Query Fine';
    } 

And then:

PHP: Select all

$all->get('content', 'id'); 

Is not working. I know nothing will display, but surely it should say 'Query Fine'. Any ideas anyone?

[Jack Franklin]

Infact, here is the entire code. It is my first real go at something useful in OOP, so be nice

PHP: Select all

class content {

//START OF CONTENT CLASS
    function connect_db($user, $db) {
        $conn = mysql_connect("localhost", "root", "") or die(mysql_error());
        mysql_select_db($db, $conn) or die(mysql_error());
    }

    function get($table, $selector = "*", $where = "", $limit = "", $orderby = "", $order = "") {
      if (mysql_query("SELECT '$selector' FROM '$table'")) {
    echo 'Query Fine';
    }                
}
} 

PHP: Select all

$all = new content;
$all->connect_db(root, test);
$all->get('content', 'id'); 

[CloudedVision]

You gotta do something like this:

PHP: Select all

$query = "SELECT `$selector` FROM `$table`";
if($where!='')
     $query .= " WHERE `something`='bla'";
mysql_query($query); 

Something like that

hope it answers your question.

[Weird1993]

Also, in queries, don't use single quotes, as it will take it literally, not as a variable I believe