We will demonstrate you to create condition a form containing a select option box field using CodeIgniter PHP framework. In our example, we have created a select option field in form with fetched values from database using for each loop…

DBNAME shows it is define as constant, my guess it must be define in constant.php You can use grep or notepad++ search in files feature to look for “DBNAME” in whole folder. This way you will get the file where…

Here I have developed an application in Codeigniter which will help you to take backup as per your wish wnenever you want to take backup. While most web hosting company do a daily backup of a customer’s database and site,…

The date_format() function returns a date formatted according to the specified format. Let’s create a date_format() in where condition using codeigniter. if(!empty($this->input->get(‘start_date’))) { $this->db->where(‘DATE_FORMAT(products.created_datetime,”%Y-%m-%d”) >=’, date(‘Y-m-d’,strtotime($this->input->get(‘start_date’)))); }

Generates an insert string based on the data you supply, and runs the query. You can either pass an array or an object to the function. Note: All values are escaped automatically producing safer queries. Let’s create a inser() method…

Query grouping allows you to create groups of WHERE clauses by enclosing them in parentheses. This will allow you to create queries with complex WHERE clauses. Nested groups are supported. $this->db->select(‘*’)->from(‘tbl_user’) ->group_start() ->where(‘a’, ‘a’) ->or_group_start() ->where(‘b’, ‘b’) ->where(‘c’, ‘c’) ->group_end()…

The count_all() method returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. Permits you to determine the number of rows in a…

The count_all_results() method is used to get the number of rows in a MySQL result handle. Permits you to determine the number of rows in a particular Active Record query. Queries will accept Query Builder restrictors such as where(), or_where(),…

Codeigniter provides a limit() method clause that is used to specify the number of records to return. The limit() method makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Returning…

The order_by() method is used to sort the result-set in ascending or descending order. The first parameter contains the name of the column you would like to order by. The second parameter lets you set the direction of the result.…