Home
Software Developers
Electronic Designers
AI Integration
Product Design

☰

Home
Software Developers
Electronic Designers
AI Integration
Product Design
FAQ
About Us
Contact Us
Portfolio
Resources

Cloud Development

Our resources for other developers, designers and engineers.

Cloud Development

Category: Queries

/MySQL / Queries /

DELETE(1)
INSERT(4)
SELECT(19)
UPDATE(11)
WHERE(2)
Working on live databases(1)

open all | close all

Special characters and translations

Digital Markets Act (EU)

.Digital Markets Act Overview

Digital Services Act (EU)

.Digital Services Act Overview

Online Harms Bill (UK)

.Online Harms Bill Overview

Visual Studio Code

SFTP by Natizyskunk

.1 Set up VS Code for web development

.2 Create new VS Code web project

.Providers / Web Platforms

AWS (Amazon Web Services)

Elastic Beanstalk

RDS With Elastic Beanstalk

PHP Applications

cron scheduled tasks

FTP into an Elastic Beanstalk environment

php.ini making changes

Set Up A PHP Environment

.Elastic Beanstalk Basics

RDS-Relational Database Service

.Create New Aurora RDS

Aurora vs MySQL

Backup of databases

RDS With Elastic Beanstalk

Creating a S3 bucket

Delete S3 File/Object

Download S3 File/Object

List S3 Objects

Upload A File From A Form

Upload A Server File

Read users country code

Using Cloudflare Turnstile (Implicit form)

Google Analytics

Using Google Analytics without requiring EU cookie law consent

Using Free Google Maps

reCAPTCHA Control Panel

reCAPTCHA see here

Server performance monitoring tools

Debugging Pages

Adding a .css stylesheet (default stylesheet)

Adding styles within an html File

Class and ID names

CSS Combinators

Nested CSS identifiers

Multi / single column depending on screen size

Adding a .css stylesheet (default stylesheet)

Classes Of Things

Creating A Page On A Background

Hide Items Using CSS

Positioning An Image

Rows Of DIV Boxes

Show Div Border

Special Site Message

Horizontal Align

Rows Of DIV Boxes

Spininng circle

Background Colour

Background Images

Background Linear Colour Transitions

Multiple background images

Border as seperator

iPhone zooms page content

Button auto size

Button from css (turn link into a button)

.Columns general

Include css file in another css file

Paths to images etc

Center aligned items flexbox

Center aligned items flexbox

Fill remaining width

Force footer to always be at the bottom of the screen

.Form css basics

Safari on iPhone zooms screen in

Hide and unhide an element

.Images General

Background image

Lazy loading images

Circled numbers list

.Margin general

Pixels and percent Calculations

Override Styles

Hide and unhide an element

Overriding Styles

.Padding general

Absolute positioning

Responsive menu – Simple using only CSS

Screen Resolution

Stopping zooming to desktop page

Combined values

Text Containers

iPhone zooms page content

Cursor / Mouse Pointer

Rollover buttons

DNS for email send

Troubleshooting

Sending email test tools

DNS for email send

Email and Cloudflare

.DEFAULT .htaccess FILE TO USE

Redirect to new domain

Redirect wordpress pages

Security htaccess rules to include

Title, description etc

Username and password in URL’s

File download from a string

.Typical form example

Simple Site Log In Form

File upload forms

Safari on iPhone zooms screen in

Auto submit on reCAPTCHA verify

Disabling the reCAPTCHA badge in the bottom right of every screen

Validate reCAPTCHA response in PHP

Auto select element when page loads

Date input fields

Emulate a form submit in php code

Refresh after form POST

iOS home screen icon

Images for social media posts

Lazy loading images

Rollover / Hover Pop Up Text

Username and password in URL’s

Multiple Column Lists

Simple Pop Up Window

Raw HTML data over the wire

POST-application/x-www-form-urlencoded

POST-multipart/form-data

Logo's and Images

Indicating organisation logo for use in search results

HTML Quick Reference

iOS home screen icon

Safari on iPhone zooms screen in

Columns Data Types

DateTime general

TEXT or VARCHAR

Connect To Database

Functions using database connection

DateTime CREATE TABLE

DateTime general

DateTime INSERT UPDATE

DateTime SELECT

Event Logging Table

HTML Forms Update Database

