Learn Programming ASP.NET PHP JAVA HTML CSS

Search option in gridview in php

noreply@blogger.com (Anonymous) — Thu, 21 Apr 2016 09:13:00 +0000

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.

 --  
 -- Table structure for table `books_tbl`  
 --  
 CREATE TABLE IF NOT EXISTS `books_tbl` (  
  `BOOK_ID` int(11) NOT NULL AUTO_INCREMENT,  
  `BOOK_NAME` varchar(100) NOT NULL,  
  PRIMARY KEY (`BOOK_ID`),  
  UNIQUE KEY `BOOK_NAME` (`BOOK_NAME`)  
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;  
 --  
 -- Dumping data for table `books_tbl`  
 --  
 INSERT INTO `books_tbl` (`BOOK_ID`, `BOOK_NAME`) VALUES  
 (10, 'Biology'),  
 (11, 'Book 1'),  
 (20, 'Book 10'),  
 (21, 'Book 11'),  
 (22, 'Book 12'),  
 (23, 'Book 13'),  
 (24, 'Book 14'),  
 (25, 'Book 15'),  
 (26, 'Book 16'),  
 (27, 'Book 17'),  
 (28, 'Book 18'),  
 (29, 'Book 19'),  
 (12, 'Book 2'),  
 (30, 'Book 20'),  
 (31, 'Book 21'),  
 (32, 'Book 22'),  
 (13, 'Book 3'),  
 (14, 'Book 4'),  
 (15, 'Book 5'),  
 (16, 'Book 6'),  
 (17, 'Book 7'),  
 (18, 'Book 8'),  
 (19, 'Book 9'),  
 (9, 'Chemistry'),  
 (1, 'English A'),  
 (2, 'English B'),  
 (7, 'General Science'),  
 (5, 'Mathematics'),  
 (8, 'Physics'),  
 (6, 'Social Studies'),  
 (3, 'Urdu A'),  
 (4, 'Urdu B');

Step 2:

create a file with the name of "pagination.php". and insert the following Code in this file.

 <?php   
 error_reporting(0);  
 $num_rec_per_page=10;  
 $con = mysql_connect('localhost','root','');  
 mysql_select_db('tutorials');  
 if (isset($_GET["search"])) // this if is related to search option  
 {  
      $searchid = $_POST["search"]; // assig the search id which you want to search to $searchid variable.  
      $pageid = ceil($searchid / $num_rec_per_page); // this statement is checking that on which page this search record is exist.   
      header("location: pagination.php?sid=".$searchid."&page=".$pageid); // after check the page redirect the URL on that page like in my case URL will: http://localhost/tutorials/pagination.php?sid=17&page=2  
 } // end if of $_GET["search"]  
 else  
 {  
      if (isset($_GET["page"]))   
      {   
           $page = $_GET["page"];   
      }   
      else   
      {   
           $page=1;  
      }  
 }  
 $start_from = ($page - 1) * $num_rec_per_page;  
 $sql = "SELECT * FROM BOOKS_TBL order by BOOK_ID LIMIT $start_from, $num_rec_per_page";   
 //echo $sql; exit;  
 $rs_result = mysql_query ($sql); //run the query  
 ?>   
 <html>  
 <head><title>Search option in a grid Tutorial | www.developerqueries.blogspot.com</title></head>  
 <body>  
 <form id="form1" method="POST" action="pagination.php?search">  
 <input type="text" name="search" /><input type="submit" id="btnsearch" name="btnsearch" value="Go" />  
 </form>  
 <table>  
 <tr><td>ID</td><td>Name</td></tr>  
 <?php   
 while ($row = mysql_fetch_array($rs_result)) {   
 ?>   
       <?php   
                     if ($_REQUEST["sid"] == $row['BOOK_ID']) // if your search result match row will be highlighted with yellow colour.  
                     {  
                          echo "<tr style='background-color:yellow'>";  
                     }  
                     else  
                     {  
                          echo "<tr>";  
                     }  
                ?>  
       <td><?php echo $row['BOOK_ID']; ?></td>  
       <td><?php echo $row['BOOK_NAME']; ?></td>        
       </tr>  
 <?php   
 }  
 ?>   
 </table>  
 <?php   
 $sql = "SELECT * FROM BOOKS_TBL";   
 $rs_result = mysql_query($sql); //run the query  
 $total_records = mysql_num_rows($rs_result); //count number of records  
 $total_pages = ceil($total_records / $num_rec_per_page);   
 echo "<a href='pagination.php?page=1'>".'|<'."</a> "; // Goto 1st page   
 for ($i=1; $i<=$total_pages; $i++) {   
       echo "<a href='pagination.php?page=".$i."'>".$i."</a> ";   
 }  
 echo "<a href='pagination.php?page=$total_pages'>".'>|'."</a> "; // Goto last page  
 ?>  
 </body>  
 </html>

Server side pagination in php

noreply@blogger.com (Anonymous) — Fri, 15 Apr 2016 07:16:00 +0000

Pagination has two types

pagination (Server side pagination) in php

Server Side Pagination

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.

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.

 --  
 -- Table structure for table `books_tbl`  
 --  
 CREATE TABLE IF NOT EXISTS `books_tbl` (  
  `BOOK_ID` int(11) NOT NULL AUTO_INCREMENT,  
  `BOOK_NAME` varchar(100) NOT NULL,  
  PRIMARY KEY (`BOOK_ID`),  
  UNIQUE KEY `BOOK_NAME` (`BOOK_NAME`)  
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;  
 --  
 -- Dumping data for table `books_tbl`  
 --  
 INSERT INTO `books_tbl` (`BOOK_ID`, `BOOK_NAME`) VALUES  
 (10, 'Biology'),  
 (11, 'Book 1'),  
 (20, 'Book 10'),  
 (21, 'Book 11'),  
 (22, 'Book 12'),  
 (23, 'Book 13'),  
 (24, 'Book 14'),  
 (25, 'Book 15'),  
 (26, 'Book 16'),  
 (27, 'Book 17'),  
 (28, 'Book 18'),  
 (29, 'Book 19'),  
 (12, 'Book 2'),  
 (30, 'Book 20'),  
 (31, 'Book 21'),  
 (32, 'Book 22'),  
 (13, 'Book 3'),  
 (14, 'Book 4'),  
 (15, 'Book 5'),  
 (16, 'Book 6'),  
 (17, 'Book 7'),  
 (18, 'Book 8'),  
 (19, 'Book 9'),  
 (9, 'Chemistry'),  
 (1, 'English A'),  
 (2, 'English B'),  
 (7, 'General Science'),  
 (5, 'Mathematics'),  
 (8, 'Physics'),  
 (6, 'Social Studies'),  
 (3, 'Urdu A'),  
 (4, 'Urdu B');

Step 2:

create a file with the name of "pagination.php". and insert the following Code in this file.

 <?php   
 error_reporting(0);  
 $num_rec_per_page=10;  // set the number of records display at per page
 $con = mysql_connect('localhost','root','');  
 mysql_select_db('tutorials');

// bellow mentioned if set the page number, means which page you want to visit like pagination?page=1
 if (isset($_GET["page"]))   
 {   
      $page = $_GET["page"];   
 }   
 else   
 {   
      $page=1;  
 }

 $start_from = ($page - 1) * $num_rec_per_page;  //  set page wise starting limit like if page 1 and the total records display 10 on per page starting limit from 0 and if page 2 starting limit 10 and so on.


 $sql = "SELECT * FROM BOOKS_TBL order by BOOK_ID LIMIT $start_from, $num_rec_per_page"; // query that returns the records for per page with respect to limit.

     
 $rs_result = mysql_query ($sql); //run the query  
 ?>   
 <html>  
 <head><title>Server Side Pagination Tutorial | www.developerqueries.blogspot.com</title></head>  
 <body>  
 <table>  
 <tr><td>ID</td><td>Name</td></tr>

<!-- below mention php tag will display the data  -->
 <?php   
 while ($row = mysql_fetch_array($rs_result)) {   
 ?>   
       <tr>  
       <td><?php echo $row['BOOK_ID']; ?></td>  
       <td><?php echo $row['BOOK_NAME']; ?></td>        
       </tr>  
 <?php   
 }  
 ?>


 </table>


 <?php   // below mentioned php tags shows the pagination number like on click which page number related data show.

 $sql = "SELECT * FROM BOOKS_TBL";   
 $rs_result = mysql_query($sql); //run the query  
 $total_records = mysql_num_rows($rs_result); //count total number of records  
 $total_pages = ceil($total_records / $num_rec_per_page);   
 echo "<a href='pagination.php?page=1'>".'|<'."</a> "; // Go to first page   
 for ($i=1; $i<=$total_pages; $i++) {   
       echo "<a href='pagination.php?page=".$i."'>".$i."</a> ";   
 }  
 echo "<a href='pagination.php?page=$total_pages'>".'>|'."</a> "; // Go to last page  
 ?>


 </body>  
 </html>

Insert Into MySQL PHP MVC

noreply@blogger.com (Anonymous) — Mon, 05 Oct 2015 19:45:00 +0000

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:

Create the 3 folders with the name Model,View and Controller respectively. Also Create a index.php file.

Folders and file which is used

In Controller folder create Controller.php.

In Model folder create Model.php.

In View folder create view.php.

Step 2:

in the above mention index.php file write the following code:

<?php

include_once("Controller/Controller.php");

$Controller = new Controller();

$Controller->show();

Step 3:

Now in the Controller folder create a file with name "Controller.php" and write the bellow mentioned code.

<?php

include_once("Model/Model.php");

Class Controller{

public $model;

public function Controller()

{

$this->model=new Model();

}

public function show()

{

$result = $this->model->insert_data();

include 'View/view.php';

}

Step 4:

Create a "Model.php" file inside the Model folder and write the code like this.

<?php

Class Model{

public function Model()

{

$con = mysql_connect("localhost","root","") or die('Not connected to Database<br>' . mysql_error());

mysql_select_db("mvc_db",$con) or die('Not Select Database' . mysql_error());

}

public function insert_data()

{

if (isset($_POST['name']) && isset($_POST['age']) && isset($_POST['name'])) {

$name = $_POST['name'];

$age = $_POST['age'];

$city = $_POST['city'];

$qry = "insert into table1 (name,age,city) values('$name',$age,'$city')";

$result = mysql_query($qry);

if ($result) {

return "Insert Data Successfully.";

}

else

{

return "Error...! Not Inserted.";

}

else

{

return "";

}

Step 5:

At last create the "view.php" file in View folder and write the following code. It's simple html base form.

<!DOCTYPE html>

<html>

<head>

<title>Insert Data in MySQL using PHP MVC</title>

</head>

<body>

<?php

echo $result;

<p>

</p>

<p>

</p>

<p>

</p>

<br />

<p>

<button type="submit" class="green big" name="submit"><span>Save</span></button> <button type="reset" class="grey big"><span>Cancle</span></button>

</p>

</form>

</body>

</html>

output:

After complete all these five steps open the "index.php" file on browser. Form will display like this:

Insertion Form

Now enter the required field data and press Save button. If the record inserted then the "Insert Data Successfully" message will display as shown in bellow mention screen shot. and if the data will not inserted then the "Error...! Not Inserted." message will display.

After data inserted successfully

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

noreply@blogger.com (Anonymous) — Tue, 21 Apr 2015 08:22:00 +0000

"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.

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

Solution Screens:

Auto Complete Textbox in PHP

noreply@blogger.com (Anonymous) — Tue, 21 Apr 2015 06:02:00 +0000

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

first of all you will create the two php files.

index.php
autocomplete.php

Step 1:

when you create the index.php file then open it and past the following code in it.

Code:

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
 <html xmlns="http://www.w3.org/1999/xhtml">  
 <head>  
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />  
 <title>Auto Complete textbox in php | www.developerqueries.blogspot.com</title>  
 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />  
 <script type="text/javascript" src="jquery.js"></script>  
 <script type="text/javascript" src="jquery.autocomplete.js"></script>  
 <script>  
 $(document).ready(function(){  
  $("#student").autocomplete("autocomplete.php", {  
           selectFirst: true  
      });  
 });  
 </script>  
 </head>  
 <body>  
   <label>Student:</label>  
   <input name="student" type="text" id="student" size="20" />  
 </body>  
 </html>

Step 2:

Now open the autocomplete.php file which is already created, and past the following code in it.

Code:

 <?php  
      $q=$_GET['q'];  
      $my_data=mysql_real_escape_string($q);  
      $mysql=mysql_connect('localhost','root','') or die("Database Error");  
      $db=mysql_select_db('test') or die("Database Error");  
      $sql="SELECT std_name FROM student_info WHERE std_name LIKE '%$my_data%' ORDER BY std_name";  
      $result = mysql_query($sql,$mysql);  
      if($result)  
      {  
           while($row=mysql_fetch_array($result))  
           {  
                echo $row['std_name']."\n";  
           }  
      }  
 ?>

Now your auto complete textbox is ready for working. run your index.php file and use this functionality.

PHP Multiple Checkbox Array

noreply@blogger.com (Anonymous) — Wed, 25 Feb 2015 11:23:00 +0000

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

Multiple Checkbox Array

PHP Code:

<table>

<tr>

<td>Checkbox Array Example. Select from below</td>

</tr>

<tr>

<td>

<input type='checkbox' name='checkboxarray[]' value='checkbox 1'>checkbox 1<br>

<input type='checkbox' name='checkboxarray[]' value='checkbox 2'>checkbox 2<br>

<input type='checkbox' name='checkboxarray[]' value='checkbox 3'>checkbox 3

</td>

</tr>

</table>

</form>

<?php

if (isset($_GET['process']))

{

echo "you Selected: ";

foreach($_POST['checkboxarray'] as $value)

{

echo $value."\t";

}

Note:

Copy and paste this code and save the file with the name of "CheckboxArray.php" and enjoyed.

OUTPUT

Multiple Checkbox Array

php checkbox

noreply@blogger.com (Anonymous) — Mon, 23 Feb 2015 07:24:00 +0000

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

<html>

<body>

<input type="checkbox" id="Checkbox1" name="Checkbox1" <?php if(isset($_GET['process'])){ echo "checked=true"; } ?>> Checkbox 1

<input type="checkbox" id="Checkbox2" name="Checkbox2" <?php if(isset($_GET['process'])){ echo "checked=true"; } ?>> Checkbox 2

<input type="checkbox" id="Checkbox3" name="Checkbox3" <?php if(isset($_GET['process'])){ echo "checked=true"; } ?>> Checkbox 3

</br></br>

</form>

</form>

</body>

</html>

OUT PUT

when you click on the "Select All" button the output will...

Select all checkboxes

when click on the "Deselect All" button output wil...

Deselect all checkboxes

Note:

copy and paste PHP code in php file and you must save it with the name of "Checkbox.php".

Free Website Templates

noreply@blogger.com (Anonymous) — Fri, 21 Nov 2014 06:17:00 +0000

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

-------------------------------------------------------------------------------------------

Business Today Template:

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/businesstoday/

Download Link:

http://www.free-css.com/assets/files/free-css-templates/download/page1/businesstoday.zip

----------------------------------------------------------------------------------------------------------------------------------

Academic Education Template:

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/academic-education/

Download Link:

http://www.free-css.com/assets/files/free-css-templates/download/page1/academic-education.zip

-----------------------------------------------------------------------------------------------------------------------------------

Darkness Template:

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/darkness/

Download Link:

http://www.free-css.com/assets/files/free-css-templates/download/page1/darkness.zip
-----------------------------------------------------------------------------------------------------------------------------------

Education Time Template:

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/education-time/

Download Link:

http://www.free-css.com/assets/files/free-css-templates/download/page1/education-time.zip

-----------------------------------------------------------------------------------------------------------------------------------

Gallery Template:

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/gallerised/

Download Link:

http://www.free-css.com/assets/files/free-css-templates/download/page1/gallerised.zip

Write data in text file C++ Filling

noreply@blogger.com (Anonymous) — Wed, 28 May 2014 12:58:00 +0000

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:

In this example I will create “items_file.txt”. and take a number as a input from user and store it into that text file.

Compile and run the below code and check it out.

Write data in text file C++ Filling Code

Code is here:

#include <cstdlib>

#include <iostream>

#include <fstream>

using namespace std;

int main(int argc, char *argv[])

{

ofstream myfile("items_file.txt");

if (myfile.is_open())

{

int number;

cout<<"Enter that Number which you want to write in text file"<<endl;

cin>>number;

myfile << number<<"\n";

myfile.close();

cout<<"Record Inserted"<<endl;

}

else cout << "Unable to open file";

system("PAUSE");

return EXIT_SUCCESS;

}

An error has occurred during Report Processing

noreply@blogger.com (Anonymous) — Mon, 26 May 2014 14:07:00 +0000

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:

Its solution is very simple. Go to that Table Adapter in a DataSet which you use in a report. Select the unique, foreign-key field and then right click on it go to the “delete key” option and delete it.

Table Adapter Field Propertie | Delete Key

Save DataSet Table Adapter and run report again.

C++ Library Management System Project (LMS)

noreply@blogger.com (Anonymous) — Tue, 13 May 2014 07:18:00 +0000

C++ Library Management System Project (LMS)

Library system Features/Methods:

Add Book
Add Teachers
Add Students
Issue book to teachers
Issue book to student
Return book from teachers
Return book from students
Display all books
Display all teachers
Display all students
Check book is issued or not?
Check all issued books

How you can use or run this code:

Copy the bellow mentioned class in separate files like book class in book.ccp file, teacher class in teacher.cpp, student in student.cpp and main in main.cpp

After that compile and run the main class.

download from here: https://drive.google.com/file/d/0B599xkio99pxd0NyX0d5OWNZTFE/edit

Overview:

This tutorial is about Library Management System, created in C++. It is a small library system.

In this system user can add books, teachers and students it’s a default. Default means first you enter these three things. After that you can issue the books to teachers or students. Teachers can issue the 3 books at a time but a student can issue the single book at a time. Book return functionality is also available on this system.

C++ Library Management System has different search criteria’s as mention in above.

Library Management System has 4 main classes

Classes:

Book Class
Teacher
Student
Main

Book Class:

Book class manages the books like book number, book name and book issued or not.

Here is a code of book class:

#include <cstdlib>

#include <iostream>

#include <string>

using namespace std;

class book

{

protected:

int b_no;

string bname;

int bissued;

public:

book();

void set_bname(string bn);

string get_bname();

void set_bno(int b_no);

int get_bno();

void set_bissued(int b_iss);

int get_bissued();

};

book::book()

{

b_no = 0;

bissued = 0;

}

void book :: set_bname(string bn)

{

bname = bn;

}

void book :: set_bno(int bno)

{

b_no = bno;

}

void book :: set_bissued(int b_iss)

{

bissued = b_iss;

}

string book :: get_bname()

{

return bname;

}

int book :: get_bno()

{

return b_no;

}

int book :: get_bissued()

{

return bissued;

}

Teacher Class:

Teacher class manages the all teacher related things like teacher name, book issued limit and book no (which is issued to teacher).

Here is a code of teacher class:

#include <cstdlib>

#include <iostream>

#include <string>

using namespace std;

class teacher

{

public:

string name;

int limit;

int emp_code;

int bno[3];

public:

teacher();

void set_limit(int lmt);

int get_limit();

//void set_emp_code(int lmt);

//int get_emp_code();

void set_name(string n);

string get_name();

void Insert_Teacher_Data(string tn, int lm);

};

teacher :: teacher()

{

limit = 0;

bno[0]=0;

bno[1]=0;

bno[2]=0;

}

void teacher :: set_limit(int lmt)

{

limit = lmt;

}

void teacher :: set_name(string n)

{

name = n;

}

int teacher :: get_limit()

{

return limit;

}

string teacher :: get_name()

{

return name;

}

void teacher :: Insert_Teacher_Data(string tn, int lm)

{

this->set_name(tn);

this->set_limit(lm);

}

Student Class:

Student class manages the all student related data like student name, book issued limit and book no (which is issued to student).

Here is a code of student class:

#include <cstdlib>

#include <iostream>

#include <string>

using namespace std;

class Student

{

public:

string name;

int limit;

int bno;

public:

Student();

void set_limit(int lmt);

int get_limit();

void set_b_code(int bc);

int get_b_code();

void set_name(string n);

string get_name();

};

Student :: Student()

{

limit = 0;

bno = 0;

}

void Student :: set_limit(int lmt)

{

limit = lmt;

}

void Student :: set_name(string n)

{

name = n;

}

void Student :: set_b_code(int bc)

{

bno = bc;

}

int Student :: get_b_code()

{

return bno;

}

int Student :: get_limit()

{

return limit;

}

string Student :: get_name()

{

return name;

}

Main Class:

All the activities are managed in the main class like add book, add teacher, add student, book issue, book return, search etc.

Here is a code of Main class:

#include <cstdlib>

#include <iostream>

#include <string>

#include "book.cpp"

#include "teacher.cpp"

#include "student.cpp"

using namespace std;

int main(int argc, char *argv[])

{

const int max_bk = 100, max_t = 5, max_std = 5;

book bk[max_bk];

teacher tec[max_t];

Student std[max_std];

int bkn=0;

int tn=0;

int sn=0;

char ans;

char menu;

{

system("cls");

cout<<"---------------- Main Menu ---------------------------"<<endl;

cout<<"1. For Add Book"<<endl;

cout<<"2. Add Teacher"<<endl;

cout<<"3. Add Student"<<endl;

cout<<"4. Issue Book to Teacher"<<endl;

cout<<"5. For Return Book from teacher"<<endl;

cout<<"6. Issue Book to Student"<<endl;

cout<<"7. For Return Book from Student"<<endl;

cout<<"8. For Searching"<<endl;

cout<<"0. For Exit"<<endl;

cout<<"------------------------------------------------------"<<endl;

cout << "Select from Menu:";

cin>>menu;

switch (menu)

{

case '1':{

cout<<"---------------- Add Book -----------------------"<<endl;

do{

string bn;

int bno;

cout << "Enter Book Name";

cin>>bn;

cout << "Enter Book Code:";

cin>>bno;

bk[bkn].set_bname(bn);

bk[bkn].set_bno(bno);

bk[bkn].set_bissued(0);

bkn++;

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '2':{

cout<<"---------------- Insert Teacher -----------------------"<<endl;

do{

string tnm;

cout << "Enter Teacher Name";

cin>>tnm;

tec[tn].set_name(tnm);

//bk[tn++].set_bno(bno);

tec[tn].set_limit(0);

tn++;

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '3':{

cout<<"---------------- Insert Student -----------------------"<<endl;

do{

string stdn;

cout << "Enter Student Name";

cin>>stdn;

std[sn].set_name(stdn);

std[sn].set_b_code(0);

std[sn].set_limit(0);

sn++;

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '4':{

cout<<"---------------- Issue Book to Teacher -----------------------"<<endl;

do{

string tnm;

int bcode;

cout << "Enter Teacher Name";

cin>>tnm;

cout << "Enter Book Code";

cin>>bcode;

for(int i=0; i<max_t; i++)

{

if(tec[i].get_name() == tnm)

{

int lm = tec[i].get_limit();

// cout<<"Limit is: "<<lm<<endl;

if(lm <=3)

{

for(int k=0; k<max_bk; k++)

{

if(bk[k].get_bno()==bcode)

{

cout<<"Issued: "<<bk[k].get_bissued()<<endl;

if(bk[k].get_bissued()==0)

{

bk[k].set_bissued(1);

tec[i].bno[lm] = bcode;

lm = lm +1;

tec[i].set_limit(lm);

}

else

{

cout << "This Book is already issued" <<endl;

}

break;

}

else

{

cout << "You have reached the MAX Limit."<<endl;

}

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '5':{

cout<<"---------------- Return Book -----------------------"<<endl;

do{

string tnm;

int bcode;

cout << "Enter Teacher Name";

cin>>tnm;

cout << "Enter Book Code";

cin>>bcode;

for(int i=0; i<max_t; i++)

{

if(tec[i].get_name() == tnm)

{

for(int b=0; b<3; b++)

{

int bkno = tec[i].bno[b];

//cout<<"bk: "<<bkno<<endl;

if(bkno == bcode)

{

int lm = tec[i].get_limit();

// cout<<"Limit is: "<<lm<<endl;

if(lm <=3)

{

for(int k=0; k<max_bk; k++)

{

if(bk[k].get_bno()==bcode)

{

//cout<<"Issued: "<<bk[k].get_bissued()<<endl;

if(bk[k].get_bissued()==1)

{

bk[k].set_bissued(0);

lm = lm - 1;

tec[i].set_limit(lm);

tec[i].bno[lm] = 0;

}

break;

}

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '6':{

cout<<"---------------- Issue Book to Student -----------------------"<<endl;

do{

string stdn;

int bcode;

cout << "Enter student Name";

cin>>stdn;

cout << "Enter Book Code";

cin>>bcode;

for(int i=0; i<max_std; i++)

{

if(std[i].get_name() == stdn)

{

int lm = std[i].get_limit();

// cout<<"Limit is: "<<lm<<endl;

if(lm == 0)

{

for(int k=0; k<max_bk; k++)

{

if(bk[k].get_bno()==bcode)

{

//cout<<"Issued: "<<bk[k].get_bissued()<<endl;

if(bk[k].get_bissued()==0)

{

bk[k].set_bissued(1);

std[i].set_b_code(bcode);

lm = lm +1;

std[i].set_limit(lm);

}

else

{

cout << "This Book is already issued" <<endl;

}

break;

}

else

{

cout << "You have reached the MAX Limit."<<endl;

}

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '7':{

cout<<"---------------- Return Book -----------------------"<<endl;

do{

string stdn;

int bcode;

cout << "Enter student Name";

cin>>stdn;

cout << "Enter Book Code";

cin>>bcode;

for(int i=0; i<max_std; i++)

{

if(std[i].get_name() == stdn)

{

for(int b=0; b<3; b++)

{

int bkno = std[i].get_b_code();

//cout<<"bk: "<<bkno<<endl;

if(bkno == bcode)

{

int lm = std[i].get_limit();

// cout<<"Limit is: "<<lm<<endl;

if(lm ==1)

{

for(int k=0; k<max_bk; k++)

{

if(bk[k].get_bno()==bcode)

{

//cout<<"Issued: "<<bk[k].get_bissued()<<endl;

if(bk[k].get_bissued()==1)

{

bk[k].set_bissued(0);

lm = lm - 1;

std[i].set_limit(lm);

std[i].set_b_code(0);

}

break;

}

cout << "Enter another (y/n)?: " ;

cin >> ans;

} while ( ans != 'n' );

}break;

case '8':{

char smenu;

system("cls");

cout<<"---------------- Search Menu ---------------------------"<<endl;

cout<<"1. For Display all Book"<<endl;

cout<<"2. For Display all Teachers"<<endl;

cout<<"3. For Display all Student"<<endl;

cout<<"4. For check book is issued or not"<<endl;

cout<<"5. For check all issued Book"<<endl;

cout<<"------------------------------------------------------"<<endl;

cout << "Select from Menu: ";

cin>>smenu;

switch (smenu)

{

case '1':{

for(int i=0; i<max_bk; i++)

{

cout<<"Name is: "<<bk[i].get_bname()<<endl;

cout<<"Book Code: "<<bk[i].get_bno()<<endl;

cout<<"Book issued: "<<bk[i].get_bissued()<<endl;

}

system("pause");

}break;

case '2':{

for(int i=0; i<max_t; i++)

{

cout<<"Name is: "<<tec[i].get_name()<<endl;

cout<<"Limit is: "<<tec[i].get_limit()<<endl;

for(int j=0; j<3; j++)

{

cout<<"Book Code: "<<tec[i].bno[j]<<endl;

}

system("pause");

}break;

case '3':{

for(int i=0; i<max_std; i++)

{

cout<<"Name is: "<<std[i].get_name()<<endl;

cout<<"Book Code: "<<std[i].get_b_code()<<endl;

cout<<"Limit is: "<<std[i].get_limit()<<endl;

}

system("pause");

}break;

case '4':{

int bk_no;

cout << "Book Code: ";

cin>>bk_no;

for(int i=0; i<max_bk; i++)

{

if(bk[i].get_bno()==bk_no)

{

cout<<"Name is: "<<bk[i].get_bname()<<endl;

cout<<"Book Code: "<<bk[i].get_bno()<<endl;

if(bk[i].get_bissued()==1)

{

cout<<"Book is issued. "<<endl;

}

else

{

cout<<"Book is not issued. "<<endl;

}

system("pause");

}break;

case '5':{

for(int i=0; i<max_bk; i++)

{

if(bk[i].get_bissued()==1)

{

cout<<"Name is: "<<bk[i].get_bname()<<endl;

cout<<"Book Code: "<<bk[i].get_bno()<<endl;

}

system("pause");

}break;

default:{

break;

} break;

}

}break;

default:{

cout << "Realy want to Exit (y/n)?: " ;

cin >> menu;

} break;

}

}while(menu!='y');

system("pause");

return 0;

}

C++ Banking System Project

noreply@blogger.com (Anonymous) — Fri, 14 Mar 2014 17:46:00 +0000

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

Brief description about bank System:

First login using 4 different authentications (Username, Password) which is already stored in the string type two dimensional arrays. Then you can open the 10 different accounts after that you can do different transaction through these accounts. You can also search a specific account through CNIC no. and can also display all the records at a same time.

Here is the code of a bank system:

#include <iostream>

#include <string>

#include <sstream>

using namespace std;

int total_accounts = 10;

string accounts[10][5];

string login_authentication[4][2] = {{"user1","111"},{"user2","222"},{"user3","333"},{"user4","444"}};

void authentication();

void open_account();

void menu();

void deposit_amount();

void all_accounts();

void search_acc();

void withdraw_amount();

int main()

{

char choice;

{

system("cls");

cout<<"1 Log in"<<endl;

cout<<"0 Exit"<<endl;

cout<<"Choose the desired option: ";

cin>>choice;

switch (choice)

{

case '1':

authentication();

break;

default:

choice='$';

break;

}

}while(choice!='$');

exit(0);

return 0;

}

////////////////// Functions //////////////////////

///////////////// Menu /////////////////////////////

void menu()

{

cout<<"1 Open an Account"<<endl;

cout<<"2 Deposit amount"<<endl;

cout<<"3 withdraw amount"<<endl;

cout<<"4 Search All Accounts"<<endl;

cout<<"5 Search an account using CNIC and display its information"<<endl;

cout<<"0 Exit"<<endl;

cout<<"Choose the desired option (1-5): ";

}

////////////////////////////////////////////////////////

//////////////// Log in Authentication Function //////////////

void authentication()

{

char choice;

char ch;

system("cls");

string username;

string password;

int log_in = 0;

cout<<"User Name: ";

cin>>username;

cout<<"Password: ";

cin>>password;

for(int i=0; i<4; i++)

{

if(username == login_authentication[i][0] && password == login_authentication[i][1])

{

system("cls");

menu();

cin>>choice;

switch (choice)

{

case '1':

open_account();

system("cls");

menu();

break;

case '2':

deposit_amount();

system("cls");

menu();

break;

case '3':

withdraw_amount();

system("pause");

break;

case '4':

all_accounts();

system("pause");

break;

case '5':

search_acc();

break;

default:

choice='0';

break;

}

}while(choice != '0');

}

else

{

cout<<"Invalid Username and Password."<<endl;

}

//////////////////////////////////////////////////////////////

///////////////// Open an Acciunt ////////////////////////////

void open_account()

{

char ch;

string acc_num;

string acc_title;

string acc_bal;

string acc_holder_name;

string acc_holder_cnic;

int account_num = 1;

if(account_num<=total_accounts)

{

system("cls");

menu();

for(int j=0; j<total_accounts; j++)

{

cout<<endl;

cout<<"Account: "<<account_num<<endl;

cout<<"Enter Account Number: ";

cin>>acc_num;

cout<<"Enter Account Title: ";

cin>>acc_title;

cout<<"Enter Account Balance: ";

cin>>acc_bal;

cout<<"Enter Account Holder Name: ";

cin>>acc_holder_name;

cout<<"Enter Account Holder CNIC: ";

cin>>acc_holder_cnic;

accounts[j][0] = acc_num;

accounts[j][1] = acc_title;

accounts[j][2] = acc_bal;

accounts[j][3] = acc_holder_name;

accounts[j][4] = acc_holder_cnic;

cout<<"Open another Account.(y/n)?: ";

cin>>ch;

if(ch != 'n')

{

account_num++;

}

else

{

j=10;

}

else

{

cout<<"Maximum accounts limit reached."<<endl;

}

///////////////////////////////////////////////////////////

///////////////////// Deposit Amount //////////////////////

void deposit_amount()

{

int current_bal;

string acc_no;

int acc_bal;

cout<<endl;

cout<<"Enter Account Number: ";

cin>>acc_no;

cout<<"Enter Deposit Amount: ";

cin>>acc_bal;

for(int j=0; j<total_accounts; j++)

{

if(acc_no == accounts[j][0])

{

string s = accounts[j][2];

stringstream ss(s);

ss >> current_bal;

current_bal = current_bal + acc_bal;

stringstream ss1;

ss1 << current_bal;

accounts[j][2] = ss1.str();

//cout<<"Amount Added."<<current_bal<<endl;

//system("pause");

}

//////////////////////////////////////////////////////////

///////////////////// Withdraw Amount //////////////////////

void withdraw_amount()

{

int current_bal;

string acc_no;

int acc_bal;

cout<<endl;

cout<<"Enter Account Number: ";

cin>>acc_no;

cout<<"Enter Deposit Amount: ";

cin>>acc_bal;

for(int j=0; j<total_accounts; j++)

{

if(acc_no == accounts[j][0])

{

string s = accounts[j][2];

stringstream ss(s);

ss >> current_bal;

current_bal = current_bal - acc_bal;

stringstream ss1;

ss1 << current_bal;

accounts[j][2] = ss1.str();

//cout<<"Amount Added."<<current_bal<<endl;

//system("pause");

}

//////////////////////////////////////////////////////////

////////////////////////// Search all Accounts /////////////

void all_accounts()

{

for(int j=0; j<total_accounts; j++)

{

cout<<"Account Number: "<<accounts[j][0]<<endl;

cout<<"Account Title: "<<accounts[j][1]<<endl;

cout<<"Account Balance: "<<accounts[j][2]<<endl;

cout<<"Account Holder Name: "<<accounts[j][3]<<endl;

cout<<"Account Holder CNIC: "<<accounts[j][4]<<endl;

}

/////////////////////////////////////////////////////////////

////////////////// Search Account by CNIC //////////////////

void search_acc()

{

string acc_h_cnic;

cout<<"Enter Account Holder CNIC: ";

cin>>acc_h_cnic;

cout<<endl;

for(int j=0; j<total_accounts; j++)

{

if(acc_h_cnic == accounts[j][4])

{

cout<<"Account Number: "<<accounts[j][0]<<endl;

cout<<"Account Title: "<<accounts[j][1]<<endl;

cout<<"Account Balance: "<<accounts[j][2]<<endl;

cout<<"Account Holder Name: "<<accounts[j][3]<<endl;

cout<<"Account Holder CNIC: "<<accounts[j][4]<<endl;

system("pause");

}

////////////////////////////////////////////////////////////

Calculator Tutorial in JavaScript

noreply@blogger.com (Anonymous) — Sat, 08 Mar 2014 19:47:00 +0000

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:

Step 1:

In a first step you will design the calculator layout using simple HTML, means a text area for input and output, and some buttons for numeric and operator purpose like this.

Calculator in JavaScript

HTML Code:

<html>

<head>

<title> Calculator Tutorial | developerqueries.blogspot.com </title>

</head>

<body>

<table>

<tr>

<td colspan="5">

<input id="temp_output" name="temp_output" value="" type="hidden" readonly="readonly">

</td>

</tr>

<tr>

<td colspan="5">

<input id="temp_oprtr" name="temp_oprtr" value="" type="hidden" readonly="readonly">

<input id="oprtr" name="oprtr" value="" type="hidden" readonly="readonly">

</td>

</tr>

<tr>

<td colspan="5">

<input id="output" name="output" value="" type="text" readonly="readonly">

</td>

</tr>

<tr>

<td><input type="button" id="seven" name="seven" value="7" /></td>

<td><input type="button" id="eight" name="eight" value="8" /></td>

<td><input type="button" id="nine" name="nine" value="9" /></td>

<td><input type="button" name="divider" value="/" /></td>

</tr>

<tr>

<td><input type="button" id="four" name="four" value="4" /></td>

<td><input type="button" id="five" name="five" value="5" /></td>

<td><input type="button" id="six" name="six" value="6" /></td>

<td><input type="button" name="multiplier" value="*" /></td>

</tr>

<tr>

<td><input type="button" id="one" name="one" value="1" /></td>

<td><input type="button" id="two" name="two" value="2"/></td>

<td><input type="button" id="three" name="three" value="3" /></td>

<td><input type="button" name="subtracter" value="-" /></td>

</tr>

<tr>

<td><input type="button" id="zero" name="zero" value="0" /></td>

<td><input type="button" value="C"/></td>

<td><input type="button" name="equal" value="=" /></td>

<td><input type="button" name="addition" value="+" /></td>

</tr>

</table>

</body>

</html>

Step 2:

In Step two you will write scripts to perform the calculator functionality using JavaScript. Here I use a function base approach, means for every purpose I write a function for example: for values input, for calculation of values etc. Now here is a code.

Functions for Input Purpose (Numbers):

function num_0()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("zero").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("zero").value;

}

function num_1()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("one").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("one").value;

}

function num_2()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("two").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("two").value;

}

function num_3()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("three").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("three").value;

}

function num_4()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("four").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("four").value;

}

function num_5()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("five").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("five").value;

}

function num_6()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("six").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("six").value;

}

function num_7()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("seven").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("seven").value;

}

function num_8()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("eight").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("eight").value;

}

function num_9()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("nine").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("nine").value;

}

Function for addition, subtraction, division, multiplication calculation:

function operator(optr_val)

{

if(document.getElementById("temp_output").value=="")

{

document.getElementById("temp_output").value = document.getElementById("output").value;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else

{

var val1 = document.getElementById("output").value;

var val2 = document.getElementById("temp_output").value;

if(document.getElementById("oprtr").value == "+")

{

var result = parseInt(val2) + parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "-")

{

var result = parseInt(val2) - parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "/")

{

var result = parseInt(val2) / parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "*")

{

var result = parseInt(val2) * parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

Function for Equal (=) Operator:

function eql()

{

if(document.getElementById("temp_output").value!="")

{

var val1 = document.getElementById("output").value;

var val2 = document.getElementById("temp_output").value;

if(document.getElementById("oprtr").value == "+")

{

var result = parseInt(val2) + parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "-")

{

var result = parseInt(val2) - parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "/")

{

var result = parseInt(val2) / parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "*")

{

var result = parseInt(val2) * parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

Function for clear the text area:

function clear_val()

{

document.getElementById("output").value = "";

document.getElementById("temp_output").value = "";

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

Put these all Functions between JavaScript tags in the HTML page. And on click event of every button call the function according to the button functionality.

Here is the final Code of Calculator tutorial in JavaScript.

just copy and past this code in html file.

<html>

<head>

<title> Calculator Tutorial | developerqueries.blogspot.com </title>

<script type="text/javascript">

function clear_val()

{

document.getElementById("output").value = "";

document.getElementById("temp_output").value = "";

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

function num_0()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("zero").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("zero").value;

}

function num_1()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("one").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("one").value;

}

function num_2()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("two").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("two").value;

}

function num_3()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("three").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("three").value;

}

function num_4()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("four").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("four").value;

}

function num_5()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("five").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("five").value;

}

function num_6()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("six").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("six").value;

}

function num_7()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("seven").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("seven").value;

}

function num_8()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("eight").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("eight").value;

}

function num_9()

{

if(document.getElementById("temp_oprtr").value == "")

{

document.getElementById("output").value = document.getElementById("output").value + document.getElementById("nine").value;

}

else

{

document.getElementById("temp_oprtr").value = "";

document.getElementById("output").value = document.getElementById("nine").value;

}

function operator(optr_val)

{

if(document.getElementById("temp_output").value=="")

{

document.getElementById("temp_output").value = document.getElementById("output").value;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else

{

var val1 = document.getElementById("output").value;

var val2 = document.getElementById("temp_output").value;

if(document.getElementById("oprtr").value == "+")

{

var result = parseInt(val2) + parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "-")

{

var result = parseInt(val2) - parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "/")

{

var result = parseInt(val2) / parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

else if(document.getElementById("oprtr").value == "*")

{

var result = parseInt(val2) * parseInt(val1);

document.getElementById("temp_output").value = result;

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = optr_val;

document.getElementById("oprtr").value = optr_val;

}

function eql()

{

if(document.getElementById("temp_output").value!="")

{

var val1 = document.getElementById("output").value;

var val2 = document.getElementById("temp_output").value;

if(document.getElementById("oprtr").value == "+")

{

var result = parseInt(val2) + parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "-")

{

var result = parseInt(val2) - parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "/")

{

var result = parseInt(val2) / parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

else if(document.getElementById("oprtr").value == "*")

{

var result = parseInt(val2) * parseInt(val1);

document.getElementById("temp_output").value = "";

document.getElementById("output").value = result;

document.getElementById("temp_oprtr").value = "";

document.getElementById("oprtr").value = "";

}

</script>

</head>

<body>

<table>

<tr>

<td colspan="5">

<input id="temp_output" name="temp_output" value="" type="hidden" readonly="readonly">

</td>

</tr>

<tr>

<td colspan="5">

<input id="temp_oprtr" name="temp_oprtr" value="" type="hidden" readonly="readonly">

<input id="oprtr" name="oprtr" value="" type="hidden" readonly="readonly">

</td>

</tr>

<tr>

<td colspan="5">

<input id="output" name="output" value="" type="text" readonly="readonly">

</td>

</tr>

<tr>

<td><input type="button" id="seven" name="seven" onclick="num_7()" value="7" /></td>

<td><input type="button" id="eight" name="eight" value="8" onclick="num_8()" /></td>

<td><input type="button" id="nine" name="nine" value="9" onclick="num_9()"/></td>

<td><input type="button" name="divider" value="/" onclick="operator(this.value)" /></td>

</tr>

<tr>

<td><input type="button" id="four" name="four" value="4" onclick="num_4()" /></td>

<td><input type="button" id="five" name="five" value="5" onclick="num_5()" /></td>

<td><input type="button" id="six" name="six" value="6" onclick="num_6()" /></td>

<td><input type="button" name="multiplier" value="*" onclick="operator(this.value)" /></td>

</tr>

<tr>

<td><input type="button" id="one" name="one" value="1" onclick="num_1()" /></td>

<td><input type="button" id="two" name="two" value="2" onclick="num_2()" /></td>

<td><input type="button" id="three" name="three" value="3" onclick="num_3()" /></td>

<td><input type="button" name="subtracter" value="-" onclick="operator(this.value)" /></td>

</tr>

<tr>

<td><input type="button" id="zero" name="zero" value="0" onclick="num_0()" /></td>

<td><input type="button" onclick="clear_val()" value="C"/></td>

<td><input type="button" name="equal" value="=" onclick="eql()" /></td>

<td><input type="button" name="addition" value="+" onclick="operator(this.value)" /></td>

</tr>

</table>

</body>

</html>

Hope this Tutorial wills Helpful for you all.

Display data from database depending on selected drop down value

noreply@blogger.com (Anonymous) — Sat, 11 Jan 2014 20:53:00 +0000

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.

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

Step 1:

In connection.php file write PHP script to make a connection from MySQL database.

Code

-----------------------------------------------------------------------

<?PHP
$con = mysql_connect("localhost","root","");

    if (!$con)
    {
           die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("database_name", $con);
?>

---------------------------------------------------------------------------

Step 2:

In index.php file write the following HTML code.

Code

-------------------------------------------------------------------------------

<html>
<head>
<title>developerqueries.blogspot.com - Display data depending on selected drop down value</title>
</head>
<body>

<!--

bellow is java script code which call get_student.php file and display the result of get_student.php file.

-->
<script type="text/javascript">
function show_student()
{
    var strclass=document.getElementsByName("select_class")[0].value;
    document.getElementById("display_student").innerHTML="";
    var xmlhttp;
    if (window.XMLHttpRequest)
    {
        xmlhttp=new XMLHttpRequest();
    }
    else
    {
        xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
    }
    xmlhttp.onreadystatechange=function()
        {
            if (xmlhttp.readyState==4 && xmlhttp.status==200)
            {
                document.getElementById("display_student").innerHTML=xmlhttp.responseText;
            }
        }
    xmlhttp.open("GET","get_student.php?c="+strclass,true);
    xmlhttp.send();
}
</script>

            <table border="0" cellpadding="0" cellspacing="0">
                <tr>
                    <th>Class:</th>
                    <td>
                        <select name="select_class" id="select_class" onChange="show_student()">
                        <option value="-1">Select...</option>
                        <option value="1">One</option>

                         </select>
                    </td>
                </tr>
            </table>

            <div id="display_student">

            </div>

</body>
</html>

----------------------------------------------------------------------------

Step 3:

In get_student.php file include a connection.php file for connect to database. and write a query that fetch the student of selected class and result will display using echo statement on index.php file.

Code

------------------------------------------------------------------------------------

<?PHP
include("connection.php");
$_val = $_REQUEST["c"];
if($_val=="-1")
{
    return 0;
}
else
{
    echo "<table border=1 width=50% cellpadding=0 cellspacing=0 >" ;
    echo        "<tr>";
    echo                "<th>Subjects</th>";
    echo            "</tr>";


                    $sql = "SELECT * FROM tbl_student where class_id = ".$_val;
                    $sql_result = mysql_query($sql,$con);
                    if($sql_result)
                    {
                        while($row=mysql_fetch_array($sql_result))
                        {
    echo            "<tr>";
    echo                "<td>";
    echo                    $row["sub_name"] ;
    echo                "</td>";
    echo            "</tr>";

                            }
                        }

    echo            "</table>";
}

?>

--------------------------------------------------------------------------

Now run the index.php file and enjoy. Hope this tutorial will help full for all PHP programmers.

Populate Select List PHP Mysql

noreply@blogger.com (Anonymous) — Tue, 07 Jan 2014 17:24:00 +0000

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:

Here is a very simple steps for this work.

Step 1:

In a first step create a PHP file like index.php. And write a simple HTML code in it. like this

<html>

<head>

<title>Populate Select List PHP MySQL</title>

</head>

<body>

<select name="select_list" id="select_list">
<option value="-1">Select...</option>

</select>

</body>

</html>

Step 2:

Now its time to write a query that fetch a values from the database. write this query code between a <select> tag. i.e:

<html>

<head>

<title>Populate Select List PHP MySQL</title>

</head>

<body>

<select name="select_list" id="select_list">
<option value="-1">Select...</option>

<?PHP
                            $sql = "SELECT student_id, student_name FROM tbl_student;                                                     $result = mysql_query($sql);
                            if($result)
                            {
                                while($row=mysql_fetch_array($result))
                                {

<?PHP

}

</select>

</body>

</html>

Step 3:

Add or display or echo the fetched values between <option> tag. like this:

<html>

<head>

<title>Populate Select List PHP MySQL</title>

</head>

<body>

<select name="select_list" id="select_list">
<option value="-1">Select...</option>

<?PHP

}

</select>

</body>

</html>

All code is done and the Select List is now Populated.

Save image into Database

noreply@blogger.com (Anonymous) — Tue, 25 Jun 2013 17:09:00 +0000

Export data to Excel in ASP.NET

noreply@blogger.com (Anonymous) — Mon, 27 May 2013 18:22:00 +0000

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.

Step 1:

Right click on project and add the Dataset.

Export data to Excel in ASP.NET

Step 2:

From the server explorer drag a table from the database and drop it into the Dataset. Like this.

Export data to Excel in ASP.NET

Step 3:

Open .aspx page. Here I am use “Default.aspx”. On page add a button. When button press the export process will run. So now on the button click event write the following cod.

Code:

protected void Button1_Click(object sender, EventArgs e)

{

DataSet1TableAdapters.CustomerTableAdapter object_customer = new DataSet1TableAdapters.CustomerTableAdapter();

DataSet1.CustomerDataTable table = object_customer.GetData();

DataGrid dg = new DataGrid();

dg.DataSource = table;

dg.DataBind();

Response.ClearContent();

Response.AddHeader("content-disposition", "attachment; filename= CustomerReport.xls");

Response.ContentType = "application/excel";

System.IO.StringWriter sw = new System.IO.StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

dg.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

Step 4:

After the code save the file and run the page. And click or press the button. File Download window will open, save the Excel file and check the excel file data will show in it.

Export data to Excel in ASP.NET

Here is the output:

Export data to Excel in ASP.NET

I hope this tutorial will helpful for you. Now follow these simple and easy steps and achieve you target.

Best Regard.

Shoes Template

noreply@blogger.com (Anonymous) — Wed, 22 May 2013 19:09:00 +0000

Shoes Template Free Download

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

Form View in asp.net

noreply@blogger.com (Anonymous) — Tue, 04 Sep 2012 18:57:00 +0000

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

noreply@blogger.com (Anonymous) — Fri, 31 Aug 2012 12:26:00 +0000

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

After that add another GridView. And on the selected index changed event of the DropDownList write following code:

DataTable dt = new DataTable();

dt.Columns.Add("ID");

dt.Columns.Add("Name");

dt.Columns.Add("Father");

int count = 0;

for (int i = 0; i < GridView1.Rows.Count; i++)

{

if (GridView1.Rows[i].Cells[1].Text.StartsWith(DropDownList1.SelectedItem.Text.ToLower()))

{

DataRow dr = dt.NewRow();

dr["ID"] = GridView1.Rows[i].Cells[0].Text;

dr["Name"] = GridView1.Rows[i].Cells[1].Text;

dr["Father"] = GridView1.Rows[i].Cells[2].Text;

dt.Rows.Add(dr);

count++;

}

if (count == 0)

{

Response.Write("No Record Found.....!");

GridView1.Visible = true;

GridView2.Visible = false;

}

else

{

GridView1.Visible = false;

GridView2.Visible = true;

GridView2.DataSource = dt;

GridView2.DataBind();

}

Now run the project and select the item from the DropDownList.

Filterd Record

Record not found

insert into database - ASP.Net

noreply@blogger.com (Anonymous) — Fri, 31 Aug 2012 09:29:00 +0000

This Tutorial is about insert data into database in asp.net. Here is steps:

Step 1:

First create the form where you enter the record.

Insert Form

Step 2:

Now add a "DataSet" in the project and insert the table from the database in it. After this write the following code against the button click event.

try

{

DataSet1TableAdapters.tbl_PersonInfoTableAdapter obj_adapter = new DataSet1TableAdapters.tbl_PersonInfoTableAdapter();

obj_adapter.Insert(TextBox1.Text, TextBox2.Text);

Label1.Text = "OK! Data Inserted";

}

catch (Exception exp)

{

Label1.Text = "Error! No data Inserted";

}

Step 3:

Finally run the project.

Record Inserted

Hope so this tutorial will help you to insert the record into the database in ASP.Net.

Edit Delete data in GridView

noreply@blogger.com (Anonymous) — Mon, 27 Aug 2012 18:02:00 +0000

This Example is about how to Edit/Delete data in GridView. here is the step by step explain about this example.

Step 1:

Select new data source

Step 2:

Choose database type

Step 3:

Data Connection

Step 4:

Connection string

Step 5:

Select statement

Step 6:

Test Query

Step7 For Enable Edit/Delete:

Edit/Delete in GridView

Step 8 Query for Delete:

Query for Delete

Step 9 Query for Edit:

Query for Edit

Bind GridView using DataSet

noreply@blogger.com (Anonymous) — Mon, 27 Aug 2012 16:24:00 +0000

This tutorial is about bind gridview using dataset. First add dataset and drop the table in the dataset. then go to the page load our any button event and write the code.
These are the simple steps to bind the gridview:

Add DataSet

Add table in DataSet

Now go to the page load event and write this code:

DataSet1TableAdapters.tbl_PersonInfoTableAdapter obj_adapter = new DataSet1TableAdapters.tbl_PersonInfoTableAdapter();

DataSet1.tbl_PersonInfoDataTable obj_dt = obj_adapter.GetData();

GridView1.DataSource = obj_dt;

GridView1.DataBind();

Display Data in the GridView from database using SqlDataSource in asp.net

noreply@blogger.com (Anonymous) — Sun, 26 Aug 2012 18:46:00 +0000

This tutorial is about how to retrieve data from the database and display in the GridView using SqlDataSource in ASP.NET. It is very simple with the SqlDataSource.
Here is steps.

Step 1:

On the page add the GridView control. after that select the GridView and click on the top right side button a GridView Tasks window will appear now from this window choose the new data source from the DropDownList. Like this:

Select new data source

Step 2:

when you select new data source from the DropDownList a new window will appear where you choose the database type. From this window choose the database type and click on OK button. Like this:

Choose database type

Step 3:

Now a wizard will start for configure data source. From the "choose your data connection" window select the a data connection from the DropDownList and press next button.

Data Connection

Step 4:

Now connection string window will appear, on this window write the connection string name in the textbox and click on next.

Connection string

Step 5:

After connection string a "configure the select statement" window will appear. On this window first select the table from the DropDownList and then select the columns that you want to display in the GridView and press next.

Select statement

Step 6:

Now test query window will appear. to preview the data returned by this data source, click Test Query. to complete this wizard click Finish.

Test Query

Last Step 7:

Now run the project and check the page data will show in the GridView like this:

Data show in GridView

Show data in grid view in ASP.NET

noreply@blogger.com (Anonymous) — Sat, 25 Aug 2012 09:13:00 +0000

This tutorial is about the grid view control. grid view Control is a very powerful control. it is a table structure where data show in the rows and columns.
Here we can see how to show data in the grid view when user press the button.
When the user Click on the button every time a new row will added in the grid view.
Below mention code is used for this purpose.

Step1:

In the Default.aspx page write these code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
<br /><br /><br />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</ContentTemplate>
</asp:UpdatePanel>

</form>
</body>
</html>

Step2:

In the Default.aspx.cs file write following code:

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

datastructure();

}

private void datastructure()

{

DataTable dtC = new DataTable();

dtC.Columns.Add("Name");

dtC.Columns.Add("Father");

ViewState["dt"] = dtC;

}

protected void Button1_Click(object sender, EventArgs e)

{

DataTable dt = (DataTable)ViewState["dt"];

DataRow dtRow = dt.NewRow();

dtRow["Name"] = "ABC";

dtRow["Father"] = "XYZ";

dt.Rows.Add(dtRow);

dt.AcceptChanges();

GridView1.DataSource = dt;

GridView1.DataBind();

}

----------------------------------------------------------------

Try this your self. Hope this will help you.

Learn Programming ASP.NET PHP JAVA HTML CSS

Search option in gridview in php

Step 1:

Step 2:

Server side pagination in php

Server Side Pagination Client Side Pagination

Step 1:

Step 2:

Insert Into MySQL PHP MVC

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

output:

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

"Saving changes is not permitted" in SQL Express Server

Solution:

Solution Screens:

Auto Complete Textbox in PHP

Step 1:

Code:

Step 2:

Code:

PHP Multiple Checkbox Array

PHP Code:

Note:

OUTPUT

php checkbox

PHP Code

OUT PUT

Note:

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 Template:

Demo/View Link: http://www.free-css.com/assets/files/free-css-templates/preview/page1/businesstoday/

http://www.free-css.com/assets/files/free-css-templates/download/page1/businesstoday.zip ----------------------------------------------------------------------------------------------------------------------------------

Academic Education Template:

Darkness Template:

Education Time Template:

Gallery Template:

Write data in text file C++ Filling

#include <fstream>

ofstream myfile("items_file.txt");

Example:

Code is here:

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.

Solution:

C++ Library Management System Project (LMS)

Library system Features/Methods:

How you can use or run this code:

download from here: https://drive.google.com/file/d/0B599xkio99pxd0NyX0d5OWNZTFE/edit

Overview:

Classes:

Book Class:

Here is a code of book class:

Teacher Class:

Here is a code of teacher class:

Student Class:

Here is a code of student class:

Main Class:

Here is a code of Main class:

C++ Banking System Project

C++ Banking system features/Methods:

Brief description about bank System:

Here is the code of a bank system:

Calculator Tutorial in JavaScript

Calculator Tutorial in JavaScript:

Step 1:

HTML Code:

Step 2:

Functions for Input Purpose (Numbers):

Function for addition, subtraction, division, multiplication calculation:

Function for Equal (=) Operator:

Function for clear the text area:

Here is the final Code of Calculator tutorial in JavaScript.

Server Side Pagination

Client Side Pagination

Demo/View Link:

http://www.free-css.com/assets/files/free-css-templates/preview/page1/businesstoday/

http://www.free-css.com/assets/files/free-css-templates/download/page1/businesstoday.zip

----------------------------------------------------------------------------------------------------------------------------------