Freelance work is not for everyone. Freelancing, or working for specific clients on specific projects, comes with distinct advantages and disadvantages. Sometimes people will not know if they are cut out for freelance work until they actually start working. Others may only need to think about a freelance lifestyle to know that it is not for them. If you are considering freelance work, make sure that you think through the many advantages and...

Everything You Need to Get Started With CodeIgniter Tutorial Details Difficulty: Beginner Technology: PHP CodeIgniter is a web application framework for PHP. It enables developers to build web applications faster, and it offers many helpful code libraries and helpers which speed up tedious tasks in PHP. CodeIgniter is based on a modular design; meaning that you can implement specific libraries at your discretion – which adds to...

Working with Database Create a database with a specified name if it does not exist in database server CREATE DATABASE [IF NOT EXISTS] database_name Use database or change current database to another database you are working with USE database_name Drop a database with specified name permanently. All physical file associated with the database is no longer exists. DROP DATABASE [IF EXISTS] database_name Show all available databases in...

SQL UNION allows you to combine two or more result sets from select statements into a single result set. The usage of using SQL UNION is as follows: SELECT statement UNION [DISTINCT | ALL] SELECT statement UNION [DISTINCT | ALL] … The column list of each individual SELECT statement must have the same data type. By default the UNION removes all duplicated rows from the result set even if you don’t explicit using DISTINCT after the UNION...

PHP (“Hypertext Preprocessor”) is a widely-used Open Source general-purpose scripting language that is especially suited for Web applications and website development, and can be embedded into HTML. Most of its syntax draws upon C, Java, and Perl, being very easy to learn. The main goal of the PHP language is to allow web developers to write dynamically generated web pages quickly, but due to its powerful flexibility, you can do...