Ok Bpk terima kasih, saya coba dulu. Thank's.
________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Tue, January 19, 2010 7:15:05 AM Subject: Re: [belajar-access] PHP-Access kl sy tidak salah itu karena data yang anda masukkan sudah ada, jadi terjadi duplikasi data. semoga membantu salam Nurhasim --- On Mon, 1/18/10, Belajar Office <belajaroffice@ ymail.com> wrote: >From: Belajar Office <belajaroffice@ ymail.com> >Subject: Re: [belajar-access] PHP-Access >To: belajar-access@ yahoogroups. com >Date: Monday, January 18, 2010, 3:02 AM > > > >Terima kasih Pak, bila saya run script test.php sbb: > ><html> ><body><?php >$conn=odbc_connect( 'dbPersonal' ,'',''); >if (!$conn) >{exit("Connection Failed: " . $conn);} >$sql="SELECT * FROM EntryPersonal" ; >$rs=odbc_exec( $conn,$sql) ; >if (!$rs) >{exit("Error in SQL");} >echo "<table><tr>"; >echo "<th>Login Name</th>"; >echo "<th>Password</th></tr>"; >while (odbc_fetch_ row($rs)) >{ >$loginname=odbc_ result($rs, "loginname" ); >$password=odbc_ result($rs, "Password" ); >echo "<tr><td>$loginname</td>"; >echo "<td>$password</td></tr>"; >} >odbc_close($ conn); >echo "</table>"; >?></body> ></html> > >Muncul hasilnya: > >Login Name >Password >abidin bidinbidun >alfian alfian >rina rina >riska riska >teguh teguh >upik noviruna >beny beny >thoriq thoriq >nurhasim hasan admin > Namun saya coba run file Bpk, muncul pesan error sbb: >Data Anda Telah Tersimpan >Belajar OfficeInput data tidak berhasil >Saya simpan seluruh filenya di C:\Inetpub\wwwroot\ php >Kemudian sebelumnya saya install dahulu FastCGI & PHP 5.3.1. Barangkali Bpk >mengetahui penyebabnya, mohon bantuan solusinya. >Thank's. > > > > > ________________________________ From: "hasimnurhsm@ yahoo.com" <hasimnurhsm@ yahoo.com> >To: belajar-access@ yahoogroups. com >Sent: Mon, January 18, 2010 2:56:29 PM >Subject: Re: [belajar-access] PHP-Access > > >ini file attach yang sudah saya edit dan dicoba di komputer bisa.. >mudah2an membantu > >salam > > >Nurhasim > >--- On Sun, 1/17/10, hasimnurhsm@ yahoo.com <hasimnurhsm@ yahoo.com> wrote: > > >>From: hasimnurhsm@ yahoo.com <hasimnurhsm@ yahoo.com> >>Subject: Re: [belajar-access] PHP-Access >>To: belajar-access@ yahoogroups. com >>Date: Sunday, January 17, 2010, 11:33 PM >> >> >> >>silahkan dicoba mudah2an membantu, berikut sy tambahkan sedikit kode lagi, >>$_POST untuk mengambil nilai dari form sesuaikan nilai methode di formnya, >>dan [txtloginname] sesuaikan dgn penamaan diformnya juga. >> >><?php >>$koneksi = odbc_connect( "dbPersonal" ,"",""); >> >>$txtloginname = $_POST[txtloginname ]; >>$$txtpassword = $_POST[txtpassword] ; >>$txtemail = $_POST[txtemail] ; >> >>if ($koneksi) { >> $tampil = odbc_exec($koneksi, "insert into entrypersonal( loginname, >> password, email) values ('".$txtloginname. "', '".$txtpassword.. "', >>'".$txtemail. "')"); >> if ($tampil) { >> echo "Input data berhasil"; >> } else { >> echo "Input data tidak berhasil"; >> } >>} else { >> echo "Database tidak ditemukan"; >>} >>odbc_close($ koneksi); >>?> >> >>salam >> >> >>Nurhasim >> >>--- On Sun, 1/17/10, erna yanti <erna_a...@yahoo. . com> wrote: >> >> >>>From: erna yanti <erna_a...@yahoo. com> >>>Subject: [belajar-access] PHP-Access >>>To: "belajar access" <belajar-access@ yahoogroups. com> >>>Date: Sunday, January 17, 2010, 8:41 PM >>> >>> >>> >>>hai master, >>> >>>toong dong diliat scrip ini apa masalahnya, koq data yang diinput ga bisa di >>>insert ke Tabel entrypersonal ke personal.mdb. >>> >>><? >>>$koneksi = odbc_connect( "dbPersonal" ," "," "); >>>if ($koneksi) { >>> $tampil = odbc_exec($koneksi, "insert into entrypersonal( loginname, >>> password, email) values ('".$txtloginname. "', '".$txtpassword. "', >>>'".$txtemail. "')"); >>> if ($tampil) { >>> echo "Input data berhasil"; >>> } else { >>> echo "Input data tidak berhasil"; >>> } >>>} else { >>> echo "Database tidak ditemukan"; >>>} >>>odbc_close($ koneksi); >>>?> >>> >>> >>>salam, >>>erna >>> >>> >> > >
