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:

C++ Library Management System Project (LMS)

C++ Library Management System Project (LMS)

Library system Features/Methods:

1. Add Book
2. Add Teachers
3. Add Students
4. Issue book to teachers
5. Issue book to student
6. Return book from teachers
7. Return book from students
8. Display all books
9. Display all teachers
10. Display all students
11. Check book is issued or not?
12. Check all issued books

C++ Banking System Project

Here is a small Bank system using C++. It is not a professional Bank process system. Basically this tutorial is about learning C++. It is a Small C++ course project and C++ basic syntax and structure cover on it.

C++ Banking system features/Methods:

• Login Authentication - 4 logins with user name & password
• Account Open
• Deposit amount
• Withdraw amount
• Display all accounts
• Search account by CNIC No

Calculator Tutorial in JavaScript

This tutorial is about a web base simple calculator which is created in HTML and JavaScript language. JavaScript is very simple and intelligent language. It is a scripting language based on client-side scripting. You can use this script in anywhere on HTML page.

This tutorial is covering all the simple calculator functionality, like Addition, Subtraction, division,
multiplication. Its functionality is similar to Windows calculator.

Calculator Tutorial in JavaScript:

 

Display data from database depending on selected drop down value

Hi friends this tutorial is about how to display data from database depending on selected drop down value in PHP. Normally have different ways for this work. Here i am using very simple way.
Through java script it is very simple to display data from database depending on selected drop down value. 
In this tutorial i use a very simple example like when you select a class from drop down list then all the students of that particular class will display.

Now let's start the tutorial:

First of all we create three .PHP files.

1. connection.php   // make connection to database
2. index.php           // for view class and students.
3. get_student.php  // get data from database and display on index.php file

Populate Select List PHP Mysql

This tutorial is about to "Populate Select List" in PHP using MySQL. Get values which you want to populate into DropDownList, Combobox or Select List from MySQL through query, and then these values add into Select List using PHP code.
Too many ways to populate or bind the Select List, DropDownList, Combobox.

Steps to Populate Select List:

Save image into Database

Export data to Excel in ASP.NET

Today we learn how export the data from the database into Microsoft excel sheet.  So many techniques or ways to export the data into Microsoft excel sheet, but here I have tried to use the easiest way for this purpose or task. No extra namespace, class our assemblies are not required for it. Just follow few steps and get the data on the excel sheet.

We will work step by step

• First step is to create the database and insert the values in it.
• Now add the Dataset into the project. And create a query in it that gets the data from the database table.
• Now go to the .CS page and write the code for it.

Bellow is step by step Example for this task.

Shoes Template

• Shoes Template Free Download

Download this classic template from this link.
Shoes Template >>

Form View in asp.net

Form View control in asp.net is a powerful control. Here is the simple example of form view.
Add form view on the page and bind it with the database using following steps.

Filter GridView in .Net - ASP.Net

This tutorial is about how to add filter in gridview  in asp.net. It is very simple.
First you bind the GridView with database. if you not know how to bind than check the following tutorial:
http://developerqueries.blogspot.com/2012/08/display-data-in-gridview-from-database.html
Now add the DropDownList and fill it with all alphabets.

DropDownList