Code Snippets

PDO database connection

Basic Connection

<?php                                    

//This is a standard PDO connection script that you just change the connection variable details to your own.

// Connection variables
$DB_HOST  = "localhost";
$DB_LOGIN = "root";
$DB_PASS  = "password";
$DB_NAME  = "databaseName"; // Replace with your actual database name
$charset  = "utf8mb4";

// Connection string
$dsn = "mysql:host=$DB_HOST;dbname=$DB_NAME;charset=$charset";

try {
    // Create a PDO instance
    $pdo = new PDO($dsn, $DB_LOGIN, $DB_PASS);

    // Optional: You can echo a message to confirm the connection
    echo "<hr><p>Connected to the ".$DB_NAME." database</p>";

    // Perform other operations with the $pdo instance as needed

} catch (PDOException $e) {
    // Handle connection errors
    die("Connection Failed: " . $e->getMessage());
}

?>

PDO Assoc Arrays Connection

<?php                                    
                                    
    //This script may cause issues with the options. If things are not working as expected, then comment out the 2nd option,
    // \PDO::ATTR_DEFAULT_FETCH_MODE and try testing your project again.
    
    //Some like to put the variables into a separate file then require them into this connection file.
    $DB_HOST  = "localhost";
    $DB_LOGIN = "root";
    $DB_PASS  = "password";
    $DB_NAME  = "databaseName";
    $charset  = "utf8mb4";
    
    //Connection Script
    $options = [
        \PDO::ATTR_ERRMODE            => \PDO::ERRMODE_EXCEPTION,
        \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
        \PDO::ATTR_EMULATE_PREPARES   => false,
    ];
    
    $dsn = "";
    
    try{
    
        $dsn = "mysql:host=$DB_HOST;dbname=$DB_NAME;charset=$charset";
    
        $pdo = new PDO($dsn, $DB_LOGIN, $DB_PASS, $options);
    
        $connected = "<hr><p>Connected to the ".$DB_NAME." database</p>";
        echo $connected; //Echo this var, and the line above, out of your code when in production. This is only to demonstrate the connection whilst testing.
    
    } catch (PDOException $e){
    
        die ("Connection Failed: ".$e->getMessage());
    
    }

?>

MySQLi
database connection

<?php                                    

// This is a standard MySQLi connection script.
// Change the connection variable details to your own.

// Connection variables
$host = "localhost";
$username = "root";
$password = "password";
$database = "databaseName"; // Replace with your actual database name

// Create a MySQLi connection
$conn = new mysqli($host, $username, $password, $database);

// Check the connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Optional: You can echo a message to confirm the connection
echo "<hr><p>Connected to the ".$database." database</p>";
########### Just remember to remove it before you put it online #########

// Perform other operations with the $conn instance as needed

// Close the connection
$conn->close();


?>

Arrays Loops

Php Loops

For Loop While Loop

DoWhile Loop Foreach Loop

Foreach Loop Keys & Values

For Loop

<?php                                    

// Basic PHP for loop that counts from 1 to 10 with line break for each number

for ($i = 1; $i <= 10; $i++) {
    echo htmlentities("$i = $i;") . htmlentities("<br>");
}

?>

While Loop

<?php                                    

// Basic PHP while loop that counts from 1 to 10 without line breaks

$counter = 1;
while ($counter <= 10) {
    echo "$counter = $counter;";
    $counter++;
}

?>

DoWhile Loop

<?php                                    

// Basic PHP do-while loop that counts from 1 to 10 without line breaks

$counter = 1;
do {
    echo "$counter = $counter;";
    $counter++;
} while ($counter <= 10);

?>

Foreach Loop

<?php                                    

// Basic PHP foreach loop that iterates over an array and prints values

$colors = array("red", "green", "blue");

foreach ($colors as $color) {
    echo $color;
}

?>

Foreach Loop
with keys & values

<?php                                    

// PHP foreach loop with keys and values

$colors = array("red" => "#FF0000", "green" => "#00FF00", "blue" => "#0000FF");

foreach ($colors as $colorName => $hexCode) {
    echo "Color: " . $colorName . ", Hex Code: " . $hexCode . "<br>";
}

?>

Array

<?php                                    

// Basic PHP array example
$colors = array("red", "green", "blue");
foreach ($colors as $color) {
    echo "Color: " . $color;
}

?>

Associative Array

<?php                                    

// Basic PHP associative array example
$userInfo = array(
    "name" => "John Francis",
    "age" => 22,
    "city" => "New York"
    
    "name" => "Anna Carpenter",
    "age" => 30,
    "city" => "Chicago"
);

foreach ($userInfo as $key => $value) {
    echo $key . ": " . $value;
}


?>

