RDBMS LAMP & Full Stack Development - Part I MariaDB

 Preface

This blog is intended to provide an option for full stack development using the LAMP, XAMP or WAMP stack with MariaDB as the backend for RDBMS MIS application development.


RDBMS Logical Design

The following QuickDBD website offers a good online application that will help you draw database diagrams quickly. It also offers an online tool for you to create a logic model of your database system and it also can automatically generate an SQL statement to create that database in your SQL database.

QuickDBD FAQ

 



Install XAMPP

Download and install Apache XAMPP for your operating system from their website following their installation instructions. You may encounter installation problems if you are using Windows 11. This will mainly be related to port conflicts. Windows 11 may be using port 80 for IIS. If this is the case and an error warning is issued from the XAMPP control panel then you could change the port to 8012 or some other unused port.

If you are unfamiliar you can check out YouTube or XAMPP's tutorials on installation. Once you have completed the installation and any port modifications you will get the control panel on launch.


You can see that I had to change the Apache port 80 to 8012 because Windows is using port 80 on my computer. To do that you can select 'Config' and select Apache (httpd.conf) configuration file and change port 80 to 8012. Stop and Start Apache again to reset the port from 80 to 8012.

Note: to access the XAMPP dashboard with a different port to 80 you will need to add that in the url link as follows: 'http://localhost:8012/ Enter'. If you don't then you will get the application that is using port 80 instead.

Once you have started MySQL (MariaDB) on the control panel you can launch phpMyAdmin by selecting it by clicking on the button on the top right of the dashboard 'phpMyAdmin'. You will be redirected to the phpMyAdmin dashboard.


You are now ready to create your relational database with MariaDB.







Comments

Post a Comment

Popular posts from this blog

LibreBase to MariaDB (MySQL) on Synology NAS Drive DS923+

Image
Step 1:  Install MariaDB and PHPMyAdmin in Synology NAS Drive Connect to your Synology NAS Dashboard. Select >  Package Center > MariaDB 10 > Install. Once the database is installed the next time you open Package Center it will show an Open button. Select > Open and note the Enabled TCP/IP connection Port. The default is 3306 but a different port number may be allocated such as 3308. Similarly install phpMyAdmin. If it is installed the button will show Open. To run phpMyAdmin you will need to launch it from your browser to Synology NAS Drive IP Address. The NAS IP Address is shown on the lower right hand corner of the Dashboard under System Health. e.g. LAN1   192.168.1.232 Step 2:  Access phpMyAdmin from your browser To access your phpMyAdmin you need to enter the IP Address of your NAS drive as shown in the Dashboard. You can now Import a csv table from your spreadsheet like the table shown below. You can edit and change records and fields with php...
Read more

CRUD - CodeIgnighter & Grocery-CRUD

This blog tutorial is created to help you create a browser based (cloud) database application using MariaDB with CodeIgniter together with the Grocery-CRUD plugin that you can easily test through your localhost server on your desktop, on your LAN or via internet through your ISP. Download and install XAMPP on Windows OS or Apache, MariaDB (MySQL) and PHP on Linux. Download and install CodeIgniter3 in /xampp/htdocs or /var/www/html/ in Ubuntu under your website folder name. Download and install Grocery-CRUD application folders by merging them with the CodeIgniter3 folders in your proposed website. Use phpAdmin to create the MariaDB database for your website. Edit /application/config/database.php to point to your database as required. Edit /application/config/config.php to point to your database as needed. You can follow the following online tutorials or read the user manuals online to customise your site to work with CRUD. https://www.grocerycrud.com/ https://www.groceryc...
Read more

Installing RaspberryPi Desktop on Acer AspireOne Intel Atom Laptop

Raspberry Pi Desktop on an Intel Atom N270 Acer One Laptop  I was recently given an Acer Aspire One laptop with Windows XP with 1 GB RAM and 160 GB hard drive with a 1024 by 600 pixel display. I thought it would be interesting to try and refurbish it with a RaspberryPi desktop for PC, which I downloaded from: Raspberry Pi Desktop for PC and Macdesktop/ The downloaded filename is 2021-01-11-raspios-buster-i386.iso which is a 32 bit OS that could be installed on the Aspire One. The Aspire One had a limited legacy BIOS that allowed booting from the USB ports but did not allow me to create a backup image using Clonezilla or Macrium Reflect. Perhaps it was the operator's fault. I gave up after spending a day trying. I used Rufus to enable the raspios iso to boot off my USB.  Installing Raspberry Pi Desktop You can run the Debian with Raspberry Pi Desktop from the live USB drive or use it to install as your computer's main operating system. You can follow the instructions from the f...
Read more