<?php
// Database configuration
error_reporting(E_ALL);
ini_set('display_errors', 1);
$servername = "localhost:3306";
$username = "jibhires_s";
$password = "P@jy$550SK190";
$dbname = "jibhires_HUMTEMP";
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } else {
        echo "Connected successfully\n";
    }
    
    $sql = "INSERT INTO dev_loc (id,dev_loc,t1,t2,h1,h2,gap_temp,gap_hum,email)
        VALUES ('1', 'loc -1', '10','30','30','60','0','0','Y'),
        ('2', 'loc -1', '10','30','30','60','0','0','Y'),
        ('3', 'loc -1', '10','30','30','60','0','0','Y'),
        ('4', 'loc -1', '10','30','30','60','0','0','Y'),
        ('5', 'loc -1', '10','30','30','60','0','0','Y'),('6', 'loc -1', '10','30','30','60','0','0','Y'),
        ('7', 'loc -1', '10','30','30','60','0','0','Y'),
        ('8', 'loc -1', '10','30','30','60','0','0','Y'),
        ('9', 'loc -1', '10','30','30','60','0','0','Y'),
        ('10', 'loc -1', '10','30','30','60','0','0','Y')";
        
    if ($conn->query($sql) === TRUE) {
            echo "New record created successfully";
    } 
    else {
            echo "Error: " . $sql . "<br>" . $conn->error;
    }
    $conn->close();

function test_input($data) {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

?>