How to Test PHP MySQL Database Connection Using Script

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Aaron Kili

Aaron Kili is a Linux and F.O.S.S enthusiast, an upcoming Linux SysAdmin, web developer, and currently a content creator for TecMint who loves working with computers and strongly believes in sharing knowledge.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

10 Responses

  1. Elizabeth says:

    Hey @Aaron Kili, thanks for this script it was very useful to me. Now I want to build a small PHP script about an invoice without a user interface, it should check for me how many customers in the database have paid in the database, then i should be able to put this as a service since its sending to many people.

    My question is how do i get to build this system without a user interface and and my invoice should have CSS script embedded. please help thanks

    • Aaron Kili says:


      What do you want to use the CSS for if you don’t want a user interface(UI)? To the best of my knowledge, CSS is used for describing the presentation of Web pages. Trying to embed CSS means adding a UI.

  2. Gideon says:

    Worked but no php script to retrive data from database

  3. UgoChukwu says:

    I got an error message that says…

    Could not open input file: db-connect-test.php

    How can I resolve it?

  4. Nathan Samson says:

    The PHP scripts to connect to database is not closed. Please check but the scripts is very useful. Thanks

  5. Kyle says:

    This is an integration test. Next Step could be to adapt it into an automation framework (phpunit?) and then be used as part of a CI pipeline.

Leave a Reply to Gideon 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.