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: "[email protected]" <[email protected]>
To: [email protected]
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
>>
>>
>
