CRUD-app

Create, Read, Update, Delete app made using laravel. Clone the app from master branch and follow setup instructions.

You will need php, composer, mysql (or preffered database), database gui client.

To get started with a maria mysql DB you can follow these steps to install on arch linux!

sudo pacman -Syu

sudo pacman -S mysql

Verify Installation:

mysqld --version

Run before starting:

mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Start and ensure my sql is running:

sudo systemctl start mysqld

sudo systemctl status mysqld

Start again:

sudo systemctl enable mysqld

Follow installation directions:

sudo mysql_secure_installation

Login as root:

sudo mysql

Create user (DB commands always end with a semicolon ';' except for 'exit':

CREATE USER ‘’@’localhost’ IDENTIFIED BY ‘’;

example: CREATE USER 'john@localhost' IDENTIFIED BY '123securepass'; you will type out @localhost no need to put your local ip here same rules to command below.

Grant all priveleges to user (this will be the user you connect your dev enviroment to:

GRANT ALL PRIVILEGES ON . TO ‘’@’localhost’ WITH GRANT OPTION;

Clear Cache and exit:

FLUSH PRIVILEGES;

exit

Login:

mysql -u testuser -p

Create database and ensure its listed as a database:

CREATE DATABASE ;

SHOW DATABASES;

Once you have succesfully installed and created a mysql database you can connect it be sure to edit the php.ini file usually located in /etc/php/php.ini and uncomment the line that says ;extension=pdo_mysql

You can uncomment this by removing the ; infront of it.

Once this is done your database is ready to be used. You can add its information into the .env file. To easier view the data in the database you can install a mysql gui client. I use dbeaver-ce you can find an installation guide here https://snapcraft.io/install/dbeaver-ce/arch

Be sure to run php artisan migrate after changing the .env file so laravel detects the database to link to.

Docker Compose for running a Laravel application with MySQL database

version: '3.8'

services:
app:
image: dxle/latkisblog:latest
ports:
- "8080:80"
environment:
- DB_CONNECTION=mysql
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=your_database_name
- DB_USERNAME=your_database_username
- DB_PASSWORD=your_database_password
command: sh -c "php artisan key:generate && apache2-foreground"

db:
image: mysql:5.7
environment:
MYSQL_DATABASE: your_database_name
MYSQL_USER: your_database_username
MYSQL_PASSWORD: your_database_password
MYSQL_ROOT_PASSWORD: your_mysql_root_password
ports:
- "3306:3306"

Instructions:

1. Modify the environment variables under the 'app' and 'db' services to match your configuration.

2. Place this Docker Compose file in the root directory of your Laravel project.

3. Build and start the containers using the command: docker-compose up -d

4. Access your Laravel application at http://localhost:8080

5. Remember to replace 'your_database_name', 'your_database_username', 'your_database_password', and 'your_mysql_root_password' with your actual database credentials.

6. Ensure that Docker and Docker Compose are installed on your system before running the above command.

Now Public!