class ODB{
private $hostname;
private $user;
private $password;
private $db;
private $link;
private $error;
private $debug;
###LOCAL
public function __construct($debug){
$this->debug = $debug;
if($debug){
print ('Konstruktor ODB
');
}
$this->hostname = "rdbms.strato.de"; // Name des Rechners, auf dem MySQL laeuft
$user = "U920758"; // Benutzername
$password = "data4girotonne"; // Passwort
$db = "DB920758";
$this->link = mysqli_connect($this->hostname, $this->user, $this->password, $this->db) or die("Could not connect 1 : " . mysqli_connect_error());
mysqli_query($this->link, "SET NAMES utf8");
if($debug){
print ('Link = ' . $this->link . '
');
}
}
public function query($q, $param = "", $count = ""){
$res = mysqli_query($this->link, $q);
$re = array();
$z = 0;
if($param == "assoc"){
while($row = mysqli_fetch_array($res, MYSQLI_ASSOC)){
if($count == 1){
foreach ($row as $key => $value){
$re[$key] = $value;
}
}
elseif($count == 0){
foreach ($row as $key => $value){
$re[$z][$key] = $value;
}
$z++;
}
}
}
elseif($param == "num"){
while($row = mysqli_fetch_array($res, MYSQLI_NUM)){
if($count == 1){
foreach ($row as $key => $value){
$re[$key] = $value;
}
}
elseif($count == 0){
foreach ($row as $key => $value){
$re[$z][$key] = $value;
}
$z++;
}
}
}
elseif($param == "both"){
while($row = mysqli_fetch_array($res, MYSQLI_BOTH)){
if($count == 1){
foreach ($row as $key => $value){
$re[$key] = $value;
}
}
elseif($count == 0){
foreach ($row as $key => $value){
$re[$z][$key] = $value;
}
$z++;
}
}
}
return $re;
}
}