global $db; //$q = "CREATE TABLE $name (id INT(9) UNSIGNED PRIMARY KEY NOT NULL"; $db->rawQuery("DROP TABLE IF EXISTS {$name}"); $q = "CREATE TABLE {$name} (id INT(9) UNSIGNED PRIMARY KEY AUTO_INCREMENT"; foreach ($data as $k => $v) { $q .= ", {$k} {$v}"; } $q .= ")"; $db->rawQuery($q); } // rawQuery test foreach ($tables as $name => $fields) { $db->rawQuery("DROP TABLE " . $prefix . $name); createTable($prefix . $name, $fields); } if (!$db->ping()) { echo "db is not up"; exit; } // insert test with autoincrement foreach ($data as $name => $datas) { foreach ($datas as $d) { $id = $db->insert($name, $d); if ($id) { $d['id'] = $id; } else { echo "failed to insert: " . $db->getLastQuery() . "\n" . $db->getLastError(); exit; } } }