| | 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 |
