public function select(string $table, $where = false, $column = false, $operator = false, $logic = false, $orderBy = false, $orderOpt = false, $limit = false, $limitStart = false){ $sql = "SELECT"; if($column) { if(is_array($column)) $sql .= " ".implode(", ", $column)." FROM"; else $sql .= " $column FROM"; } else $sql .= " * FROM"; $sql .= " $table"; if($where) { $sql .= " WHERE"; if(is_array($where)) { $where_keys = array_keys($where); $where_values = array_values($where); $i = 0; foreach($where_keys as $value) { if(isset($operator[$i])) $opt = $operator[$i]; else $opt = "="; if(isset($logic[$i])) $log = $logic[$i]; else $log = " and"; if($i < count($where_keys)-1) $sql .= " ".$value." ".$opt." :".$value." ".$log; else $sql .= " ".$value." ".$opt." :".$value; $i++; } } } if($orderBy && is_string($orderBy)) { if($orderOpt) $oOpt = $orderOpt; else $oOpt = "DESC"; $sql .= " ORDER BY $orderBy $oOpt"; } if($limit) { if($limitStart) $sql .= " LIMIT $limit, $limitStart"; else $sql .= " LIMIT $limit"; } $query = self::$connection; $query = $query->prepare($sql); if($where) { foreach($where as $key=>$value) { $query->bindValue("$key", $value); } } $this->query = $query; $query->execute();}Kendi yazdığım Database sınıfının select sorgu metodu. Tam sınıfı maalesef veremiyorum. Okuyabilirseniz size yol gösterecektir.