note 104699 deleted from pdo.exec by danbrown
| From: | danbrown@php.net | Date: | Fri, 01 Jul 2011 16:46:34 +0000 |
| Subject: | note 104699 deleted from pdo.exec by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-181141@lists.php.net to get a copy of this message | ||
Note Submitter: chris
----
if($_SERVER['REQUEST_METHOD'] == 'GET') {
$path = $_SERVER['PATH_INFO'];
if($path != null) $path_params = spliti("/", $path);
$db = new PDO("mysql:host=127.0.0.1;dbname=aktien", "gast",
"gast");
$kursname = $path_params[1];
$datum = $path_params[2];
$query = 'SELECT preis FROM kurs WHERE
name LIKE :kursname AND
datum LIKE :datum';
$stmt = $db->prepare($query);
$stmt->bindParam(':kursname', $kursname);
$stmt->bindParam(':datum', $datum);
$stmt->execute();
$reihe = $stmt->fetchObject();
$kurswert=$reihe->preis;
echo $kurswert;
return;
}
echo "Fehler";