/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

6 votes332 views1 answer
How to count number of rows in sql
SQL
13 votes363 views2 answers
Sql join 3 tables
SQL
0 vote330 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote354 views1 answer
Where date = max(date) in sql
SQL
0 vote337 views1 answer
What is the use of index in mysql table
SQL
4 votes355 views6 answers
Second max salary in sql
SQL
0 vote348 views1 answer
Less than and between in sql query
SQL
0 vote356 views1 answer
Run mysql xampp shell
SQL
0 vote342 views1 answer
Check sql database table lock
SQL
0 vote397 views1 answer
How to find date from date table in sql
SQL