Javascript with Ajax

                                    
//This JS script along with the Ajax script below, controls the dropdown list in the Random Components section on this page.

$(document).ready(function () {   
    // Attach the submitForm function to the click event of the submit button   
    $("#submitBtn").on("click", function () {      
        var formData = $("#myForm").serialize();      
        // Add dropdownId to the form data      
        formData += "&dropdownId=dropdown1";      
        $.ajax({         
            type: "POST",         
            url: "ajax_handler.php",         
            data: formData,         
            success: function (response) {            
                // Clear existing content before appending new content            
                $("#resultContainer1").empty().html(response).show();   
                
                // Reset the form            
                $("#yourForm")[0].reset();            
                // Hide the message after 8000 milliseconds (8 seconds)            
                setTimeout(function () {               
                    $("#resultContainer1").hide();            
                }, 8000);         
            },         
            error: function () {            
                // Display error message            
                $("#resultContainer1").empty().html("You need to make a selection.").show();         
            }      
        });   
    });   
    // Attach the submitForm function to the change event of the dropdown   
    $("#programming").on("change", function () {      
        // Trigger the form submission when a selection is made      
        $("#submitBtn").click();   
    });   
    // Trigger the form submission after the page has fully loaded   
    $(window).on("load", function () {      
        // Hide the error message initially      
        $("#resultContainer1").hide();   
    });
});

Ajax


    //This is part of the JS script above in the Javascript section so you only need copy that.
   
      $.ajax({
         type: "POST",
         url: "ajax_handler.php",
         data: formData,
         success: function (response) {
            // Clear existing content before appending new content
            $("#resultContainer1").empty().html(response).show();
            

            // Reset the form
            $("#myForm")[0].reset();

            // Hide the message after 8000 milliseconds (8 seconds)
            setTimeout(function () {
               $("#resultContainer1").hide();
            }, 8000);
         },
         error: function () {
            // Display error message
            $("#resultContainer1").empty().html("<p class='text-danger'>You need to make a selection.</p>").show();
         }
      });
   });

   // Attach the submitForm function to the change event of the dropdown
   $("#programming").on("change", function () {
      // Hide the success message
      $("#resultContainer1").hide();
   });

Projects

🚧 Under Construction 🚧

Introduction

Building this site is a hobby that in my spare time I have built using Bootstrap, php, javascript, html, css, JQuery and several other technologies.

The site is a work in progress and over time will develop. Currently there are the pages on the basic site, home, projects, about and contact, as layout in the navigation bar

Once registered and verified there is additional content to view such as a dashboard where you will have access to all the information you have registered with and should you need to change any of that information you can do it from the dashboard which you will need to be logged in for to gain access.

Some time ago I put a cookbook together just to demonstrate what was possible. The recipes are all from other sites and you can link to the source in the project.

All the projects as I complete them will be available via links below.

The accordion on the left if viewing on larrger screens or underneath on smaller screens has code snippets that can be copied and pasted for you to use with 1 click.

Coming Soon to the site

Projects

See the latest projects coming to the site.

Take me there!

dashby.co.uk

Project Name	Desc	Link
Web Elements	Web	Link
I.T. Links	I.T. info	Link
Cookbook	Recipes	Link
To view any of these projects, just click on the corresponding link in the Link column, and you'll be taken to that section.

Top of Page

Web Elements

In this section I have put together a number of components/examples that are useful when building a site. I have also included general information on the subjects listed below.

Html

html boilerplate

Opposite is an image that if you click on it then you will see the basic html needed for a standard start to a page. A boilerplate is the barebones of your web page.

You just need to alter the path to your css file and if you have an icon that will show in the browser tab put that in your root directory and edit the path so it points to the file.

CSS

CSS Reset Rule

With CSS many start with their own version of the reset rule. Some just have the very basic rules. Some go to town and reset everything they will possibly be using.

Opposite is an image that gives you the basics of the reset rule but if you search google, many other search engines available, you will see many examples.

Top of Page

Bootstrap

Go to Bootstrap

Bootstrap Carousel

Bootstrap Carousel with images from unsplash.com

Top of Page

Bootstrap Cards

Cards

Bootstrap have several different types of cards and they can be tweaked to suit with a little mix and match thrown in.

Edit to Suit

You can play about with the margins and padding to suit your requirements as well as align the title centre or left or right.

Card title

As you will see if you view this on a mobile device the cards stack on top of each other and can obviously be used for many things.

Top of Page

Bootstrap Accordion

There is a working bootstrap accordion on this page here. The accordion has several useful Php and other scripts that you can just copy and paste and tailor to your needs.

Top of Page

Php

Php is a server side language......

PDO

PDO stands for PHP Data Objects. PDO is one of the two ways we have of using php to connect to a database and interact with it. The other way is MySQLi.

MySQLi

