Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. <?php
  2. /* Connect to an ODBC database using driver invocation */
  3. $dsn = 'mysql:dbname=test;host=127.0.0.1';
  4. $user = 'root';
  5. $password = '';
  6. try {
  7. $dbh = new PDO($dsn, $user, $password);
  8. $sql = 'SELECT * FROM naprawy';
  9. foreach ($dbh->query($sql) as $row) {
  10. // print $row['pojemnosc_silnika'] . "\n";
  11. echo '
  12. <br>Id naprawy: '.$row['id_naprawy'].'<br>Numer rejestracyjny: '.$row['nr_rejestracyjny'].'<br>Marka: '.$row['marka'].'<br>Model: '.$row['model'].'<br>Rocznik: '.$row['rok'].'<br>Pojemnosc: '.$row['pojemnosc'].'<br>Wlasciciel: '.$row['wlasciciel'].'<br>Numer telefonu: '.$row['nr_telefonu'].'<br>Opis: '.$row['opis'].'<br>Faktury: '.$row['faktury'].'<br>Koszt: '.$row['koszt'].'<br>Id statusu: '.$row['id_statusu'].'<br>Status: '.$row['status'].'<br><br>';
  13. }
  14. } catch (PDOException $e) {
  15. echo 'Connection failed: ' . $e->getMessage();
  16. }
  17.  
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement