<?php /////////////////////////////////////// // Example to show how to Obtain the // insert ID of the Last Record // inserted into the database table /////////////////////////////////////// include "dbclass.php"; $a = new dbClass('localhost', 'test', 'root', 'password'); // Open database connection ------------------------------------------------------------------------- $a->openConnection(); // Execute an SQL command like INSERT or UPDATE ---------------------------------------------- $a->execCommand("INSERT INTO `test1` (column1,column2,column3,column4) VALUES ('1','2','3','4');"); $LastInsertID = $a->getLastInsertID(); echo "The Last Record ID you Inserted was: " . $LastInsertID; $a->closeConnection(); ?>
echo "Who Is Online Security:<br>Please Remve <b>install.php</b>."; exit; } $db1 = new dbClass(); $db1->setDBVars($dbhost, $dbname, $dbuser, $dbpass); $db1->openConnection(); $ip = $_SERVER['REMOTE_ADDR']; $sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}` WHERE `ip`='{$ip}';"; $rowOut = $db1->queryRowArray($sql); $ip_exists = $rowOut[0]; if ($ip_exists > 0) { $sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}`"; $rowOut = $db1->queryRowArray($sql); $count = $rowOut[0]; } else { $db1->execCommand("INSERT INTO `{$dbname}`.`{$dbtable}` (`ip`) VALUES ('{$ip}');"); $sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}`;"; $rowOut = $db1->queryRowArray($sql); $count = $rowOut[0]; } echo "<table>"; echo "<tr><td>" . $txtVisitors . "</td><td>" . $count . "</td></tr>"; echo "<tr><td>" . $txtYourIP . "</td><td>" . $ip . "</td></tr>"; echo "</table>"; if (ago($_SESSION['entrytime']) > 600) { // -------------- REMOVE OLD IP ENTRIES ------------------------------------------------------------------------ $db1->execCommand("DELETE FROM `{$dbname}`.`{$dbtable}` WHERE modified < (now() - INTERVAL {$purge_length} MINUTE);"); // ------------------------------------------------------------------------------------------------------------- $_SESSION['entrytime'] = time(); echo "Purged Rows"; }
$dbpass = $_POST['txtdbpass']; //echo "Inside The Installer<br>"; //echo "$dbhost-$dbname-$dbtable-$dbuser-$dbpass"; $sql1 = "CREATE DATABASE IF NOT EXISTS `{$dbname}`;"; $sql2 = "CREATE TABLE IF NOT EXISTS `{$dbname}`.`{$dbtable}` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,`ip` VARCHAR(20) NOT NULL,`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY(`id`));"; $cfgsettings = '<?php $dbhost="' . $dbhost . '"; $dbname="' . $dbname . '"; $dbtable="' . $dbtable . '"; $dbuser="******"; $dbpass="******"; $purge_length=10; $txtVisitors="Visitors:"; $txtYourIP="Your IP:"; ?>'; echo "<center>"; echo "SQL Statement Database: <br><textarea cols=\"45\" rows=\"2\">{$sql1}</textarea><br><br>"; echo "SQL Statement TABLE: <br><textarea cols=\"45\" rows=\"8\">{$sql2}</textarea><br><br>"; echo "Configuration Setting: <br><textarea cols=\"45\" rows=\"8\">{$cfgsettings}</textarea><br>"; // Table Creation SQL Statement ------------------- include "dbclass.php"; $db1 = new dbClass(); $db1->setDBVars($dbhost, $dbname, $dbuser, $dbpass); $db1->openConnection(); $db1->execCommand($sql1); $db1->execCommand($sql2); $db1->closeConnection(); echo "<br><br>Installation Completed!"; echo "</center>"; } else { ?> <!-- HTML Form --> <form name="whoisonlineinstall" action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post"> <table border="0" cellpadding="0" cellspacing="2" align="center"> <tr> <td>