What steps are involved in updating a MySQL table to include a field for user status (guest or logged in) in a PHP application?

To update a MySQL table to include a field for user status (guest or logged in) in a PHP application, you will need to first alter the table structure by adding a new column for user status. Then, you can update this field based on the user's login status in your PHP code. 

// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

// Alter table to add user_status field
$sql = "ALTER TABLE users ADD user_status VARCHAR(10) NOT NULL DEFAULT 'guest'";
if ($conn->query($sql) === TRUE) {
  echo "Table altered successfully";
} else {
  echo "Error altering table: " . $conn->error;
}

// Update user status based on login status
$user_id = 1; // Example user ID
$user_status = "logged in"; // Example user status

$sql = "UPDATE users SET user_status = '$user_status' WHERE id = $user_id";
if ($conn->query($sql) === TRUE) {
  echo "User status updated successfully";
} else {
  echo "Error updating user status: " . $conn->error;
}

// Close database connection
$conn->close();

Keywords

MySQL table update PHP application user status field addition

Related Questions