Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //try connect to database
- $db=mysqli_connect("localhost","root","",
- "mycompanyhr");
- //if db setting incorrect
- if (mysqli_connect_errno($db)) {
- echo "Connect failed: ". mysqli_connect_error($db);
- exit();
- }
- else{//if db no problems
- echo "Database connected<br>";
- //sql query
- $sql="select EMPNO, FIRSTNAME, LASTNAME, PHONENO
- from employee";
- //execute sql query
- $qr=mysqli_query($db, $sql);
- //fetch one record
- while ($record=mysqli_fetch_array($qr)){
- //display record content
- echo "Employe ID ".$record['EMPNO']."<br>";
- echo "Firstname ".$record['FIRSTNAME']."<hr>";
- }//display all using while loop
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement