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(){