PHP Indonesia - Facebook: misi gan.. ini errornya dimana ya?? ga bisa updat...

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/

misi gan.. ini errornya dimana ya?? ga bisa updat... Aug 7th 2013, 02:27, by Erwin Lukas Erwin Lukas 2:27am Aug 7 misi gan.. ini errornya dimana ya?? ga bisa update data.. Warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "" at character 97 in C:\ms4w\ <?php include "koneksi.php"; $id = pg_escape_string($_POST['isi']); $data1 = pg_escape_string($_POST['data1']); $data2 = pg_escape_string($_POST['data2']); $data3 = pg_escape_string($_POST['data3']); $data4 = pg_escape_string($_POST['data4']); $data4 = pg_escape_string($_POST['data5']); $query = "UPDATE coba1 SET data1='".$data1."',data2='".$data2."',data3='".$data3."',data4='".$data4."',data5='".$data5."' WHERE id='".$id."' "; $result = pg_query($konek,$query); if(!$result){ echo "Masukan inputan yang benar..."; } else{ printf("Data telah disimpan<br><br>"); } Muhammad Saleh Hafizh Fajri 2:30am Aug 7 $data4 = pg_escape_string($_POST['data4']); $data4 = pg_escape_string($_POST['data5']); <= data4 apa data5 nama variabelnya???? $query = "UPDATE coba1 SET data1='".$data1."',data2='".$data2."',data3='".$data3."',data4='".$data4."',data5='".$data5."' WHERE id='".$id."' "; <== data5 dipanggl, tapi pas ngambil data dari post g ada defenisi variabel $data5 Erwin Lukas 2:36am Aug 7 eh salah.. benernya ini.. $data4 = pg_escape_string($_POST['data4']); $data5 = pg_escape_string($_POST['data5']); $query = "UPDATE coba1 SET data1='".$data1."',data2='".$data2."',data3='".$data3."',data4='".$data4."',data5='".$data5."' WHERE id='".$id."' "; tp kok masih eror ya?? _query(): Query failed: ERROR: invalid input syntax for integer: "" at character 103 Muhammad Saleh Hafizh Fajri 2:38am Aug 7 id itu integer bukan di database? Erwin Lukas 2:39am Aug 7 id itu integer.. jadi bgmn?? Muhammad Saleh Hafizh Fajri 2:40am Aug 7 $id = pg_escape_string($_POST['isi']); <== isi ini datany apa? Erwin Lukas 2:41am Aug 7 itu isinya id dari form sebelumnya.. Muhammad Saleh Hafizh Fajri 2:43am Aug 7 bukan tanya asal nya dari form mana tapi tanya isinya apa?string? integer? kalau string? ya g cocok dengan tipe data kamu didatabase mas Erwin Lukas 2:44am Aug 7 oh.. heheh... itu di database typenya serial / integer.. Muhammad Saleh Hafizh Fajri 2:46am Aug 7 tipe bisa 2 gitu? serial serial , integer integer Erwin Lukas 2:48am Aug 7 bukan.. tipe itu serial ga bisa.. aku ganti integer juga tidak bisa mas.. Muhammad Saleh Hafizh Fajri 2:49am Aug 7 wah ra mudeng aku mas id itu biasanya integer sih, kalau isi itu dari form sebelah itu string, bearti kamu tambahin aja mas 1 field namanya isi di tabelnya Erwin Lukas 2:53am Aug 7 heheh.. udah aku coba barusan.. berhasil.. tp ga masuk ke db.. brarti?? Muhammad Saleh Hafizh Fajri 2:56am Aug 7 querynya dibenerin lagi :)

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