Published June 20, 2020 by RIT with 0 comment

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



      edit

0 comments:

Post a Comment