MySQLi. The i is for Improved. This is not to be confused with MySQL which has beed deprecated. This is also not to be confused with Mysql databases.

Mysql in this context is using php functions that were used in interacting with databases, such as ~~mysql_connect();~~

To see a MySQLi connection script Click Here

Top of Page

Database Interaction

The table below is displaying data from a database. The data itself is a collection of links to tutorials on that particular subject.

Subject	URL	Description
CSS code validation	Link	W3C tool to validate your CSS
html code validation	Link	W3C tool to validate your html markup
Markup visulisation and storage tool	Link	Codepen - Build, share, and learn JavaScript, CSS, and HTML with their online code editor. Discover web applications and hire talent from the world's largest community of ...
Save Code Snippets	Link	Pastebin - Store & share code in the cloud.
PHP Codechecker	Link	This free service performs a line-by-line analysis for common mistakes and errors in your PHP syntax and will not execute or save your code.
Colour Converter (Hex to RGB)	Link	Converts Hex values to RGB and RGBA
Browser Dimensions Live	Link	Advises you of your browser size live, as you change your browser dimensions it updates.
Jquery DataTables	Link	Using bootstrap css and the for the pagination this tutorial shows how to utilise JQuery DataTables.
Media Queries	Link	This video gives you a basic understanding of media queries. You can also visit https://www.freecodecamp.org/news/css-media-queries-breakpoints-media-types-standard-resolutions-and-more/
Media Queries	Link	Media Query CSS Tutorial ‐ Standard Resolutions, CSS Breakpoints, and Target Phone Sizes. https://www.freecodecamp.org/news/css-media-queries-breakpoints-media-types-standard-resolutions-and-more/
Colour Converter (RGB to Hex)	Link	Enter your RGB to convert to HEX.
Clean URL's	Link	The process to have clean URLs has evolved as with everything overtime. There may well be an easier process than this now, as this was posted in 2013.
PDO - Data Retrieval	Link	Basic scripts PDO
AI	Link	ChatGPT
PHP Closures - Anonymous Functions	Link	PHP Anonymous functions or closures as well as functions.
CSS Tricks (5 useful)	Link	Youtube - Useful tricks with CSS
Gradiant Generator	Link	CSS Gradiant generator
clip path maker	Link	Clip path maker
CSS Tricks (10 useful)	Link	Video showing 10 css tricks.
Site Testing	Link	Is your web page mobile friendly? Test it here. You can either direct to a live site or paste the code in, click go and the tool will give you feedback as to whether your site is mobile friendly.
Image Conversion	Link	Convert images, (jpg, jpeg, png) to icons .ico format.
Dropdown lists (dependant)	Link	This shows you how to setup a dependant dropdown system retrieving data from a database using PHP PDO.
Dropdown or Combo box	Link	Video tutorial Drop down VS Combo box VS List box. This explains exactly when to use what.
html/css/Javascript	Link	This tutorial goes through laying out and styling form elements with some Javascript for the error indicator on the form field.
Styled Radio Buttons	Link	This tutorial takes you through the html and css to style radio buttons for your form which look a lot better than the standard radio buttons.
Checkboxes	Link	This video tutorial takes you through the design of checkboxes. These look 100% better thanh the standard checkbox.
All form field types	Link	This is a 25minute tutorial that takes you through all the form field types you will use on your site.
Select elements	Link	How to syle select elements. Video tutorial.
Google Recaptcha V3	Link	This tutorial takes you through the whole process of utilising Google Recaptcha version 3 on your web forms.
iframe	Link	How To Make iframe's Responsive (YouTube Embeds, Google Maps etc.)
Cookies	Link	PHP Security: HttpOnly Cookies. Tutorial takes you through the process.
CSS Grid - Responsive	Link	This tutorial gives you the basics of setting up a grid layout.
html & Fireworks	Link	This tutorial, part 1/2, goes through designing a bespoke search image to use on a search form for your site, just to be different. The tutorial is focused on using Fireworks CS5, it is from 2012, obviously you can use a preferred graphics capable package. Part 2 is located at https://www.youtube.com/watch?v=mmo9co9Lz3E
PDO	Link	This is an introduction to PDO. This link will take you to the first of eight, a total of 9 with the introduction.
Responsive Navigation	Link	At the end of this tutorial you wil have a fully functionable navigation bar that is fully responsive just using html and css with grid and a splash of flex.
Left Sidebar	Link	Sidebar Navigation with profile picture.This tutorial takes you from scratch right through to a fisnished product where you have a great looking sidebar navigation menu with a profile picture above.
CSS & html	Link	This tutorial takes you through the coding that gives you a profile card at the end.
functions, closures, variables	Link	Variable, anonymous & arrow functions in PHP - Callable type & Callbacks - Full PHP Tutorial - PHP 8
Cookies Banner	Link	Creating a Cookie Banner (Part 1/2).
Cookies Banner	Link	Creating a Cookie Banner (Part 2/2)
Sessions	Link	A basic explanation and small demonstration of how sessions work.
Create table	Link	30: Create a MySQL Table in Database \| PHP Tutorial \| Learn PHP Programming \| PHP for Beginners.
Sanitize Filters	Link	PHP Manual goes through the filters available to sanitize the various data types.
Password hash and verify	Link	This tutorial goes through the old methods such as MD5 and how they are no longer secure. Password_hash and Password_verify are the latest methods.
Regex	Link	This site enables you to test your regular expressions out to see if they are valid.
regex key/options	Link	This site takes you through the symbols with explanations
html/javascript/php and more	Link	This website has a large number of tutorials for websites.
Delete & Update	Link	This quick tutorial shows goes through deleting records and then updating records.
Date/Time	Link	This page shows you the various parameters for date and time formats.
Date/Time Exmaples	Link	W3C have a number of examples of how to produce outputs of dates and times.
Date/Time Functions	Link	W3C give an extensive list of the various Date/Time functions within php.
Centering Vertically	Link	5 ways to center vertically
Html and CSS	Link	Customise a select menu item (drop down list).
Make a triangle with css	Link	How (and why) to use borders to make a CSS triangle (plus a scss mixin)
Which, Block, Inline & Inline-Block	Link	Block, Inline, and Inline-Block explained \| CSS Tutorial
Database	Link	How to Order Alphabetically in SQL.
Database	Link	Introduction to MySQL DISTINCT clause.
url shortener	Link	A free tool to shorten url's.
Pagination	Link	This tutorial goes through the process of setting up pagination from scratch.
Sanitize, Validate and Escape Data	Link	Good Practices: how to sanitize, validate and escape in PHP [3 methods]
Attacks on Software Applications	Link	Looking at the various types of attacks on software applications
Code Checker	Link	This tool will chack your query syntax. lower down the page there are a number of links to check other types of code such as html5, php and a regular expression tester.
Ajax, MySqli	Link	How to Auto populate dropdown with jQuery AJAX. The author provides you with the sql files to import into your database and apart from changing a couple of details in the connection file it works as expected.
TCP / UDP	Link	TCPView is a Windows program that will show you detailed listings of all TCP and UDP endpoints on your system, including the local and remote addresses and state of TCP connections.
Responsive Web Design	Link	Build fast, responsive sites with Bootstrap.
Object Oriented Programming	Link	There are 18 videos in this one subject.
CSS Grid	Link	Hints and tips on using grid.
preg_match	Link	Check your regular expressions on this site.
.htaccess	Link	Some webhosts provide basic SSL Certificates and this is one of the ways to install them on your site so that visitors do not see a warning in their browser that the site is unsecure.
Hard Refresh on Phone	Link	This article takes you through the steps to clear the cache from your mobile device so it will do a hard refresh.
Image Compression	Link	If you have a large amount of images to display on your page then it is worth optimizing them, so they load faster, on the page.
Command Window	Link	This will show you the required dos commands to change the path. There is a full MS-DOS Help section to look through.
Web Tech Check	Link	This site enables you to check on support for technology on the web. If you enter CSS Grid into the search field it will show you how much support this technology has with all the browsers.
HTML	Link	Validate your html code with W3C
CSS	Link	Validate your css code with W3C
Sitemap	Link	Once you have registered you will be taken to another page for you to submit your page, xml file or html file, and then Google will confirm if everything ok.
Test Site Responsiveness	Link	Test the responsiveness of your site on a variety of devices.
Input Security	Link	Get a better understanding of, and preventing XSS attacks, Google has built an XSS game website for learning how these attacks work and how to better prevent them.
Form Security	Link	What is an XSS attack, how its done and suggested ways to prevent it happening to you.
Responsive Presentation	Link	The Responsive Website Font Size Guidelines.
Website Attacks	Link	10 Most Common Website Security Attacks
Scan Site	Link	Free Tools to Scan Website Security Vulnerabilities & Malware
Protect Forms (CSRF Security)	Link	How to Protect Forms with CSRF Tokens in PHP
Javascript	Link	Show/Hide a Form on button click using JavaScript
Joins	Link	Bad Habits to Kick : Using old-style JOINs
Session Variables	Link	Session Variables: How much data is too much?
Destroy & Unset	Link	Destroy only one session php
Box-Shadows	Link	Beautiful CSS box-shadow examples
SQL Injection	Link	PHP PDO Prepared Statements Tutorial to Prevent SQL Injection
if, elseif and else with operators	Link	If, Else if, Else in PHP Learn how to write if statements in PHP in this tutorial. It also includes a video for those who prefer to get things explained.
Sessions	Link	How do you set up use HttpOnly cookies in PHP - Stack Overflow
Regenerate Session Id	Link	regenerate session id php - CodeGrepper
Google Drive	Link	Google Drive Support Page
Skype For Web	Link	Communicate through your browser using Skype
Date and time formats	Link	PHP date_format() Function
Windows 10	Link	Ever try to remove/delete a file or program that the system says you can't because something else is using it. This is may solve the issue
Databases	Link	Restore databases to new/fresh installation of Xampp
Help Files	Link	Getting started with Visual Studio IDE
Help Files	Link	Getting Started
Error	Link	This error is due to permissions. See link for solution
Installation	Link	How to install PHP 8.2 on Windows 11
Windows	Link	How to find your licence key for windows 11
Disconnection	Link	How to safely disconnect a displayport cable
Broadband Speed Checker	Link	To test the upload and download speed of your connection
Cable management	Link	The two most popular cables for connecting gaming consoles and PCs to TVs and monitors are DisplayPort and HDMI. Which s best?
Checking Version .NET installed	Link	Three ways to check the version of .NET running on your PC
Beginners	Link	Tutorial using vVSCode creating 1st project using .NET
Change Sync Settings	Link	By default Windows 11 is set to sync your PC's. If you want to have a look and see what sesttings you want to change or just see where they are then this is the guide for you.
C#	Link	Due to changes that have been made within Visual Studio Code where when you create a new program, by default you only see the code within the braces, your code. If you are fine with that you can just enter dotnet new console. If you want to view the namespace and all the other system generated code then you will need to enter dotnet new console --use-program-main this will generate the full code starting with the namespace.
Remove	Link	How to use Remove, RemoveAt, RemoveRange methods in C# list collections?
Startup Menu	Link	The process of adding programs to the startup menu.
Batch Files	Link	How to create your basic batch file and then schedule it in the task scheduler.
Schedule Task Hourly	Link	This will show you how to schedule the task hourly as when you first setup the batch file the option for hourly is not listed.
Email Signature	Link	How to set up or change an Android email signature
phpMyAdmin configuration storage is not completely configured	Link	If you get this message in phpmyadmin, try this solution
PhpMyAdmin	Link	When your told inside PhpMyAdmin that you should update PhpMyAdmin itself in Xampp.
The phpMyAdmin configuration storage is not completely configured.	Link	This YouTube video is not in English but is well presented and easy to follow and solves a problem many seem to go round the houses to get the same result.
Frameworks	Link	This tutorial goes through the installation provcess of installing Laravel and the tools needed before you can install it. The audio in places is appalling but they demonstrate every step on screen, so it is easy to follow.
Errors	Link	If you run Xampp and you get this error which by research is quite common perhaps try these possible fixes.
Denied Access	Link	If like me you have been using PhpMyAdmin all morning and suddenly you get access denied, try this fix.
JQueryUI	Link	Once you have incorporated Datatables into your site you have the option of adding themes by utilising JQueryUI. This site shows you the developed themes. Just click on the gallery tab.
robots.txt	Link	Enter your domain in the form. They then crawl your site and provide you with a sitemap.xml file to save to your domain for search engines.
Toggle Form	Link	code and a demo on toggling a form
CRUD	Link	CREATE, READ, UPDATE and DELETE. Tutorial on developing a system of forms for admin purposes
CRUD	Link	PHP Ajax CRUD without page reload with Bootstrap Modal (Pop up box) using jQuery, PHP Ajax in 2022
SEO	Link	Download a free copy of their software and create an XML sitemap for SEO. The software is limited whilst you are using the free version.
Responsive Design	Link	Responsive Flexbox Layout
Google Docs	Link	How to change 1 or more pages from portrait to landscape in Google Docs
Responsive web design	Link	They say, The most advanced responsive front-end framework in the world.
Responsive web design	Link	UIkit is a lightweight and modular front-end framework for developing fast and powerful web interfaces.
Online Store	Link	Online store to purchase almost anything I.T. Related, normally reasonably priced.
Regular expressions	Link	PHP Regular Expressions Form Security and Validation from PhpBasics
Php	Link	All about Php right up until the latest version 8.3
Php	Link	11 Best PHP URL Shortener Scripts (Free and Premium)
Php	Link	How to create smart URLs using PHP
Php	Link	21 Useful PHP Snippets
Php	Link	13 Projects built using Php
Php	Link	20 Useful PHP Components
Php Frameworks	Link	12 top PHP frameworks for web developers to consider
Php	Link	Relative and absolute paths, in the file system and on the web server.
Html to PDF	Link	wkhtmltopdf and wkhtmltoimage are open source, LGPLv3, command line tools to render HTML into PDF and various image formats using the Qt WebKit rendering engine. These run entirely, headless, and do not require a display or display service.
Php	Link	Validating and verifying email addresses in PHP using abstract API
Cloud Key Management	Link	Cloud Key Management Service overview with Google
Libsodium security with encryption	Link	Libsodium, security with encryption
Security	Link	Encryption of data
Operating System	Link	To find the build and version of Windows OS
Broadband ISP	Link	Get true fibre optic broadband through Zzoom
Convert Video Files online	Link	On this site you can convert to various formats
Microsoft Windows 11	Link	How to set up God Mode in Windows 11 (and why you should) God Mode provides easy access to an array of settings from one single window. Here's how it works. The name of the folder you will create on your desktop is GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Tutorials	Link	This is a tutorial that guides you through the process of installing Composer and then Laravel.
A collection of links to tutorials. Use the search facility above to find many subjects

