Customization of php session processing
user-define-session-inc.php file code:
Copy code The code is as follows:
function mysession_open($save_path, $session_name)
{
@mysql_connect("localhost", "root","1981427") //You need to connect to the database server before selecting the database
or die("Database server connection failed");
@mysql_select_db("test") //Select database mydb
or die("Database failed exists or is not available");
return true;
}
function mysession_close()
{
return true;
}
function mysession_read($key)
{
@mysql_connect("localhost", "root","1981427" ) //You need to connect to the database server before selecting the database
or die("Database server connection failed");
@mysql_select_db("test") //Select the database mydb
or die("The database does not exist or is unavailable");
$expiry_time = time(); //Get the Session expiration time
//Execute the SQL statement to get the value of the Session
$query = @mysql_query("select session_data from mysession "
."where session_key = '$key' and session_expiry > ; $expiry_time")
or die("SQL statement execution failed");
if($row = mysql_fetch_array($query))
return $row['session_data'];
else
return false;
}
function mysession_write ($key, $data)
{
@mysql_connect("localhost", "root","1981427") //You need to connect to the database server before selecting the database
or die("Database server connection failed");
@mysql_select_db ("test") //Select database mydb
or die("Database does not exist or is unavailable");
$expiry_time = time() + 1200; //Get the Session expiration time
//Query whether the Session key value has expired Exists
$query = @mysql_query("select session_data from mysession "
."where session_key = '$key'")
or die("SQL statement execution failed");
//If it does not exist, perform the insert operation, Otherwise, perform the update operation
if(mysql_numrows($query) == 0)
{
//Execute the SQL statement to insert the value of the Session
$query = @mysql_query("insert into mysession values('$key', '$data' , $expiry_time)")
or die("SQL statement execution failed");
}
else
{
//Execute SQL statement to update the value of Session
$query = @mysql_query("update mysession set "
."session_data = '$data', session_expiry = $expiry_time "
."where session_key = '$key'")
or die("SQL statement execution failed");
}
return $query;
}
function mysession_destroy($key )
{
@mysql_connect("localhost", "root","1981427") //You need to connect to the database server before selecting the database
or die("Database server connection failed");
@mysql_select_db("test") / /Select database mydb
or die("Database does not exist or is unavailable");
//Execute SQL statement to delete Session
$query = @mysql_query("delete from mysession where session_key = '$key'")
or die( "SQL statement execution failed");
return $query;
}
function mysession_gc($expiry_time)
{
@mysql_connect("localhost", "root","1981427") //You need to connect to the database server before selecting the database
or die("Database server connection failed");
@mysql_select_db("test") //Select database mydb
or die("Database does not exist or is unavailable");
$expiry_time = time();
// Execute SQL statement to delete Session
$query = @mysql_query("delete from mysession where session_expiry < $expiry_time")
or die("SQL statement execution failed");
return $query;
}
//Set user customization Session storage
session_set_save_handler('mysession_open',
'mysession_close',
'mysession_read',
'mysession_write',
'mysession_destroy',
'mysession_gc');
?>
Copy code Code As follows:
include('user-define-session-inc.php'); //File containing session_set_save_handler definition
session_start();
$_SESSION['username'] = "zhuzhao";
$_SESSION['password'] = "123456";
?> '); //File containing session_set_save_handler definition
session_start();
";
echo "PassWord:".$_SESSION['password' ]."
";
?> The above introduces the customization of PHP session processing, including aspects of content. I hope it will be helpful to friends who are interested in PHP tutorials.

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



In MySQL database, the relationship between the user and the database is defined by permissions and tables. The user has a username and password to access the database. Permissions are granted through the GRANT command, while the table is created by the CREATE TABLE command. To establish a relationship between a user and a database, you need to create a database, create a user, and then grant permissions.

Data Integration Simplification: AmazonRDSMySQL and Redshift's zero ETL integration Efficient data integration is at the heart of a data-driven organization. Traditional ETL (extract, convert, load) processes are complex and time-consuming, especially when integrating databases (such as AmazonRDSMySQL) with data warehouses (such as Redshift). However, AWS provides zero ETL integration solutions that have completely changed this situation, providing a simplified, near-real-time solution for data migration from RDSMySQL to Redshift. This article will dive into RDSMySQL zero ETL integration with Redshift, explaining how it works and the advantages it brings to data engineers and developers.

MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.

To fill in the MySQL username and password: 1. Determine the username and password; 2. Connect to the database; 3. Use the username and password to execute queries and commands.

1. Use the correct index to speed up data retrieval by reducing the amount of data scanned select*frommployeeswherelast_name='smith'; if you look up a column of a table multiple times, create an index for that column. If you or your app needs data from multiple columns according to the criteria, create a composite index 2. Avoid select * only those required columns, if you select all unwanted columns, this will only consume more server memory and cause the server to slow down at high load or frequency times For example, your table contains columns such as created_at and updated_at and timestamps, and then avoid selecting * because they do not require inefficient query se

Navicat itself does not store the database password, and can only retrieve the encrypted password. Solution: 1. Check the password manager; 2. Check Navicat's "Remember Password" function; 3. Reset the database password; 4. Contact the database administrator.

Detailed explanation of database ACID attributes ACID attributes are a set of rules to ensure the reliability and consistency of database transactions. They define how database systems handle transactions, and ensure data integrity and accuracy even in case of system crashes, power interruptions, or multiple users concurrent access. ACID Attribute Overview Atomicity: A transaction is regarded as an indivisible unit. Any part fails, the entire transaction is rolled back, and the database does not retain any changes. For example, if a bank transfer is deducted from one account but not increased to another, the entire operation is revoked. begintransaction; updateaccountssetbalance=balance-100wh

View the MySQL database with the following command: Connect to the server: mysql -u Username -p Password Run SHOW DATABASES; Command to get all existing databases Select database: USE database name; View table: SHOW TABLES; View table structure: DESCRIBE table name; View data: SELECT * FROM table name;
