$query = $db_con->prepare("select * from malzeme where malzeme_birimid=2 order by malzeme_adi ASC"); $query->execute(); if ($query->rowCount() > 0){ $select = $query->fetchAll(PDO::FETCH_ASSOC); $json_data = json_encode($select); }