What are the potential security risks of storing session IDs in cookies and databases in PHP?

Storing session IDs in cookies and databases in PHP can pose security risks if not properly implemented. One potential risk is that session IDs stored in cookies can be vulnerable to attacks like session hijacking if not properly secured. Storing session IDs in a database can also expose them to SQL injection attacks if input validation and sanitization are not implemented correctly. To mitigate these risks, it is recommended to use secure methods for generating and storing session IDs, such as using PHP's built-in session handling functions and implementing proper security measures.

// Fix: Use PHP's built-in session handling functions and set session cookie parameters for security

// Start the session
session_start();

// Set session cookie parameters for security
session_set_cookie_params([
    'lifetime' => 0,
    'path' => '/',
    'domain' => 'example.com',
    'secure' => true,
    'httponly' => true
]);