Hello,
I am new to this PHP and any web based code etc.
I have a webform which is submitting to SQL on my localhost (innodb maria) as far as i am aware. I am using cpanel to work on the DB which i am happy with. I find it easy to use. HOWEVER.... at work they want me to send my data to a Microsoft database on cloud... i don't know how, i don't know the best way, i don't understand a lot of what im reading,
I have signed up to Azure, I don't have a clue how to use it or how to send the data to it from the form on my webhost, i do not want to host my form on azure at the moment.
i am struggling with it quite a bit and spent a few hours watching youtube and messing around last night but to no favourable result. My post script to local DB is....
<?php
// Check If form submitted, insert form data into table.
if(isset($_POST['Submit'])) {
$timestamp = $_POST['timestamp'];
$depot = $_POST['depot'];
$user = $_POST['user'];
$type = $_POST['type'];
$status = $_POST['status'];
$location = $_POST['location'];
$litter = $_POST['entrylitter'];
$detritus = $_POST['entrydet'];
$comment = $_POST['comment'];
$lat = $_POST['lat'];
$lon = $_POST['lon'];
$nogps = $_POST['nogps'];
$issue = $_POST['issue'];
$contract = $_POST['contract'];
// include database connection file
include_once("config.php");
// Insert user data into table
$result = mysqli_query($mysqli, "INSERT INTO refuse (timestamp, depot, user, type, location, litter, detritus, status, comment, lat, lon, nogps, image, contract) VALUES('$timestamp', '$depot', '$user', '$type', '$location', '$litter', '$detritus', '$status','$comment', '$lat', '$lon', '$nogps', '$image', '$contract')");
// Show message when user added
header('Location: page2.php');
}
?>