{"id":1402,"date":"2017-01-19T01:00:14","date_gmt":"2017-01-19T01:00:14","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=1402"},"modified":"2019-01-23T06:09:32","modified_gmt":"2019-01-23T06:09:32","slug":"establishing-a-database-connection-using-php","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/establishing-a-database-connection-using-php\/","title":{"rendered":"Establishing a Database Connection Using PHP"},"content":{"rendered":"

In this tutorial, we’ll show how to establish a database connection to your MySQL database using PHP.<\/p>\n

PHP and MySQL is one of the most common stacks for web development. With it such a common combination powering so many websites.<\/p>\n

Database Connection settings<\/h5>\n

To be able to connect to a MySQL database, you need to update the following MySQL Database Connection Credentials.<\/p>\n

Before that make sure to create a Database name, Database username\u200b and Password for your database user. <\/p>\n

Database Name, Database USER and Database Password can be created from your cPanel or from shell.\u200b<\/p>\n

DATABASE NAME, DATABASE USER, PASSWORD, HOSTNAME<\/p>\n

Now, you’ve to create a sample.php file and copy the below code and replace the fields with your DATABASE Credentials. The below is how it looks in your terminal and the code follows.<\/p>\n

\"Database<\/span><\/p>\n

================================================<?php<\/p>\n

\/\/ENTER YOUR DATABASE CONNECTION INFO BELOW:<\/p>\n

$hostname=”localhost”;$database=”test_db”;$username=”test_user”;$password=”qwe234@#$”;<\/p>\n

\/\/DO NOT EDIT BELOW THIS LINE$link = mysql_connect($hostname, $username, $password);if (!$link) {die(‘Connection failed: ‘ . mysql_error());}else{echo “Host SUCCESS! ” .$hostname . “” . PHP_EOL;}<\/p>\n

$db_selected = mysql_select_db($database, $link);if (!$db_selected) {die (‘Can’t select database: ‘ . mysql_error());}else {echo ‘You have successfully established a connection to your DB ‘ . $database . ”;}<\/p>\n

mysql_close($link);<\/p>\n

?>=============================================<\/p>\n

Just RUN this sample.php files in your browser and you can see the below result on browser.<\/p>\n

                                                                   http:\/\/IP\/sample.php<\/p><\/blockquote>\n

Host SUCCESS! localhost You have successfully established a connection to your DB test_db<\/p>\n

Conclusion<\/h5>\n

Finally, after complete reading this article you can surely connect your database using PHP.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this tutorial, we’ll show how to establish a database connection to your MySQL database using PHP. PHP and MySQL is one of the most common stacks for web development. With it such a common combination powering so many websites. Database Connection settings To be able to connect to a MySQL database, you need to update the […]<\/p>\n","protected":false},"author":6,"featured_media":1432,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[80],"tags":[57,36,65],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1402"}],"collection":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/comments?post=1402"}],"version-history":[{"count":3,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1402\/revisions"}],"predecessor-version":[{"id":4732,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1402\/revisions\/4732"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media\/1432"}],"wp:attachment":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media?parent=1402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/categories?post=1402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/tags?post=1402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}