Setting Up Your Environment<\/h2>\n
First, log in<\/a> to your AccuWeb.Cloud dashboard. If you haven’t already set up a PHP environment with a database, click on the \u201cCreate New PHP Environment with Database\u201d button<\/p>\n If you’ve already set up a PHP server and database and wish to access phpMyAdmin for the database, click on the SQL Database option and then on \u201cOpen in Browser.\u201d This will redirect you to the phpMyAdmin page.<\/p>\n Check AccuWeb.Cloud’s Best PHP Hosting Services!<\/a><\/p>\n In the dashboard, you’ll find the Deployment Manager. This tool helps you deploy your application using various methods. You can also find the option to access Web SSH by expanding the PHP server. Check your email for your database and server credentials. You should have received an email containing this information, which you can use when deploying your application. That’s it! You have successfully set up a PHP server with a database and accessed it to deploy your application.<\/p>\n Once your project is successfully deployed, you need to connect it to your database. This requires your application to be properly configured, for example, using the MySQLi (MySQL Improved) extension.<\/p>\n Check our High Performance MySQL database hosting services!<\/a><\/p>\n Here are some basic functions to help you connect to your database:<\/p>\n Use the following function to get a connection string for accessing your MySQL\/MariaDB node:<\/p>\n Replace the placeholders with your connection data:<\/p>\n To switch to a different database within the same server, use the following function:<\/p>\n Replace {connect} with the connection string obtained using the mysqli_connect function.<\/p>\n To close a connection to your database, execute the following:<\/p>\n Note:<\/strong>\u00a0You need to specify the necessary functions in every\u00a0*.php<\/strong>\u00a0page, which should be connected to the database.<\/p>\n Sign up\u00a0and avail $100 free credits now!!<\/a><\/p>\n You can check the connection using the following code:<\/p>\n Replace {host}, {user}, {password}, and {db_name} in the connection string with the corresponding values<\/p>\n Here’s an example of how to execute a simple request to your database and output it onto a table:<\/p>\n![\"Setting](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/for_setting_application_env_configration.png\" "\\"Setting")
<\/a><\/p>\n![\"Create](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/login_phpmyadmin_throu_admin_dashboard.png\" "\\"Create")
<\/a><\/p>\n![\"Open](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/for_deploying_application.png\" "\\"Open")
<\/a><\/p>\n
\n![\"MySQL](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/mail_when_installation_completed_of_mysql.png\" "\\"MySQL")
<\/a><\/p>\n
\n![\"Environment](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/mail_when_env_setup_is_completed.png\" "\\"Environment")
<\/a><\/p>\n![\"\"](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/12\/final-img-kb-cloud.svg\")
<\/a><\/p>\nConnection to the Database<\/h2>\n
1. Getting a Connection String<\/h3>\n
mysqli_connect('{host}', '{user}', '{password}', '{db_name}');<\/code><\/pre>\n\n
2. Switching to a Different Database<\/h3>\n
mysql_select_db('{connect}','{db_name}');<\/code><\/pre>\n3. Closing a Connection<\/h3>\n
mysqli_close( );<\/code><\/pre>\nChecking the Connection<\/h2>\n
\r\n?php $link = mysqli_connect('{host}', '{user}', '{password}', '{db_name}');\r\n\/\/if connection is not successful you will see text error\r\nif (!$link) { die('Could not connect: ' . mysql_error()); }\r\n\/\/if connection is successfully you will see message below echo 'Connected successfully';\r\nmysqli_close($link); ?<\/code><\/pre>\nExecuting a Simple Request<\/h2>\n
\r\n?php \r\n\/\/ Connection checking:\r\n$link = mysqli_connect('{host}', '{user}', '{password}', '{db_name}');\r\nif (!$link)\r\n{\r\n\techo \"\r\n\"; exit; } \/\/ Switch to a different database: $db=\"mysql\"; mysqli_select_db($link, $db); \/\/ table header output: echo \"\r\n\"; echo \"\r\n\r\n\"; \/\/ SQL-request: $q = mysqli_query ($link, \"SELECT * FROM help_topic;\"); \/\/ table-result output for ($c=0; $c<mysqli_num_rows($q); $c++) { echo \"\r\n\"; $f = mysqli_fetch_array($q); \/\/ Returns an array that corresponds to the fetched row and moves the internal data pointer ahead. echo \"\r\n\r\n\"; echo \"\r\n\"; } echo \"\r\n<\/code><\/pre>\n
![\"Index](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/07\/06-database-connection-example-applicatiom-e1689941518753.png\" "\\"Index")
<\/a><\/p>\n