Tag Archives: SQL

XML Public Data Genericization Attributes Tutorial

Posted on December 25, 2023 by admin

Where to with improving on yesterday’s XML Public Data Genericization Where Clause Tutorial, today? Well … we “dip our toes” into XML attributes in terms of … expressing them in a SELECT list (if you’ll pardon the SQL) … and … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged annotated timeline chart, annotation, attribute, calendar, calendar chaer, calendar widget, chart, clause, data, date, date picker, DDL, Google chart, HTML, HTML5, input, interface, interfacing, Javascript, order by, PHP, picker, programming, relational database, resize, sort, sorting, SQL, timeline, timeline chart, tutorial, where, where clause, widget, Worldbank, YUI | Leave a comment

XML Public Data Genericization Where Clause Tutorial

Posted on December 24, 2023 by admin

If you’re like me, regarding online data, you work it in your mind to work in with SQL statements, in a relational database sense. In that sense, the first two of the three ways (while the third reminding us more … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged annotated timeline chart, annotation, calendar, calendar chaer, calendar widget, chart, clause, data, date, date picker, DDL, Google chart, HTML, HTML5, input, interface, interfacing, Javascript, order by, PHP, picker, programming, relational database, sort, sorting, SQL, timeline, timeline chart, tutorial, where, where clause, widget, YUI | Leave a comment

WordPress Blog Post Frontend Error Tutorial

Posted on February 24, 2023 by admin

Running a WordPress.org (self hosted, versus a WordPress.com WordPress hosted) blog you are reading, a few times over several years have seen us stuck with the WordPress TwentyTen theme “Add Post” frontend webpage, to create a blog posting, “shooting ourselves … Continue reading →

Posted in Database, eLearning, Tutorials | Tagged backend, blog, browse, cPanel, database, frontend, MySql, PHP, phpMyAdmin, printf, SQL, textarea, tutorial, TwentyTen, update, Wordpress, wordpress.com, wordpress.org | Leave a comment

PHP MySql Select Query UTF-8 Return Values Tutorial

Posted on February 20, 2023 by admin

Yes, ever since embracing emojis, we’re on the lookout for gobbledegook. And yes, a lot of the strategies we found on the “stumbled upon” Reading UTF-8 Content from MySql Table we were familiar with, but one we weren’t, which was … Continue reading →

Posted in Database, eLearning, Tutorials | Tagged database, dropdown, emoji, gobbledegook, landing page, MySql, PHP, programming, query, select, SQL, tutorial, utf-8 | Leave a comment

CentOS Web Server cPanel Apache Status Tutorial

Posted on November 5, 2022 by admin

Our RJM Programming Linux CentOS Web Server cPanel Apache web server’s suite of software has a very useful report called Apache Status. We use it a bit like another Linux user without this report might use … ps -ef … … Continue reading →

Posted in Database, eLearning, Operating System, Tutorials | Tagged add post, address bar, Adobe, Apache, apache status, backend, blog, blog post, blog posting, browse, buffer, category, CentOS, codex, connection, copy, cPanel, curl, custom fields, database, dropdown, emoji, error, file_get_contents, frontend, hanging, HTML, html validator, issue, lightbulb, link, Linux, local web server, macOS, MAMP, MySql, operating system, paste, PHP, phpMyAdmin, post, problem, process, programming, ps, report, select, single.php, SQL, status, symptom, tag, textarea, top, troubleshoot, troubleshooting, tutorial, TwentyTen, TwentyTen theme, url, validator, web browser, web server, webpage, Wordpress | Leave a comment

Date Range Reporting Primer Tutorial

Posted on October 17, 2022 by admin

Are you always satisfied with Search and/or Advanced Search functionality on websites? We’d say “sometimes”, but understand that some of the access to “Advanced Search” is debatable for webmasters given it can lead to database searches of some complexity, that … Continue reading →

Posted in eLearning, Tutorials | Tagged advanced search, date, date range, file_get_contents, NSW, NSW Government, PHP, programming, range, report, search, SQL, tutorial, url | Leave a comment

MySql Repair Table Diskspace Error Log Consequence Tutorial

Posted on October 7, 2022 by admin

If you are managing a web server, you can run into times when … a total solution to a problem needs more research that will take time … but, perhaps … there is a solution that “eases the pain” of … Continue reading →

Posted in Database, eLearning, Event-Driven Programming, Operating System, Tutorials | Tagged Access, Apache, command, command line, copy, crontab, database, diskspace, error log, find, Linux, log, log file, MySql, operating system, rename, repair, rotation, SQL, ssh, table, tutorial, web server | Leave a comment

MySql Repair Table Failure Diskspace Consequence Tutorial

Posted on September 21, 2022 by admin

The previous MySql Repair Table Primer Tutorial outlined some phpMyAdmin administering of MySql (database) maintenance via SQL like … REPAIR TABLE wps_comments; … but what about if the SQL above fails or times out? Well, there can be implications, as … Continue reading →

Posted in Database, eLearning, Operating System, Tutorials | Tagged Apache, CentOS, command, command line, database, diskspace, error, Linux, MySql, phpMyAdmin, programming, REPAIR TABLE, SQL, ssh, table, timeout, tutorial, web server | Leave a comment

Your Numbers Game
Get clue	Your answer	Your Score
Clue?		Score 0/0

Search for:
Recent Posts
Categories
- Ajax
- Android
- Animation
- Anything You Like
- Code::Blocks
- Coding
- Colour Matching
- Data Integration
- Database
- Delphi
- Eclipse
- eLearning
- ESL
- Event-Driven Programming
- Games
- GIMP
- GUI
- Hardware
- Installers
- iOS
- Land Surveying
- Moodle
- Music Poll
- NetBeans
- Networking
- News
- Not Categorised
- OOP
- Operating System
- Photography
- Projects
- Signage Poll
- Software
- SpectroPhotometer
- Tiki Wiki
- Trips
- Tutorials
- Uncategorized
- Visual Studio
- Xcode
April 2024

S M T W T F S

« Mar

1 2 3 4 5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30
Meta
Tags
Ajax animation array background button canvas command line CSS div DOM dropdown email emoji event form game games Google Google chart HTML IFRAME image iOS iPad Javascript MAMP map mobile navigation onclick overlay PHP programming select share sharing SVG table textarea tutorial url video web browser webpage Wordpress
Your Background Image
OnTopList

Tag Archives: SQL

XML Public Data Genericization Attributes Tutorial

XML Public Data Genericization Where Clause Tutorial

WordPress Blog Post Frontend Error Tutorial

Date Range Reporting Primer Tutorial

MySql Repair Table Diskspace Error Log Consequence Tutorial

MySql Repair Table Failure Diskspace Consequence Tutorial

Numbers Guessing Game

Your Numbers Game

Recent Posts

Categories

Meta

Your Background Image

OnTopList

Recent Comments

April 2024
S	M	T	W	T	F	S
« Mar
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

Tag Archives: SQL

Numbers Guessing Game

Your Numbers Game

Recent Posts

Categories

Meta

Tags

Your Background Image

OnTopList