Two ways to host a website on remote server (for static and dynamic website)

How to host a website on a remote server? First of all, remote server refers to server that can be accessed by a group of team which requires an URL. For example: https://syahirahnsmn.github.io/ (this is static web page hosted on github)

There are many ways to do so & there are many web hosting provider as well.


One of the ways is by using github which need some simple steps:

*note: this is only for static website (doesnt require database)

(1) Host on github (url: username.github.io)


Another way I found is by hosting the website on Heroku by connecting the Heroku profile to github. The steps are as below:

*note: this is suitable for dynamic website that requires database connection [reference: https://www.youtube.com/watch?v=I4Ra-80O3R4]

(1) Set up a Heroku account and connect to a github repository

(2) Git commit project from any IDE (I am using VS Code) from github desktop -> push to github

(3) Deploy the github repo manually on Heroku

*note: usually the main page should be named as: index.php 

(Heroku does not recognize html file)

(4) The website url will be displayed (if there is no error)

To connect this web server to database:

*note: this database here refers to MySQL

(5) Make sure to have MySQL Workbench installed in your computer

(6) Create a new database on remotemysql.com (username, server, and password will be generated for you)

(7) Double click on the new created database -> it will enter MySQL Workbench

(8) Export database file from phpMyAdmin (localhost) and copy the SQL from the downloaded file & paste it in MySQL Workbench query

(9) The query will generate the required tables on "schemas" tab which can be found on the left side (if there is no error - i once encountered an error but i simply solved it by uninstall the workbench and install it again)

(10) Go to your connection (.php) file to the website page - mine is connection.php

(11) Replace the server/host, username and password with the one generated in remotemysql.com

For example:

// Remote database connection

$servername = "remotemysql.com";

$user = 'username';

$pass = 'password';

$db = 'database';

(11) Deploy the new updated php file in Heroku (don't forget to git and push from github desktop)


Comments

Post a Comment

Popular posts from this blog

How to: Display Data from SQL Database in HTML Table - Bootstrap 5

Image
The above picture refers to the table displaying the information from an SQL database. *note: this tutorial is using Bootstrap 5 (CSS Framework) & PDO (PHP Data Object) 1. Set connection to the database <?php require_once('core.php') ?> 2. Write HTML <table>      <div class="data">              <div class="row">             <div class="col-lg-12">                 <div class="table-responsive">                     <table class="table table-striped table-hover">                     <thead>                     <tr>                         <th scope="col">ID</th>                         <th scope="col">Email</th>                         <th scope="col">Full Name</th>                         <th scope="col">Address</th>                         <th scope="col">City</th>
Read more

HTML5: HTML Tags

The tags introduced in HTML5 are more descriptive such as: main , header , footer , nav , video , article , section , audio & many more.  These tags helps with Search Engine Optimization (SEO) and accessibility. The main tag helps search engine and other developers find the main content of your page.  Adding an image to your page: Using img element by pointing it to a specific image's URL using the src attribute. This img tag is self-closing. The img tag must come with alt attribute to help screen readers especially when the image is failed to load (might be due to heavy load, internet connection and whatnots). alt attribute should contain a description of the image to help screen readers understand it. Link to external pages: Using a (anchor) element to link to any external pages The a tag contains href attribute which contains the destination page's URL The tag should also contain anchor text to allow clickable text which will direct user to the destination page &l
Read more

How to: Display Data from Database in Pagination

1. Please refer to this post to display data in table 2. After displaying them in the table, follow the instructions attached on the comment section (//) :   //determine no of data to display per page $results_per_page = 10; //count all column from the database $sql = "SELECT COUNT(*) FROM test_user"; $res = $dbx->query($sql); $count = $res->fetchColumn(); // determine no of total pagination needed by dividing no of total columns ($count) with total data to display (10) $number_of_pages = ceil($count/$results_per_page); // determine which page number visitor is currently on if(!isset($_GET['page'])){     $page = 1; }else{     $page = $_GET['page']; } // determine the sql LIMIT starting number for the results on the displaying page $this_page_first_result = ($page-1)*$results_per_page;                          $sql = "SELECT id, user_email, user_fullname, user_address, user_city, user_zip, user_state, user_country, user_tel, user_fax from test_user
Read more