PHP Designing Interfaces in PHP Introducing Interfaces Implement MySQL RepositoryInterface

Gerard Hattem
Gerard Hattem
1,806 Points

What is the password and user and database to create a database connection with PDO

I don't the credentials of the database to use.

sqlRepository.php
<?php
class sqlRepository extends PDO implements RepositoryInterface{
      function all($table){

        $dsn = 'mysql:dbname=testdb;host=127.0.0.1';
                $user = 'root';
                $password = 'PASSWORD';
        $pdo = new PDO("mysql:host=localhost","root" ,"root");
                $dbs = $pdo->query( 'SHOW DATABASES' );

while( ( $db = $dbs->fetchColumn( 0 ) ) !== false )
{
    echo $db.'<br>';
}
        exit(); 



        new PDO("mysql:host=localhost;dbname=shirts4mike","root");


        $stmt = $pdo->query("SELECT * from ".$table);
        return $stmt->fetchAll(PDO::FETCH_OBJ); 

      }
}