This guide will walk you through setting up the Calisthenics Admin system on your local machine using XAMPP.
- XAMPP: Installed and running on your machine.
- Project Files: The Calisthenics Admin project files, including the
conn.phpfile and the database SQL file.
-
Locate the
conn.phpfile in your project (usually in the root orconfigfolder). -
Open the file in a text editor and update the database connection settings:
<?php // Database connection settings $servername = "localhost"; // Server name (usually 'localhost' if using XAMPP) $username = "root"; // Default username for XAMPP $password = ""; // Default password for XAMPP (empty) $dbname = "calisthenics_db"; // Name of your database // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?>
-
Save the
conn.phpfile after making changes.
-
Start XAMPP:
- Open the XAMPP Control Panel.
- Start the
ApacheandMySQLservices.
-
Access phpMyAdmin:
- Open your browser and go to
http://localhost/phpmyadmin.
- Open your browser and go to
-
Create a New Database:
- In phpMyAdmin, click "New" in the left sidebar.
- Enter a name for your database (e.g.,
calisthenics_db) and click "Create".
-
Import the Database File:
- Select the newly created database from the left sidebar.
- Click the "Import" tab at the top.
- Click "Choose File" and select the SQL file from the
databasefolder of your project. - Click "Go" to import the database.
-
Place the Project in the XAMPP Directory:
- Move your project folder (e.g.,
calisthenics_admin) to thehtdocsdirectory inside the XAMPP installation folder (usuallyC:\xampp\htdocs).
- Move your project folder (e.g.,
-
Access the Application:
- Open your browser and navigate to
http://localhost/calisthenics_admin(replacecalisthenics_adminwith the name of your project folder).
- Open your browser and navigate to
-
Verify the Connection:
- If everything is set up correctly, you should see "Connected successfully" or a similar message.
- Connection Issues: Double-check the
conn.phpfile for typos or incorrect credentials. - Database Import Issues: Ensure the SQL file is not corrupted and matches the expected structure.
- XAMPP Issues: Check the XAMPP Control Panel for error messages and ensure no other services are using the same ports (e.g., port 80 for Apache, port 3306 for MySQL).
- Login to the Admin Panel: Navigate to the login page (e.g.,
http://localhost/calisthenics_admin/admin/login.php). - Use Default Credentials: email:admin@admin.com password:password.
You should now have the Calisthenics Admin system running on your local machine. If you encounter any issues, refer to the troubleshooting steps or consult the documentation for your specific application.
Happy Coding! 🚀






