function saveDataToDatabase()
{
date_default_timezone_set("Asia/Tokyo");
//set timezone to Tokyo
$date = date("Y-m-d H:i:s");
$servername = "domremy.xsrv.jp";
$username = "******";
$password = "******";
$dbname = "domremy_product";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$ProductName = $conn->real_escape_string($_POST["product"]);
$PepperText = $conn->real_escape_string($_POST["pepperText"]);
$Text = $conn->real_escape_string($_POST["detail"]);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO product_tb (productName, productDetailText, productPepperText, productRecodeDate, productValidity)\n VALUES ('{$ProductName}', '{$Text}','{$PepperText}','{$date}','1')";
if ($conn->query($sql) === TRUE) {
$temp = explode(".", $_FILES["file"]["name"]);
$extension = strtolower(end($temp));
$id = $conn->insert_id;
$filename = $id . "." . $extension;
$sql = "UPDATE product_tb SET productFileName ='{$filename}' WHERE productId='{$id}'";
$conn->query($sql);
saveImageToServer($filename);
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
}
$pPepperText = $conn->real_escape_string($_POST['pepperText']);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (is_uploaded_file($_FILES['file']['tmp_name'])) {
//$filename = $_POST["file"].$_FILES["file"]["name"];
if (verifyImage() == "OK") {
$sql = "UPDATE product_tb SET productName ='{$pName}', productDetailText = '{$pDetail}', productPepperText = '{$pPepperText}' WHERE productId='{$id}'";
if ($conn->query($sql) === TRUE) {
$temp = explode(".", $_FILES["file"]["name"]);
$extension = strtolower(end($temp));
$filename = $id . "." . $extension;
$sql = "UPDATE product_tb SET productFileName ='{$filename}' WHERE productId='{$id}'";
$conn->query($sql);
saveImageToServer($filename);
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
}
} else {
$sql = "UPDATE product_tb SET productName ='{$pName}', productDetailText = '{$pDetail}', productPepperText = '{$pPepperText}' WHERE productId='{$id}'";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
}
$conn->close();
// function saveImageToServer(){
