How to connect to a database

      mysql:host = host_address;
      dbname = database_name;
      

      $dsn = "mysql:host=localhost;dbname=my_guitar_shop1";
      $username = "mgs_user";
      $password = "pa55word";
      $db = new PDO($dsn, $username, $password); // creates PDO object 
      

      $dsn = "mysql:host=bscacad3.buffalostate.edu;dbname=your-bsc-userid";
      $username = "your-bsc-userid";
      $password = "your-Banner-id";
      $db = new PDO($dsn, $username, $password); // creates PDO object      
      

Description

• To create an object from a class, you code the new keyword, followed by the name of the class, followed by a set of parentheses. Within the parentheses, you code the arguments that are required by the class, separating multiple arguments with commas.
• To create a PDO object that connects to a MySQL database, you use the PDO class with the three arguments shown above: DSN (Data Source Name), username, and password.
• The DSN for a MySQL connection specifies the host computer for the MySQL database and the name of the database. If the MySQL database is running on the same server as PHP, you can use the localhost keyword to specify the host computer.
• The PDO (PHP Data Objects) extension to PHP defines a consistent interface for accessing databases. Since PDO supports most popular databases, this lets you write PHP code that can be used for more than one type of database.
• PDO is included with PHP 5.1 and later and is available as a PECL extension for PHP 5.0. However, PDO doesn’t work with earlier versions of PHP. For those versions, you must use the skills presented in chapter 19.