In this tutorial, we will develop a complete asp.net web application with database functionality. We will also add ajax functionality in our application. CREATION OF DATABASE We create the internal database file with the visual studio. The database file is placed in the same application folder. The following are database tables: Database Name: mydb.mdf person CREATE
In this code, we present a database class that can be easily used to perform any operation on database, e.g., select, insert, update, delete, etc. The following is the code of database class: filename: include/functions.php <?php include("db/opendb.php"); $msg = NULL; /// STARTING CODE OF Database Class ///////// class Database { public $pstmt=NULL; function FetchRecord($query) {
In this example, we created a simple asp.net database application. We created the database locally, which is stored in App_Data folder. This application uses asp.net master pages, which are used to create the design of the application. Moreover, the application also uses GridView data control, which is configured to perform edit and delete operations. To
In this example, we present two uses of ajax. In first use, we created an ajax based nested drop downs which are also databased enabled. In second use, we create a keyword list suggestion in ajax (as we see in google search box). For this example, we used the following database: ajaxexample.sql SET SQL_MODE =
In this example, we create an ajax based input form. The form is not submitted to the server, rather, its values are stored in the database using ajax without submitting form. default.php <html> <head> <title></title> <script type="text/javascript" src="ajax_javascript.js"></script> </head> <body> <form id="frm" name="frm" method="post" action=""> <table border="1"> <tr> <td>City</td> <td><input id="txtcity" name="txtcity" type="text"></td> </tr> <tr>
AJAX stands for Asynchronous Javascript And XML. With ajax, we do need to submit whole form to php, rather, we can send information from a portion of form and receive the response. In this way, the communication cost and delay in submitting the form and receiving response can be significantly reduced. The following program uses
Often we pass ID values in URLs which can pose a great security risk in php applications. It is always better to encrypt such information before sending from one page to other. Here is an example. The student.php page is encrypting the information. The studentview.php page is comparing the information with its encrypted value: student.php
When we upload image, it is better to crop the image so that the image easily fits in the space provided. In the following example, an image is cropped and its thumbnail is created. Cropped image is stored in its directory whereas thumbnail image is stored in its directory. To test the example, you need
We can do numerous file directory operations in PHP. To delete a file “unlink” function is used. In below program, we can see different operations, we can uncomment code to see the behavior. <!doctype html> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> </head> <body> <?php $dir = "tasks/"; // to delete a single file unlink("tasks/temp.txt"); //