/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

0 vote282 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes264 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote230 views1 answer
Enable sql server full text indexing
SQL
0 vote222 views1 answer
How to order result of subquery in select
SQL
1 vote251 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote235 views1 answer
Delete a record from a table sqlite3
SQL
1 vote221 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
2 votes226 views1 answer
Set boolean flasksql
SQL
15 votes216 views2 answers
How to drop database name in postgresql
SQL
0 vote226 views1 answer
Storing RGBA in mysql db
SQL