57 lines
1.7 KiB
PHP
57 lines
1.7 KiB
PHP
<?php
|
|
include('include/headscript.php');
|
|
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
|
|
|
$product = "12185"; // Sostituisci con il valore reale
|
|
|
|
$checkservice = "SELECT idservice
|
|
FROM service
|
|
WHERE FIND_IN_SET('$product', wpcatalognumber) > 0";
|
|
|
|
$result = $conn->prepare($checkservice);
|
|
$result->bind_param("s", $product);
|
|
$result->execute();
|
|
$result->store_result();
|
|
|
|
if ($result->num_rows > 0) {
|
|
$result->bind_result($idservice);
|
|
$result->fetch();
|
|
$copyOrderItemyogi['idservice'] = $idservice;
|
|
} else {
|
|
$copyOrderItemyogi['idservice'] = "0";
|
|
}
|
|
|
|
echo $copyOrderItemyogi['idservice'];
|
|
|
|
$email = "csironi@cesoft.io";
|
|
$first_name = "Claudio";
|
|
$last_name = "Sironi";
|
|
$auth_user_query = $conn->prepare("SELECT * FROM auth_users WHERE email = ?;");
|
|
$auth_user_query->bind_param("s", $email);
|
|
$auth_user_query->execute();
|
|
$auth_user_result = $auth_user_query->get_result();
|
|
|
|
if ($auth_user_result->num_rows === 0) {
|
|
// If email doesn't exist, add it to auth_users
|
|
$user_data = array(
|
|
'email' => $email,
|
|
'password' => '!Yogibook159',
|
|
'first_name' => $first_name,
|
|
'last_name' => $last_name,
|
|
'role_id' => '2',
|
|
'status' => 'Active'
|
|
);
|
|
|
|
$insert_query = "INSERT INTO auth_users (email, password, first_name, last_name, role_id, status, email_verified_at, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, NOW(), NOW(), NOW())";
|
|
$insert_stmt = $conn->prepare($insert_query);
|
|
$insert_stmt->bind_param("ssssss", $user_data['email'], $user_data['password'], $user_data['first_name'], $user_data['last_name'], $user_data['role_id'], $user_data['status']);
|
|
$insert_stmt->execute();
|
|
} else {
|
|
$idusercheck = '4';
|
|
}
|
|
if (isset($idusercheck)) {
|
|
echo $idusercheck;
|
|
}
|
|
?>
|