Guest User

Untitled

a guest
May 17th, 2018
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.41 KB | None | 0 0
  1. <?php header("Content-Type: text/html; charset=utf-8");
  2.  
  3. $servername = "**********";
  4. $username = "********";
  5. $password = "*******";
  6. $dbname = "********";
  7.  
  8. function connect(){
  9. $conn = mysqli_connect("*******", "********", "********", "********");
  10. if (!$conn) {
  11. die("Connection failed: " . mysqli_connect_error());
  12. }
  13. return $conn;
  14. }
  15.  
  16. function init(){
  17. //вывожу список товаров
  18. $conn = connect();
  19. $sql = "SELECT id, name FROM goods";
  20. $result = mysqli_query($conn, $sql);
  21.  
  22. if (mysqli_num_rows($result) > 0) {
  23. $out = array();
  24. while($row = mysqli_fetch_assoc($result)) {
  25. $out[$row["id"]] = $row;
  26. }
  27. echo json_encode($out);
  28. } else {
  29. echo "0";
  30. }
  31. mysqli_close($conn);
  32. }
  33. ?>
  34.  
  35.  
  36.  
  37.  
  38. <?php header("Content-Type: text/html; charset=utf-8");
  39. $mysqli->set_charset("utf8");
  40. //читать json файл
  41. $json = file_get_contents( '../goods.json');
  42. $json = json_decode($json, true);
  43.  
  44. //письмо
  45. $message = '';
  46. $message .= '<h1>Заказ в магазине</h1>';
  47. $message .='<p>Телефон: '.$_POST['ephone'].'</p>';
  48. $message .='<p>Почта: '.$_POST['email'].'</p>';
  49. $message .='<p>Клиент: '.$_POST['ename'].'</p>';
  50.  
  51.  
  52. $cart = $_POST['cart'];
  53. $sum = 0;
  54. foreach ($cart as $id=>$count) {
  55. $message .=$json[$id]['name'].' --- ';
  56. $message .=$count.' --- ';
  57. $message .=$count*$json[$id]['cost'];
  58. $message .='<br>';
  59. $sum = $sum + $count*$json[$id]['cost'];
  60. }
  61. $message .='Всего: '.$sum;
  62. //print_r($message);
  63.  
  64. $to = '******************'.',';
  65. $to .=$_POST['email'];
  66. $specttext = '<!DOCTYPE html><html><head><title>Заказ</title></head><body>';
  67. $headers = 'MIME-Version: 1.0' . "rn";
  68. $headers .= 'Content-type: text/html; charset=utf-8' . "rn";
  69.  
  70. $m = mail($to, 'Заказ в магазине', $specttext.$message.'</body></html>', $headers);
  71. if ($m) {echo 1;} else {echo 0;}
  72.  
  73. ?>
  74.  
  75. header('Content-Type: text/html; charset=utf-8');
  76.  
  77. AddDefaultCharset UTF-8
  78.  
  79. mysql_connect("localhost","user","password");
  80. mysql_select_db("db");
  81. mysql_set_charset("utf8");
  82.  
  83. $mysqli = new mysqli("localhost", "user", "password", "bd");
  84. $mysqli->set_charset("utf8");
  85.  
  86. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  87. $opt = [
  88. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  89. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  90. PDO::ATTR_EMULATE_PREPARES => false,
  91. ];
  92. $pdo = new PDO($dsn, $user, $pass, $opt);
Add Comment
Please, Sign In to add comment