ADD Un début d'helper pour mysql

[cl7.git] / php / mysql_tools.php

diff --git a/php/mysql_tools.php b/php/mysql_tools.php
index 918d6a9..9c1e1c7 100644 (file)
--- a/php/mysql_tools.php
+++ b/php/mysql_tools.php
@@ -2,14 +2,19 @@
 \r
 # voir : http://us2.php.net/manual/en/function.func-num-args.php\r
 \r
-function query($query, $a, $b, $c, $d, $e)\r
+# utiliser mysqli à la place :\r
+# $stmt = $mysqli->prepare("INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");\r
+# $stmt->bind_param('sssd', $code, $language, $official, $percent);\r
+function query($query)\r
 {\r
-   if ($a == null)\r
-      return mysql_query($query);\r
-   if ($b == null)\r
-      return mysql_query(sprintf($query,\r
-         is_string($a) ? mysql_real_escape_string($a) : $a\r
-      ));\r
+   $args = func_get_args();\r
+   foreach ($args as $i => $arg)\r
+      if (is_string($arg))\r
+         $args[$i] = mysql_real_escape_string($a);\r
+         \r
+   array_shift($query, $args);\r
+         \r
+   return mysql_query(call_user_func_array('sprintf', $args));\r
 }\r
 \r
 ?>
\ No newline at end of file