Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('Databaze.php');
- $Db = new Databaze();
- $Db->pripoj('localhost','root',"",'pocty');
- $Db->vypis("SELECT Slovo, Kod FROM pocty WHERE id_slova = 10");
- $Db->zapis();
- $Db->vyber();
- //------------------------------------------------------------------------------------------------
- <?php
- Class Databaze
- {
- public $zkouska = 0;
- public $pripojeni = "";
- public $vypis="";
- public function pripoj($server,$uzivatel,$heslo,$databaze)
- {
- define('SQL_HOST', $server);
- define('SQL_DBNAME', $databaze);
- define('SQL_USERNAME', $uzivatel);
- define('SQL_PASSWORD', $heslo);
- $dsn = 'mysql:dbname=' . SQL_DBNAME . ';host=' . SQL_HOST . '';
- $user = SQL_USERNAME;
- $password = SQL_PASSWORD;
- try {
- $this->pripojeni = new PDO($dsn, $user, $password);
- $this->pripojeni->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- } catch (PDOException $e) {
- die('Connection failed: ' . $e->getMessage());
- }
- }
- public function vypis($prikaz)
- {
- $dotaz = $this->pripojeni->prepare($prikaz);
- // Vykonání dotazu
- $vysledek = $dotaz->execute(array( ));
- $this->Vypis = $dotaz->fetch();
- Echo("<tr><td>".$this->Vypis['Slovo']."</td><td>".$this->Vypis['Kod']."</td></tr><br />");
- }
- public function zapis()
- {
- Echo("Zapisuju");
- }
- public function vyber()
- {
- Echo("Vybírám");
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement