<?php
    define('DB_SERVER', 'localhost');
    define('DB_USERNAME', '16600846_l2m');
    define('DB_PASSWORD', '8*#YduIvo#YJ');
    define('DB_DATABASE', '16600846_l2m');
    define("BASE_URL", "http://love2move.pl/");
    define("BASE_URL_ENGLISH", "http://love2move.pl/index_eng.php");


    $dbhost = DB_SERVER;
    $dbuser = DB_USERNAME;
    $dbpass = DB_PASSWORD;
    $dbname = DB_DATABASE;
    $baseurl = BASE_URL;
    $baseurl_english = BASE_URL_ENGLISH;


    $db = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
    $db->exec("set names utf8");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    error_reporting(0);

if($_GET['test'] == 1){
 $_POST['t_status'] = 2;
 $_POST['amount'] = 2.1;
 $_POST['control'] = 'test';
}

if ($_POST['t_status'] == 2 && $_POST['amount'] != '' && $_POST['control'] != '') {


        $ciag_pomocniczy=($_POST['control']);

        $sql = "UPDATE tickets set status = 1  where md5(crc) = '".md5($ciag_pomocniczy)."'";
        $stmt = $db->prepare($sql);
        $stmt->execute();

        $user = "select * from tickets where md5(crc) = '".md5($ciag_pomocniczy)."'";
        $select = $db->prepare($user);
        $select->execute();
        $dane = $select->fetch();

        var_dump($dane);
        //send mail

        //treść




session_destroy();

}
?>