www.file-making.com

FX.php Tutorial
Blah	Suggested reading	Simple query	Useful query	Simple login

How do I make a login page?
My way of writing an authentication usually has 2 files; login.php and index.php The way I use authentication requires cookies, as the $_SESSION variable is required. login.php <? session_start(); session_unset(); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/FX.php" ); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/server_data.php" ); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/Developer/FMErrors.php" ); if( $_REQUEST['a'] == 'Login' ) { $q = new FX( $serverIP, $webCompanionPort ); $q->SetDBData( 'MemberDatabase', 'member_php' ); $q->SetDBUserPass( $webUN, $webPW ); $q->AddDBParam( 'valid', md5( $_REQUEST['login'].'/'.$_REQUEST['password'] ), 'eq' ); $r = $q->FMFind(); if( $r['foundCount'] == 1 ) { $currentKey = key( $r['data'] ); $_SESSION[$pKey]['id'] = $r['data'][$currentKey]['memberID'][0]; $_SESSION[$pKey]['id2'] = md5( $r['data'][$currentKey]['memberID'][0] ); header( "Location: ./index.php" ); } } print_r( $r ); ?> <html> <head> <title>This is the login page</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="/1.css" rel="stylesheet"> </head> <body> <form action="" method="post"> <table> <tr> <td class="brodtekst">Username:</td> <td><input name="login"></td> </tr> <tr> <td class="brodtekst">Password:</td> <td><input name="password" type="password"></td> </tr> <tr> <td></td> <td><input type="submit" name="a" value="Login"></td> </tr> </table> </form> </body> </html> ?> index.php <? session_start(); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/FX.php" ); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/server_data.php" ); include_once( $_SERVER['DOCUMENT_ROOT'] . "/FX/Developer/FMErrors.php" ); if( md5( $_SESSION[$pKey]['id'] ) != $_SESSION[$pKey]['id2'] ) { header( "Location: ./login.php" ); } $q = new FX( $serverIP, $webCompanionPort, $dataSourceType ); $q->SetDBUserPass( $webUN, $webPW ); $q->SetDBData( 'TheNameOfYourDatabaseFile', 'TheNameOfYourBeautifullyDesignedLayout' ); $q->AddDBParam( 'someFieldName', 'aFieldValue' ); $r = $q->FMFind(); print_r( $r ); ?>

I have noticed that this site has started to gather some traffic now,
This page is dedicated to FileMaker developers developing web solutions with FileMaker XML as data source,
if you have suggestions on what should be on this portal message me: AIM:fxphp