|
<?php include('/big/dom/xphplens/www/php/phplens/phplens.inc.php'); session_start(); //---------------------------------------- // The following lines are for formatting // the page and not needed by phplens $gTitle = "Registration Demo"; include('./header.php'); session_register('gNewUser'); //---------------------------------------------------- // setup lens and render it with persistent connection if (empty($gNewUser)) print "<h3>Please register with <a href=ex307.php>ex307</a></h3>"; else { $sql = "select * from lensusers where userid='$gNewUser'"; print "<h3>Thank you for registering</h3>"; $lens = PHPLensPConnect ( 'ex306', // id to uniquely identify this phplens setup $sql, 'mysql', // database server type, eg. pgsql, odbc, mssql, oci8 $gEX_server, // eg. localhost or ODBC DSN $gEX_userid, $gEX_password, $gEX_db2); // optional, name of database to connect to if (!$lens) erroralert('Unable to create phpLens'); $lens->showGrid = false; // hide the grid, only show details $lens->menuHide='ALL'; $lens->nameLens = 'AGE^Age;COUNTRY^Country^^^;CREATED^CREATED^^^;LASTMOD^LASTMOD^^^;PASSWORD^Password^^^;USERID^User ID^^^;FIRSTNAME^First Name^^^;LASTNAME^Last Name^^^;EMAIL^email^^^;ADDRESS1^Address Line 1^^^;ADDRESS2^Address Line 2^^^;POSTCODE^Postcode^^^;CITY^City^^^;STATE^State^^^'; $lens->detailLens = 'USERID;FIRSTNAME;LASTNAME;EMAIL;ADDRESS1;ADDRESS2;POSTCODE;CITY;STATE;COUNTRY;AGE;CREATED;LASTMOD'; //--------------------------------------------------------- // the following lines are for the security of this website //$lens->dynEdit = 0; // disable designer editing $lens->Render(); $lens->Close(); } ?> <h4>Notes</h4> The same data can be seen in <a href=ex300.php>example 300</a>. <?php include ('./footer.php'); ?>
|
|