Though you can import the CSV directly in DB, but importing it with an importer gives you more control over the data manipulation while importing.Below is the Script you will be needing for that.<pre class="ql-syntax" spellcheck="false">&lt;?php
/**
 * importer for CSV in MySQL DB.
 * pleas keep the CSV file in the same directory and run :
 *
 * &gt; php ./import.php
 */

$host = "localhost"; // Host name.
$db_user = "root"; //mysql user
$db_password = ""; //mysql pass
$db = ''; // Database name.

$con = mysqli_connect($host, $db_user, $db_password, $db);

// Check connection
if (mysqli_connect_errno()) {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$file = fopen('filename.extension', "r");
while (($data = fgetcsv($file, 100000, ",")) !== FALSE) {
 $sql = "INSERT into hs_codes(col1, col2, col3) values('$data[0]', '$data[1]', '$data[2]')";
 mysqli_query($con, $sql);
}

fclose($file);
echo "CSV File has been successfully Imported.";
</pre>

Though you can import the CSV directly in DB, but importing it with an importer gives you more control over the data manipulation while importing.

CSV Importer script for PHP

Assuming that you have installed php from brew. You can switch the versions between php from the script below.Update the script as per the requirement of your versioning.<pre class="ql-syntax" spellcheck="false">#!/usr/bin/python3

""" 
script to switch between php versions
author: msamgan
created: 22 july, 2022
additional info
 - make the script executable chmod +x php.switch &lt;version&gt;
 - put the script in .local/bin for global access
 - or run directly from terminal ./php.switch &lt;version&gt;
"""

import argparse
import os
import sys

parser = argparse.ArgumentParser(description="Script to switch between php versions")
parser.add_argument("version", metavar="Version", type=str, help="Version")

args = parser.parse_args()

print("Switching php version to: " + args.version)

if args.version == "8.1":
 os.system("brew unlink php@7.4 &amp;&amp; brew link php@8.1 --force --overwrite")
 os.system("php -v")
 sys.exit()

if args.version == "7.4":
 os.system("brew unlink php@8.1 &amp;&amp; brew link php@7.4 --force --overwrite")
 os.system("php -v")
 sys.exit()

print("Invalid version")
</pre>

Assuming  that you have installed php from brew. You can switch the versions between php from the script below

Python script to switch between php versions in Mac

Deployment in itself is a messy task, and it becomes a bit more of hectic if you need to run a bunch of commands every time you deploy.The one of the best way is to create a deployment script and run it every time you deploy.<h2>Step 1: Create deployment script</h2>create a deploy.sh file in the root of your folder and make it executable. You can use the following commands.<pre class="ql-syntax" spellcheck="false">touch deploy.sh
sudo chmod +x deploy.sh
</pre><h2>Step 2: Update the script</h2><pre class="ql-syntax" spellcheck="false"># Turn on maintenance mode
php artisan down

# Pull the latest changes from the git repository
git reset --hard
git clean -df
git pull origin master

# Install/update composer dependecies
composer install --no-interaction --prefer-dist --optimize-autoloader --no-dev

# Run database migrations
php artisan migrate --force

# Clear caches
php artisan cache:clear

# Clear expired password reset tokens
php artisan auth:clear-resets

# Clear and cache routes
php artisan route:clear
php artisan route:cache

# Clear and cache config
php artisan config:cache
php artisan config:clear

php artisan view:clear

# Install node modules
npm install

# Build assets using Laravel Mix
npm run prod

# Turn off maintenance mode
php artisan up
</pre><h2>Step 3: Run on Deployment</h2>Now every time you need to deploy. just run deploy.sh<pre class="ql-syntax" spellcheck="false">./deploy.sh
</pre>Feel free to suggest any modification if you feel so.

Creating a Deployment script to make the Deployment Easy

There are a number of options available for purpose of blog creation but if you are a developer non of them are as satisfying as <a href="https://github.com/themsaid/wink" rel="noopener noreferrer">laravel wink</a>. It not only comes with a straight forward deployment but also the UI implementation for the blog is super easy (we will discuss it in our next article).In this article we will discuss how to get started with wink for blog creation. <h2>Step One</h2>Since wink is a laravel package its but obvious first we have to install laravel. You can follow the <a href="https://laravel.com/docs/8.x/installation" rel="noopener noreferrer">official installation guide</a> for the same<h2>Step Two</h2>Ones we have laravel all setup and running wink is installed as all the other laravel packages <pre class="ql-syntax" spellcheck="false">composer require themsaid/wink
php artisan wink:install
php artisan storage:link
</pre>Ones this is done, we have to set up the Database. Configure the database connection in&nbsp;config/wink.php. <div class="embedded_image" contenteditable="false" data-layout="default"><img alt="" src="/storage/wink/images/ehvh5zHWzfVXFcy9DtiRMLVUL9b4Sm2zvgchbzto.png"></div> use "mysql" if you want the use the default DB connection else you can make a different one as per the requirement. After this run the following commands<pre class="ql-syntax" spellcheck="false">php artisan config:cache
php artisan wink:migrate
</pre>and that it, you are good to go.Head to&nbsp;"your-project.test/wink/login"&nbsp;and use the provided email and password to log in.Although there is not much left for the setup part but here is the source of <a href="https://github.com/themsaid/wink" rel="noopener noreferrer">wink GitHub</a>.<h2>Updates</h2>as in each update there might be a chance DB is changes so make sure to run these two commands too.<pre class="ql-syntax" spellcheck="false">php artisan wink:migrate
php artisan vendor:publish --tag=wink-assets --force
</pre>Feel free to comment.

There are a number of options available for purpose of blog creation but if you are a developer non of them are as satisfying as laravel wink

How to get started with laravel wink for creating a blog

If you are habitual of writing a formatted code don’t worry it’s a good habit but when sometimes you get to debug files which are not formatted what so ever. In that case, it’s a headache to get things done in that sort of files.In this kind of scenario, PhpStorm comes to rescue, Normal indentation of the file can be done only by the following commands.<pre class="ql-syntax" spellcheck="false">Ctrl + A (to select complete file)
Ctrl + Alt + I (this will indent the file properly.)
</pre>But sometimes we need more than just indentation. To completely format file got for<pre class="ql-syntax" spellcheck="false">Ctrl + Shift + Alt + l
</pre>This will open a dialogue box, easy to understand. Select as you are pleased and go for it. This will format your file as you wished it was.Moreover, sometimes a file is full of unused commented code which is there for no use. I tried for searching a plugin or something to remove all that commented code at ones but I guess there isn’t any.But found a good solution to this problem. You can use&nbsp;search and replace with regular expression&nbsp;with the following regex.<pre class="ql-syntax" spellcheck="false">Multi line comment: /\*(\*)?(((?!\*/)[\s\S])+)?\*/
Single line comment: //.*$
</pre>And replace them with empty and we are good to go.If you also got some more tricks down your sleeves feel free to comment.

If you are habitual of writing a formatted code don’t worry it’s a good habit but when sometimes you get to debug files which are not formatted what so ever. In that case, it’s a headache to get things done in that sort of files.

How to format file in PhpStorm

Making an application live majorly depends on the type of hosting you are having along with the method to access you are provided for that hosting.I am assuming that you have shared hosting with Cpanel.Please go through the below steps to make your PHP application live.<h2>Steps:</h2><ul><li>Make a .zip file of your application</li><li>Login into your server (live server with the credentials you are provided by the hosting vendor)</li><li>Once you got into the panel, find file manager.</li><li>Inside file manager search for public_html (this is the base directory, like htdocs in XAMPP)</li><li>Upload your .zip file in public_html</li><li>Extract it in here.</li></ul>Your code files are live now.<h2>Creating a Database</h2>If your application is static then the above steps should be enough for making it live but if you have a database in action then you also have to create and connect a database too, to the application.Below are the steps to create a DB in cPanel<ul><li>Search for MySQL database wizard</li><li>Name your database</li><li>Create a user, password, and privileges</li></ul>Connect your Database to your application through config or how so ever you have designed to it.For any concerns and doubts feel free to ask in comment section.

Making an application live majorly depends on the type of hosting you are having along with the method to access you are provided for that hosting.

Steps to make your php application live in cPanel (shared hosting)

Steps to make your PHP application live in Cpanel (shared hosting)

As you may know according to the default configuration of CakePHP the debug and error log is generated in the same file. But this can be changed in a few simple steps. All you have to do is following.<ol><li>Got to config/app.php</li><li>Find the ‘Log’ configuration array</li><li>In both debug and error replace the ‘file’ with “’debug-‘ .&nbsp;date(‘Y-m-d’),” and “’error-‘ . date(‘Y-m-d’),” respectively</li><li>Save the file and you are good to go.</li></ol>Now, the log will be generated on a daily basis.

As you may know according to the default configuration of CakePHP the debug and error log is generated in the same file. But this can be changed in a few simple steps

How to make log daily in CakePHP 3.x

Although the development has taken a great deal of up-gradation in the last few years with DevOps, frameworks, automation etc. etc. etc. but still there are a number of people who still prefer the old way. Moreover, if you are starting new of just creating a college project or something like that it’s still cool to use the core PHP.The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them. Below is the function you can use for the same. It’s simple, straight forward and easy to use.<h2>Benefits:</h2><ul><li>It reduces the threat of SQL injection by removing the SQL (if there is any)</li><li>It also removes the HTML tags from the data passed as some bad guys pass &lt;scripts&gt; too for some undesirable works.</li></ul><h2>Uses:</h2>Using the function is simple all you have to do is make sure that it needs&nbsp;mysql_connection&nbsp;links to function. Please make sure you provide it. Remaining is nothing to worry about.<h2>Function:</h2><pre class="ql-syntax" spellcheck="false">/**
 * protecting the input form the SQL injection and script injection.
 * @param $data
 * @return mixed
 */
public function sanitizer ($data)
{
 if (!empty($data)) {
 foreach ($data as $key =&gt; $dataValue) {
 if (empty($dataValue)) {
 continue;
 }
 $dataValue = strip_tags($dataValue);
 $data[$key] = mysql_real_escape_string($dataValue, $this-&gt;link);
 }
 }

 return $data;
}
</pre><h2>Function Call:</h2><pre class="ql-syntax" spellcheck="false">$object = new Class();
$sanitizedGetArray = $object-&gt;sanitizer($_GET);
$sanitizedPostArray = $object-&gt;sanitizer($_POST);
</pre>If you have some other things to add to this function feel free to comment, I am still learning too you know.

The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them

How to sanitize Input in PHP  - Code By Samgan

How to Sanitize Input in PHP

Although the authentication component of CakePHP 3 has made the life of a developer much easier but still there are some functionalities that are still needed to be done manually. One of them is login automatically if the users have checked for ‘remember me’.To be frank auto login also known as cookie-based login is not that big deal. The real idea behind that is to make browser remember that user from a particular site has visited and if he comes back please don't ask him/her to log in again.By so far you must have understood that we are going to use cookies to implement the logic. So, without wasting any time lets get started<h2>Step 1.</h2>Add cookie component to the system. You may have noticed the best place to add a component is in the&nbsp;appController.php&nbsp;initialize action as the request handler and flash are also included there.You can add the following line to add the cookie component.<pre class="ql-syntax" spellcheck="false">$this-&gt;loadComponent('Cookie');
</pre><h2>Step 2.</h2>Now since we have cookies support with us, we can proceed further.Now we have to make a remember me checkbox on the login page so that we can check if the user is willing to be remembered by the browser.You can do it easily by just adding an input with type=”checkbox”. For this article name of the checkbox is “remember”<pre class="ql-syntax" spellcheck="false">&lt;input class="form-control" type="checkbox" name="remember"&gt; Remember Me
</pre><h2>Step 3.</h2>Now we are all set for the main functionality.Now if the user’s checks “remember me” we are going to add a secret hash in the cookies and the same hash will be assigned to the login user for future identification. To do that we only need 1 thing a “secret hash”. This can be done with the help “Security” utility.Add the following line to&nbsp;appController.php<pre class="ql-syntax" spellcheck="false">use Cake\Utility\Security;
</pre>Now create a function in app controller which will return a secret and unique hash.<pre class="ql-syntax" spellcheck="false">function _hashGenerator()
{
 return Security::hash(rand());
}
</pre>Congratulations! We have hash now.<h2>Step 4.</h2>Things from here are simple from here. Below is the pseudo code for the same.<ul><li>Check if the remember is checked</li><li>if checked then set a variable remember and unset the check form the request as it will create a problem in the auth identify.</li><li>Once the user is identified and remember is set then set the auto login. (function is mentioned below).</li><li>In setting autoLogin</li><li class="ql-indent-1">generate a hash</li><li class="ql-indent-1">assign&nbsp;same&nbsp;hash to login user</li><li class="ql-indent-1">set the same hash in cookies.</li></ul>The function to implement the above pseudo code is mentioned below (to be written in&nbsp;usersController.php)<pre class="ql-syntax" spellcheck="false">if ($user = $this-&gt;Auth-&gt;identify()) {
 if ($remember) {
 $this-&gt;_setAutoLogin($user['id']);
 }
...
function _setAutoLogin($id=null)
{
 $hash = $this-&gt;_hashGenerator();
 $this-&gt;Cookie-&gt;config([
 'expires' =&gt; '+30 days',
 'httpOnly' =&gt; true
 ]);
 $this-&gt;Cookie-&gt;write('connects', $hash);
 $user = $this-&gt;Users-&gt;get($id);
 $user-&gt;hash = $hash;
 if ($this-&gt;Users-&gt;save($user)) {
 return true;
 } else {
 return false;
 }
}
</pre><h2>Step 5.</h2>All set we are done now. All we have to do is add the below line at the start of the login function in&nbsp;usersController.php.<pre class="ql-syntax" spellcheck="false">$this-&gt;_autoLogin();
</pre>and add the below function to&nbsp;usersController.php<pre class="ql-syntax" spellcheck="false">function _autoLogin()
{
 if ($this-&gt;Cookie-&gt;read('connects')) {
 $user = $this-&gt;Users-&gt;findByHash($this-&gt;Cookie-&gt;read('connects'))-&gt;first()-&gt;toArray();
 $this-&gt;_setAutoLogin($user['id']);
 $this-&gt;Auth-&gt;setUser($user);
 
 return $this-&gt;redirect(['controller' =&gt; 'pages', 'action' =&gt; 'home']);
 } else {
 return false;
 }
}
</pre>See, it was that simple. If you any query or suggestion regarding the issue feel free to comment.

Although the authentication component of CakePHP 3 has made the life of a developer much easier but still there are some functionalities that are still needed to be done manually. One of them is login automatically if the users have checked for 'remember me'.