Database Configuration

Configure the MySQL database connection for Hotel Guevarini using the Conexion class in php/conexion.php.

The database connection is managed by the Conexion class defined in php/conexion.php. All PHP files that need database access instantiate this class and call obtenerConexion() to receive a PDO connection object.

The Conexion Class

<?php

class Conexion
{
    private $host = "tu-host";
    private $db_name = "tu-base-de-datos";
    private $username = "tu-usuario";
    private $password = "tu-contraseña";
    public $conn;

    public function obtenerConexion()
    {
        $this->conn = null;
        try {
            $this->conn = new PDO(
                "mysql:host=" . $this->host . ";dbname=" . $this->db_name,
                $this->username,
                $this->password
            );
            $this->conn->exec("set names utf8");
            $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
        catch (PDOException $exception) {
            echo "Error de conexión: " . $exception->getMessage();
        }

        return $this->conn;
    }
}

Configuration Fields

Property	Description
$host	The database server address. For local development this is typically "localhost".
$db_name	The name of the MySQL database. Must match the database created when importing the SQL file.
$username	The MySQL user that has access to the database.
$password	The MySQL user’s password. Often empty for local development setups.

Error Handling

obtenerConexion() sets PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION. This means any failed query or connection problem will throw a PDOException rather than silently returning false, making errors visible and easier to debug.

The method also runs set names utf8 immediately after connecting, ensuring special characters (accents, ñ, etc.) are handled correctly throughout the application.

The database name must be hotel_guevarini_publico — this is the name that base_de_datos.sql creates automatically when imported. If you use a different name here, the connection will fail.

Configuration Steps

1. Open php/conexion.php

   Locate the file at php/conexion.php in the project root and open it in your editor.

2. Set the host

   Replace "tu-host" with your database server address. For XAMPP, WAMP, or Laragon running locally, use "localhost".

   private $host = "localhost";
   
3. Set the database name

   Replace "tu-base-de-datos" with the name of the database you imported.

   private $db_name = "hotel_guevarini_publico";
   
4. Set your MySQL credentials

   Replace the username and password with those of your MySQL user.

   private $username = "root";
   private $password = "";
   
5. Save and verify

   Save the file and open the application in your browser. If the connection fails, the error message from PDOException will be printed to the page to help diagnose the problem.

Example: XAMPP Local Setup

For a standard XAMPP installation the default MySQL user is root with an empty password:

private $host = "localhost";
private $db_name = "hotel_guevarini_publico";
private $username = "root";
private $password = "";

Never commit real database credentials to version control. If you push php/conexion.php with a real username and password to a public repository, those credentials will be exposed. Use environment variables or a gitignored config file for production credentials.