Search option in gridview in php

Search Option

This tutorial is about search option in a grid. There are many searching techniques. Here I explain how to add search option in a grid when a grid has also server side pagination. It’s a simple and very easy way that I use.

When you using server side pagination first you must check it out that on which page your record is exist. Like in my example I want to search ID number “17”. And on per page I am displaying total 10 numbers of rows/records so it means ID number “17” exist on page 2.

Copy and paste this example code which is more understandable.

Step 1:

Create database like "tutorials" and then create table "BOOKS_TBL" with more then 10 record. below is the script of table and data.

Server side pagination in php

Pagination has two types

pagination (Server side pagination) in php

1.  Server Side Pagination
2. Client Side Pagination

In this tutorial we will learn server side pagination technique. To select from these two’s that which one is the best approach, then it’s totally depend on number of rows. Server side pagination technique used when number of rows is more.

Now let’s start example step by step.

Insert Into MySQL PHP MVC

This tutorial helps to developer when developer want to insert data into database (MySQL) with PHP MVC. MVC contains on an Model, View and Controller. In a Model programmer write the code related to Database or business logic. In View create the layout or forms  and using the Controller Model return the data on a View.
To insert into mysql php mvc we follow the few simple steps.

Step 1:

Error message when you try to save a table in SQL Express Server

"Saving changes is not permitted" in SQL Express Server

This problems appear when the Prevent saving changes that require the table re-creation option is checked or enabled. And usually you make the any one changes from following option to table.

• Want to change Allow NULL property of a column
• Want to Reorder the columns
• Want to modify the column data type
• Want to add new column in the table

When you do any one from the above option then you see the following screen or error:

Prevent saving changes that require the table re-creation

Solution:

very Simple and easy solution about this problem.

1.  Open a project in Visual Studio.
2. Click on Tools menu from top and go to Options...
3. Option window will appear. On this window select the Database Tools -> Table and database designers -> Table and Diagram options from the left panel.
4. uncheck the Prevent saving changes that require the table re-creation.
5. At the end click on Ok button.

Solution Screens:

Auto Complete Textbox in PHP

In this tutorial you will learn how a auto complete textbox using php. It so simple and easy.
here i will use the java script function for this task.

Auto Complete textbox in php

PHP Multiple Checkbox Array

This example shows how the programmer can use multiple checkbox array and display the values of selected checkboxes.

Multiple Checkbox Array

PHP Code:

php checkbox

This example or tutorial is about the checkbox in PHP. It is a web form having three checkboxes and two buttons “Select All”, “Deselect All”. “Select All” button purpose is to checked all three checkboxes and “Deselect All” button used for unchecked all three checkboxes.

Select and Deselect All Checkboxes

 PHP Code

Free Website Templates

Web templates free: 

The free premium templates platform. These are pre-defined templates, just download your favorite template and add your content in it.  

Business Today

Academic Education

Darkness

Education Time

      

Gallerised

Write data in text file C++ Filling

To read and write data into file is called filling. Here you learn how to write data in text file.

First include fstream library.

#include <fstream>

 Then in the main function make an object of ofstream and pass the text file name with extention as a parameter to object like this:

ofstream myfile("items_file.txt");

After that open this file and write data in the file.

Example:

An error has occurred during Report Processing

Error:

An error has occurred during report processing. Exception has been thrown by the target of an invocation. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

An error has occurred during Report Processing

This tutorial is about how to solve the above mention error. This error is occurred when the unique, foreign-key field is existing in Table Adapter of DataSet. And this Table Adapter is used in the report Data Source. 

Table Adapter

Solution: