i need help for this video here: PHP CRUD Operations with PHP-Creating Records- Reading Project Data

Where is the data you'd like to retrieve, do you have a local environment with MySQL?

Yes i use a local mysql database

OK Mikkel,

It would help to know how you set up your local instance of MySQL - what's your OS, are you using something like XAMPP or WAMP or MAMP?

Here's the steps that are pretty much global - just let me know if you need additional detail or have any questions:

1. Check your phpinfo() and verify you have the MySQL PDO extension enabled (probably should verify MySQLi also)
2. Check the server name in phpMyAdmin (should be at top of page - breadcrumbs) - usually "localhost"
3. Create a database - remember the database name (create tables as desired).
4. Select the database in phpMyAdmin and go to Priviledges
5. Select Add User Account (you much have a database specific user to connect)
6. Create a User with "grant all privileges on db...")
7. Note your Username and Password (needed for connection)
8. Now you can create a db connection - using your values below:

<?php
$user = 'your Username'
$pass = 'your Password'
$dbh = new PDO('mysql:host=localhost;dbname=yourdb', $user, $pass);
?>

1. Next steps - execute PDO stuff - check the manual for details