ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/submit_review.php |
<?php
header('Content-Type: application/json');
ini_set('display_errors', 1);
error_reporting(E_ALL);
try {
// --- Database Configuration ---
$host = 'localhost';
$db = 'poojajeweller';
$user = 'poojajeweller_user';
$pass = 'Poojajeweller@12345#';
$charset = 'utf8mb4';
// --- Database Connection ---
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$pdo = new PDO($dsn, $user, $pass, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
]);
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$action = $_POST['action'] ?? '';
// ===== 1. Product Review Form =====
if ($action === 'add_review') {
$product_id = intval($_POST['product_id'] ?? 0);
$product_name = trim($_POST['product_name'] ?? '');
$review_name = trim($_POST['review_name'] ?? '');
$review_email = trim($_POST['review_email'] ?? '');
$review_title = trim($_POST['review_title'] ?? '');
$review_message = trim($_POST['review_message'] ?? '');
if (!$product_id || !$product_name || !$review_name || !$review_email || !$review_title || !$review_message) {
echo json_encode(['success' => false, 'message' => 'Please fill all review fields.']);
exit;
}
if (!filter_var($review_email, FILTER_VALIDATE_EMAIL)) {
echo json_encode(['success' => false, 'message' => 'Invalid email address.']);
exit;
}
$stmt = $pdo->prepare("INSERT INTO product_reviews
(product_id, product_name, review_name, review_email, review_title, review_message, created_at)
VALUES (:product_id, :product_name, :review_name, :review_email, :review_title, :review_message, NOW())");
$stmt->execute([
':product_id' => $product_id,
':product_name' => $product_name,
':review_name' => $review_name,
':review_email' => $review_email,
':review_title' => $review_title,
':review_message' => $review_message
]);
echo json_encode(['success' => true, 'message' => '✅ Thank you for your review!']);
exit;
}
// ===== 2. Contact Form =====
elseif ($action === 'contact_form') {
$name = trim($_POST['name'] ?? '');
$email = trim($_POST['email'] ?? '');
$phone = trim($_POST['phone'] ?? '');
$message = trim($_POST['message'] ?? '');
if (!$name || !$email || !$phone || !$message) {
echo json_encode(['success' => false, 'message' => 'All fields are required.']);
exit;
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo json_encode(['success' => false, 'message' => 'Invalid email address.']);
exit;
}
$stmt = $pdo->prepare("INSERT INTO contact_messages (name, email, phone, message, created_at)
VALUES (:name, :email, :phone, :message, NOW())");
$stmt->execute([
':name' => $name,
':email' => $email,
':phone' => $phone,
':message' => $message
]);
echo json_encode(['success' => true, 'message' => '✅ Your message has been sent successfully!']);
exit;
}
// ===== 3. Newsletter Form =====
elseif ($action === 'newsletter_form') {
$email = trim($_POST['newsletter_email'] ?? '');
$terms = isset($_POST['newsletter_terms']) ? 1 : 0;
if (!$email) {
echo json_encode(['success' => false, 'message' => 'Email is required.']);
exit;
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo json_encode(['success' => false, 'message' => 'Invalid email address.']);
exit;
}
if (!$terms) {
echo json_encode(['success' => false, 'message' => 'You must agree to terms and conditions.']);
exit;
}
$stmt = $pdo->prepare("INSERT INTO newsletter_subscribers (email, terms_agreed, created_at) VALUES (:email, :terms, NOW())");
$stmt->execute([
':email' => $email,
':terms' => $terms
]);
echo json_encode(['success' => true, 'message' => '✅ You have subscribed successfully!']);
exit;
}
// ===== Invalid Action =====
else {
echo json_encode(['success' => false, 'message' => 'Invalid action.']);
exit;
}
}
// If not POST
echo json_encode(['success' => false, 'message' => 'Invalid request method.']);
} catch (Exception $e) {
echo json_encode(['success' => false, 'message' => 'Error: ' . $e->getMessage()]);
}
?>
........