HTML Code

HTML




<!DOCTYPE html>
<html>
 
<head>
    <style>
        table,
        th,
        td {
            border: 1px solid grey;
            border-collapse: collapse;
            padding: 5px;
        }
         
        table tr:nth-child(odd) {
            background-color: #f1f1f1;
        }
         
        table tr:nth-child(even) {
            background-color: #ffffff;
        }
    </style>
</head>
 
<body>
    <table>
        <tr>
            <td>Avinash</td>
            <td>USA</td>
        </tr>
        <tr>
            <td>Aisha</td>
            <td>UK</td>
        </tr>
        <tr>
            <td>Emma</td>
            <td>Australia</td>
        </tr>
        <tr>
            <td>Shreyas</td>
            <td>India</td>
        </tr>
        <tr>
            <td>Rachel</td>
            <td>USA</td>
        </tr>
        <tr>
            <td>Shravan</td>
            <td>India</td>
        </tr>
    </table>
</body>
</html>


Output:



AngularJS SQL

In any web application, we need to save, update, insert and fetch data to and from a database. AngularJS is a JavaScript MVC (Model-View-Controller) framework developed by Google. It helps developers to build well-structured, easily testable, and maintainable front-end applications. 

Important Features in AngularJS Library are given below:

  • Concept
  • Template
  • Directives
  • Model
  • Scope
  • Expressions
  • Compiler
  • Filter
  • Data Binding
  • Controller
  • Module
  • Service

Similar Reads

Need for AngularJS Framework

With the directives to the HTML elements and attributes, dynamic web pages are easily created by adding additional coding. AngularJS is pretty much helpful for displaying data from a Database. Provided data should be in JSON format. Let’s see an example of it. Data is in MySQL and on the server-side PHP interacts with MySQL and gets the data in JSON format. Angular JS displays the output. With the basic example below, let us see in detail Angular JS SQL....

Server Code PHP and MySQL

...

HTML Code

PHP ", "", "");           $result = $connection->query( "SELECT EmployeeName, EmployeeCity, EmployeeCountry FROM Employees");           $output = "";     while ($rs = $result->fetch_array(MYSQLI_ASSOC)) {         if ($output != "") {             $output = ", ";         }         $output .= '{"Name":"' . $rs["EmployeeName"] . '", ';         $output .= '"City":"' . $rs["EmployeeCity"] . '", ';         $output .= '"Country":"' . $rs["EmployeeCountry"] . '"}';     }     $output = '{"records":[' . $output . ']}';     $connection->close();           echo $output; ?>...