php DBHost localhost DBUser root DBPassword DBName lv DBSimpleUser Use

<?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'];

}

?>