note 109216 deleted from class.iterator by danbrown
| From: | danbrown@php.net | Date: | Wed, 27 Jun 2012 16:35:44 +0000 |
| Subject: | note 109216 deleted from class.iterator by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-188924@lists.php.net to get a copy of this message | ||
Note Submitter: max dot mueller dot 65 at gmx dot de
----
<?php
class Benutzer {
private $db;
public function __construct() {
try {
$this->db = new PDO
("mysql:host=localhost;dbname=b4g4","b4g4","Aikoo3om");
} catch (PDOException $e) {
throw new Exception ('Verbindung nicht moeglich: ' . $e->getMessage());
}
}
public function benutzerEinfuegen ($vorname, $nachname, $geschlecht, $alter) {
if (!$stmt=$this->db->prepare('INSERT INTO
benutzer (vorname,
nachname, geschlecht, alter) VALUES (:vorname, :nachname,
:geschlecht, :alter)')) {
throw new Exception ('PDO::prepare fehlgeschlagen!');
}
if (!$stmt->bindParam(':vorname',$vorname)||
!$stmt->bindParam(':nachname',$nachname)||
!$stmt->bindParam(':geschlecht',$geschlecht)||
!$stmt->bindParam(':alter',$alter)) {
throw new Exception ('PDOStatement::bindParam fehlgeschlagen!');
}
if (!$stmt->execute()) {
throw new Exception ('PDOStatement::execute fehlgeschlagen!');
}
}
}
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Ex1 - k1</title>
</head>
<body>
<?php
print_r($_POST);
$user = new Benutzer();
$user->benutzerEinfuegen($_POST['vorname'],$_POST['name'],$_POST['gender'],$_POST['age']);
?>
</body>
</html>