| yang paling gw benci kl disuruh perbaiki script database kl bentuknya begini
$sql=mysql_fetch_array(mysql_query("SELECT * FROM tabel_transaksi WHERE MONTH( tgl_transaksi ) = '$bulan' AND YEAR( tgl_transaksi ) = '$tahun'"));
kl dah nongol >> "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL..... repotkhan.. mending dipecah2 aja deh $sql="xxxxx"; $r=mysql_query($sql); $row=mysql_fetch_array($r);
en kl diperbaiki jadi pdo khan tinggal $sql="xxxxx"; $q=$pdo->query($sql);$hasil7 = $q->fetch(PDO::FETCH_ASSOC); |
|
| (PDO::FETCH_ASSOC) buat apa ? |
|
| (y)(y) (y) (y) (y) (y) |
|
| masih pada level ngamatin :v |
|
| fetch assoc dari 0. fetch array dari 1, itu menurut pemahaman ku |
|
| ow kalo PDO:: nya buat apa ? |
|
| masih level kecebong ... ngelamun aja liat nya.eheheh .. sabar gan rekan mu iya |
|
| Iya pernah nemu kayak gitu jadinya malah pusing baca scriptnya @@ |
|
| PDO di atas adalah class static.. sama seperti parameter ke 2 dalam mysql_fetch_array($res, {parameter kke 2} ) |
|
| saya masil level telor, jadi nanya nanya, biar netasnya jadi naga :v |
|
| PDO::FETCH_ASSOC>> agar hasilnya keluar pake nama saja gk termasuk hasil pake angka |
|
| ow iya lupa itu pake framework apa ? CI ? |
|
| bukan.. gk pake fw |
|
| trus tanda -> ? ato cuman pake OOP ? CMIIW |
|
| $pdo itu hasil deklarasi krn ini khan pake PDO |
|
| fetch(PDO::FETCH_ASSOC); << bru liat yg bgni? tuh buat apa yah ? |
|
| fetch_style Controls how the next row will be returned to the caller. This value must be one of the PDO::FETCH_* constants, defaulting to value of PDO::ATTR_DEFAULT_FETCH_MODE (which defaults to PDO::FETCH_BOTH). ◾ PDO::FETCH_ASSOC: returns an array indexed by column name as returned in your result set
◾ PDO::FETCH_BOTH (default): returns an array indexed by both column name and 0-indexed column number as returned in your result set
◾ PDO::FETCH_BOUND: returns TRUE and assigns the values of the columns in your result set to the PHP variables to which they were bound with the PDOStatement::bindColumn() method
◾ PDO::FETCH_CLASS: returns a new instance of the requested class, mapping the columns of the result set to named properties in the class. If fetch_style includes PDO::FETCH_CLASSTYPE (e.g. PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE) then the name of the class is determined from a value of the first column.
◾ PDO::FETCH_INTO: updates an existing instance of the requested class, mapping the columns of the result set to named properties in the class
◾ PDO::FETCH_LAZY: combines PDO::FETCH_BOTH and PDO::FETCH_OBJ, creating the object variable names as they are accessed
◾ PDO::FETCH_NUM: returns an array indexed by column number as returned in your result set, starting at column 0
◾ PDO::FETCH_OBJ: returns an anonymous object with property names that correspond to the column names returned in your result set |
|
| ada lg yg namanya cursor_orientation dan offset |
|
| uh ternyata masih banyak yang blm saya ketahui |
|
| pdo khan menangani lebih dari 1 database.. bahkan pdo tidak support hitung jumlah data yg di panggil aka count_rows |
|
| nubi mau nanya gan. maksudnya nggak support ngitung gimana ya? bukannya ada method rowCount() di class PDOStatement? kcuali klo query-nya pke mode unbuffered yg nggak bisa dihitung jumlah row-nya berapa |