How to Install Flarum Forum on a Ubuntu Server

Flarum runs on top of the LAMP stack. So the first step in getting it up and running on your server is to use the DigitalOcean LAMP One-Click application or to follow this tutorial: We’ll also need Composer installed. sudo apt-get install curl php5-cli git curl -sS https://getcomposer.org/installer | sudo php — –install-dir=/usr/local/bin –filename=composer Now […]

Read More

Bootstrap Table Search

Some times you have many data in your  table, in which you have to search any particular data …and at that time it is very typical to find that particular data ..here is the script to search table using bootstarp ..

Read More

How To Get Posts Category In WordPress

Problem Can we get the list of blog posts in the following structure? Published Date Author Category Post Title Blog URL Solution 1 2 3 4 5 6 7 8 9 10 SELECT p.ID,DATE(p.post_date) Date,u.display_name Author,p.post_title Title,GROUP_CONCAT(t.name) Category, CONCAT(‘http://yourdomain.com/blog/’,p.post_name) URL FROM wp_posts p LEFT JOIN wp_users u ON p.post_author = u.ID LEFT JOIN wp_term_relationships rel ON rel.object_id = […]

Read More

Get featured image url direct using mysql query in wordpress

As  we know that there are various method through which we can display featured image in frontend but sometime we need to add some contents or add blog on another site then at that time there does not work wordpress query neither wordpress functions. so that we use mysql query to display wordpress blog data […]

Read More

How to manage MySQL databases and users from the command line

CREATING USERS AND DATABASES To create a MySQL database and user, follow these steps: At the command line, log in to MySQL as the root user: mysql -u root -p Type the MySQL root password, and then press Enter. To create a database user, type the following command. Replace username with the user you want to create, […]

Read More

How To Set Up Apache Virtual Hosts on Ubuntu 14.04 LTS

Introduction The Apache web server is the most popular way of serving web content on the internet. It accounts for more than half of all active websites on the internet and is extremely powerful and flexible. Apache breaks its functionality and components into individual units that can be customized and configured independently. The basic unit […]

Read More