/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 votes147 views6 answers
Rename column postgres
SQL
0 vote127 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote131 views1 answer
Mysql exception output
SQL
2 votes76 views1 answer
Mysql admin u root p password change password
SQL
0 vote79 views1 answer
Count char in java
SQL
0 vote154 views2 answers
How to check if a column exists in a SQL Server table?
SQL
9 votes125 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote168 views2 answers
Fanyi
SQL
1 vote133 views1 answer
Sql group by sum with condition
SQL
0 vote127 views2 answers
Mysql updating multiple column values from array variable
SQL