Top of Page

Tutorials & Other Links

Table with links to various I.T. Tutorials and other materials......

Author	Subject	Date	Number	URL	Notes
Dani Krossing	Php (Procedural)	2015	65	Link	Procedural MySQLi. Beginners to intermediate
Dani Krossing	HTML & CSS	2017	43	Link	Starts from a very basic level
Dani Krossing	PHP (OOP)	2019	19	Link	Object Oriented Programming - PHP
Dani Krossing	Javascript	2019	36	Link	From begginer to intermediate
Angela Delise	CSS Grid	2020	1	Link	This is an introduction to CSS Grid and gives you a good understanding of how CSS Grid works.
Dev Dreamer	CSS Grid	2020	1	Link	Starts by explaining what CSS Grid is
Dev Dreamer	Flexbox	2020	1	Link	Introduction to Flexbox
Php Basics (Shawn)	Joining Tables (MySQL/Php)	2018	1	Link	How to join two MySQL tables
Richard Stibbard	PDO	2017	9	Link	These tutorials take you from the basics to retrieviong data through queries to prepared statements.
Sunita Rai	Java - Bubble Sort	2021	1	Link	Bubble Sort Algorithm with Animation and Code
Php Basics (Shawn)	Php Relational DropDown Menus	2021	1	Link	Fetch data from MySQL to fill a dropdown list
Php Basics (Shawn)	MySQL - Show entire table	2020	1	Link	List the entire table on one page.
Coding Snow	Sidebar Menu Dashboard Template UI	2020	1	Link	Full Left Side Navigation including placeholder for profile image
The Digital Craft	CMS	2014	112	Link	Using MySQLi and Bootstrap
These are some of the links I have collected over the last few years. Each link will open a new tab..

