Databas och PHP, en tutorial
Lista alla bilar
carId |
personId |
registrationNr |
make |
model |
year |
price |
---|
1 |
1 |
ABC123 |
Volvo |
V70 |
2012 |
199000 |
2 |
null | DEF456 |
Saab |
95 |
2008 |
145000 |
3 |
2 |
GHI789 |
Renault |
Clio |
2010 |
95000 |
4 |
4 |
JKL987 |
Volvo |
S40 |
2005 |
75000 |
5 |
6 |
QWERTY |
Mercedes-Benz |
B 180 |
2012 |
185500 |
6 |
1 |
BKW127 |
BMW |
320d |
2006 |
89000 |
7 |
4 |
ACO112 |
BMW |
520 |
2011 |
185000 |
8 |
9 |
KAS911 |
Volvo |
V70 |
2001 |
18000 |
9 |
7 |
BUY111 |
VOLVO |
V60 |
2011 |
159900 |
10 |
null | DYR BIL |
Jaguar |
F-Type |
2014 |
789000 |
SQL
SELECT * FROM car;