Assuming you have created already created a MySQL database named "database_name" with a table named "users" that has columns for "username", "password", and "email". And that you have also created a login system that sets the "username" session variable when a user logs in. Write a simple PHP code that makes use of sessions, mysql insert, update, and delete. The code should first start with a session using session_start(). It should then connect to a MySQL database using mysqli_connect(). It inserts a new record into the users table using mysqli_query() and an SQL INSERT statement. It updates an existing record in the users table using mysqli_query() and an SQL UPDATE statement. It deletes a record from the users table using mysqli_query() and an SQL DELETE statement. It sets a session variable using $_SESSION["username"] and displays it using echo. Finally, it closes the MySQL connection using mysqli_close()
Assuming you have created already created a MySQL
Write a simple PHP code that makes use of sessions, mysql insert, update, and delete. The code should first start with a session using session_start(). It should then connect to a MySQL database using mysqli_connect(). It inserts a new record into the users table using mysqli_query() and an SQL INSERT statement. It updates an existing record in the users table using mysqli_query() and an SQL UPDATE statement. It deletes a record from the users table using mysqli_query() and an SQL DELETE statement. It sets a session variable using $_SESSION["username"] and displays it using echo. Finally, it closes the MySQL connection using mysqli_close()
Step by step
Solved in 3 steps