subject	url
Php (Procedural)	Link
HTML & CSS	Link
PHP (OOP)	Link
Javascript	Link
CSS Grid	Link
CSS Grid	Link
Flexbox	Link
Joining Tables (MySQL/Php)	Link
PDO	Link
Java - Bubble Sort	Link
Php Relational DropDown Menus	Link
MySQL - Show entire table	Link
Sidebar Menu Dashboard Template UI	Link
CMS	Link
Each link will open a new tab.

Subject	Title	Published	# in Series	URL	Author
C#	C# (C Sharp)	2019	19	Link	Dani Krossing
CMS (Content Management System)	Developing a Dynamic CMS	2014	112	Link	The Digital Craft
CSS	CSS em and rem explained	2017	1	Link	Kevin Powell
CSS	CSS Units: vh, vw, vmin, vmax	2017	1	Link	Kevin Powell
CSS	CSS Positioning: Position absolute and relative explained	2018	1	Link	Kevin Powell
Flexbox	Flexbox for Beginners	2020	1	Link	Dev Dreamer
Flexbox	Flexbox Basics	2017	3	Link	Kevin Powell
HTML	HTML Tutorial for Beginners	2021	1	Link	Programming with Mosh
HTML & CSS	Sidebar Menu Dashboard Template UI \| Side Navigation Bar - Only Using CSS and HTML	2020	1	Link	Coding Snow
HTML & CSS	CSS Grid Tutorial [Complete Guide] - CSS Full Tutorial	2020	1	Link	Dev Dreamer
HTML & CSS	Responsive CSS Grid	2020	1	Link	Angela Delise
HTML & CSS	HTML & CSS for Beginners	2018	43	Link	Dani Krossing
HTML & CSS	CSS Grid Responsive Image Gallery	2020	1	Link	FollowAndrew
HTML & CSS	Insert Video into a Website Using HTML5	2016	1	Link	Geek Tutorials
Java	Bubble Sort (Java)	2021	1	Link	CS CORNER Sunita Rai
Javascript	Introduction to Javascript	2019	36	Link	Dani Krossing
Php	Populating Drop Down menus from Database	2018	1	Link	PhpBasics
Php	How to show the entire MySQL table with PHP	2020	1	Link	PhpBasics
Php	How To Create A OOP PHP Login System For Beginners	2021	1	Link	Dani Krossing
Php	TRICKS WITH FOR LOOPS	2018	1	Link	PhpBasics
Php	PHP Regular Expressions Form Security & Validation	2019	1	Link	PhpBasics
Php	OOP Php Tutorials	2021	19	Link	Dani Krossing
Php	Php (Procedural) Tutorials (65)	2015	65	Link	Dani Krossing
Php	Select from Drop-down list and display MySQL data on PHP page using AJAX query	2021	1	Link	Raj Bhise
Collection of tutorial links.

