Untitled

****<?php
    function Connection(){
        $server="server";
        $user="user";
        $pass="pass";
        $db="database";

        $connection = mysqli_connect($server, $user, $pass);
        //$db = new PDO('mysql:host=localhost;dbname=testdb;charset=utf8', 'user', 'pass');
        if (!$connection) {
            die('MySQL ERROR: ' . mysql_error());
        }

        mysql_select_db($db) or die( 'MySQL ERROR: '. mysql_error() );
        return $connection;
    }
?>****

**<?php
    include("connect.php");

    $link=Connection();
    $temp1=$_POST["temp1"];
    $hum1=$_POST["hum1"];
    $query = "INSERT INTO `tempLog` (`temperature`, `humidity`)
        VALUES ('".$temp1."','".$hum1."')";

    mysql_query($query,$link);
    mysql_close($link);
    header("Location: index.php");
?>**

**<?php
    include("connect.php");

    $link=Connection();
    $result=mysql_query("SELECT * FROM `tempLog` ORDER BY `timeStamp` DESC",$link);
?>
<html>
   <head>
      <title>Sensor Data</title>
   </head>
<body>
   <h1>Temperature / moisture sensor readings</h1>
   <table border="1" cellspacing="1" cellpadding="1">
        <tr>
            <td>&nbsp;Timestamp&nbsp;</td>
            <td>&nbsp;Temperature 1&nbsp;</td>
            <td>&nbsp;Moisture 1&nbsp;</td>
        </tr>
      <?php
          if($result!==FALSE){
             while($row = mysql_fetch_array($result)) {
                printf("<tr><td> &nbsp;%s </td><td> &nbsp;%s&nbsp; </td><td> &nbsp;%s&nbsp; </td></tr>",
                   $row["timeStamp"], $row["temperature"], $row["humidity"]);
             }
             mysql_free_result($result);
             mysql_close();
          }
      ?>
   </table>
</body>
</html>**

$connection = mysqli_connect($server, $user, $pass);
if (!$connection) {
    die('MySQL ERROR: ' . mysql_error());
}

mysql_select_db($connection,$db) or die( 'MySQL ERROR: '. mysql_error() );
return $connection;

$connection = mysqli_connect($server, $user, $pass, $db);
if (!$connection) {
    die('MySQL ERROR: ' . mysql_error());
}

$connect = mysqli_connect($server, $user, $pass);

mysql_select_db($db) or die( 'MySQL ERROR: '. mysql_error() );

$link=Connection();
$result=mysql_query("SELECT * FROM `tempLog` ORDER BY `timeStamp` DESC",$link);

$con = mysqli_connect('$host', '$user', '$pass', '$db');

$con = mysqli_connect("$host", "$user", "$pass", "$db");