host = 'localhost';
$this->user = 'skch_fatima_lilia';
$this->pass = 'GmzibA1d';
$this->base_name = 'skch_fatima_lilia';
}
function Login ()
{
$this->conn = mysqli_connect($this->host, $this->user, $this->pass, $this->base_name);
if ($this->conn->connect_errno) {
echo "Failed to connect to MySQL: " . $this->conn->connect_error;
exit();
}
//$this->conn = mysqli_connect($this->host, $this->user, $this->pass) OR die("Brak połączenia z bazą; Proszę spróbowac za chwilę");
// mysqli_select_db($this->base_name, $this->conn);
// $sql="SET NAMES 'utf8'";
// $this->Insert($sql);
}
function Logoff ()
{
return(mysqli_close($this->conn));
}
function Take($sql)
{
$all = array();
$result = mysqli_query($this->conn, $sql) or die ("Proszę spróbowac za chwilę".mysqli_error());
$i = 0;
while ($row = mysqli_fetch_row($result) ) {
$all[$i] = $row;
$i++;
}
@mysqli_free_result($result);
return $all;
}
function Take_name($sql)
{
$all = array();
$result = mysqli_query($this->conn, $sql) or die ("Proszę spróbowac za chwilę".mysqli_error());
$i = 0;
while ($row = mysqli_fetch_array($result) ) {
$all[$i] = $row;
$i++;
}
@mysqli_free_result($result);
return $all;
}
function Insert ($sql)
{
mysqli_query($this->conn, $sql);
return mysqli_insert_id($this->conn);
}
function Update ($sql)
{
mysqli_query($this->conn, $sql);
}
function Delete ($sql)
{
mysqli_query($this->conn, $sql);
}
}
?>