Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /* Connect to an ODBC database using driver invocation */
- $dsn = 'mysql:dbname=test;host=127.0.0.1';
- $user = 'root';
- $password = '';
- try {
- $dbh = new PDO($dsn, $user, $password);
- $sql = 'SELECT * FROM naprawy';
- foreach ($dbh->query($sql) as $row) {
- // print $row['pojemnosc_silnika'] . "\n";
- echo '
- <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>';
- }
- } catch (PDOException $e) {
- echo 'Connection failed: ' . $e->getMessage();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement