Published June 20, 2020 by RIT

CARA MENAMPILKAN DATA DARI DATABASE MICROSOFT ACCESS


Assalamualaikum warohmatullohi wabarokatuh.
Wa alaikum salam warohmatullohi wabarokatuh.

Terima kasih telah berkunjung di media pembelajaran bahasa program online langsungkoding.blogspot.com ,

This is post writing only in my blog and my solved problem when building website.
and now, my problem on DISPLAYING DATA FROM MICROFSOFT ACCESS WITH PHP, I Have, this is script from my brain hehehe :) just kidding, I Have code when I trying code in query SELECT with clause WHERE, this is above code :




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<table id="example" class="display" style="width:100%">
    <thead>
        <tr>
            <th>USERID</th>
            <th>JAM</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $koneksi = odbc_connect("absen", "" , ""); // koneksi database
 
        $am = 1;
        function abc($am){
            global $koneksi;
            $query2 = ' WHERE USERID='.$am;
            $query = 'SELECT CHECKTIME, CHECKTYPE, USERID FROM checkinout '.$query2;
            return odbc_exec($koneksi, $query);
        }
        $a = abc($am);
        while ($data = odbc_fetch_array($a)){ 
        ?>
          <tr>
              <td><?php echo $data['USERID']; ?></td>
              <td><?php echo $data['CHECKTIME']; ?></td>
          </tr>
        <?php } ?>
     </tbody>
</table>

Thank's
Terima Kasih.

Tag :
Microsoft Access | Database Microsoft Access | Microsfot Access With PHP| How to SELECT data From Microsfot Access With PHP | HOW TO SELECT data With Clause WHERE in Microsoft Access | HOW TO DISPLAY DATA from Microsoft Access | SELECT data From Microsoft Access in PHP | cara menampilkan data dari Microsoft Access dengan php | script SELECT data pada Microsoft Access | Script SELECT data dengan Microsoft Access menggunakan PHP



Comments: