Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // listing.php
- //to display from table
- //1. connect to database
- include "connection.php";
- //2. provide sql command
- $sql="select EMPNO, FIRSTNAME,
- LASTNAME, PHONENO
- from employee";
- //3. run the sql command to db
- $qr=mysqli_query($db, $sql);
- //4. fetch one record
- while($rekod=mysqli_fetch_array($qr)){
- //5. display record(s)
- echo "<br>";
- echo "Employee no ".$rekod['EMPNO'];
- echo "Firstname ".$rekod['FIRSTNAME'];
- echo "Lastname ".$rekod['LASTNAME'];
- echo "Phone ".$rekod['PHONENO'];
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement