WEEK 12 - Connect the server with browser

-
In this week, we learn about how to connecting the database server with the browser. The example we take is from w3school. After that we enter the data based on our database.

First we need to create a table in php, purpose to show a simple interface to present the database.
The following is the code to present the database
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<style>
#customers {
    font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
    border-collapse: collapse;
    width: 100%;
}

 #customers td, #customers th {
    border: 1px solid #ddd;
    padding: 8px;
}

 #customers tr:nth-child(even){background-color: #f2f2f2;}

 #customers tr:hover {background-color: #ddd;}

 #customers th {
    padding-top: 12px;
    padding-bottom: 12px;
    text-align: left;
    background-color: #4CAF50;
    color: white;
}
</style>
</head>

 <body>

 <?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbgui";

 // Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = "SELECT guest_id, name, last_name, phone FROM guest";
$result = mysqli_query($conn, $sql);

 if (mysqli_num_rows($result) > 0) {
 echo "<table id=\"customers\">";
 echo "<tr>";
    echo "<th>Guest ID</th>";
    echo "<th>Name</th>";
    echo "<th>Phone</th>";
   echo "</tr>";

    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "<tr>".
   "<td>" . $row["guest_id"]. "</td>" . "<td>" . $row["name"].  " " . $row["last_name"]. "</td>" . "<td>" . $row["phone"]. "</td></tr>";
    }
} else {
    echo "0 results";
}
echo "</table>";


$conn->close();
?>

 </body>
</html>
After that, this is the result table and the database information




Comments

Post a Comment

Popular posts from this blog

WEEK 6 - Introduction to Java Script

-
Image
Java script is a document help the web designer to build more functional and interactive website. For example, popup window, alert message, form validation, etc. are common use by the developer. In this week, our lecturer teach us on how to form a java script in html document. First, we use this code from lecturer slide. Exercise 1 INPUT: <html><head><title> JAVA SCRIPT</title></head> <body> <h1> Welcome to SMMTC </h1>  This is HTML section.... </body> </html> <script type="text/javascript">   window.alert("welcome to JavaScript!"); </script> OUTPUT: Exercise 2 INPUT: <html><head><title> JAVA SCRIPT</title> <script type="text/javascript">   function showText() {       window.alert("welcome to JavaScript!");   } </script></head> <body  onload="showText();"> <h1> Welcome to SMMTC </h...
Read more

WEEK 7 - Introduction to PHP

-
Today class is briefly explain what is php and how it work with web browser and server. After that, we have to identify the data type and valid syntax use in Php. Php is a simple programming language  use to develop compare to Java, C, python and many others. Php support a variety of different database system that include MySQL, Informix, Oracle, Sybase and so on... How php script are accessed and interpreted? 1. User access PHP file 2. User request for PHP file 3. Receive request,find file and read it. 4. Execute PHP script/code 5. Send result back 6. Return results. In this chapter we learn that every php must include this three special markup tag i. <?php      php code      ?> ii. <?          php code      ?> iii. <script language = "php"    php code    </script> All variable in php must begin with $ ( dollar  sign)
Read more

WEEK 13 - PHP (QUIZ)

-
Image
In this week, we having our last quiz attempt in WWW Programming class. This quiz is to test our skill on writing java script. First, our lecturer provide a result for us. We need to develop a page with same result given by lecturer. Here is the result that I get ...
Read more