CSS Color (Colour) Concatenation

by Garth | Aug 24, 2023 | Uncategorized

So I figured this out by mistake and had my mind blow when I saw it. Haha I have been programming with CSS for 7 years and I didn't know this!

I was adjusting default bootstrap checkbox colours and I accidentally typed an additional colour without clearing and it ended up splitting the colours. Looks quite cool! Check how the border splits half half on each side with the colours.

.form-check-input:checked {
    background-color: #000;
    border-color: #000#FFF;
}

Laravel Import Template with Error Handling and Try Catch for failures

by Garth | Jul 18, 2023 | Uncategorized

public function import_data(Request $request)
{
    $success = true;

    try {
        DB::beginTransaction();

        foreach ($request->array_or_object as $item) {
            $record_payload = [
                "name" => $item->name,
                "surname" => $item->surname,
            ];

            $record_id = $item->id ?? null;
            $inserted_record = RecordModel::updateOrCreate(['id' => $record_id], $record_payload);

            if (!$inserted_record) {
                $success = false;
                break; // Stop further processing if any insert fails
            }
        }

        if ($success) {
            DB::commit();
            return ['status' => true, 'message' => 'Success, Your import has completed with no issues.'];
        } else {
            DB::rollBack();
            return ['status' => false, 'message' => 'Unsuccessful Transaction. Not an exception.'];
        }
    } catch (\Exception $e) {
        DB::rollBack();
        $i = count($e->errorInfo) - 1;
        return ['status' => false, 'message' => $e->errorInfo[$i]];
    }
}

Laravel Migration Error – SQLSTATE[HY000] [2002] php_network_getaddresses

by Garth | May 15, 2023 | Uncategorized

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mysql 
failed: Temporary failure in name resolution (SQL: select * from 
information_schema.tables where table_schema = laravel and 
table_name = migrations and table_type = 'BASE TABLE')

The issue has to do with the env variable DB_HOST
You need to change it. To what your localhost is configured for.
It can most likely be one of the following.

mysql
127.0.0.1
localhost

or alternatively check your docker container name for your mysql DB:
mysql_container_name

Divi – Align Gallery images vertically center

by Garth | May 11, 2023 | Uncategorized

Take note of the height restriction!

In this case we set the height for the default size of landscape images layout for the divi gallery element.

/* Gallery Image Alignment */
.et_pb_gallery_image.landscape {
    display: flex;
    justify-content: center;
    align-items: center;
    min-height: 226px;
}

Create New Laravel Project & Generate Auth

by Garth | May 9, 2023 | Uncategorized

Create Project

Just use one.
The are multiple as examples.

composer create-project --prefer-dist laravel/laravel blog "11.*"

composer create-project --prefer-dist laravel/laravel blog "10.*"

composer create-project --prefer-dist laravel/laravel blog "9.*"

Generate Auth

An alternative instead of running npm run build.
Run npm run dev OR npm run watch

// With Boothstrap
composer require laravel/ui --dev
php artisan ui bootstrap --auth
npm install 
npm run build

// With VUE
composer require laravel/ui --dev
php artisan ui vue --auth
npm install
npm run build 

Uploading your js build to the server

If you using git and working locally and using laravel vite.
Build your project and use the below gitignore. This will push your build to the server.

The below is that if you don't include certain directories then your build files will not get uploaded and some servers don't have suffucient resources to run builds online.
So you need to build locally and upload the build via GIT.

/vendor/
npm-debug.log
yarn-error.log
public/hot
public_html/storage
public_html/hot
public/robots.txt
storage/*.key
.env
.htaccess
Homestead.yaml
Homestead.json
/.vagrant
.phpunit.result.cache

Manage MySQL Server on Linux Terminal

by Garth | Apr 16, 2023 | Uncategorized

Check Serve Status

sudo service mysql status

Start or Stop MySQL Server

service mysql stop
service mysql start

MySQL Terminal Actions

create database this_is_my_database_name;

Also, give this a read 🙂
https://www.tutorialspoint.com/starting-and-stopping-mysql-server

Manage Apache Server on Linux

by Garth | Apr 16, 2023 | Uncategorized

Check Apache Status

sudo systemctl status apache2

Start, Stop or Restart Apache

sudo service apache2 start
sudo service apache2 restart
sudo service apache2 stop

For other operating systems such as CentOS/Fedora
Try httpd instead of apache2
Example : systemctl status httpd

Install MySQL – Linux and Windows

by Garth | Apr 16, 2023 | Uncategorized

You can install MySQL for Windows here.
The new MySQL install very convenient. But is made for Windows.

https://dev.mysql.com/downloads/installer/

Give this article a read for Linux
https://ubuntu.com/server/docs/databases-mysql

You can install MySQL for linux like this :

sudo apt install mysql-server
sudo service mysql status

Bootstrap Mobile Optimisation

by Garth | Apr 16, 2023 | Uncategorized

The best CSS library I have ever used for mobile Optimisation!

https://getbootstrap.com/

After full time developing since 2016 I still used this one almost every project I complete. In terms of mobile optimisation. Bootstrap remains king!

It is simple and easy to learn. Allowing new developers to pick it up fast. And cutting down the work load for mobile optimisation greatly. I highly recommend BootStrap to any web developer.