$post_content=”"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit…"”; Try encoding special characters. See: http://www.w3schools.com/tags/ref_entities.asp & http://php.net/manual/en/function.htmlentities.php
Connecting a mobile app directly to the database is possible, but ill-advised. WordPress provides great tools for integrating your application with your site using the XML-RPC interface. WordPress has open-source Android and iOS applications, so there’s some great source code there to get you started. http://codex.wordpress.org/XML-RPC_WordPress_API http://ios.wordpress.org/development/ http://android.wordpress.org/development/ In addition, the Jetpack plugin provides a … Read more
There is a SQL query in the theme file /themes/ExtraGrid/content-single.php, and it is asking for a column that doesn’t exist. This seems to be a commercial theme, so we can just guess why that query exists. Maybe you forgot to set a required theme option, or your tables are just incomplete.
195 queries for one page is a lot. 7000 queries is not a lot, it is insane. Install Query Monitor. It tracks all queries and presents them in groups. I don’t know if it can track that many queries, this is probably an interesting stress test. 🙂 Find the source of those queries, deactivate it. … Read more
Woocommerce stores ‘order’ metakeys in the table wp_woocommerce_termmeta. The mechanism it uses is the same as menu_order for posts. Check this thread for reference. Thanks
did you change or modify any core WordPress files? just make sure that core files are not modified. and i suggest you to double check the wp-config.php file for DB Configurations. restart your local server (apache & php). Try with following configuration. DB HOST: ‘127.0.0.1’ DB USER: ‘root’ DB PASS: ” (blank)
Your question lacks info, but I think you only need a guidance on how to start. If you want do develop locally, you should install XAMPP, WAMPP or any other program that ’emulates’ a server in your computer. After you do that, you need to configure your database with PhpMyAdmin for example, to create the … Read more
There are many ways to achieve this. You can use a widget and custom widgetareas or print it with a plugin like widget on pages. You can create a page and print the pages content like this. (you can 301 redirect that page to the homepage to disallow users to hit the page directly) You … Read more
Your database contains all your data for each of your sites. Without the databases, your sites will not have any posts, pages, site configuration, users, comments, or settings. If you stand these back up, you will have to create blank databases for each and install WordPress from scratch. You can follow the “Famous 5-minute Installation” … Read more
Short answer: You should use the way described in the documentation, sanitize anything that goes in an SQL query, and always use prepared statements. Slightly longer answer: The main use of $wpdb->prepare() is to prevent against SQL injection attacks. Here, we don’t know where ‘foo’, 1337 and ‘%bar’ come from. And that’s somewhat the deciding … Read more