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 […]
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 ..
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 = […]
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 […]
MySql offer two quick function to add and subtract date through MySql query, you can directly add or subtract day, month, year on any given date using your MySql query. In below example I’ll show you how to add/subtract x number of days, month and year in date through MySql query. So that you don’t […]
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, […]
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 […]