• Skip to primary navigation
  • Skip to main content
Sal Ferrarello
  • About Sal Ferrarello
  • Speaking
  • Connect
    Mastodon GitHub Twitter (inactive)
You are here: Home / Archives for database

database

Syringe in front of medical vials.

WordPress and SQL Injection

Last updated on February 28, 2020 by Sal Ferrarello

An SQL injection vulnerability occurs when you use a variable in your SQL statement and someone uses the variable to add unexpected code. In this article, we’ll look at how this occurs and how to prevent it.

Warning! This is a draft, not a finalized post. See full draft disclosure.

Filed Under: Dev Tips, Draft, Programming Tagged With: database, MySQL, WordPress

WordPress Database Prefix

Last updated on April 29, 2019 by Sal Ferrarello

By default all of the WordPress database tables will start with the prefix “wp_” (e.g. wp_users, wp_posts, etc.). Because this is the default value, you’ll often hear the tables referred to (and written about) using the “wp_” prefix. Let’s look at how and why this prefix is modified.

Warning! This is a draft, not a finalized post. See full draft disclosure.

Filed Under: Dev Tips, Draft, Programming Tagged With: database, WordPress

Photograph of a spooky dark tunnel.

WordPress Database Tables

Last updated on April 26, 2019 by Sal Ferrarello

A list of the database tables (and the columns in those tables) used by a default WordPress installation. This is the companion blog post to my talk, “Introduction to the WordPress Database”.

Filed Under: Programming Tagged With: database, WordPress

term_taxonomy_id vs term_id

Last updated on April 24, 2019 by Sal Ferrarello

In the WordPress database table “wp_term_taxonomy”, each row almost always has the same value for the two columns ‘term_taxonomy_id’ and ‘term_id’. What is the difference between these two columns?

Warning! This is a draft, not a finalized post. See full draft disclosure.

Filed Under: Computing, Draft, Programming Tagged With: database, WordPress

Copyright © 2023 · Bootstrap4 Genesis on Genesis Framework · WordPress · Log in