You have destroyed a significant section of your database. Unless you have a backup you cannot get it back. What happened when you changed the varchar to an int was that every entry not recognized as an integer was converted to 0. You can see that in your screenshot. That is not reversible. Data was … Read more
If you can answer ‘yes’ to the questions in Emetrop’s comment, then try: $sql = $wpdb->get_results(‘SELECT * from table1 WHERE id = $bransId’);
Simple SQL Query in wordpress
I suggest for you some ideas : Before run functions from you make, you register table database store ( Example WP_IP and WP_UTM ) After create 2 table that, you run function of you You need read on Codex some resource on WP working with parameters : https://codex.wordpress.org/Class_Reference/wpdb https://codex.wordpress.org/Creating_Tables_with_Plugins
It’s not clear what do you mean by template “accepting” variables. WP_Query (which query_posts()/get_posts() are build on top of) is very flexible. In many cases it’s not as much being able to do something with it, as having experience using it to achieve results. Typically even when queries cannot be expressed in single set of … Read more
Some things to check: Have you update the site URL in the wp_options table? Once you log-in to wp-admin change the permalink structure and click save – this makes the system refresh all the links. I personally always use MySQL Workbench to Export and Import data for MySQL databases as it makes life much easier.
Are you sure it isn’t saving the values to the DB? Perhaps it’s just not displaying the previously saved values in your form? $values = get_post_custom( $post->ID ); This is what you are using to get your meta – but this returns a multi-dimensional array. Therefore when accessing your beef_meta_box_price value, you need to use … Read more
So I solve my problem by configuring the all content by default. However I did the same on another example and I came alive with zero configuration to be done, I still don’t understand. The Answers a) There is no inconsistency with regard to versions used in place over the remote at that time; b) … Read more
@Adrian, You don’t really need to assign anything to variables. You already have the information, you just need to loop through it and add the required HTML as you wish. If you actually want to use a table you can do something similar to: <table> <?php $myrows = $wpdb->get_results( “SELECT first_name, surname FROM members” ); … Read more
I ended up appending a string to the iframe break: top.location = self.location.href + “&noframe=1”; Then checking for it. if(isset($_GET[‘noframe’]) && $_GET[‘noframe’] == 1) Then I insert into the database.