AJAX-based Functionality Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using PHPRunner
Working with projects
Templates
What are templates
Cars
Classified ads
Events
Jobs
Knowledge base
News
Paypal
Real estate
Sporting
Vacation houses
Connecting to the database
Datasource tables
SQL query page
About SQL query designer
Query Designer
SQL
Results
Charts
Creating chart and setting parameters
Chart appearance
Using SQL to shape chart data
Reports
Creating report and setting parameters
Report totals and layout
Choose pages
Login page
User login settings
Advanced security settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
"View as" settings
"Edit as" settings
Validation types
Lookup wizard
Events
Output directory settings
After you are done
FTP upload
FrontPage Publishing
Advanced topics
Events
More info about events
Global events
Table events
Page life cycle overview
Predefined actions
Send a simple email
Send an email with new data
Save new data in another table
Insert a record into another table
Check to see if a specific record exists
Display a message on the Web page
Redirect to another page
Custom code
Sample events
Show list of customer orders
Check if start date is ealier than end date
Before deleting a record check for related records
Speed up data entry using events
Publishing PHP application to the remote Web server
Using FTP client to publish PHP pages to the remote Web server
Using FrontPage to publish PHP pages to the remote Web server
Demo Account
What is the Demo Account?
Terms and Conditions
Connect using PHP
Master-details relationships
Using JOIN SQL queries
AJAX-based Functionality
PHPRunner session variables
Debugging tips
Template files processing rules (Files.txt)
Multilanguage support
Useful functions and links
Smarty templates
Stylesheets
Template language
How to control Inline Add/Edit functionality from script
Rich Text Editor plugins
Upgrade Guide from PHPRunner 3.0 and older
PDF view settings
Order PHPRunner online

 
  PHPRunner manual


AJAX-based Functionality

 

PHPRunner 4.0 comes with AJAX-based functionality added. Now you can search information more easily than ever with google-like auto-suggest feature. Web pages with AJAX driven dependent dropdown boxes are loaded faster. If you want to see details records you just need to mouse over the link, and you don't need to proceed to the Details page. Also new feature for lookup fields was added. Now you can choose the variant from suggest list which is refreshed each time while you are typing in the text box instead of searching through all values in the dropdown boxes.

Note: If for some reasons you don't want to use AJAX-based functionality then all you need to do is to change the $useAJAX and $suggestAllContent variables value in the dbcommon.php file to False.

$useAJAX = false;

$suggestAllContent = false;

 

AJAX-based Auto-Suggest

This feature comes in two versions and is enabled on the Basic and Advanced search pages. It is similar in fashion to that of Google Suggest using AJAX technologies.

Search suggest makes your site much more user friendly. To see how it will look like just begin to type in the search box.

The picture below demonstrates the search suggest feature on the basic search page:

On the Advanced search page search suggest looks like this:

By default, search suggest results include only those values that begin with the search phrase. If you want to be shown all values in which the search phrase presents to be shown you should change the $suggestAllContent variable value in the dbcommon.php file to True. In this case the search phrase in the search suggest results will be highlighted as shown on the picture below:

AJAX-based dependent dropdown boxes

In PHPRunner dependent dropdown boxes are AJAX Driven. This feature works similar as in the previous version but now dropdown boxes content is loaded in the real time using AJAX technologies instead of loading all the content on the web page load. This means web pages are loaded more faster now.

 

Details Records Preview

In PHPRunner you can see details records preview directly on the list page. All you need to do is to mouse over the link. The following picture demonstrates how the details preview looks like:

The number of records in the details preview is limited. Only first ten details are displayed. If there is an image in the details then only first five details are displayed.

Lookup wizard as Edit box with AJAX popup

This feature is added to lighten the search among the large amount of data. Now you can choose the variant from AJAX popup which is refreshed each time you type in the text box, instead of searching through all the values in the dropdown boxes.

To turn on this feature, you should select the appropriate checkbox on the "Edit as" settings tab.

After you build your project, you can see how it works on the Edit, Add, and Search pages. When you begin to type in the edit box AJAX popup appears and you can choose the needed value from the suggest list. If you type in the text box the value which doesn't exist in the database and move to another form control then the border of the text box will change colour into red. When you correct the value, it will change back to usual.

If you try to submit the form with wrong value entered in the text box then the form will be submitted with the previous correct value entry.

 

The CHM file was converted to HTML by chm2web software.