PHP db_manager::db_result_to_array Examples

Example #1

File: db_manager.php Project: justquizz/web

 public function getTestsByCategory($id_category)
 {
     $query1 = "SELECT table_name FROM categories WHERE id='{$id_category}'";
     $result1 = mysql_query($query1);
     $row = mysql_fetch_row($result1);
     $table_name = $row[0];
     $query2 = "SELECT * FROM {$table_name}";
     $result2 = mysql_query($query2);
     $resultToArray = db_manager::db_result_to_array($result2);
     //print_r($resultToArray);
     $xml = db_manager::makeTestsXmlString($resultToArray);
     return $xml;
 }