Subject	URL
Introduction to Course	Link
Lets Create Our First Project & Document	Link
Learn About HTML Elements & Attributes	Link
Learn to Create Titles & Text	Link
We Use Boxes in Websites	Link
How Do We Include CSS in our HTML	Link
How to Create HTML & CSS Comments	Link
Introduction to Classes & IDs in HTML	Link
CSS Text Syling	Link
How to Import New Fonts	Link
How to Create Sub Pages in HTML	Link
How to Create Links	Link
How to Create a Navigation Menu	Link
How to Create a Wrapper in HTML	Link
How to Insert Images	Link
How to Create HTML5 Videos and Embed Them	Link
How to Make a Responsive Site	Link
Create A Responsive Website - Part 1/2 - Project	Link
Create A Responsive Website - Part 2/2 - Project	Link
Outdated Code in html & css	Link
Flexbox Gallery Exercise	Link
Exercise Using Flexbox	Link
File Paths in html & css	Link
Forms	Link
Tables	Link
Are You Done Learning html & css?	Link
Which Meta Tags are Required in a Website	Link
How to Write Better html and css	Link
How to Easily Upload a Website	Link
How to Validate a Website \| Check it for Errors	Link
How to Create an XML Sitemap \| Register a Sitemap	Link
How to Create a 404 Page	Link
How to Remove the Page File Extension From the URL	Link
How to Use CSS Position to Move Elements	Link
How to Create Variables in CSS	Link
CSS Pseudo Elements & Classes	Link
Create Transitions Using CSS	Link
How to Create Website Layouts Using CSS Grid	Link
Add a Favicon to a Website	Link
How to Create an HTML Dropdown Menu	Link
How to Always Keep the Footer at the Bottom	Link
How to get started with html & css	Link
Create a Google Map in a Website	Link
Java - Bubble Sort	Link
How to get started with Javascript	Link
Which tools to use when developing Javascript	Link
How to install extensions for Javascript Development	Link
How to include Javascript in out html	Link
How to use the developer tool for Javascript	Link
Rules for writing Javascript Code	Link
How to create variables in Javascript	Link
Different types of operator in Javascript	Link
MySQL - Show the Entire Table	Link
Introduction	Link
PDO Connection	Link
Error Catching	Link
Query Method	Link
Fetch Method	Link
FetchAll Method	Link
Prepared Statements with Placeholders	Link
Prepared Statements with Named Parameters	Link
Insert, Update & Delete Records	Link
Introduction to OOP PHP	Link
What is the MVC Model?	Link
Create Classes in OOP Php	Link
Visibility & Inheritance in OOP Php	Link
Properties & Methods in OOP Php	Link
Constructors & Destructors in OOP Php	Link
Delete Objects in OOP Php	Link
Static Properties & Methods in OOP Php	Link
Load Classes Automatically in OOP Php	Link
Type Declarations in OOP Php	Link
First Exercise in OOP Php	Link
Intro to the course	Link
Setup Xampp	Link
Using Php Code	Link
Variables	Link
Commenting Code	Link
Built in Functions	Link
Data Types	Link
Arithmatic Operators	Link
Assignment Operators	Link
Comparison Operators	Link
Increment/Decrement Operators	Link
Logical Operators	Link
Conditional Statements	Link
Switch Statements	Link
Execrcise Using PHP - Calculator	Link
Execrcise Using PHP - Day of the Week	Link
Loops - While Loop	Link
Loops - Do While Loop	Link
Loops - For Loop	Link
Loops - Foreach Loop	Link
Arrays in PHP	Link
User Defined Function	Link
Include Documents	Link
Scope - Local & Global Scope	Link
SuperGlobals - $GLOBALS	Link
SuperGlobals - $_POST & $_GET	Link
SuperGlobals - Session & Cookies	Link
SuperGlobals - Setting a Session	Link
Create a MySQL Database Using Xampp	Link
Create a Table in your MySQL Database Using Xampp	Link
Insert Data into Database	Link
Select Data from a Database	Link
Update Data from a Database	Link
Delete Data from a Database	Link
Set Data Order from your MySQL Database	Link
Connect to the Database using Php	Link
How to Show Database Data on your Website	Link
Insert data from a website form into the database	Link
Protect Your Database Against SQL Injection	Link
What are Prepared Statements	Link
What are Error Handlers	Link
How to Display Error Messages using PHP	Link
Hashing & De-hasing Data Using PHP	Link
Building a Login System from scratch - MySQLi	Link
What are arrays used for in PHP	Link
Insert Data into an array	Link
Inserting Database Results into an Array	Link
Different Types of Arrays in PHP	Link
What is an Associative Array	Link
What are Multidimensional Arrays	Link
Uploading Images & files to a Directory	Link
How to Upload Profile Images to Users	Link
Delete Profile Image from Login System	Link
How to Delete Files From a Folder	Link
Delete More than one File or Image	Link
Search for Full File Name to Delete File	Link
How to Create a Search Field with Php & MySQLi	Link
How to Create A PHP Contact Form	Link
Functions Using Regular Expressions	Link
Search Patterns Using Regular Expressions	Link
How to Create a Unique String in PHP \| Generate a Key	Link
How to Remove the File Extension and Variables From the URL	Link
Create a PHP Gallery - Part 1/3	Link
Create a PHP Gallery - Part 2/3	Link
Create a PHP Gallery - Part 3/3	Link
PHP Relational DropDown Menus	Link
Additional tutorials.

