Administrace komentářů

Zdravim,

potrebujem radu ohladom jedneho mojho projektu. zacal som pred par rokmi programovat a vyslo to na PHP v kombinacii s MySQL + pouzivam apache pripadne ak to nahadzujem na RPI tak lighttpd. mam mensi problem a to v tom ako premigrovat klasicke Mysql na Mysqli ono to nie je nic hrozne vsak stale sa da pouzit neobjektovy mysqli zmeny su len vo funkciach minimalne, rozmyslam ale nad tym ci by nebolo lepsie prepisat vsetko do Postgresql. Celkovo PHP je dost meniaci sa jazyk, Mysql to uz je na mna moc kedze ten projekt je o trochu vecsi a ked uz si dat namahu tak nech to je nieco co ma prinos.

skusam spravit aj db wrapper kde si budem moct vybrat co a aku databazu budem pouzivat, zatial su to len zaciatky

// WARP
// DB WRAPPER
//
// 0 - Mysql
// 1 - Mysqli
// 2 - Postgresql

var $warp = 0;
var $con;

/*db_connect*/
public function warp_connect($host,$user,$pass) {
//return mysql_connect($host,$user,$pass);
switch ($this->warp) {
case 0:
return mysql_connect($host,$user,$pass);
break;
case 1:
$co = mysqli_connect($host,$user,$pass,$this->table);
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
return $co;
break;
default:
// postgree not implemented yet
break;
}
}

/*error*/
public function warp_error() {
//return mysql_error();
switch ($this->warp) {
case 0:
return mysql_error();
break;
case 1:
return mysqli_error($this->con);
break;
default:
// postgree not implemented yet
break;
}
}

/*query*/
public function warp_query($que) {
//return mysql_query($que);
switch ($this->warp) {
case 0:
return mysql_query($que);
break;
case 1:
return mysqli_query($this->con, $que);
break;
default:
// postgree not implemented yet
break;
}
}

/*num_fields*/
public function warp_num_fields($res) {
//return mysql_num_fields($res);
switch ($this->warp) {
case 0:
return mysql_num_fields($res);
break;
case 1:
return mysqli_num_fields($res);
break;
default:
// postgree not implemented yet
break;
}
}

/*num_fields*/
public function warp_num_rows($res) {
//return mysql_num_rows($res);
switch ($this->warp) {
case 0:
return mysql_num_rows($res);
break;
case 1:
return mysqli_num_rows($res);
break;
default:
// postgree not implemented yet
break;
}
}

/*fetch_assoc*/
public function warp_fetch_assoc($res) {
//return mysql_fetch_assoc($res);
switch ($this->warp) {
case 0:
return mysql_fetch_assoc($res);
break;
case 1:
return mysqli_fetch_assoc($res);
break;
default:
// postgree not implemented yet
break;
}
}

/*fetch_row*/
public function warp_fetch_row($res) {
//return mysql_fetch_row($res);
switch ($this->warp) {
case 0:
return mysql_fetch_row($res);
break;
case 1:
return mysqli_fetch_row($res);
break;
default:
// postgree not implemented yet
break;
}
}

/*select_db*/
public function warp_select_db($name) {
//return mysql_select_db($name);
switch ($this->warp) {
case 0:
return mysql_select_db($name);
break;
case 1:
return mysqli_select_db($this->con, $name);
break;
default:
// postgree not implemented yet
break;
}
}

/*real_escape_string*/
public function warp_real_escape_string($res) {
//return mysql_real_escape_string($res);
switch ($this->warp) {
case 0:
return mysql_real_escape_string($res);
break;
case 1:
return mysqli_real_escape_string($this->con, $res);
break;
default:
// postgree not implemented yet
break;
}
}