{"id":40978,"date":"2024-05-13T12:21:54","date_gmt":"2024-05-13T12:21:54","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=40978"},"modified":"2026-02-19T05:45:41","modified_gmt":"2026-02-19T05:45:41","slug":"php-connection-to-mysql-mariadb","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/php-connection-to-mysql-mariadb","title":{"rendered":"How To Connect A PHP Application With Mysql\/MariaDB\/Percona for PHP?"},"content":{"rendered":"

How To Connect A PHP Application With Mysql\/MariaDB\/Percona for PHP?<\/h2>\n

MySQL, MariaDB<\/a>, and Percona are very famous databases that anyone can use for free. Developers worldwide like to use them. Read the steps below to find out how to link your PHP program<\/a>, which is on the same platform, to one of these database servers (MySQL, MariaDB, and Percona).<\/p>\n

Environment Creation<\/h2>\n

Step 1.<\/strong>\u00a0Sign in to your AccuWeb.cloud<\/a> account and make a setup with either MySQL<\/strong> or MariaDB database<\/strong> server (both are options in the SQL wizard).<\/p>\n

We’ve included an Apache PHP Application Server to show how to connect.<\/p>\n

\"PHP<\/a><\/p>\n

Step 2.<\/strong>\u00a0Once your setup is done, you’ll receive an email containing details for administering and connecting to MySQL (or MariaDB)<\/a>.<\/p>\n

\"MySQL<\/a><\/p>\n

Step 3.<\/strong> Return to your account dashboard and click the “Open in Browser<\/strong>” button for the right database node (MySQL or MariaDB). Log in to the admin panel using the login details sent to you in the email.<\/p>\n

\"Open<\/a><\/p>\n

Step 4.<\/strong> Navigate to the “Databases”<\/strong> section and create a new database (like “accutest_db<\/strong>“).<\/p>\n

\"New<\/a><\/p>\n

Step 5 . <\/strong>Now, you’re set to deploy your application (either from an archive or a GIT\/SVN<\/strong> repository) to the setup you’ve created.<\/p>\n

\"GIT\/SVN\"<\/a><\/p>\n

Connecting to the Database<\/h2>\n

Once your project is set up, you’ll need to connect it to your database. You can do this by configuring your application properly, like using the built-in MySQLi extension.<\/p>\n

Check the official documentation page for all available functions. Here, we’ll cover the basics:<\/p>\n

\n
\nUse mysql or PDO to connect PHP with MySQL, MariaDB, or Percona. Validate credentials, use prepared statements to prevent SQL injection, and handle errors securely.<\/div>\n
\n