database example

This form illustrates a login form, which is definitely the most typical database validation. There's a user in the installed example database with the login name "joe" and the password "weakpass" (without the "s ofcourse): using this login/pass you'll see only the results of the call, in case of an error you'll receive the error messages.

The live form - submit it!

Source

This is the config array for Clonefish which generates the form you've just seen.
Scroll at the bottom of this window to see how to use this array!


<?php

$config = Array(



  'login' => Array(

    'type'           => 'inputText',

    'displayname'    => 'Login name',

    'help'           => 'The login name or the password is invalid!',

    validation     => Array(

      Array(

        'type' => 'database',

        'sql'  => "

          SELECT *

          FROM demousers 

          WHERE 

            login= <FORM.login>  AND 

            password= <FORM.password>

        ",

        'minrows' => 1,

      ),

    ),

  ),



  'password' => Array(

    'type'           => 'inputPassword',

    'displayname'    => 'Password',

    validation     => Array(

    ),

  ),



);

?>

Usage example

To create a form using this array you'll only need a few lines of code:

<?php // create the form object $clonefish = new clonefish( 'loginform', 'test.php', 'POST' ); // setup codepage so your data will be handled // perfectly by the appropriate string functions $clonefish->codepage = 'utf-8'; $clonefish->multibytesupport = 'multibyteutf8'; // add the form elements (fields) pre-filled with // values from $_POST $clonefish->addElements( $config, $_POST, get_magic_quotes_gpc() ); // validate the form if the form has been submitted if ( count( $_POST ) && $clonefish->validate() ) { // form is valid, go and store values in database, etc. // $clonefish->getElementValues() provides a // normalized value array. } else // if the form wasn't submitted yet or the validation // had failed, show the form (automatically // including error messages) echo "<html><body>" . $clonefish->getHTML() . "</body></html>"; ?>

Take a look at
the PHP source!

Data dump

Below are the dumps of some PHP variables - submit the form to see the changes!

Contents of the $_POST array:
$_POST = array (
)

Results of a $clonefish->getElementValues() call:
array (
  'login' => NULL,
  'password' => NULL,
)

There are cases when the above arrays are different. This is not a bug, but a feature: clonefish was written to help with everyday form hassles (like avoiding the missing value of an unchecked checkbox or compiling the whole date string from date selector fields).

Examples
Element types
Validation
- date
- number
- required
- string
- database
- captcha

form validation for developers!

clonefish is a proven, mature form generator class that helps PHP developers to create, validate and process secure, flexible and easy-to-maintain forms
learn more

clonefish - PHP form generator and validator class