<?php
// Copyright:   Youri van Mill
// Date:        2010


$settings['targetpay']['id'] = xxxxx;
$settings['targetpay']['country'] = 31;
$settings['targetpay']['shortcode'] = 3010;
$settings['targetpay']['keyword'] = 'BETAAL+AI';
$settings['targetpay']['testmode'] = 1;


class Sms_Targetpay
{
    public $id;
    public $country;
    public $result;
    public $testmode;


    public function __construct($id, $country, $testmode)
    {
        $this->id = $id;
        $this->country = $country;
        $this->testmode = $testmode;
    }


    public function startPay($code, $shortcode, $keyword)
    {
        $this->result = file_get_contents('https://www.targetpay.com/api/sms-pincode' .
            '?rtlo=' . $this->id . '&code=' . $code . '&shortcode=' . $shortcode .
            '&keyword=' . $keyword . '&country=' . $this->country . '&test=' . $this->
            testmode);


        if ($this->result == '000 OK') {
            return true;
        } else {
            return false;
        }
    }
}


$sms = new Sms_Targetpay($settings['targetpay']['id'], $settings['targetpay']['country'],
    $settings['targetpay']['testmode']);


if (isset($_POST['submit'])) {
    if (empty($_POST['code'])) {
        echo 'Je hebt geen code ingevoert.';
    } elseif (!ctype_digit($_POST['code'])) {
        echo 'De code die je hebt ingevult is niet nummeriek.';
    } else {
        if (!$sms->startPay($_POST['code'], $settings['targetpay']['shortcode'], $settings['targetpay']['keyword'])) {
            echo 'Er is iets fout gegaan tijdens het betalen.' . PHP_EOL;
            echo '<!--' . $sms->result . '-->';
        } else {
            echo 'Betaling gelukt.';
            echo '<!--' . $sms->result . '-->';
        }
    }
} else {
?>
    <table>
        <form action="/test.php" method="post">
            <tr>
                <td>Code</td>
                <td><input type="text" name="code"></td>
            </tr>
            <tr>
                <td><input type="submit" name="submit" value="Submit"></td>
                <td>&nbsp;</td>
            </tr>
        </form>
    </table>
    <?php
}
?>

try {
    if(!file_exists("inc/config.php"))
    {
        throw new Exception("De config is niet gevonden.");
    }
    else
    {
        include("inc/config.php");
    }
}
catch(Exception $e) {
    echo $e->getMessage();
}

$sql = mysql_query("SELECT * FROM table")


$results = array();


while($res = mysql_fetch_assoc($sql))
{
    $results[] = $res;
}


$smarty->assign("results", $results);

$dbh = new PDO("mysql:host=localhost;dbname=xxx", "xxx", "xxx");


$res = $dbh->prepare("SELECT *
                     FROM messages
                     WHERE `to` = 'conteaster'"); 
$res->execute();
$res->setFetchMode(PDO::FETCH_ASSOC);


$smarty->assign("res", $res);