replace every ? with each word in an array.

[turkman]

Hey i hope the title explains it enough. I'm just trying to get into classes.  I am making a function to make making mysql querys easier.

 

I pass the class the first string

 

$db->inputstring("INSERT INTO ? (?,?) VALUES ('?','?')");

$db->format('mytable','id','name','1','ben');

 

Can someone tell me how the format fuction would look? Im not sure how to swap arrays.

[phprocker]

 

I actually haven't watched this yet but this guy has really great tutorials.  I've been meaning to get around to watching this one myself.  Hopefully I get the chance today. 

 

Let me know if that tutorial helps you.

[turkman]

i dont think thats what i need, i know how to do the mysql stuff, i just need to know how to replace arrays... switch each ? with the corresponding word sent to format

[AbraCadaver]

I can show you some ways, but why?  PDO has this: http://us2.php.net/manual/en/pdostatement.bindparam.php and if you're using MySQL you can use this: http://us2.php.net/manual/en/mysqli-stmt.bind-param.php.  These have the benefit of escaping the data for you, and maybe other benefits.

 

If not, then there is always: http://us2.php.net/manual/en/function.sprintf.php.

[turkman]

its not really for functionality its just more out of intrest to see how it would work... can you replace may ?'s with different elements of an array?

 

Also if you want to pass an array to a function, how do you do it.

 

say

 

function acceptarray($arr)

 

would you call that like the followin ---- acceptarray('arr1','arr2','arr3')

 

can someone answer these for me please.

 

Thanks.

[AbraCadaver]

This is very convoluted, but I'm tired and I couldn't get the simple solution to work.  I'll revisit it later.  This is still not the right approach for this type of thing, but just to answer the question:

 

$db = new DB;
$db->inputstring("INSERT INTO ? (?,?) VALUES ('?','?')");
$db->format('mytable', array('id'=>1, 'name'=>'ben'));
echo $db->query;

class DB {
public function inputstring($string) {
	$this->query = $string;
}

public function format($table, $data) {
	$replace = array_merge(array($table), array_keys($data), array_values($data));
	$search  = array_fill(0, count($replace), '/\?/');

	$count = true;
	while($count) {
		  $this->query = preg_replace($search, $replace, $this->query, 1, $count);
	}
}
}