[SOLVED] Creating queries dynamically?

[kevin_newbie]

Hello,

 

I was wondering if there is a way to create queries dynamically with php functions?

 

For example every time i want to display something from the db I do this:

$q = "SELECT id,something FROM table_name";
$r = $mysqli->query($q);
while ($row = $r->fetch_object())  {

echo $row->id;
echo $row->something;

}

 

So is there a way where I can use php function and so that all i have to do is type field names and table name and the rest is plug and play. I want to be able to reuse that function to. Is it possible? Not only is it possible but is it a right thing to do?

[kickstart]

Hi

 

Possible and quite easy.

 

Eg, build an array of the fields you want, and pass that.

 

<?php
$ArrayOfFields = array('id','name','address');

sqlFunction($ArrayOfFields);

function sqlFunction($PassedFields)
{
$q = "SELECT ".implode(',',$PassedFields)." FROM table_name";
$r = $mysqli->query($q);
while ($row = $r->fetch_assoc())  
{
	foreach($PassedFields AS $aField)
	{
		echo $row[$aField];
	}
}
}
?>

 

All the best

 

Keith

[kevin_newbie]

Keith,

 

Thank you very much.

 

now I noticed that you did fetch_assoc() why that instead of fetch_object()?

 

With this function I can put it in a function.php and include anywhere on the site right? just call that function like you have it on top of the function.

[kickstart]

Hi

 

I used fetch_assoc as I am using normal mysql rather than mysqli most of the time, and with it returning a associative array it is easy to use the passed column names to get the values.

 

You will want to pass in the connection to the function (either as a parameter or as a global).

 

You can put it anywhere in your code, but think an included function needs to be included before it is used.

 

All the best

 

Keith

[kevin_newbie]

Keith,

 

You answered it all, it works perfect now thanks