Merhabalar, kullandığınız sorguyu buradan iletebilirseniz daha iyi olur.
public function GetData($table, $whereHead = "", $whereMain = "", $ordeby = "ORDER BY Id ASC", $limit="")
{
try
{
$sql = "SELECT * FROM ".$table;
if(!empty($whereHead) && !empty($whereMain))
{
$sql.=" ".$whereHead;
if(!empty($ordeby)){ $sql.=" ".$ordeby; }
if(!empty($limit)){ $sql.=" LIMIT ".$limit; }
$run=$this->connection->prepare($sql);
$return=$run->execute($whereMain);
$data=$run->fetchAll(PDO::FETCH_ASSOC);
}
else
{
if(!empty($ordeby)){ $sql.=" ".$ordeby; }
if(!empty($limit)){ $sql.=" LIMIT ".$limit; }
$data=$this->connection->query($sql, PDO::FETCH_ASSOC);
}
if($data!=false && !empty($data))
{
$datas = array();
foreach ($data as $info)
{
$datas[] = $info;
}
return $datas;
}
else{
return false;
}
}
catch (PDOException $e)
{
echo $e->getMessage();
exit();
}
} $data=$VT->GetData("categories","where Id=?",array($Id));