<?php
$DBHost = "localhost";
$DBUser = "root";
$DBPassword = '';
$DBName = "lv";
$DBSimpleUser = 'User';
$DBSimpleUserPassword = "";
$DBAdmin = "adminUser";
$DBAdminPassword = "IAMTHELAW";
$Link;
session_start();
function DBsearch($getRequest)
{
global $Link;
$arrayForSearch = array_keys($getRequest);
$values = $getRequest;
$searchOption = "";
$valueOption = 'WHERE ';
foreach((array)$arrayForSearch as &$value )
{
if($value=="search")
{
break;
}
if(trim($values[$value])!="")
{
$searchOption .= $value.",";
$valueOption .= $value."="."'".$values[$value]."'"." AND ";
}
}
if($valueOption=='WHERE ')
{
$valueOption="";
}
else
{
$valueOption = mb_substr(trim($valueOption),0,-3);
}
if($searchOption=="")
{
$searchOption ="*";
}
else
{
$searchOption = mb_substr(trim($searchOption),0,-1);
}
if(isset($values['option'])=="all")
{
if($values['option']=="all")
{
$searchOption="*";
}
}
$query = "SELECT ".$searchOption." FROM people ".$valueOption ;
$Result = mysqli_query($_SESSION['Link'],trim($query),1);
if($Result)
{
$RowArray=array_keys(mysqli_fetch_assoc($Result));
$resulstText = "<table><tr>";
foreach($RowArray as &$rowName)
{
$resulstText .= "<th>".$rowName."</th>";
}
$resulstText .= "</tr>";
while($Rows = mysqli_fetch_array($Result))
{
$resulstText .="<tr>";
foreach($RowArray as &$rowName)
{
$resulstText .= "<th>".$Rows[$rowName]."</th>";
}
$resulstText .="</tr>";
}
$resulstText .= "</table>";
return $resulstText;
}
else
{
return "Данных нэт". mysqli_error($_SESSION['Link']);
}
}
function DBChange($getRequest)
{
global $Link;
$arrayForSearch = array_keys($getRequest);
$values = $getRequest;
$setQuery = "SET ";
$setOption = array ();
$condiitonQuery = 'WHERE ';
$condiitonOption = array ();
foreach((array)$arrayForSearch as &$value )
{
if($value=="change")
{
break;
}
if(substr($value, -1) == 1)
{
$condiitonOption[mb_substr(trim($value),0,-1)]=$values[$value];
$condiitonQuery .= mb_substr(trim($value),0,-1)."='".$values[$value]."' AND ";
}
else
{
if($values[$value]=="")
{
$values[$value]=NULL;
}
$setOption [mb_substr(trim($value),0,-1)]=$values[$value];
$setQuery .= mb_substr(trim($value),0,-1)."='".$values[$value]."',";
}
}
$condiitonQuery = mb_substr(trim($condiitonQuery),0,-3);
$setQuery = mb_substr(trim($setQuery),0,-1);
mysqli_query($_SESSION['Link'],trim("UPDATE people ".$setQuery." ".$condiitonQuery),1);
}
function DBAdd($getRequest)
{
$arrayForSearch = array_keys($getRequest);
$values = $getRequest;
$insertOption = "(";
$valueOption = 'VALUES ( ';
foreach((array)$arrayForSearch as &$value )
{
if($value=="insert")
{
break;
}
if(trim($values[$value])!="")
{
$insertOption .= $value.", ";
$valueOption .= "'".$values[$value]."',"." ";
}
}
if($valueOption=='VALUES ( ')
{
$valueOption="";
}
else
{
$valueOption = mb_substr(trim($valueOption),0,-1);
$valueOption.= ')';
}
if($insertOption=="(")
{
$insertOption = "*";
}
else
{
$insertOption = mb_substr(trim($insertOption),0,-1);
$insertOption .=')';
}
$query = "INSERT INTO people".($insertOption)." ".$valueOption;
mysqli_query($_SESSION['Link'],trim($query),1);
}
function MakeDataBase()
{
global $DBHost;
global $DBUser;
global $DBPassword;
global $DBSimpleUser ;
global $DBSimpleUserPassword ;
global $DBAdmin ;
global $DBAdminPassword ;
global $Link;
global $DBName;
$Link = mysqli_connect($DBHost, $DBUser, $DBPassword);
$Query = "CREATE DATABASE IF NOT EXISTS $DBName";
mysqli_query($Link,$Query);
mysqli_select_db( $Link,$DBName);
$Query = "CREATE TABLE IF NOT EXISTS
people (id INT(2) PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100), Phone VARCHAR(20),Adr VARCHAR(100))";
mysqli_query( $Link,$Query);
$Query = "CREATE USER $DBAdmin@localhost IDENTIFIED BY '$DBAdminPassword'";
mysqli_query($Link,$Query);
$Query = "GRANT ALL PRIVILEGES ON $DBName.* TO $DBAdmin@localhost;";
mysqli_query( $Link,$Query);
$Query = "FLUSH PRIVILEGES;";
mysqli_query($Link,$Query);
$Query = "CREATE USER $DBSimpleUser@localhost;";
mysqli_query($Link,$Query);
$Query = "GRANT SELECT ON $DBName.* TO $DBSimpleUser@localhost;";
mysqli_query( $Link,$Query);
mysqli_close($Link) ;
}
function ConnectToDataBase($getRequest)
{
global $DBName;
global $Link;
global $DBHost;
$_SESSION['Link'] = mysqli_connect($DBHost, $getRequest['user'], $getRequest['passwd'],$DBName) ;
mysqli_select_db( $_SESSION['Link'],$DBName);
$Link = $_SESSION['Link'];
}
?>