Retrieve all entries with $pdo->query in a foreach
| cleansweep 5 | 20
|
| cleansweep 7 | 30
|
| shooting star | 5
|
Create a new entry with $pdo->exec
Inserted record for firebolt
Retrieve $rs->fetch(PDO::FETCH_ASSOC)
| cleansweep 5 | 20
|
| cleansweep 7 | 30
|
| shooting star | 5
|
| firebolt | 4000
|
Create new entries with $pdo->prepare
insert nimbus 2000
insert nimbus 2001
Retrieve with PDO::FETCH_ASSOC
| cleansweep 5 | 20
|
| cleansweep 7 | 30
|
| shooting star | 5
|
| firebolt | 4000
|
| nimbus 2000 | 100
|
| nimbus 2001 | 150
|
Update entries with $pdo->prepare
begin transaction
update nimbus 2000
update nimbus 2001
commit
Retrieve with PDO::FETCH_BOUND
| cleansweep 5 | 20
|
| cleansweep 7 | 30
|
| shooting star | 5
|
| firebolt | 4000
|
| nimbus 2000 | 120
|
| nimbus 2001 | 250
|
Delete the new entries
delete firebolt
delete nimbus 2000
delete nimbus 2001
Retrieve with PDO::FETCH_OBJ
| cleansweep 5 | 20
|
| cleansweep 7 | 30
|
| shooting star | 5
|