Top of Page

Random Components

This dropdown list works by the user making a selection from the dropdown list the pressing the submit button. The feedback depends on if you make a selection then press submit or if you don't make a selection and submit an empty form.

The script can be tweaked so that it gives you feedback as soon as you make the selection which means there is no need for the submit button.

Dropdown List using Ajax

Buttons Animation with CSS

Here we have some buttons and with the bootstrap utility classes and some plain old css including animation you have yourself some smart looking buttons.

If you view this landscape or on a larger screen there is a short video of the animation.

Coming Soon!

Create Your Own To-Do Lists

As a registered user you will have access to additional materials.

In this case it is a todo application where you can create your own todo list and add items specific to that list. You list all the tasks/jobs you need to complete. When you have completed the task you hit the mark as done button and the task is marked off the list.

All you need to ensure this application works is a connection to the internet so it can update in front of you.

Here is a small demo of the application.

Coming Soon!

Create Your Own To-Do Lists

As a registered user you will have access to additional materials.

All you need to ensure this application works is a connection to the internet so it can update in front of you.

Here is a small demo of the application.

If you turn your mobile landscape there is a small demo of the application.

A Forum

Currently I am creating a forum that will have a variety of categories whilst also enabling the registered user to put a suggested category forward.

Whilst the forum will be available for all to view, only registered users will be able to post question and answers as well as make suggestions for categories and topics.

