• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
logo

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Write For US
  • News
  • About Us
  • Snippets
You are here: Home / PHP / Basic Database Connection using PDO in PHP

Basic Database Connection using PDO in PHP

Jan 7, 2018 by Editorial Staff Leave a Comment

In this tutorial we are going to learn  connecting to MySQL with PHP using PDO.

“PDO – PHP Data Objects – is a database access layer providing a uniform method of access to multiple databases.”

You don’t need to worry about different syntax for different database types, PDO will do this painless.

# connect to the database
try {
  $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
  $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); // this will enable printing the exceptions
 
  # It's a select statement
  $statement = $dbh->prepare('SELECT * FROM  FROM users');
  $statement->execute();
  $result = $statement->fetchAll();
}
catch(PDOException $e) {
    echo "Oops something gone wrong!";    
}

Did you notice the setAttribute function and the params, this will enable the error more on in your database connection,


Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Filed Under: PHP

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar




Quick Links

  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Base64 Decode Online
  • Base64 Encode Online

Subscribe

* indicates required

Share

   

Hot topics

  • A Simple YouTube Video Downloader Script in PHP 271 views
  • Replace “\n” with new line characters, using Notepad++ 243 views
  • Add FTP/SFTP in Visual Studio Code 178 views
  • Open a URL in a new tab using JavaScript 141 views
  • Using Third-Party Libraries in Codeigniter 140 views
  • Upload Multiple Images and Store in Database using PHP and MySQL. 130 views
  • Laravel Image Intervention Tutorial With Example 125 views
  • Hierarchical Tree view Category Example in Laravel 112 views
  • Spout, an awesome library for reading and writing in Excel. 102 views
  • Manually Install APK Files In Android Studio Emulator 98 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube

Copyright © 2021 · TutsPlanet Gene Theme on Genesis Framework · Powered By BunnyCDN