public function GetSpecifiedData($tableName, $atributeName, $value)
{
$sqlConntect = new mysqli(SERVER, USERNAME, PASSWORD, DATABASE);
if(!mysqli_connect_errno())
{
$atributes = null;
foreach ($atributeName as $atributeTemp)
$atributes .= sprintf("%s,", $atributeTemp);
$atributes = substr($atributes, 0, -1);
$values = null;
if($value != null)
{
foreach ($value as $valueTemp)
$values .= sprintf("'%s', ", $valueTemp);
$values = substr($values, 0, -2);
}
$sqlCommand = null;
if($atributeName != null && $value != null)
$sqlCommand = sprintf("SELECT %s FROM %s WHERE %s", $atributes, $tableName, $values);
if($atributeName == null && $value != null)
$sqlCommand = sprintf("SELECT * FROM %s WHERE %s", $tableName, $values);
if($atributeName != null && $value == null)
$sqlCommand = sprintf("SELECT %s FROM %s", $atributes, $tableName);
if($atributeName == null && $value == null)
$sqlCommand = sprintf("SELECT * FROM %s", $tableName);
if($sqlCommand != null)
{
$output = array();
if($sqlResult = $sqlConntect->query($sqlCommand))
{
while ($sqlRow = $sqlResult->fetch_row()) {
$output[] = $sqlRow;
}
}
return $output;
}
}
else
echo sprintf("Connection to Database Faild. Message: %s", mysqli_connect_error());
return null;
}