Top of Page

Ajax

Working with Ajax.....

Javascript

Working with Javascript.....

Top of Page

Images through unsplash.com

Photo by Dave Hoefler on Unsplash.

Images through unsplash.com

Photo by Nathan Anderson on Unsplash.

Images through unsplash.com

Photo by Yoksel ðŸŒ¿ Zok on Unsplash

Images through unsplash.com

Photo by Dave Hoefler on Unsplash.

Images through unsplash.com

Photo by Dave Hoefler on Unsplash.

Images through unsplash.com

Photo by Nathan Anderson on Unsplash.

Images through unsplash.com

Photo by Yoksel ðŸŒ¿ Zok on Unsplash

Images through unsplash.com

Photo by Dave Hoefler on Unsplash.

Scan this QR Code so you have this site on your mobile.

Session Timeout Warning!

Code Snippets

Php PDO Connection

PDO database connection

Basic Connection

PDO Assoc Arrays Connection

Php MySQLi Connection

MySQLidatabase connection

Php Scripts

Php Loops

For Loop

While Loop

DoWhile Loop

Foreach Loop

Foreach Loopwith keys & values

Array

Associative Array

Javascript

Javascript with Ajax

Ajax

Ajax

Projects

🚧 Under Construction 🚧

Introduction

Projects

Web Elements

Html

CSS

Bootstrap

Bootstrap Carousel

Bootstrap Carousel with images from unsplash.com

Bootstrap Cards

Cards

Edit to Suit

Card title

Bootstrap Accordion

Php

PDO

MySQLi

Database Interaction

Tutorials & Other Links

Random Components

Dropdown List using Ajax

Buttons Animation with CSS

Coming Soon!

Create Your Own To-Do Lists

Coming Soon!

Create Your Own To-Do Lists

A Forum

Ajax

Javascript

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

Images through unsplash.com

MySQLi
database connection

Foreach Loop
with keys & values