php

How To Implement Pagination in MySQL with PHP on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Implement Pagination in MySQL with PHP on Ubuntu 18.04

Pagination is the concept of constraining the number of returned rows in a recordset into separate, orderly pages to allow easy navigation between them, so when there is a large dataset you can configure your pagination to only return a specific number of rows on each page. In this tutorial, you’ll build a PHP script to connect to your database and introduce pagination to your script using the MySQL LIMIT clause.

Read more
How To Install and Secure phpMyAdmin with Apache on a CentOS 7 Server — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure phpMyAdmin with Apache on a CentOS 7 Server

While many users require access to a database management system like MySQL or MariaDB, not all users feel comfortable interacting with the SQL prompt on a daily basis. In this guide, we’ll discuss how to install and secure phpMyAdmin, a web management interface for MySQL and MariaDB, on a CentOS 7 server. We will leverage the Apache web server for this guide.

Read more
How To Install And Start Using Sculpin — step-by-step Linux tutorial on Progressive Robot

How To Install And Start Using Sculpin

In this tutorial, we will install Sculpin on our VPS running Ubuntu 12.04 and get started using it. We will see how to start a project from scratch, how to generate the static files, and how to use its internal web server to deliver the files to the browser. Additionally, I will show you how you can get started with a pre-made blogging site built in Sculpin and add new blog posts to it.

Read more
How To Install DokuWiki with Nginx on an Ubuntu 12.04 VPS — step-by-step Linux tutorial on Progressive Robot

How To Install DokuWiki with Nginx on an Ubuntu 12.04 VPS

Wiki-style document editing is a very popular way of presenting content and allowing group collaboration. There are many different wiki applications available that each have their uses. DokuWiki is a small, contained wiki that does not rely on an entire database to get up and running. In this guide, we will install DokuWiki and serve it with Nginx on an Ubuntu 12.04 VPS.

Read more
How To Install Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7

In this guide, we’ll get a LEMP stack installed on an CentOS 7 server. A LEMP software stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the ENginx web server (which replaces the Apache component of a LAMP stack). The site data is stored in a MySQL database (using MariaDB), and dynamic content is processed by PHP.

Read more
CHAT