connect_error) { die("Connection failed, completely: " . $conn->connect_error); } echo 'Connected to SQL'; $sql = "INSERT INTO " .$sensor. " (id, decDay, date, dawnHrs, dayHrs, duskHrs, nightHrs, maxHrs, maxLux, batt) VALUES (NULL, '" . $decDay . "', " . $date . ", '" . $dawnHrs . "', '" . $dayHrs . "', '" . $duskHrs . "', '" .$nightHrs. "', '" .$maxHrs. "', '" .$maxLux. "', '" .$batt. "')"; if ($conn->query($sql) === TRUE) { echo "New record created super successfully"; } else { echo "Error: " . $sql . "
" . $conn->error; } $conn->close(); } } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?>