+ 39

How to link MySQL server to the webhost.

I want to link MySQL Database server with my website host

2nd Sep 2018, 9:16 AM
Shams Awais
Shams Awais - avatar
4 Answers
+ 25
Thank You All for your Response and Suggestion 🌴Vincent Berger🌴 , // Zohir , John Parkar
5th Oct 2018, 4:35 PM
Shams Awais
Shams Awais - avatar
+ 4
Use PHP to link to MySQL Database or else, you can use PHP My Admin to save information in your website.
2nd Sep 2018, 4:35 PM
// Νεχο
// Νεχο - avatar
+ 4
Hi Shams Awais, Is your MySQL db local on your pc and you want to establish a connection with your website hosted external? In that case: You need to port-forward port 80,8080 or 443 on your local router to establish a connection between your host and local server. Or you want to connect your MySQL db to your website, both on your webhost? In that case: To connect your MySQL db throught your website you need to work with PHP. $servername = "localhost"; $username = "username"; $password = "password"; $databassname = "dbname"; $conn = mysqli_connect($servername, $username, $password, $databasename); OR $db = mysqli_connect('localhost','username','password','databasename'); 1. mysqli_connect 2. mysqli_query 3. mysqli_fetch_array 4. mysqli_close 1. make the connection and select the database 2. perform the query on the table 3. print out the data 4. close the connection
3rd Sep 2018, 9:02 PM
🌴Vincent Berger🌴
🌴Vincent Berger🌴 - avatar
+ 1
The MySQL is such a software that is related to the database over the network where it allows storing of the piles of data that needs to be connected properly with the step by step instructions that would be available at https://www.mobilerepairdubai.net/. If it is not done properly, the database would not be accessed.
3rd Sep 2018, 10:14 PM
John Parkar