Code: Select all
<?php
/*
Session Library - Controls Sessions using MySQL
*/
$mysql = array();
$mysqlї"open_connection"] = true;
$mysqlї"host"] = "localhost";
$mysqlї"usr"] = "root";
$mysqlї"pwd"] = "";
$mysqlї"tbl"] = "session";
$mysqlї"db"] = "test";
function sess_open($save_path, $sess_name) {
GLOBAL $mysql;
if($mysqlї"open_connection"])
{
$link = mysql_pconnect($mysqlї"host"],$mysqlї"usr"],$mysqlї"pwd"]) or die(mysql_error());
mysql_select_db($mysqlї"db"]);
}
return(true);
}
function sess_read($sess_id) {
GLOBAL $mysql;
$temp = mysql_query("SELECT data FROM ".$mysqlї"tbl"]." WHERE id = '$sess_id'") or die(mysql_error());
if(mysql_num_rows($temp) == 0) {
return("");
}
$result = mysql_fetch_array($result);
mysql_free_result($temp);
return($rowї"data"]);
}
function sess_write($sess_id, $val) {
GLOBAL $mysql;
$temp = mysql_query("REPLACE INTO ".$mysqlї"tbl"]." VALUES ('$sess_id','$val', null)") or die(mysql_error());
return(true);
}
function sess_destroy($sess_id) {
GLOBAL $mysql;
$temp = mysql_query("DELETE FROM ".$mysqlї"tbl"]." WHERE id = '$sess_id'") or die(mysql_error());
return(true);
}
function sess_gc($max_lifetime) {
GLOBAL $mysql;
$old = time() - $max_lifetime;
$temp = mysql_query("REPLACE INTO ".$mysqlї"tbl"]." UNIX_TIMESTAMP(t_stamp) < $old") or die(mysql_error());
return(true);
}
session_set_save_handler("sess_open", "", "sess_read", "sess_write", "sess_destroy", "sess_gc")
?>Code: Select all
<?php
/*
MySQL Function Library - Contains Functions for MySQL
*/
class lsbb_mysql {
$mysql = array();
$mysqlї"usr"] = "root";
$mysqlї"pwd"] = "";
$mysqlї"host"] = "localhost";
$mysqlї"db"] = "test"
function connect() {
GLOBAL $mysql;
$connect = @mysql_connect($mysqlї"host"],$mysqlї"usr"],$mysqlї"pwd"]);
if(!$connect) {
echo "Failed to establish connection with mySQL.";
exit();
}
$select = @mysql_select_db($mysqlї"db"]);
if(!$select) {
echo "Failed to select a database.";
}
}
function close() {
mysql_close();
}
function free($result_handle) {
mysql_free_result($result_handle);
}
function execute($sql_query,$option) {
switch ($option) {
case 1:
$temp = @mysql_query($sql_query);
if(!$temp) {
echo "Failed to execute to query: ".$sql_query."<br>mySQL has returned the following error: ".mysql_error().".";
mysql_close();
exit();
}
$result = mysql_fetch_array($temp);
if(mysql_num_rows($temp) == 0) {
echo "Query: ".$sql_query." returned nothing from the database.";
mysql_close();
exit();
}
break;
case 2:
$temp = @mysql_query($sql_query);
if(!$temp) {
echo "Failed to execute to query: ".$sql_query."<br>mySQL has returned the following error: ".mysql_error().".";
mysql_close();
exit();
}
$result = mysql_object_array($temp);
if(mysql_num_rows($temp) == 0) {
echo "Query: ".$sql_query." returned nothing from the database.";
mysql_close();
exit();
}
break;
case 3:
$temp = @mysql_query($sql_query);
if(!$temp) {
echo "Failed to execute to query: ".$sql_query."<br>mySQL has returned the following error: ".mysql_error().".";
mysql_close();
exit();
}
$result = mysql_num_rows($temp);
break;
}
return($result);
}
}
?>Code: Select all
$mysql = array();