Skip to content
Home
Helium
What is a Helium Hotspot?
How to Install a Helium Hotspot
Helium Maps and Elevation Measuring
Helium Hotspot Cables and Connections
Port Forwarding – Helium Miner
Things to Consider when installing a Helium Miner
Helium Hotspot Antenna Gallery
Best Stablecoin Investing Websites
Crypto Blog
HotspotRF Referral code 2022
PHP
Php – Arrays
Php – Csv
Php – Dates & Time
Php – Email
Php – Loops
Php – Maths
Php – Miscellaneous
Php – Strings
Jquery
Jquery – Ajax
Jquery – Forms Posting
Jquery – Modals
Jquery – Strings
Jquery – Tricks
Jquery – Validation
Jquery – Variables
Jquery – Misc
MySQL
CSS
Javascript
WordPress
Admin – WP
WooCommerce
WordPress – Get
WordPress – Miscellaneous
WordPress – Show
Misc
Firefox
Python
Random Coding
Raspberry Pi
Reviews
SEO
SEO News
Sublime Text
Windows
Menu
Home
Helium
What is a Helium Hotspot?
How to Install a Helium Hotspot
Helium Maps and Elevation Measuring
Helium Hotspot Cables and Connections
Port Forwarding – Helium Miner
Things to Consider when installing a Helium Miner
Helium Hotspot Antenna Gallery
Best Stablecoin Investing Websites
Crypto Blog
HotspotRF Referral code 2022
PHP
Php – Arrays
Php – Csv
Php – Dates & Time
Php – Email
Php – Loops
Php – Maths
Php – Miscellaneous
Php – Strings
Jquery
Jquery – Ajax
Jquery – Forms Posting
Jquery – Modals
Jquery – Strings
Jquery – Tricks
Jquery – Validation
Jquery – Variables
Jquery – Misc
MySQL
CSS
Javascript
WordPress
Admin – WP
WooCommerce
WordPress – Get
WordPress – Miscellaneous
WordPress – Show
Misc
Firefox
Python
Random Coding
Raspberry Pi
Reviews
SEO
SEO News
Sublime Text
Windows
Search
Generic filters
Exact matches only
MySql
Appending data to a MySQL database field
Between statement
Build a mysql statement dynamically
Change port on Wamp to 8080
Check if you have a result from query
Concat – find duplicates
Connect to database code Mysqli
Count rows returned (mysqli) – results from database
Create database by PHP script & mysql
Create database with two tables – .sql file import
Current date in mysql curdate()
Current Timestamp – on update/insert
Data from 2 tables – 1 Mysql statement – operator
Data Types – Large Numbers – Decimal
Datediff – Find records where data > 24 hours old
DateTime format – search or delete – Wildcard
Delete by Time
Delete column with foreign key
Delete from multiple tables
Delete range of data from database with limit
Delete the oldest records first – MySql
Delete/drop database
Difference between inner and outer join
Display database contents in MSsql (Not mysql)
Display only first 50 characters of a mysql text field
Distinct (Unique) – Select statement
Distinct Sub Query – NOT IN
Drop Column
Drop Primary Key
Drop unique index
Drop, then Create, then Clone database
Dropdown from MySql Select Query – Select
Dual dropdown populate (both from database)
Dual dropdown populate (one from database)
Enable MYSQL Log
Find Birthday next 30 days MYSQL
Find duplicate values in MySQL database
Find Duplicates – delete duplicate and keep higher/lower one
Find Max(id)
Find text in multiple columns/fields – concat
Find the latest record added – Highest ID
Get last inserted ID (Laravel Database)
Get last query (Illuminate- Laravel)
Get one (1) result from MySQL query
Get records from both sides of inner join middle table
Get sum total and show one result
Get the ID of the last inserted record
Get Time from Database
Import csv to phpmyadmin
Import SQL file and Create Database using php
IN statement example with JOIN highest ID
Increase phpmyadmin import limit
Inner Join 2 tables to 3 tables -Add another table
Insert data into column
Inserted row – Show last row inserted by Mysql
Join – Complex query – Highest ID using left join
Join – Get data from two tables using one query
JSON encode mysql result
Laravel Database functions
Lock read/write MySQL tables to update
Manually set phpMyAdmin login cookie validity time
Move or Copy a table to a different database using MYSQL
Multiple MySQL databases on a single webpage
MySQL DATE_SUB Function – Date minus time
MySQL Errors – or die
Mysql Join – Basic example Data from two tables
Mysql Random record
MySQL result as first in PHP Select Dropdown
Mysql statement as variable (if – else)
Mysqli – Basic – Select 1 Record
Mysqli – Basic Delete Record
Mysqli – Basic Select Records Statement
Mysqli – Update Record
Mysqli Basic – ON DUPLICATE KEY UPDATE
Mysqli Basic Insert
Mysqli if record exists then update
Order by and limit
order by by two columns – Mysql
Order MYSQL results using a specific result first – Field
PDO – Basic connection and fetch
Percentage – Maths in Mysql Statement – Cast
Query – One of each colour, highest ID of each – ‘Group By’ and ‘Order By’
Random – Get Records Mysql Randomly 6 at a time
Re-number a column sequentially from 1 to ?
Search two tables with joins – complex query
Search using previous search data – MySQL
Select Database
Select Distinct (with other fields)- Group by
Select Mutiple Columns as one – Union
Select records where result in PHP array – MySql
Select records where X is in an array
Select Where NOT LIKE (does not contain) – MySQL query
Show all tables from database
Show odd or even rows only
Show rows affected by mysqli
Stop duplicate entry into database
Store slashes and quotes in database addslashes
SUM (total) a column
SUM and GROUP BY
Test Connection to database
Time search older/earlier than a date/time
Time update current date
Timeout settings in phpmyadmin change
Update database not Insert new
Update Date format in DB from Varchar to Date
Update Else Insert
Update then delete old record – Allow only 1 entry
Updating a Mysql column incrementally adding one each time
Upgrade Phpmyadmin using Wamp
WildCards
Only insert into table if item does not exist
10th December 2015
MySql
Make the row you want unique and then this code should do
$query = "INSERT IGNORE INTO blocks (pagename) VALUES ('$pagetitle')"; mysql_query($query) or die(mysql_error());
1
2
3
4
$
query
=
"INSERT IGNORE INTO blocks (pagename) VALUES ('$pagetitle')"
;
mysql_query
(
$
query
)
or
die
(
mysql_error
(
)
)
;
Was this code snippet helpful?
Yes
0
No
0
Exclude category from blog while adding them to sitemap.xml
What Router can I use with Onestream Broadband?
Firefox 113 (2023) Tabs on top/bottom not working fixed again
Disable buying – Woocommerce
Windows Desktop Wallpaper Background for OCD users with shelves
Featured Image Admin Thumb – Working Plugin (WordPress 6.2)
Create a gallery in a Posts page
Clickable elements too close together – Solved
Best ChatGPT Prompts
Make Elementor Accordion Closed by Default
noindex a specific page in WordPress using functions file
A random number picker that picks 6 numbers from 1 to 49 but only once
Sticky header – Logo smaller and adds border on scroll
Editor Only CSS – Elementor Sticky Header
Change Woocommerce Dropdowns to Radio Buttons
Get character count of a string saved in database – html_entity_decode not working
How to check if a checkbox has been ticked in Jquery
Firefox 89-100 (2022) Tabs on top/bottom not working fixed again
Slash canonicalization at the end of the URL – htaccess
Elementor json template files not uploading
Multiple featured images for blog posts
Autostart Browser in Kiosk Mode – Raspberry Pi 4 Terminal Command
Open Chromium full screen -Raspberry Pi (Kiosk mode)
Populate dropdown with data from database