Advertisement
Guest User

Untitled

a guest
Oct 8th, 2018
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. <?php
  2. require_once('Databaze.php');
  3.  
  4. $Db = new Databaze();
  5. $Db->pripoj('localhost','root',"",'pocty');
  6. $Db->vypis("SELECT Slovo, Kod FROM pocty WHERE id_slova = 10");
  7. $Db->zapis();
  8. $Db->vyber();
  9. //------------------------------------------------------------------------------------------------
  10. <?php
  11. Class Databaze
  12. {
  13. public $zkouska = 0;
  14. public $pripojeni = "";
  15. public $vypis="";
  16.  
  17. public function pripoj($server,$uzivatel,$heslo,$databaze)
  18. {
  19. define('SQL_HOST', $server);
  20. define('SQL_DBNAME', $databaze);
  21. define('SQL_USERNAME', $uzivatel);
  22. define('SQL_PASSWORD', $heslo);
  23.  
  24. $dsn = 'mysql:dbname=' . SQL_DBNAME . ';host=' . SQL_HOST . '';
  25. $user = SQL_USERNAME;
  26. $password = SQL_PASSWORD;
  27.  
  28. try {
  29. $this->pripojeni = new PDO($dsn, $user, $password);
  30. $this->pripojeni->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  31. } catch (PDOException $e) {
  32. die('Connection failed: ' . $e->getMessage());
  33. }
  34. }
  35.  
  36. public function vypis($prikaz)
  37. {
  38. $dotaz = $this->pripojeni->prepare($prikaz);
  39. // Vykonání dotazu
  40. $vysledek = $dotaz->execute(array( ));
  41. $this->Vypis = $dotaz->fetch();
  42. Echo("<tr><td>".$this->Vypis['Slovo']."</td><td>".$this->Vypis['Kod']."</td></tr><br />");
  43. }
  44.  
  45. public function zapis()
  46. {
  47. Echo("Zapisuju");
  48. }
  49.  
  50. public function vyber()
  51. {
  52. Echo("Vybírám");
  53. }
  54. }
  55. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement