Tolong pilih kategori sesuai, jenis posting (diskusi atau bukan) dan sertakan tag/topik yang sesuai seperti komputer, java, php, mysql, dll. Promosi atau posting tidak pada tempatnya akan kami hapus!
Class DBQuery untuk mempermudah query MySQL di PHP
Comments
Untuk melakukan query Get-Where<div class='geshi_syntax'><table><tr><td><div class='code'><pre class="php"><span class="re0">$query</span> <span class="sy0">=</span> <span class="re0">$this</span><span class="sy0">-></span><span class="me1">db</span><span class="sy0">-></span><span class="me1">get_where</span><span class="br0">(</span><span class="st_h">'mytable'</span><span class="sy0">,</span> <span class="kw3">array</span><span class="br0">(</span><span class="st_h">'id'</span> <span class="sy0">=></span> <span class="re0">$id</span><span class="br0">)</span><span class="sy0">,</span> <span class="re0">$limit</span><span class="sy0">,</span> <span class="re0">$offset</span><span class="br0">)</span><span class="sy0">;</span></pre></div></td></tr></table></div>
Ditambah lagi dengan metode Chaining<div class='geshi_syntax'><table><tr><td><div class='code'><pre class="php"><span class="re0">$this</span><span class="sy0">-></span><span class="me1">db</span><span class="sy0">-></span><span class="me1">select</span><span class="br0">(</span><span class="st_h">'title'</span><span class="br0">)</span><span class="sy0">-></span><span class="me1">from</span><span class="br0">(</span><span class="st_h">'mytable'</span><span class="br0">)</span><span class="sy0">-></span><span class="me1">where</span><span class="br0">(</span><span class="st_h">'id'</span><span class="sy0">,</span> <span class="re0">$id</span><span class="br0">)</span><span class="sy0">-></span><span class="me1">limit</span><span class="br0">(</span><span class="nu0">10</span><span class="sy0">,</span> <span class="nu0">20</span><span class="br0">)</span><span class="sy0">;</span></pre></div></td></tr></table></div>