/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

2 votes273 views3 answers
How to replace null values in sql
SQL
0 vote191 views1 answer
Tsql delete all rows
SQL
0 vote223 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote203 views1 answer
Sql server query database space available
SQL
2 votes270 views1 answer
Mysql now format
SQL
14 votes266 views1 answer
Excel is not a database
SQL
0 vote202 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote206 views1 answer
Mysql select another database
SQL
0 vote211 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes210 views1 answer
How to make insert script from table in SQL server
SQL