Category Archives: SQL

Simple PHP MySQL Rest API Sample Example Tutorial

In this article, we will look at a very basic rest api implementation using PHP. If you are to build server infrastructure for any of your new website or app, I would recommend to use rest implementation for your server database access. Rest APIs are really useful when you have to make several different calls… Read More »

14,255 total views, 54 views today

How to install (XAMPP 1.8.3) lamp stack on Ubuntu 14.04, 12.04, 13.10, 13.04, 12.10, and Linux Mint 13/14/15/16.

LAMP stands for Linux, Apache, MySQL, PHP. In this tutorial we will learn how to install XAMPP Server on Ubuntu 14.04. XAMPP Server The latest XAMPP now available in version 1.8.3 has the following features: Apache 2.4.7; MySQL 5.6.14; PHP 5.5.6; PEAR + SQLite 2.8.17/3.7.17 + multibyte support (mbstring); Perl 5.16.3; phpMyAdmin 4.0.9; OpenSSL 1.0.1e;… Read More »

2,096 total views, 4 views today

quick SQL basic concepts learn all in 10 minutes Tutorial with examples

SQL STATEMENTS BASIC SQL COMMANDS SQL statements are classified as follows: Data Retrieval Statement: SELECT is the data extracting statement which retrieves the data from the database. Data Manipulation Language (DML): This language constitutes the statements that are used to manipulate with the data. It has three commands, which are INSERT, UPDATE and DELETE. Data… Read More »

867 total views, 1 views today

Category: SQL