Long option names fail silently?
This was really driving me crazy. I was debugging some code with code-generated transient names and they were failing like crazy for no apparent reason.
database
Retrieving and Displaying Data From a Table
At the moment, I have created a code that retrieves data from the database and displays it. However, for some reason, I cannot see the files I want to retrieve on my page. My goal is that the data gets retrieved from the database, and is displayed on the webpage. I do not need to make a connection with the database since WordPress does that automatically.
WPDB Insert or if exists Update
I’m not crazy familiar with WPDB or SQL in general but I have a custom table for my project and I’m trying to assign some metadata to it. What I’d “like” to happen is if a row exists, update it and if not insert it. I’ve read both Insert and Update in the WPDB Codex but neither really went into an “either or” situation. I thought i could work with update, so my code so far looks like this:
How to integrate custom database table in WordPress and using WordPress functions
I’m on WordPress 3.0.4 and I’m having a hard time deciding which way to go. The following is my problem:
How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
Normally, a MySQL database can be exported and imported using these simple SSH commands:
How do I show data from gravity forms in my template?
Preface I’ve installed gravity forms, created a form and users are submitting data to my site. What I want to do is show the data users are submitting to my site on one of my pages. I know there’s the Gravity Forms Directory plugin. But this gives only a fixed data presentation. Question Is there … Read more
Update Option Stored in Multi-Dimensional Array
I have data in the wp_options table currently stored as a multi-dimensional array (profile_element_order):
How can I delete orphan keys in WordPress database tables?
In particular in table wp_options. After almost 2 years of blog production it seems increased a lot, and I don’t know how many crap is in there.
Migrating data between local and development server
I’ve been working away at a medium-size WordPress site. So far I’ve just been hosting the site on my local machine and showing it to internal consultants over our local network. Things are working well, and now it’s time to show it off to the client. I’ve been using git all along, so pushing it to the dev server was a breeze. I duplicated the local DB and pushed it to the dev server manually, which was fairly easy except that I had to manually change a few URL entries.
How is custom menu hierarchy output handled?
I’m looking to pass custom nav_menus through an RSS feed so I can grab them on other sites to create the same custom menu on multiple sites.