Lock row for modifying

Text field used to store limited number of old events

Universal Settings Table

Importing MySQL Table From An Uploaded CSV File

PHP4 Connect To Database

PHP4 .SELECT General

PHP7 updating old database code

Searching An Entire Database

.DELETE General

.INSERT General

DateTime INSERT UPDATE

INSERT or UPDATE ON DUPLICATE

Null row setting

.SELECT General

Case Sensitivity

Count – Get number of results

DateTime general

DateTime SELECT

IN – is value IN a list of values

Is A Name Taken

JOIN to get results from 2 tables

LIKE to search within text fields

Manipulating Returned Results

Maths based results

Querying Across Tables

Ternary Operator if( , , )

.UPDATE general

DateTime INSERT UPDATE

INSERT or UPDATE ON DUPLICATE

Null row setting

Random value per row

Ternary Operator if( , , )

Toggle boolean value

Update From Row + Value Array

Working on live databases

Create Random Value Within A Query

mysqli_real_escape_string

Prepared statements

Columns Data Types

TEXT or VARCHAR

Debugging Arrays

Strange Errors Checklist

Useful Debugging Examples

Differences To C and C++

PHP Server General

.API’s general

Getting posted data

See curl for POST, GET, etc examples

Bitwise Operators

Bitwise Operators

State ? ( ) : ( ) Ternary Operator

.CanvasJS Geenral

Create a new class

Global members of a class

Inheritance of a class

Creating a cron job

CURL GET Request

Curl POST Request

Convert DateTime Formats

Convert seconds to

Days until / Days Ago

Time since last seen

Time Difference

Email and Cloudflare

Email never arrives

Base64 Encoding

Adding Message To PHP Error Log

Throw an exception

Try Catch error handling

Bitwise Operators

Creating Debug Output File

Does File Exist

Importing MySQL Table From An Uploaded CSV File

Running scripts and executibles

Working with directories

Working with files

Checking form input

File upload forms

File Upload Troubleshooting

POST File uploads

.API’s general

Converting Form Text Fields

Getting Form Values

Getting posted data

Refil Form Values

Simple Site Log In Form

.Functions General

Assign value in an if statement

Functions using references/pointers

If function exists

Returning Multiple Values

If, Comparison, etc

? True False Test

Assign value in an if statement

.Include General

Detecting Name Of Page Include A File

Referencing Site Root

Dynamic json file

json data examples

json decode-convert to PHP array

Get a users latitude and longitude

HTML friendly loops

Positive / negative

Power of (Exponentiation)

Rounding values

Array Of SQL Results

Comma Separated Strings

Converting Arrays

Create Array From

Debugging Arrays

Key => Value Arrays

Manipulating Arrays

Multidimensional arrays

References (pointers)

.References general

Functions using references/pointers

Built In Superglobal Variables

Converting Values in PHP

Global Variables & Defines

Variable Functions

.Namespace general

Plugin namespace

Other Web Sites

Reading content from other web pages

Blank page until its loaded

Close Browser Window

Do not cache page

Get Page URI / URL

Getting URL Arguments

Redirect and Reload

Return HTTP response before continuing

URL, URI and URN

Pinging from a web page

QRCode.js generate QR codes in browser

Generate random string

openssl_random_pseudo_bytes

Regex Regular Expressions

Remove common words

Using regex in PHP

PHP Password Hash Function

Sanitising & encoding strings

Simple Site Log In Form

$_SESSION General

$_SESSION security

.PhpSpreadsheet basics

Installing PhpSpreadsheet

.Using Strings-Basics

Comma Separated Strings

Compare Strings

Convert Strings

Convert Strings to Array

Converting Form Text Fields

Import file into a string

Limit string length

Remove Characters

Remove common words

Sanitising & encoding strings

Special Characters In Strings

Using Strings-Characters

Using Strings-Extracting

Using Strings-Formatting

Using Strings-Parsing

Using Strings-Replace and Insert

Using Strings-Searching Strings

Using Strings-Values

Using Strings-Verifying Strings

Execute a php file in the background

Manually trigger cron

Prevent PHP function being run on different threads

Return HTTP response before continuing

Integrating Twitter

Detecting Name Of Page Include A File

Getting Site URL

Getting URL Arguments

Convert from XML

Servers-Hosting

