Avanced (maybe?) functions

dougal85

I am looking to create a function that does a number of things...

Basically i want it to be able to do the following - all in one.

return 10 most recent posts
return posts between number x and number y
return posts sorted by item x

I realise i could do that if i tell it lots of different parameters each time.

but say if i call it with just : function();

i wanted it to default to returning the 10 most recent posts.

Is this possible in PHP? Would i have to make it an object and then do constructors? (not even sure if PHP4 supports constructors).

Thanks
Dougal

brandtj

This ought to get you started:

function get_items ($x = -1, $y = -1) {
	if ($x == -1 && $y == -1) {
		// return 10 most recent
	} elseif ($x != -1 && $y == -1) {
		// get items sorted by x
	} else {
		// get items between x and y
	}
}

dougal85

oo, that looks interesting , I'm guessing thats like default values - i never realised that you could do that!

Thanks! 🙂

bpat1434

You could even slice it even further and do:

function getItems($x=1; $y=10; $sort=true)
{
  // Query getting all items from X to Y
  $query = "SELECT * FROM table LIMIT $x, $y";
  $query .= ($sort)?'ORDER BY $x':'';

  return mysql_query($query);
}

dougal85

how do i then call these functions with passing in the parameters?

brandtj

Using bpat's code, try this:

function getItems(&$conn, $x=1; $y=10; $sort=true) 
{ 
  // Query getting all items from X to Y 
  $query = "SELECT * FROM table LIMIT $x, $y"; 
  $query .= ($sort)?'ORDER BY $x':''; 

  return mysql_query($query, $conn); 
}

$conn = mysql_connect ('x', 'y', 'z');
mysql_select_db ('w');

$result = getItems ($conn);