/home/techb158/immovalet.ca/Client
Edit: /home/techb158/immovalet.ca/Client/submit_checkout.php (4143B)
"sk_test_gasejH5Gqla5lonUcJPVVpcO00RZpoQx4V",
"publishable_key" => "pk_test_va1HCezCrXV9BXGzECWGwITd002TrjPVTo"
);
\Stripe\Stripe::setApiKey($stripe['secret_key']);
//add customer to stripe
$customer = \Stripe\Customer::create(array(
'email' => $email,
'source' => $token
));
$itm_date = date("Y-m-d H:i:s");
if($item_ID == 1)
{
//item information
$itemName = "Visibilité";
$itemNumber = $item_ID;
$itemPrice = 8.99;
$Price=$itemPrice* 100;
$itemPrice=(int) round($Price, 2);
$currency = "cad";
$orderID = "BON".'-Cli-'.$Client_ID.'-Item-'.$item_ID.'-'.$itm_date;
}else if($item_ID == 2)
{
//item information
$itemName = "Alerte Emplois";
$itemNumber = $item_ID;
$itemPrice = 9.99;
$Price=$itemPrice* 100;
$itemPrice=(int) round($Price, 2);
$currency = "cad";
$orderID = "BON".'-Cli-'.$Client_ID.'-Item-'.$item_ID.'-'.$itm_date;
}
//charge a credit or a debit card
$charge = \Stripe\Charge::create(array(
'customer' => $customer->id,
'amount' => $itemPrice,
'currency' => $currency,
'description' => $itemName,
'metadata' => array(
'order_id' => $orderID
)
));
//retrieve charge details
$chargeJson = $charge->jsonSerialize();
//check whether the charge is successful
if($chargeJson['amount_refunded'] == 0 && empty($chargeJson['failure_code']) && $chargeJson['paid'] == 1 && $chargeJson['captured'] == 1){
//order details
$amount = $chargeJson['amount'];
$balance_transaction = $chargeJson['balance_transaction'];
$currency = $chargeJson['currency'];
$status = $chargeJson['status'];
$date = date("Y-m-d H:i:s");
////include database config file
//include_once 'dbConfig.php';
//insert tansaction data into the database
$sql = "INSERT INTO orders(client_id,name,email,card_num,card_cvc,card_exp_month,card_exp_year,order_id,item_name,item_number,item_price,item_price_currency,paid_amount,paid_amount_currency,txn_id,payment_status,created,modified) VALUES('".$Client_ID."','".$name."','".$email."','".$card_num."','".$card_cvc."','".$card_exp_month."','".$card_exp_year."','".$orderID."','".$itemName."','".$itemNumber."','".$itemPrice."','".$currency."','".$amount."','".$currency."','".$balance_transaction."','".$status."','".$date."','".$date."')";
$insert = $mysqli->query($sql);
$last_insert_id = $mysqli->insert_id;
//if order inserted successfully
if($last_insert_id && $status == 'succeeded'){
$statusMsg = "
The transaction was successful.
";
}else{
$statusMsg = "Transaction has been failed";
}
}else{
$statusMsg = "Transaction has been failed";
}
}else{
$statusMsg = "Transaction submission error.......";
}
//show success or error message
header('Location: plan_valeurs_checkout.php?succ='.$statusMsg);
// exit();
//echo $statusMsg;
//4242424242424242 Visa
//4000056655665556 Visa (debit)
//5555555555554444 Mastercard
//5200828282828210 Mastercard (debit)
//378282246310005 American Express
//6011111111111117 Discover