/SQL/How to add session data into mysql database from button

How to add session data into mysql database from button

$conn = Connect(); //your MySQLDB connection

// extract values from session to variables
$username= $conn->real_escape_string($_SESSION['auth_user']['username']);
$email= $conn->real_escape_string($_SESSION['auth_user']['email']);
$phone= $conn->real_escape_string($_SESSION['auth_user']['phone']);

//query execution
$query = $conn->prepare("INSERT into loginDetails(username,email,phone) VALUES (?, ?, ?)");
$query->bind_param("sss", $username, $email, $phone); 
$query->execute();

Similar codes

2 votes186 views1 answer
Convert series number to date in sql
SQL
0 vote143 views1 answer
Procedures and functions in pl/sql
SQL
2 votes190 views1 answer
Enum in SQL Server
SQL
1 vote180 views1 answer
Xampp import sql file command line
SQL
12 votes176 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote211 views1 answer
Split first name and last name in sql
SQL
0 vote176 views2 answers
Insert into
SQL
22 votes192 views6 answers
Create sql table
SQL
0 vote186 views1 answer
Postgresql default value boolean
SQL
-1 vote194 views1 answer
Adding a new table psql
SQL