At 03:30 PM 1/27/2012, Steve Vellella wrote:
I am trying to insert a row of data into R:Base to track the IP address,
login date and time, and user name for successful logins for a web site
using PHP/Oterro/Apache.
I am able to retrieve all of the data points that I need, but I cannot
figure out the syntax to "Insert a Row" into the rbase table.
Steve,
Here's an R:PHP snippet that INSERTs a row after a successful or
failed login attempt to access R:BASE application.
## ACCESS LOGS
function application_access_log($strUser,$val){
global $dbObj, $dbcnx;
$sql = "INSERT INTO AplicationAccessLog
(LoginDate,LoginTime,UserID,terminalID,ApplicationModule,AccessCode,Successful)
VALUES('".date('m/d/Y')."','".date('h:i
A')."','".$strUser."','".$_SERVER['REMOTE_ADDR']."','RRBYW18','".$_SESSION['AccessCode']."','{$val}')";
$dbcnx->query($sql,FALSE);
Notice the AplicationAccessLog table with the following columns:
. LoginDate (DATE)
. LoginTime (TIME)
. UserID (TEXT 20)
. TerminalID (TEXT 20)
. ApplicationModule (TEXT 20)
. AccessCode (INTEGER)
. Successful (TEXT 1)
Hope that helps!
There is more to this code that sets up the environment and all
global/session variables
configured using R:BASE eXtreme 9.x, Oterro 9.x on Apache 2.2.21 and
PHP 5.2.17 server.
If you require further assistance, you may contact our dedicated
R:Web Development Team
at [email protected].
Very Best R:egards,
Razzak.
