-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtransfer.php
31 lines (29 loc) · 990 Bytes
/
transfer.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<vxml version=\"2.1\" >";
//diese Werte nicht aendern!!!!!
$host = '127.0.0.1';
$login = 'root';
$password = '';
$connection = mysql_connect($host, $login, $password) or die ("Error - no connection");
$db = mysql_select_db("voicexml_bank", $connection) or die("Error - while selecting database: " . mysql_error());
//vars
$account_number = $_GET['Var_Account_Number'];
$pin_number = $_GET['Var_Pin_Number'];
$status = 'negative';
//query
$query = "SELECT * from kunde INNER JOIN kontostand ON kunde.kontonummer=kontostand.kontonummer where kunde.kontonummer = $account_number and kunde.pin = $pin_number";
$result = mysql_query($query) or die ("Error - with query: " . mysql_error());
$row = mysql_fetch_assoc($result);
if ($row["guthaben"] > 0) {
$status = 'positive';
}
echo $status;
?>
<form>
<block>
<var name="status" expr="'<?=$status?>'"/>
<return namelist="status"/>
</block>
</form>
</vxml>