Embedded Files
1. Xampp Server
1. Xampp Server
XAMPP is a free and open-source web server solution stack that includes Apache, MariaDB (or MySQL), PHP, and Perl, allowing developers to test websites and applications on a local computer before deploying them to a live server. The "X" stands for "cross-platform," meaning it works on Windows, macOS, and Linux. It provides a complete development environment for creating dynamic websites.
Key components and purpose
Cross-Platform (X): Works on various operating systems like Windows, macOS, and Linux.
Apache (A): A popular web server that handles requests and delivers content.
MariaDB (M): A database management system for storing data, similar to MySQL.
PHP (P): A scripting language commonly used for web development.
Perl (P): Another programming language used for web development, system administration, and text processing.
This applications is used for
Local testing: Developers can build and test websites on their own computers as if they were on a live server, without needing to be connected to the internet or pay for hosting.
Simplified setup: It's an easy-to-install package that bundles all the necessary software, making it an excellent tool for beginners and professionals alike.
Compatibility: Since it uses the same components as many live servers, it helps ensure that the website will function correctly once it's moved online.
Content Management Systems (CMS): XAMPP is often used to run CMS platforms like WordPress, Joomla, and Drupal locally for development and testing.
The minimum requirements for XAMPP to run
Operating System: Windows 7 or later, macOS 10.6 or later, or Linux
Processor: 1GHz or higher
Memory RAM: 2GB (4GB recommended)
Storage SSD/HDD: At least 1GB of free space for the basic installation
Administrator: Required for installation and configuration
Where to download this software
This software is free and can be downloaded with the link → https://www.apachefriends.org/download.html
2. Database - MariaDB
2. Database - MariaDB
XAMPP is a software package that includes Apache, MySQL (or MariaDB), PHP, and Perl, making it easy to set up a local server environment for web development. To use the database functionality in XAMPP, you primarily work with MySQL (or MariaDB, its drop-in replacement).
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.
MariaDB is a popular, free, and open-source relational database management system (RDBMS) that was forked from MySQL in 2009 by its original developers due to concerns about the future of MySQL after its acquisition by Oracle. It uses SQL to manage structured data and is known for being fast, scalable, and robust. It is used by major platforms like Wikipedia, WordPress, and Google.
Key characteristics
Open-source: MariaDB is released under the GNU General Public License (GPLv2), ensuring it remains free and open source, independent of commercial entities.
MySQL fork: It was created as a "drop-in replacement" for MySQL, making it easy to switch between the two. It shares a similar API and protocols.
Relational database: It organizes data into tables and uses the standard SQL (Structured Query Language) for data management.
Performance and scalability: It is designed to be fast and can handle large amounts of data, making it suitable for mission-critical applications and high-traffic sites.
Versatility: It supports a wide range of workloads, with an ecosystem of plugins and storage engines.
NoSQL capabilities: Modern versions of MariaDB have started to incorporate NoSQL-like features, such as dynamic columns and the ability to connect to other data sources.
Cross-platform: It is compatible with major operating systems, including Windows, Linux, and macOS.
Below is a concise guide to using the database in XAMPP:
Manage the Database:
Use phpMyAdmin to perform tasks like:
Adding, editing, or deleting records.
Running SQL queries (via the SQL tab).
Exporting/importing databases (via the Export/Import tabs).
Secure the Database (Optional but Recommended):
By default, XAMPP’s MySQL user is root with no password, which is insecure for production.
To set a password:
In phpMyAdmin, go to the User accounts tab.
Edit the root user for localhost, set a password, and apply changes.
Update your PHP connection code with the new password.
Stop MySQL:
When done, stop the MySQL and Apache modules in the XAMPP Control Panel to free up resources.
For more information about Maria Database click → https://mariadb.org/about/
3. phpmyadmin
3. phpmyadmin
phpMyAdmin is a free, open-source web-based tool written in PHP for administering databases like MySQL and MariaDB. It provides a user-friendly interface to perform tasks such as creating and deleting databases, tables, and users, as well as executing direct SQL statements. This allows for both simplified management through its graphical interface and the flexibility of running custom SQL queries.
Key functions of this application
Database management: Create, delete, and manage databases and their structures (tables, columns).
Data manipulation: Add, edit, and delete data within tables.
Query execution: Run SQL statements directly through an editor or build them visually using the Query-by-example (QBE) tool.
User and permissions management: Manage user accounts and set their permissions.
Data import/export: Export and import data in various formats, such as SQL, CSV, XML, PDF, and others.
Database design: Visualize and manage relationships between tables using a drag-and-drop designer.
MySQL is the database management system, or a database server. phpMyAdmin is the web application written primarily in PHP. It's used for managing MySQL database.
For more information about phpmydamin and download latest version click → https://www.phpmyadmin.net/downloads/
→ Steps to Use XAMPP Database (MySQL/MariaDB)
→ Steps to Use XAMPP Database (MySQL/MariaDB)
Start XAMPP and MySQL:
Open the XAMPP Control Panel.
Start the Apache and MySQL modules by clicking the "Start" buttons next to them. Ensure the MySQL status shows as running (port usually 3306).
Access phpMyAdmin:
Open your web browser and go to http://localhost/phpmyadmin.
phpMyAdmin is a web-based tool included with XAMPP for managing MySQL databases.
Create a Database:
In phpMyAdmin, click on the Databases tab.
Enter a name for your database in the "Create database" field and click Create.
Example: Create a database named my_database.
Create Tables:
Select the database you just created from the left sidebar.
In the "Create table" section, enter a table name (e.g., users) and specify the number of columns (e.g., 3 for id, name, email).
Click Go, then define the columns:
id: INT, Auto Increment, Primary Key.
name: VARCHAR(100).
email: VARCHAR(100).
Save the table.
Insert Data:
Click on the table name in phpMyAdmin.
Go to the Insert tab.
Fill in the values for the columns (e.g., name: John Doe, email: john@example.com) and click Go to insert the data.
Connect to the Database via PHP:
Create a PHP file (e.g., connect.php) in the XAMPP htdocs folder (e.g., C:\xampp\htdocs).
Use the following sample code to connect to the database:
4. php Hypertext Preprocessor
4. php Hypertext Preprocessor
PHP, which originally stood for Personal Home Page but now recursively stands for PHP: Hypertext Preprocessor, is a widely used open-source, server-side scripting language primarily designed for web development.
Key characteristics and uses of PHP:
Server-side scripting: PHP code is executed on the web server, generating dynamic HTML content that is then sent to the user's browser. This contrasts with client-side languages like JavaScript, which execute in the browser.
Web development focus: It is particularly well-suited for creating dynamic web pages and web applications. It can be embedded directly within HTML and interacts seamlessly with various databases, including MySQL, PostgreSQL, and Oracle.
Open-source and cross-platform: PHP is free to use and runs on various operating systems (Linux, Windows, macOS) and web servers (Apache, Nginx, IIS).
Dynamic content generation: PHP enables the creation of interactive and personalized website experiences by generating content based on user input, database information, and other server-side logic.
Database interaction: It provides robust capabilities for connecting to and manipulating databases, allowing for data storage, retrieval, and management within web applications.
Common applications: PHP powers a significant portion of the web, including popular content management systems like WordPress, Joomla, and Drupal, as well as e-commerce platforms like WooCommerce.
Versatility: While primarily used for web development, PHP is a general-purpose language and can also be used for other applications, such as command-line scripting and even desktop application development.
5. Web development HTML and PHP
5. Web development HTML and PHP
6. Topic
6. Topic
7. FAQ : Frequent Ask Questions
7. FAQ : Frequent Ask Questions
Can I relocate the htdocs folder to another drive
Yes, you can move the htdocs folder to another location, but you must update the Apache configuration file (httpd.conf) to point to the new directory. After stopping the Apache server, move the htdocs folder to its new location, then edit the httpd.conf file to change DocumentRoot and the corresponding Directory path to the new path, and finally restart Apache.
Steps to move the htdocs folder
Stop Apache: Open the XAMPP Control Panel and click the "Stop" button next to the Apache module.
Move the folder: Copy or move the entire htdocs folder to the new drive or location (e.g., D:\htdocs).
Edit the file → httpd.conf
Navigate to C:\xampp\apache\conf (or your XAMPP installation path) and open the httpd.conf file in a text editor.
Find the line that starts with DocumentRoot. Change the path to your new htdocs folder location (e.g., DocumentRoot "D:/htdocs").
Find the <Directory> block that follows DocumentRoot and update the path there as well (e.g., <Directory "D:/htdocs">).
Save and close the httpd.conf file.
Restart Apache: Go back to the XAMPP Control Panel and click "Start" for Apache. Your new htdocs folder location should now be active.
8. Error message in setup Xampp
8. Error message in setup Xampp
Error 1 : Apache path wrong
Error 1 : Apache path wrong
The error indicates that XAMPP is detecting the Apache service with a path pointing to
Error E:\xampp\apache\bin\httpd.exe, but it expects D:\xampp\apache\bin\httpd.exe.
This mismatch likely occurs because XAMPP was installed or configured on one drive (D:) but is now being run from another (E:), or the configuration still references the old path. Here’s how to resolve it:
Steps to Fix the XAMPP Apache Path Error
Verify XAMPP Installation Location:
Confirm where XAMPP is currently installed. Based on the error, it seems XAMPP is now on E:\xampp.
If you moved XAMPP from D:\ to E:\, the Apache service configuration needs to be updated.
Stop Apache Service:
Open the XAMPP Control Panel.
Stop the Apache service if it’s running (click the "Stop" button next to Apache).
Alternatively, open a Command Prompt as Administrator and run: → net stop Apache2.4
3. Update the Apache Service Path:
Open a Command Prompt as Administrator.
Remove the existing Apache service (which points to the old path): → sc delete Apache2.4
Reinstall the Apache service with the correct path: E:\xampp\apache\bin\httpd.exe -k install
This command registers the Apache service using the current installation path (E:\xampp).
4. Update XAMPP Configuration (if needed):
Open the XAMPP configuration file for Apache:
Navigate to E:\xampp\apache\conf\httpd.conf.
Open httpd.conf in a text editor (e.g., Notepad).
Search for any references to D:\xampp and replace them with E:\xampp.
Save the file.
5. Check Windows Registry (Optional):
If the above steps don’t resolve the issue, the Windows Registry may still reference the old path.
Open the Registry Editor (regedit) as Administrator.
Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Apache2.4
Check the ImagePath key. It should point to: → E:\xampp\apache\bin\httpd.exe -k runservice
If it shows D:\xampp, update it to E:\xampp.
Be cautious when editing the registry—back it up first.
Restart XAMPP and Test:
Open the XAMPP Control Panel.
Start the Apache service.
Check if the error is resolved. If Apache starts successfully, the issue is fixed.
6. Alternative: Reinstall XAMPP:
If the above steps fail or the setup is too complex to fix:
Uninstall XAMPP from E:\xampp.
Delete the E:\xampp folder.
Download the latest XAMPP version and install it on E:\ (or your preferred drive).
Reconfigure your projects and databases as needed.
7. Check for Multiple XAMPP Installations:
Ensure there’s no leftover XAMPP installation on D:\xampp. If it exists, it may cause conflicts.
Delete or move the old D:\xampp folder if it’s no longer needed.
Error 2 : My SQL Path wrong
Error 2 : My SQL Path wrong
The error you're seeing in XAMPP Control Panel occurs because XAMPP detects that MySQL is installed/configured for a different drive/path than where it is currently running from.
Found Path: E:\xampp\mysql\bin\mysqld.exe --defaults-file=e:\xampp\mysql\bin\my.ini mysql
Expected Path: D:\xampp\mysql\bin\mysqld.exe --defaults-file=d:\xampp\mysql\bin\my.ini mysql
This error means:
XAMPP was previously installed or configured on E:\xampp
Now you're running it from D:\xampp
But some configuration files still point to E:\xampp, confusing the control panel.
Method 1: Edit the control. ini
Open XAMPP Control Panel as Administrator
Right-click xampp-control.exe → Run as administrator → Stop MySQL (if running) → Edit xampp-control.ini
Location: D:\xampp\xampp-control.ini . Open and edit with Notepad
Find the line: → MySQLPath=E:\xampp\mysql
Change it to: → MySQLPath=D:\xampp\mysql
Save the file
Edit mysql_start.bat (optional but safe)
Path: D:\xampp\mysql_start.bat
Open in Notepad
Look for any hardcoded E:\xampp paths
Replace with D:\xampp
Save
Restart XAMPP Control Panel (close and reopen as admin). Try starting MySQL again
Method 2 Fix my.ini Path (if needed)
Open: D:\xampp\mysql\bin\my.ini
Look for lines like:
basedir = "E:/xampp/mysql"
datadir = "E:/xampp/mysql/data"
Change to:
basedir = "D:/xampp/mysql"
datadir = "D:/xampp/mysql/data"
Save the file.
Method 3: Error detect path wrong for MySQL
When XAMPP reports "MySQL service detected with wrong path," it indicates that the path stored in the Windows Registry for the MySQL service does not match the actual location of the mysqld.exe executable within your XAMPP installation. This often happens after moving the XAMPP folder or having a previous standalone MySQL installation.
To fix this, you need to update the ImagePath in the Windows Registry:
a. Open the Registry Editor:
Press Win + R to open the Run dialog.
Type regedit and press Enter.
b. Navigate to the MySQL service key: In the Registry Editor, navigate to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL
Note:
If you have multiple MySQL services (e.g., from a previous installation), you might see other entries like MySQL56 or similar. Ensure you are editing the entry corresponding to the XAMPP MySQL service.
c. Modify the ImagePath value:
- Locate the ImagePath entry in the right pane and double-click it.
- In the "Value data" field, you will see the incorrect path.
d:\xampp\mysql\bin\mysqld.exe --defaults-file=d:\xampp\mysql\bin\my.ini MySQL
d. Ensure the path is enclosed in double quotes and includes the --defaults-file parameter pointing to your my.ini file. Click "OK"
to save the changes.
e. Restart the MySQL service:
Open the XAMPP Control Panel.
Stop the MySQL service if it's running.
Start the MySQL service again.
Page updated
Google Sites
Report abuse