private function ConnectionStringGenerator($driver, $host, $port, $database)
{
switch ((int) $driver) {
case cbSQLConnectVar::DB_MYSQL:
cbSQLConnectConfig::$driverDB = "mysql";
break;
case cbSQLConnectVar::DB_POSTGRE:
cbSQLConnectConfig::$driverDB = "psgre";
default:
cbSQLConnectConfig::$driverDB = "mysql";
break;
}
$connectionstring = sprintf("%s:host=%s;port=%d;dbname=%s", cbSQLConnectConfig::$driverDB, $host, $port, $database);
return $connectionstring;
}
public function SQLDelete($table, $idTable, $idValue)
{
$inst = cbSQLConnectConfig::CreatePDOInstance();
$query = sprintf("DELETE FROM %s WHERE %s = :value", $table, $idTable);
$stmt = $inst->prepare($query);
$stmt->bindParam(":value", $idValue);
$result = $stmt->execute();
$stmt->closeCursor();
$inst = null;
return $result;
}
