Category: MySQL

CodeIgniter - Delete

CodeIgniter – Delete

Codeigniter – Delete This tutorial will show you how to delete record from database using Codeigniter. If you are new here and did not see previous tutorials, you may want to visit Linux Web Zone CodeIgniter Series There you can find links for all lessons from our CodeIgniter Series Controller...

CodeIgniter - Delete

Codeigniter – Update

Codeigniter – Update This tutorial will show you how to edit record and save changes back to database using Codeigniter. If you are new here, you may want to see Linux Web Zone CodeIgniter Series There you can find links for all lessons from our CodeIgniter Series Controller We will...

CodeIgniter - Read

CodeIgniter – Read

CodeIgniter – Read Today, I will show you how to get results from database and print in in table. This is very common operation and it is not to complicated, especially when using CodeIgniter’s Active Record for database communication. In case you missed our previous tutorial with adding records to...

CodeIgniter - Read

Codeigniter – Insert

Codeigniter – Insert This tutorial will show you how to add record to database using Codeigniter. I will use Codeigniter’s Active Record for database queries which is a safer way to execute queries than raw SQL. Before we begin with Codeigniter Create Tutorial, you need to set up your Codeigniter....

CodeIgniter - Read

CodeIgniter Configuration

CodeIgniter Configuration Tutorial This tutorial will show you how to configure CodeIgniter for the rest of the tutorials in our CodeIgniter Tutorials Series. I will use Bootstrap Framework which is used for developing responsive HTML projects. Bootstrap will make our project more eye pleasing than plain HTML, unless you want...

CodeIgniter - Read

Setting up CodeIgniter Framework

(Current Version 3.0.6) CodeIgniter is an web application development framework for building web sites using PHP. It allows much faster development of PHP projects than writing application from zero. CodeIgniter provides a lot of libraries for various tasks and easy access to them. Using CodeIgniter makes code writing much simpler...

#1064 – You have an error in your SQL syntax

#1064 – You have an error in your SQL syntax

  You may experienced this error while importing database: #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’ at line 20

Apache Directory Authentication Within Virtual Host

LAMP Install (Apache, MySQL, PHP)

Few things about LAMP LAMP is is a group of open source software used for web servers. LAMP stands for Linux, Apache, MySQL, and PHP. If you are planning to run a web server for personal website, forum, chat etc. LAMP is the best solution for you As you can...