FQL varlık nesneleri üzerinde sorgulama yapmanıza olanak tanıyan SQL e benzer bir sorgulama dilidir. FQL Sorguları PHP Faces Framework tarfından doğal SQL sözcüklerine dönüştürülür.
SELECT İfadesi
SELECT takmaisim FROM sıfıfadı takmaisim WHERE having vb..
Örnekler
SELECT b from Blog b
SELECT c from Categories c
SELECT b from Blog b WHERE bi.id = 1
SELECT b from Blog b WHERE bi.id = 1 and b.name=‘www’
SELECT b from Blog b limit 0,5
SELECT c from Categories c GROUP BY c.id HAVING AVG(c.id) > 1
entity manager ile beraber FQL kullanımı
$query= $this->em->createQuery("SELECT b from Blog b WHERE b.comment.id >1"); $query->execute(); $blogs = $query->getResultList();
FQL ile birlikte SQL fonksiyonları kullanımı
SELECT COUNT(b.id) FROM Blog b
SELECT MAX(b.id) FROM Blog b
entity manager ile beraber kullanımı
$query= $this->em->createQuery("SELECT count(b.id) from bir b"); $query->execute(); echo "count =" .$query->getSingle()."<br>";
İç içe geçmiş alt sorgular
<span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">SELECT b FROM </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 0, 102); letter-spacing: -0.75pt;">Blog</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> b WHERE b</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">coment</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">id </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">=(</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">SELECT MAX</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">(</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">c</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">id</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">)</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> FROM </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 0, 102); letter-spacing: -0.75pt;">Comment</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> c</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">)</span><span style="font-size: 10pt; font-family: "Courier New"; letter-spacing: -0.75pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="border: medium none ; padding: 0in;"><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">SELECT o FROM </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 0, 102); letter-spacing: -0.75pt;">Object</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> o WHERE o</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">id </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">=</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">(</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">SELECT AVG</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">(</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">i</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">id</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">)</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> FROM </span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 0, 102); letter-spacing: -0.75pt;">Object</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> i</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">)</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;"> OERDER BY o</span><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(102, 102, 0); letter-spacing: -0.75pt;">.</span><span style="font-size: 10pt; font-family: "Courier New"; color: black; letter-spacing: -0.75pt;">name</span>
SELECT b FROM Blog b WHERE b.coment.id =(SELECT MAX(c.id) FROM Comment c)
SELECT o FROM Object o WHERE o.id = (SELECT AVG(i.id) FROM Object i) ORDER BY o.name
