Category: MySql
-
INSTALL LARAVEL ON UBUNTU 17.04 / 17.10 WITH APACHE2, MARIADB AND PHP SUPPORT
INSTALL LARAVEL ON UBUNTU 17.04 / 17.10 WITH APACHE2, MARIADB AND PHP SUPPORT Laravel is a flexible and lightweight open source PHP framework with Model-View Controller (MVC) design pattern. It can be a great alternative to CodeIgniter framework. Laravel is designed for ease of use to allow developers create great applications. If you’re looking for…
-
Ubuntu 16.04 LTS – How To Install PHP, phpMyAdmin and MySQL
Ubuntu 16.04 LTS – How To Install PHP, phpMyAdmin and MySQL Step 1 – Update repositories. root@mail:/# apt-get update root@mail:/# apt-get upgrade Step 2 – Install mysql with the following command. root@mail:/# apt-get install mysql-server mysql-client Step 3 – You have to enter password for the root user. Step 4 – You have to repeat password for the root user. Step 5 – Install php7 for mysql with…
-
Installing LAMP (Linux, Apache, MariaDB, PHP/PhpMyAdmin) in RHEL/CentOS 7.0
Installing LAMP (Linux, Apache, MariaDB, PHP/PhpMyAdmin) in RHEL/CentOS 7.0 Step 1: Install Apache Server with Basic Configurations 1. After performing a minimal system installation and configure your server network interface with a Static IP Address on RHEL/CentOS 7.0, go ahead and install Apache 2.4 httpd service binary package provided form official repositories using the following command. #…
-
How To Create A Simple REST API in PHP? Step By Step Guide!
How To Create A Simple REST API in PHP? Step By Step Guide! Previously, we learned how to create, read, update and delete database records (CRUD operations) with our PHP, MySQL & OOP CRUD Tutorial. Today, before we go to JavaScript programming, we will learn how to create a simple REST API in PHP. Enjoy our…
-
HOW CAN I CHANGE THE DOMAIN NAME FOR MY WORDPRESS SITE?
HOW CAN I CHANGE THE DOMAIN NAME FOR MY WORDPRESS SITE? Via phpMyAdmin TIP: Remember that your WordPress Dashboard has now changed and will be using the URL you entered in Step 6.
-
Common OpenCart Errors and How to Solve Them
Common OpenCart Errors and How to Solve Them There is nothing more excited then try to build your own ecommerce store. Installing OpenCart extensions and themes, modificate them to your need and learn new thing during development. But most OpenCart users know how frustrating it can be get an unexpected error and not be able…
-
The Top 3 Reasons an Application Hangs
The Top 3 Reasons an Application Hangs Do you experience application hang problems? If so, read this article to discover the top 3 reasons applications hang and cause slow performance. If you have been in the IT industry long enough, you probably know this story well. The application works fine, then, suddenly, the application hangs…
-
6 Essential Tips on How to Become a Full Stack Developer
6 Essential Tips on How to Become a Full Stack Developer How to become a full stack developer? As one of the hottest topics for developers, the discussions have never stopped. On LinkedIn and Facebook, lots of people put their job title as a full stack developer. Besides, it seems that the “Full Stack” topic has…
-
What does the term “full-stack programmer” mean? What are the defining traits of a full-stack programmer?
What does the term “full-stack programmer” mean? What are the defining traits of a full-stack programmer? A full stack developer is capable of performing tasks at any level of the technical stack in which they reside. It means: In general a full-stack developer has knowledge that is a mile wide, but not necessarily very deep, and…
-
HOW TO SELECT RANDOM ROWS IN MYSQL
HOW TO SELECT RANDOM ROWS IN MYSQL The easiest way to generate random rows in MySQL is to use the ORDER BY RAND() clause. SELECT col1 FROM tbl ORDER BY RAND() LIMIT 10; This can work fine for small tables. However, for big table, it will have a serious performance problem as in order to…