Archive for 2013
Hallo,ketemu lagi dengan Yuuki,hari ini saya akan bahas 'Perbedaan MySQL dan SQLi'
Meskipun secara fungsi sama, 'mysql' dan 'mysqli' ternyata mempunyai ciri yang berbeda.
lalu apa sih perbedaan itu ? disini saya akan bahas..
Ekstensi 'mysql' adalah ekstensi asli yang didesain untuk mengizinkan script PHP berinteraksi dengan database MySQL. Ekstensi 'mysql' menyediakan fungsi prosedural dan dimaksudkan hanya untuk penggunaan versi MySQL 4.1.3 ke bawah. Ekstensi ini masih dapat didukung oleh versi MySQL 4.1.3 dan selanjutnya, tetapi tidak semua fitur didukung oleh server MySQL yang lebih baru. Dengan demikian, jika Anda menggunakan MySQL versi 4.1.3 atau setelahnya sangat direkomendasikan untuk menggunakan ekstensi 'mysqli'
Ekstensi 'mysqli' disebut juga sebagai ekstensi MySQL yang unjuk kerjanya ditingkatkan.Ekstensi 'mysqli' dikembangkan untuk memenuhi fitur-fitur baru yang ditemukan dalam sistem MySQL versi 4.1.3 dan setelahnya. Ekstensi 'mysqli' sudah disertakan pada PHP versi 5 dan setelahnya. Ekstensi 'mysqli' mendukung antarmuka berorientasi objek sekaligus antarmuka prosedural. Ekstensi 'mysqli' dibangun menggunakan PHP extension framework, yang kode sumbernya dapat ditemukan dalam direktori ext/mysqli
Keuntungan-keuntungan yang bisa diperoleh jika menggunakan ekstensi 'mysqli' :
- menyediakan antarmuka berorientasi objek
- mendukung prepared statements
- mendukung banyak statements (multiple statements)
- mendukung transaksi (transactions)
- kemampuan debugging yang lebih ditingkatkan
- dukungan server tertanam (embedded server)
Berikut adalah table perbedaan antara MySQL dan SQLi :
Performed by: ROOKiEZ is PUNK'D
Lyrics: SHiNNNOSUKE
Music composition: ROOKiEZ is PUNK'D
Music arrangement: ROOKiEZ is PUNK'D
Lyrics: SHiNNNOSUKE
Music composition: ROOKiEZ is PUNK'D
Music arrangement: ROOKiEZ is PUNK'D
Romaji :
nakidashisou na kao de ureu hikui sora
suru koto mo naku toki o kezuru
hakidasu ba no nai omoi o nomikonde
iradachi majiri no tsuba o haku
suru koto mo naku toki o kezuru
hakidasu ba no nai omoi o nomikonde
iradachi majiri no tsuba o haku
nanimokamo ga kowaresou na fuan daite asu ni obie
asatte bakka miteta tte kotae wa denai koto datte wakatteru
asatte bakka miteta tte kotae wa denai koto datte wakatteru
kagirinaku hirogaru masshiro na ashita ni nani o egaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
nayanderu jibun ga nanka dasakute
jitto shite ran nakute bakkure
yaritai koto sonna mon nai ze
okujou de kossori kuwaeru maisen
nanka tanoshiku nee kyou no saize
shinpaisou na me de miteru mai men
"naite nai ze" nante haite
tsuyogattemite mo maji tsurai ze
kayoinareta usugurai douro
yatto no omoi katta i-Pod
uwabe dake no usupperai RAP
nazeka omoi usuppera no BAG
yasashiku atatakai hazu no basho
omokurushikute akehanatsu mado
juuatsu ni oshitsubusaresou de
nigekonda itsumo no kouen
jitto shite ran nakute bakkure
yaritai koto sonna mon nai ze
okujou de kossori kuwaeru maisen
nanka tanoshiku nee kyou no saize
shinpaisou na me de miteru mai men
"naite nai ze" nante haite
tsuyogattemite mo maji tsurai ze
kayoinareta usugurai douro
yatto no omoi katta i-Pod
uwabe dake no usupperai RAP
nazeka omoi usuppera no BAG
yasashiku atatakai hazu no basho
omokurushikute akehanatsu mado
juuatsu ni oshitsubusaresou de
nigekonda itsumo no kouen
nanimokamo ga kowaresou na fuan daite asu ni obie
asatte bakka miteta tte kotae wa denai koto datte wakatteru
asatte bakka miteta tte kotae wa denai koto datte wakatteru
kagirinaku hirogaru masshiro na ashita ni nani o egaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
kagiriaru wazuka na toki no naka
hetakuso na jibun egake
ima wa mada sore de ii
hetakuso na jibun egake
ima wa mada sore de ii
kagirinaku hirogaru masshiro na ashita ni nani o egaku
genjitsu ga shimeyuku makkura na ashita ni nani o egaku
mogakikagayaku
genjitsu ga shimeyuku makkura na ashita ni nani o egaku
mogakikagayaku
kagirinaku hirogaru masshiro na ashita ni nani o egaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
genjitsu ga someyuku makkura na ashita ni nani o egaku
mogakikagayaku
English Translate :
The low sky grieves with a face that's about to cry
Without ever doing so, it shaves off a moment
Swallowing the thoughts with no place to be vomited
I spit them out, mixed with my irritation
Without ever doing so, it shaves off a moment
Swallowing the thoughts with no place to be vomited
I spit them out, mixed with my irritation
Fearing a tomorrow where I embrace the anxiety that everything's about to shatter
And looking only at the day after tomorrow won't bring me an answer--I know that
And looking only at the day after tomorrow won't bring me an answer--I know that
What will I draw on the tomorrow that spreads infinitely, pure white?
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
It's so lame for me to fret
And I refuse to sit still as I play dumb
There's nothing at all I want to do
I stealthily hold a cigarette in my mouth on the rooftop
Somehow, being at Saizeriya today isn't any fun
I'm watching my main man with worried eyes
Even if I lie, "I ain't crying!"
And try to act tough, it seriously hurts
I'm used to commuting through a dim highway
The i-Pod I bought after a huge hassle
Shallow rap that's got nothing more than a shiny surface
A flimsy bag that's heavy for some reason
The place that should be pleasantly warm
Is oppressive, and I throw open a window
I'm about to be flattened by heavy pressure
In the usual park that I run away into
And I refuse to sit still as I play dumb
There's nothing at all I want to do
I stealthily hold a cigarette in my mouth on the rooftop
Somehow, being at Saizeriya today isn't any fun
I'm watching my main man with worried eyes
Even if I lie, "I ain't crying!"
And try to act tough, it seriously hurts
I'm used to commuting through a dim highway
The i-Pod I bought after a huge hassle
Shallow rap that's got nothing more than a shiny surface
A flimsy bag that's heavy for some reason
The place that should be pleasantly warm
Is oppressive, and I throw open a window
I'm about to be flattened by heavy pressure
In the usual park that I run away into
Fearing a tomorrow where I embrace the anxiety that everything's about to shatter
And looking only at the day after tomorrow won't bring me an answer--I know that
And looking only at the day after tomorrow won't bring me an answer--I know that
What will I draw on the tomorrow that spreads infinitely, pure white?
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
Draw a crappy-looking sketch of yourself
Within a limited, cramped amount of time
Right now, I'm still fine with that
Within a limited, cramped amount of time
Right now, I'm still fine with that
What will I draw on the tomorrow that spreads infinitely, pure white?
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
What will I draw on the tomorrow that spreads infinitely, pure white?
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
What will I draw on the tomorrow that reality stained pure black?
I struggle and shine
Kanji :
泣き出しそうな表\情(かお)で憂う低い空
する事もなく時間(とき)を削る
吐き出す場のない思いを飲み込んで
苛立ち混じりの唾を吐く
何もかもが壊れそうな不安抱いて明日に怯え
明後日ばっか見てたって答えは出ないことだってわかってる
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
悩んでる自分がなんかダサくて
じっとしてらんなくてバックレ
やりたい事そんなもんないぜ
屋上でこっそり咥えるマイセン
なんか楽しくねえ今日のサイゼ
心配そうな目で見てるマイメン
「泣いてないぜ」なんて吐いて
強がってみてもマジ辛いぜ
通いなれた薄暗い道路
やっとの思い買った i-Pod
上辺だけの薄っぺらい RAP
何故か重い薄っぺらの BAG
優しく暖かいはずの場所
重苦しくて開け放つ窓
重圧に押し潰されそうで
逃げ込んだいつもの公園
何もかもが壊れそうな不安抱いて明日に怯え
明後日ばっか見てたって答えは出ないことだってわかってる
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
限りある僅かな時の中
ヘタクソ\な自分描け
今はまだそれでいい
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
する事もなく時間(とき)を削る
吐き出す場のない思いを飲み込んで
苛立ち混じりの唾を吐く
何もかもが壊れそうな不安抱いて明日に怯え
明後日ばっか見てたって答えは出ないことだってわかってる
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
悩んでる自分がなんかダサくて
じっとしてらんなくてバックレ
やりたい事そんなもんないぜ
屋上でこっそり咥えるマイセン
なんか楽しくねえ今日のサイゼ
心配そうな目で見てるマイメン
「泣いてないぜ」なんて吐いて
強がってみてもマジ辛いぜ
通いなれた薄暗い道路
やっとの思い買った i-Pod
上辺だけの薄っぺらい RAP
何故か重い薄っぺらの BAG
優しく暖かいはずの場所
重苦しくて開け放つ窓
重圧に押し潰されそうで
逃げ込んだいつもの公園
何もかもが壊れそうな不安抱いて明日に怯え
明後日ばっか見てたって答えは出ないことだってわかってる
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
限りある僅かな時の中
ヘタクソ\な自分描け
今はまだそれでいい
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
限りなく広がる真っ白な明日に何を描く
現実が染め行く真っ暗な明日に何を描く
もがき輝く
