Kamis, 14 November 2013

PHP Indonesia - Facebook: [ask] malem mas, mau nanya nih. kasusnya :: say...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Host Unlimited Domains

Unlimited Domains, Unlimited Disk Space and Unlimited Transfer For One Low Price.
From our sponsors
[ask] malem mas, mau nanya nih. kasusnya :: say...
Nov 14th 2013, 12:10, by Anshar Firman Haryadi

Anshar Firman Haryadi 12:10pm Nov 14
[ask]

malem mas,
mau nanya nih.
kasusnya ::

saya mau cari judul berita, yang mana keywordnya mengandung tanda ' (kutip), misal
sa'ya, nah saat di cari.

muncul error di phpnya begini,

pertanyaannya : gimana caranya agar tanda ' (kutip) itu diabaikan oleh sql nya ?

makasih mas :D

Wirpan Nur Eka Putra 12:18pm Nov 14
pake mysql? inputnya di-escape ga? (mysql_real_escape_string)

Anshar Firman Haryadi 12:26pm Nov 14
sekarang udah saya tambah jadi gini,

$nama = $_POST['nama'];
$nama1 = mysql_real_escape_string($nama); $nama2 = stripslashes($nama1);

nah, kok hasil pencariannya gak keluar y ?

$sql = "SELECT * from pasien where Nama='$nama2';
$result = mysql_query($sql);
$no=0;
while ($buff = mysql_fetch_array($result_wisata)) {
$no++;
<?php echo $buff['Nama']; ?>
};
mysql_close($link);

Wirpan Nur Eka Putra 12:37pm Nov 14
knp pake stripslashes? coba langsung aja $nama = mysql_real_escape_string($_POST['nama']) bisa ga?

Anshar Firman Haryadi 12:38pm Nov 14
sip, thanks mas,
worked :D

Anshar Firman Haryadi 12:47pm Nov 14
stripslashes biar di phpnya tampil sesual sa'ya mas. kalo gak pake itu hasilnya sa\'ya

Wirpan Nur Eka Putra 12:55pm Nov 14
hmm, itu kayanya magic quotes aktif diserver

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar