/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 vote172 views1 answer
Change default schema sql server
SQL
0 vote197 views1 answer
Product of a column in mysql
SQL
2 votes208 views1 answer
Revokeprivileges mysql
SQL
-1 vote252 views1 answer
Pl sql drop trigger
SQL
0 vote289 views1 answer
Postgres list all stored procedures query
SQL
0 vote196 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote187 views1 answer
Implicit inner join table alias
SQL
0 vote187 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
1 vote188 views1 answer
Mysql select from outside
SQL
7 votes197 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL