/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

4 votes377 views1 answer
Postgres delete last row
SQL
0 vote358 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote399 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes339 views1 answer
SQL IF ELSE
SQL
0 vote280 views1 answer
How to check oracle index table
SQL
0 vote327 views2 answers
How to display enum value sql server
SQL
17 votes325 views3 answers
How to change a collumn name in sql
SQL
0 vote358 views1 answer
Mysql row generator
SQL
1 vote341 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote347 views1 answer
Sql select max value from multiple rows
SQL