Download the installer and install the PostgreSQL server on Windows. Once the PostgreSQL installer installation is completed, you can connect the database from your local computer. Connect to the PostgreSQL database using SQL Shell (psql) or pgAdmin 4. Use Query Tool to write and execute SQL queries on PostgreSQL database.

Time Ago format is used to display time in human-readable format, such as 5 seconds ago, 2 minutes ago, 1 day ago, etc. Relative time format helps to avoid different time zone conversions. In this example code snippet, we will show you how to create Time Ago function to convert timestamp to time ago using PHP.

Hide alert message automatically after some time is a great feature to make web form UI user-friendly. With the auto-hide feature, the alert message element closes automatically after some specific time and disappears from the web page. Use the setTimeout() method to hide the HTML element after some time from the web page.

Full Screen Control feature helps to view maps in full-screen mode. The full-screen control button is placed at the corner of the map, it allows you to go full-screen or exit full-screen. There are some third-party plugins available to extend OpenStreetMap functionality with Leaflet. Use the leaflet.fullscreen plugin to add full screen control in OpenStreetMap with Leaflet using JavaScript.

Open Street Map provides a marker icon by default. You can change the default marker icon image and customize the icon size in OpenStreetMap. Customizing the marker icon helps to match the OpenStreetMap with the website UI. This guide will show you how to customize the OpenStreetMap marker icon using JavaScript.

DataTables server-side processing is used to fetch data from the database and list them in a tabular view. In most cases, the single database table is used in DataTables with server-side processing. The SSP class gives you the possibility to JOIN multiple tables with DataTables server-side processing. You can apply the LEFT or INNER JOIN clause to the SQL query in server-side processing.

There are various options available to get the content from the URL in PHP. You can get the file content from a remote URL using PHP. PHP file_get_contents() function is the easiest way to parse the content from a web URL. To use the file_get_contents() function, the allow_url_fopen directive must be enabled in the PHP configuration file (php.ini).

The javascript:void(0); attribute is used in the anchor tag for empty links. It helps to prevent the default behavior of href links. But, JavaScript Void 0 may not work well for some JS frameworks (Angular, Backbone.js, etc) and SPA sites. Also, the content security policy (CSP) does not support javascript:void(0) in the application. Use the “#!” in the href attribute of the <a> tag for empty links.

In general, we use the date() function to get date and time in PHP. It returns the time based on the timezone set in the PHP server. You can get the DateTime from the timezone set as default on the PHP configuration. In this example code, we will show you how to get the current time by given a timezone in PHP. You can get and display the current Date and Time from a specific timezone using PHP.