Login   Register  
PHP Classes
elePHPant
Icontem

File: test_mysql_auto_complete.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Manuel Lemos  >  Forms generation and validation  >  test_mysql_auto_complete.php  >  Download  
File: test_mysql_auto_complete.php
Role: Example script
Content type: text/plain
Description: Example to show how to use the auto-complete text custom input plug-in retrieving auto-complete texts from a MySQL database
Class: Forms generation and validation
HTML forms generation and validation.
Author: By
Last change: Reformatted the code.
Used the function ConnectFormToInput to give the focus to an input
automatically when the page is loaded.
Date: 2013-01-09 03:32
Size: 3,484 bytes
 

Contents

Class file image Download
<?php
/*
 * test_mysql_auto_complete.php
 *
 * @(#) $Header: /opt2/ena/metal/forms/test_mysql_auto_complete.php,v 1.2 2006/12/20 06:21:17 mlemos Exp $
 *
 */

    
require('forms.php');
    require(
'form_ajax_submit.php');
    require(
'form_auto_complete.php');
    require(
'form_mysql_auto_complete.php');

    
$host="localhost";
    
$user="mysqluser";
    
$password="mysqlpassword";
    
$database="locations";
    
$connection=@mysql_pconnect($host$user$password);
    if(
$connection)
        
mysql_select_db($database,$connection);

    
$form=new form_class;
    
$form->NAME='auto_complete_form';
    
$form->METHOD='POST';
    
$form->ACTION='';
    
$form->debug='error_log';
    
$form->AddInput(array(
        
'TYPE'=>'text',
        
'ID'=>'location',
        
'NAME'=>'location',
        
'LABEL'=>'<u>L</u>ocation',
        
'ACCESSKEY'=>'L',
        
'VALUE'=>'',
        
'ExtraAttributes'=>array(
            
'autocomplete'=>'off',
            
'title'=>'Type just the first letters of a location.',
        )
    ));
    
$form->AddInput(array(
        
'TYPE'=>'button',
        
'NAME'=>'show_locations',
        
'ID'=>'show_locations',
        
'VALUE'=>'...',
        
'ExtraAttributes'=>array(
            
'title'=>'Click to show all locations.'
        
)
    ));
    
$form->AddInput(array(
        
'TYPE'=>'custom',
        
'ID'=>'complete_location',
        
'NAME'=>'complete_location',
        
'CustomClass'=>'form_mysql_auto_complete_class',
        
'CompleteInput'=>'location',
        
'CompleteMinimumLength'=>1,
        
'Dynamic'=>1,
        
'ShowButton'=>'show_locations',
        
"Connection"=>$connection,
        
"CompleteValuesQuery"=>"SELECT name FROM locations WHERE name {BEGINSWITH} ORDER BY name",
        
"CompleteValuesLimit"=>10,
        
'FeedbackElement'=>'complete_location_feedback',
        
'SubmitFeedback'=>' <img src="indicator.gif" width="16" height="16" alt="Looking up for locations" title="Looking up for locations" /> ',
        
'CompleteFeedback'=>' <img src="indicator.gif" width="16" height="16" style="visibility: hidden;" /> ',
        
'MenuClass'=>'groovymenu',
        
'MenuStyle'=>'',
        
'ItemClass'=>'groovyitem',
        
'ItemStyle'=>'',
        
'SelectedItemClass'=>'groovyselecteditem',
        
'SelectedItemStyle'=>'',
    ));

    
/*
     * This code is necessary to handle the requests for fetching
     * auto-complete values.
     */
    
$form->HandleEvent($processed);
    if(
$processed)
        exit;

    
$form->ConnectFormToInput('location''ONLOAD''Focus', array());

    
$onload=HtmlSpecialChars($form->PageLoad());

?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Test for Manuel Lemos' PHP form class using the auto-complete plug-in input and MySQL database queries</title>
<style type="text/css"><!--
BODY { color: black ; font-family: arial, helvetica, sans-serif ; background-color: #cccccc }
.groovymenu { background-color: #cccccc; padding: 4px; border-style: solid ; border-top-color: #f9f9f9 ; border-left-color: #f9f9f9 ; border-bottom-color: #868686 ; border-right-color: #868686 ; border-width: 1px; opacity: 0.9; filter: alpha(opacity=90); }
.groovyitem { padding: 1px; }
.groovyselecteditem { padding: 1px; color: #ffffff; background-color: #000080; }
// --></style>
</head>
<body onload="<?php echo $onload?>" bgcolor="#cccccc">
<center><h1>Test for Manuel Lemos' PHP form class using the auto-complete plug-in input and MySQL database queries</h1></center>
<hr />
<?php
    $error_message
='';
    
$form->StartLayoutCapture();
    
$title='Auto-complete plug-in test';
    
$body_template='form_locations_auto_complete_body.html.php';
    include(
'templates/form_frame.html.php');
    
$form->EndLayoutCapture();

    
$form->DisplayOutput();

    if(
$connection)
        
mysql_close($connection);
?>
<hr />
</body>
</html>