Amir Hoshang Kioumars: July 2015

Monday 20 July 2015

Setup Node.JS, Express, Jade, and MongoDB

http://cwbuecheler.com/web/tutorials/2013/node-express-mongo/

Tuesday 7 July 2015

Get SQL Data using PHP and Display using HTML

getSqlData.php

<?php
    header("Access-Control-Allow-Origin: *");
    header("Content-Type: application/json; charset=UTF-8");

    $conn = new mysqli("localhost", "root", "root", "World");
    $result = $conn->query("SELECT Code, Name, Region FROM Country");

    $outp = "[";
    while($rs = $result->fetch_array(MYSQLI_ASSOC))
    {
        if ($outp != "[")
            $outp .= ",";

        $outp .= '{"Code":"'. $rs["Code"] . '",';
        $outp .= '"Name":"' . $rs["Name"] . '",';
        $outp .= '"Region":"' . $rs["Region"] . '"}';
    }
    $outp .="]";

    $conn->close();
    echo($outp);
?>

index.html

<!DOCTYPE html>

<head>

</head>

<body>

var xmlhttp = new XMLHttpRequest();

var url = "http://localhost/SampleWebSite/getSqlData.php";

xmlhttp.onreadystatechange=function()

{

if (xmlhttp.readyState == 4 && xmlhttp.status == 200)

myFunction(xmlhttp.responseText);

}

xmlhttp.open("GET", url, true);

xmlhttp.send();

function myFunction(response)

{

var arr = JSON.parse(response);

var i;

var out = "<table>";

for(i = 0; i < arr.length; i++)

{

out += "<tr>"+

"<td>" + arr[i].Code + "</td>" +

"<td>" + arr[i].Name + "</td>" +

"<td>" + arr[i].Region + "</td>"+

"</tr>";

}

out += "</table>";

document.getElementById("id01").innerHTML = out;

}

</script>

</body>

</html>

Sunday 5 July 2015

No 'Access-Control-Allow-Origin' Header is Present on the Requested Resource

Add the following headers to the HTML file:

<!DOCTYPE html>
<html>
   <head>

      <?php
          header('Access-Control-Allow-Origin: *');
          header('Access-Control-Allow-Methods: GET, POST');
      ?>
.
.
.

Call PHP Method with Parameter from HTML

<?php
     if (isset($_POST['getData']) and isset($_POST['country']))
     {
        $servername = "localhost";
        $username = "root";
        $password = "root";
        $dbname = "World";

        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);

        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
        $sql = "SELECT code, name FROM country where name='" . $_POST['country'] . "';";
        $result = $conn->query($sql);

        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                echo $row["code"]. " - " . $row["name"]. "<br>";
            }
        } else {
            echo "0 results";
        }
        $conn->close();
    }
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title></title>
    </head>
    <body>

       <form action="" method="post">
           Country: <input type="text" name="country">
           <input type="submit" name ="getData" value="send"></input>
        </form>

    </body>
</html>

Amir Hoshang Kioumars