".$query."->".(microtime(true)-$time)." milisegundos
"; return $ret; } /** Fetch array from query */ function dbw_fetch_array($conn,$result,$typearray = NULL){ if ($result == false || $result == NULL){return false;} switch ($conn[1]){ case "mysqli": if ($typearray == NULL || $typearray == "BOTH"){return mysqli_fetch_array($result);} if ($typearray == "ASSOC"){return mysqli_fetch_array($result,MYSQLI_ASSOC);} if ($typearray == "NUM"){return mysqli_fetch_array($result,MYSQLI_NUM);} break; case "sqlite": if ($typearray == NULL || $typearray == "BOTH"){return $result->fetchArray();} if ($typearray == "ASSOC"){return $result->fetchArray(SQLITE3_ASSOC);} if ($typearray == "NUM"){return $result->fetchArray(SQLITE3_NUM);} break; case "PgSQL": if ($typearray == NULL || $typearray == "BOTH"){return pg_fetch_array($result);} if ($typearray == "ASSOC"){return pg_fetch_array($result,NULL,PGSQL_ASSOC);} if ($typearray == "NUM"){return pg_fetch_array($result,NULL,PGSQL_NUM);} break; } } /** Make query and fetch array */ function dbw_query_fetch_array($conn,$query){ $time = microtime(true); switch ($conn[1]){ case "mysqli": $result = mysqli_query($conn[0],$query); if (!$result){return false;} $ret = mysqli_fetch_array($result); break; case "sqlite": $result = $conn[0]->query($query); if (!$result){return false;} $ret = $result->fetchArray(); break; case "PgSQL": $result = pg_query($query); if (!$result){return false;} $ret = pg_fetch_array($result); break; } //echo "".$query."->".(microtime(true)-$time)." milisegundos
"; return $ret; } /** Goes a query to $row. $row starts in 0 as first row as if not specified */ function dbw_query_goto($conn,$result,$row = 0){ switch ($conn[1]){ case "mysqli": mysqli_data_seek($result,$row); break; case "sqlite": $result->reset(); $count = 0; while ($count != $row){ $result->fetchArray(); } break; case "PgSQL": pg_result_seek($result, $row); break; } } /** Does multiple querys in one command * The erasebuffer command, in mysqli is neccesary if its only a insert for avoid problems in next querys */ function dbw_multi_query($conn,$query,$erasebuffer = 0){ switch ($conn[1]){ case "mysqli": mysqli_multi_query($conn[0],$query); if ($erasebuffer){ while(mysqli_next_result($conn[0])){;} //Erase multiquery output for avoid error in next query } break; case "sqlite": $conn[0]->exec($query); break; case "PgSQL": $null = pg_query($query); break; } } /** Returns the lastest Insert ID */ function dbw_last_id($conn){ switch ($conn[1]){ case "mysqli": return mysqli_insert_id($conn[0]); case "sqlite": return $conn[0]->lastInsertRowID(); case "PgSQL": return pg_fetch_array(pg_query("SELECT lastval();"))[0]; } } /** Returns number of results */ function dbw_num_rows($conn,$result){ switch ($conn[1]){ case "mysqli": return mysqli_num_rows($result); case "sqlite": //Emulating num_rows. Is faster to use a COUNT(*), but for make it work... $count=0; $result->reset(); //Reset pointer while($row = $result->fetchArray(SQLITE3_ASSOC)){ $count++; } $result->reset(); //Reset pointer return $count; case "PgSQL": return pg_num_rows ($result); } } /** Escapes conflictive chars for inserting into database */ function dbw_free_result($conn,$result){ switch ($conn[1]){ case "mysqli": return mysqli_free_result($string); case "sqlite": return NULL; //Not neccesary I think case "PgSQL": return NULL; //¿? } } /** Close connection */ function dbw_close($conn){ switch ($conn[1]){ case "mysqli": mysqli_close($conn[0]); break; case "sqlite": $conn[0]->close(); break; case "PgSQL": pg_close($conn[0]); break; } } /** Some internal wrappers for functions that are equal to other with arguments */ function dbw_fetch_assoc($conn,$result){return dbw_fetch_array($conn,$result,"ASSOC");} function dbw_fetch_row($conn,$result){return dbw_fetch_array($conn,$result,"NUM");} function dbw_data_seek($conn,$result){return dbw_query_goto($conn,$result,$row = 0);} function dbw_result_seek($conn,$result){return dbw_query_goto($conn,$result,$row = 0);} function dbw_insert_id($conn){return dbw_last_id($conn);} ?>