/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

15 votes294 views4 answers
How to get all tables in sql
SQL
3 votes289 views1 answer
How to uninstall microsoft sql server
SQL
0 vote301 views1 answer
Import sql in postgresql
SQL
0 vote316 views1 answer
Sql server alter table add column tinyint
SQL
0 vote278 views1 answer
Changer un mot de passe mysql
SQL
1 vote289 views2 answers
Mysql current user
SQL
0 vote318 views2 answers
MySQL PARTITION BY month automatically
SQL
32 votes314 views6 answers
How to change column name in sql
SQL
0 vote298 views1 answer
Create table with float datatype in sql server
SQL
0 vote336 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL