• Skip to main content
  • Skip to primary sidebar

Technical Notes Of
Ehi Kioya

Technical Notes Of Ehi Kioya

  • About
  • Contact
MENUMENU
  • Blog Home
  • AWS, Azure, Cloud
  • Backend (Server-Side)
  • Frontend (Client-Side)
  • SharePoint
  • Tools & Resources
    • CM/IN Ruler
    • URL Decoder
    • Text Hasher
    • Word Count
    • IP Lookup
  • Linux & Servers
  • Zero Code Tech
  • WordPress
  • Musings
  • More
    Categories
    • Cloud
    • Server-Side
    • Front-End
    • SharePoint
    • Tools
    • Linux
    • Zero Code
    • WordPress
    • Musings

Database

Implementing Pagination Using PHP And MySQL

April 4, 2020 by Chinomnso 3 Comments

Pagination Using PHP And MySQL

An SQL SELECT statement may often return thousands of rows. And when building sites, we usually don’t want to dump all those rows onto a single page (for speed and UX reasons). Instead, we split the results across multiple pages via PAGINATION.

Filed Under: Backend (Server-Side), Database, PHP, Programming, Web Development Tagged With: MySQL, Pagination, PHP, Web Development

Weird Characters In WordPress? Here’s How To Clean Them Up

May 23, 2019 by Ehi Kioya 6 Comments

Weird Characters In WordPress

If you do WordPress site migrations often, you will at some point encounter the problem of weird characters (like “ and ”) appearing in your WordPress content. This article explains why this may happen and how to fix the problem.

Filed Under: Backend (Server-Side), Database, Web Development, WordPress Tagged With: Database, SQL, Web Development, WordPress

Different Ways To Change The WordPress “siteurl” And “home” Links

April 5, 2019 by Ehi Kioya Leave a Comment

Different Ways To Change The WordPress siteurl And home Links

Once in a while, you may need to manually change your WordPress siteurl and home links (e.g. when you’re migrating your entire website to a new domain). If not done right, your site may malfunction. Here are the different proper ways to do this.

Filed Under: Backend (Server-Side), Database, PHP, Programming, Web Development, WordPress Tagged With: Database, PHP, SQL, WordPress

Understanding Conceptual, Logical, and Physical Database Modeling

March 3, 2019 by Ehi Kioya Leave a Comment

Understanding Conceptual, Logical, And Physical Database Modeling

Database Modeling is an important part of the software development process. What is a Database Model? What are Conceptual, Logical and Physical Database Models, and how do they differ? I provide a detailed but high-level overview in this article.

Filed Under: Database, Musings, Zero Code Tech Tagged With: Data Modeling, Database, Database Modeling, Modeling

“Hacking” A WordPress Password

September 6, 2018 by Ehi Kioya 1 Comment

Hacking A WordPress Password

Locked out of your WordPress website? No worries. This article explains how a server administrator can either force reset a user’s WordPress password or create a new WordPress admin user with a brand new password. Database and FTP methods are described.

Filed Under: Backend (Server-Side), Database, Programming, WordPress Tagged With: Database, MySQL, Password, PHP, Programming, WordPress

Connect To Amazon RDS (Or Any Database) Using HeidiSQL Via SSH Tunneling

July 15, 2018 by Ehi Kioya 2 Comments

HeidiSQL SSH Tunneling

Connecting to databases via SSH Tunneling is something developers and IT professionals often need to do. And HeidiSQL is one of the more popular open-source database tools. While HeidiSQL fully supports SSH tunneling, there doesn’t seem to be any documentation about how to accomplish this. So, after struggling with this for a few hours and figuring it out, I put these instructions together to help others.

Filed Under: AWS, Azure, Cloud, Cloud Computing, Database, Linux & Servers Tagged With: Amazon RDS, Cloud Computing, Database, HeidiSQL, Linux, SSH Tunneling

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

23,726
Followers
Follow
30,000
Connections
Connect
14,568
Page Fans
Like
  • Recently   Popular   Posts   &   Pages
  • Actual Size Online Ruler Actual Size Online Ruler
    I created this page to measure your screen resolution and produce an online ruler of actual size. It's powered with JavaScript and HTML5.
  • How To Change A SharePoint List Or Library URL How To Change A SharePoint List Or Library URL
    All versions of the SharePoint user interface provide an option to change the title (or display name) of a list or library. Changing SharePoint library URL (or internal name), however, is not exactly very intuitive. We will discuss the process in this article.
  • WordPress Password Hash Generator WordPress Password Hash Generator
    With this WordPress Password Hash Generator, you can convert a password to its hash, and then set a new password directly in the database.
  • Go to page 1
  • Go to page 2
  • Go to Next Page »
  • About
  • Contact

© 2022   ·   Ehi Kioya   ·   All Rights Reserved
Privacy Policy