I’ve run into this issue before when needing to import a large dataset into WordPress. The importers start failing. What I suggest is creating a custom PHP script that reads the values from the non-WP database and then inserts them into WordPress using the WordPress functions. This way, we ensure all the background data processing … Read more
I have updated the URLs stored in the database when the domain has changed. Here are the things to watch for: In the posts table, the post_content will have any embedded links. These you can change without issue. Again in the posts table, the gid would change if you do a global search and replace. … Read more
It seems you issue is with the below code piece: if ( $results ) { foreach ( $results as $result ){ echo $result[0]; } } echo $result[0]; should just be echo $result;. $results is your array so to use $results[0] (note the s) you would need a for loop and not a foreach loop. if … Read more
You probably don’t need a custom table. Read the top answer to this question which recommends using Custom Post Types. As for displaying the data, I’d recommend you investigate Custom Page Templates. Then you can create a page that loads your data however you’d like.
Use WP CLI! First grab the posts you want, we’ll use the wp post list command, and we need to run the command in our WordPress directory on the server. Here I’m grabbing all posts in October 2014 on my blog: wp post list –year=2014 –monthnum=10 This gives me ( oh noes my secret draft … Read more
The way that I backup our site is two-fold. Via our web host (rackspace) and manually every time I write any code for the site. DISCLAIMER: this is just what I do by habit, I don’t claim it’s the best or only way to do it. Just sharing. Firstly your provider may have an automated … Read more
Your approach is impractical in any site with decent traffic. In that case having real time updates from a DB is the best way to bring your site down. What you need is to check the availability when people at items to carts and then again before the actual checkout. In addition you can update … Read more
I have faced similar issue while working for a client. The issue may cause due to following reasons. Check server configuration and server cache. ( This happens if you are using specialized wordpress hosting; the server admin configured some cache mechanism to increase performance) In this case you have to wait till the sever refresh … Read more
If you aren’t familiar with web technologies, you have a long road ahead of you. That being said, if you have built an iOS app then you probably know something about programming and are willing to travel that road. The best place to get started would probably be the WordPress Plugin Developers Handbook If you … Read more
I would modify your design a bit so you can leverage the data as well prevent logic mistakes that may ruin your stats. First I would store up and down votes as two separate meta values. The reason is that you can then display both if you desire, as well as calculate votes as a … Read more