Apache Config (new server setup)

SQL Server (Microsoft)

Good SQL Coding Resources

2.OVERVIEW AND ADMIN

Backing Up SQL Server

Installing, Monitoring, Updating & Removing SQL Server

Overview and Editions

SQL Server Express Edition

Troubleshooting SQL Server

3.DATABASE DESIGN

Auto Incrementing Value

Columns (Fields)

Increase the size of a nvarchar column

General Delete Statements

General Insert Statements

Get AutoIncrement Value For A New Record

Reading Results

Checking For Null Values

DateTime in SELECT queries

General Select Statements

Parameters In Queries

Sanitizing Queries

TOP (LIMIT in mySql)

Statements General

Does Table Exist

Specifying Values In Statements

General Update Statements

Parameters In Queries

Sanitizing Queries

.Actions general

Archive page actions

Page content actions

Post & Page content actions

Useful actions – In page

Useful hooks – High level

wp-admin block users from accessing

Creating admin UI elements

Create an admin page

Tabbed admin page

Admin top toolbar

Display admin area warning if plugin not active

Number of posts, pages etc shown

Remove WordPress top black bar

Styling admin view

wp-admin block users from accessing

AJAX Background Post

AJAX Background Post and Get Response

AJAX Background Refresh Status From Server

AJAX Dynamic Page Content

Creating an API URL

Nonce Functions

Override Avatar

Disable Page Caching

Comments Display

Leave a comment form display

Turn Off Commenting

Cron scheduled tasks

5 min cron with catchup if not called every 5 mins

.WordPress Cron General

Creating cron function

Manually trigger cron

System triggered WP-Cron

Built in DB functions

DB table list of providers

INSERT or UPDATE

Creating Custom Tables

Other Databases

User Meta data storage

WordPress Database

Time difference

Debugging Wordpress

Debug Bar plugin

Plugin could not be activated because it triggered a fatal error

Cannot send session cookie – headers already sent by…

template_redirect etc not called

Debugging checklist/tips

Is define active?

WordPress simple checks

Adding Arguments Before The Loop Starts

Posts Based On Date

Adding Buttons To The HTML Editor

Using WordPress Dev Javascript

Does email exist

Email and Cloudflare

Email never arrives

Validate email address

WordPress user email addresses

Adding Custom Endpoints

File download from a string

Uploads Directory

WordPress Paths

Working with directories

Creating a filter call

Receiving a filter call

Adding Custom Endpoints

Nonce Functions

Including other files

WordPress hooks

Issues and errors

Uncaught ReferenceError: jQuery is not defined

Javascript in WordPress

Where are Polylang translations stored

Copy translations to another website

Where are WPML translations stored

.Translation functions

Translation Software & Plugins

Using tokens, keys, etc

WordPress Paths

Keep Users Logged In

Plugin namespace

.WordPress nonces general

Nonce Functions

Adding Custom Endpoints

Creating an API URL

Redirect to page

Redirect WordPress default pages

WordPress install sub folder

Generate Multipage PDF from Single Canvas of HTML

Generate multipage PDF of text

.Plugin API General

Adding Custom Endpoints

Useful hooks – High level

Create Your Own Plugin

Plugin update database

.Plugin updating general

YahnisElsts plugin-update-checker

.Create New Plugin

Distribute Your Plugin

Plugin namespace

Resources For Plugin Creation

Deactivate plugin

Display admin area warning if plugin not active

Plugin release checlist

Sanitising Functions

WordPress search

$_SESSION in wordpress

Keep Users Logged In

Sessions In WordPress

.Shortcodes General

Blank shortcode output

Sharing values between shortcodes

Using shortcodes inside a shortcode

WordPress install sub folder

WordPress site info

Remove WordPress top black bar

Styling admin view

Update child theme

YahnisElsts plugin-update-checker

.Create A Child Theme

Add your own footer into footer.php

Add your own header into header.php

Add your own sidebar content

Using Google Fonts

Template Themes

Execute a php file in the background

Access User Info

Keep Users Logged In

User Meta data storage

User Registration

wp-admin block users from accessing

Other IBEX Resource Sites

Home | Terms & Conditions | Privacy Policy

© Copyright IBEX Technology Ltd. All rights reserved. IBEX is a registered trademark of IBEX Technology Ltd.