سلام
من در یک پروژه ای قصد دارم که اطلاعاتی رو از سمت مخاطب به سمت سرور ارسال کنم ولی متاسفانه قسمت ارسال دارای ایراد هستش.
از شما خواهشنمدام که امکانش هست راهنمایی بفرمایید
پیشاپیش ممنون.
<?php
include_once('../includes/connect_database.php');
include('../variables/variables.php');
// get data from android app
$name = $_POST['name'];
$alamat = $_POST['alamat'];
$name2 = $_POST['name2'];
$date_n_time = $_POST['date_n_time'];
$phone = $_POST['phone'];
$order_list = $_POST['order_list'];
$comment = $_POST['comment'];
$sql_query = "set names 'utf8'";
$stmt = $connect->stmt_init();
if($stmt->prepare($sql_query)) {
// Execute query
$stmt->execute();
// store result
$stmt->close();
}
// insert data into reservation table
$sql_query = "INSERT INTO tbl_reservation(Name, Alamat, Number_of_people, Date_n_Time, Phone_number, Order_list, Comment)
VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt = $connect->stmt_init();
if($stmt->prepare($sql_query)) {
// Bind your variables to replace the ?s
$stmt->bind_param('sssssss',
$name,
$alamat,
$name2,
$date_n_time,
$phone,
$order_list,
$comment
);
// Execute query
$stmt->execute();
$result = $stmt->affected_rows;
// store result
//$result = $stmt->store_result();
$stmt->close();
}
// get admin email from user table
$sql_query = "SELECT Email
FROM tbl_user";
$stmt = $connect->stmt_init();
if($stmt->prepare($sql_query)) {
// Execute query
$stmt->execute();
// store result
$stmt->store_result();
$stmt->bind_result($email);
$stmt->fetch();
$stmt->close();
}
// if new reservation has been successfully added to reservation table
// send notification to admin via email
if($result){
$to = $email;
$subject = $reservation_subject;
$message = $reservation_message;
$from = $admin_email;
$headers = "From:" . $from;
mail($to,$subject,$message,$headers);
echo "OK";
}else{
echo "Failed";
}
include_once('../includes/close_database.php');
?>
سورس کد contect_database.php;
<?php
include('../ecommerce/variables/variables.php');
$connect->set_charset('utf8');
?>
اینم سورس کد varrable.php:
<?php
// database configuration
$host ="localhost";
$user ="root";
$pass ="";
$database = "ecommerce";
$connect = new mysqli($host, $user, $pass,$database) or die("Error : ".mysql_error());
$connect->query("SET CHARACTER SET utf8;");
$connect->query("SET SESSION collation_connection = 'utf8_general_ci'");
//mysql_query("SET NAMES 'utf8'", $connection);
//mysql_query("SET CHARACTER SET 'utf8'", $connection);
//mysql_query("SET character_set_connection = 'utf8'", $connection);
// access key to access API
$access_key = "12345";
// google play url
$gplay_url = "https://play.google.com/store/apps/details?id=your.package.com";
// email configuration
$admin_email = "";
$email_subject = "";
$change_message = "You have change your admin info such as email and or password.";
$reset_message = "Your new password is ";
// reservation notification configuration
$reservation_subject = "";
$reservation_message = "Ada pemesanan baru, silakan cek di halaman administrator.";
// copyright
$copyright = "";
?>
مسعود فرمانی
10 سال پیش
faridddd
10 سال پیش
faridddd
10 سال پیش
نظرات