MySQL Posts

MySQL

Need to create a WordPress admin ‘user’ when you only have database (mysql) access?

Darren Hagen • November 21, 2016

Recently we had a client contact us because they couldn’t access the dashboard of their WordPress site. Sometimes this happens because of lost credentials, database corruption, or maybe due to a website hack. In this case…

Read More

MySQL

How to Update WordPress Links

jsandahl • February 15, 2013

Best practices is to develop a site on a development environment and then copy the site to a production environment. When you do this with WordPress, there are a number of settings that you need to…

Read More

MySQL

How to Write a Recursive Function with PHP

jsandahl • January 3, 2013

For the uninitiated, the recursive function can be a mind-bender. The concept, however, is not as difficult as it may seem at first glance. The difficulty of a recursive function is that it must have a…

Read More

MySQL

Architecture of a Quiz Database

jsandahl • December 23, 2012

So you’re wanting to build a quiz database so you can keep track of the questions, answers, validate those answers, and save them. The important matter to consider is the relationships between each of the tables….

Read More

MySQL

Using Key Value pairs with MySQL

jsandahl • December 14, 2012

So you’re stumped on how to deal with PHP and MySQL when it comes to key value pairs. First off, key-value pairs are not always good database architecture. Use them only when you don’t want to…

Read More

Kohana

Kohana CRUD – Or How to Create, Update, and Delete From the Database with ORM

jsandahl • October 4, 2012

ORM::factory has become a good friend as of the last few weeks. Once you understand the basic idea behind queries, you know they can be reduced down to CRUD. That is, you will be Creating, Updating,…

Read More

MySQL

Looping through Mysql Columns

Andy Stramer • October 5, 2009

Recently I was looking into a way to echo out each column name of a mysql database. Of course I needed to do it dynamically as the database could change and the application is in PHP….

Read More