thenorth
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Woocommerce on a Sub DomainHi, thanks for the reply. All the changes have been madenin the db to reflect the new site url (domain/sub) but for some reason when I click visit Store in WordPress Backend it takes me to the main shop onna totally different install/Database. Very bizarre.
Forum: Plugins
In reply to: [WooCommerce] Applying CSS to PHPThat is the shot. Thank you ThemeSumo.
Forum: Plugins
In reply to: [WooCommerce] Applying CSS to PHPHi, part of the issue is the text doesn’t have a Class of it’s own. It’s linked to the price (which the proper ones aren’t. Can I give it a Class in PHP?
The Prices I don’t create are this <small class=”woocommerce-price-suffix”>Inc VAT</small>However the Prices created by the PHP above shows this ” inc VAT”.
Appreciate any help.
Thank you.
Forum: Plugins
In reply to: [WooCommerce] Hide Original Price when Sale Price enteredHi Andrew, thanks for quick repsonse. I tried that code but doesn’t seem to do anything. If I remove the del part all prices disappear so I’m guessing the Original Price and Sale Price are both the same thing somehow.
I’m guessing it has something to do with the Variations Products as Products with no Variation show the Sale price only. There is also a colour set for Sale Prices but the Sale price on a variable product is same colour as Original Price. Might be a big in Woo somewhere perhaps?Forum: Plugins
In reply to: [WP Customer Reviews] Enable WP Customer Reviews keeps disablingHi – did you every get this problem fixed, I’m having the same problem. Thanks.
Hi John, can this post be removed as my boss is not happy about me posting links to site on here. Much appreciated.
He’s also dealing with this issue directly with you.Thanks.
Hi John, that’s great thanks.
Basically every page has an instagram feed on the Men and Women
Really appreciate you looking at this.
Kind regards,
theNORTH
Breakthrough – Page HERE
I’ve declared the Db Name & Table as $dukdb = (
web152-thenorth.Dukes3); and used WHERE $dukdb in the Query.I’m using
$mydb = new wpdb(‘XX’,’XX’,XX’,’localhost’);
$query = $mydb->get_results($sql2, ARRAY_A) or die(mysql_error());
Instead of MSQLI_ASSOCAnd instead of using While I now use foreach($query as $row) {
and it all works with the [insert_php].This has been one head scratcher but solved with the help of some of your prompts Will. Thank you very much, hope this helps someone else in the future.
Thanks again
Noel.Hi Will made some progress with this. It was the PHP Version, so when updated, the coded worked in the Test.php page no problem, however it does not work inside a WordPress. I’ve done some research which seems to suggest you can’t use the Array MSQLI_ASSOC in wordpress and that I have to use WPDB.
However it now seems that using WPDB in WordPress doesn’t like the DB declaration in the SQL Query, specifically it seems it can’t handle the dash in my dbname web152-thenorth.Dukes3 and it sees the DB as thenorth.Dukes3.
Not sure what to do now!
It does Will, see below. Connection is fine (as when it’s not it throws the Error Oh Oh Oh out).
I’ve even tried bringing the dbcon into the page, but it does not change the outcome<?php
DEFINE (‘DB_USER’, ‘XXXXX’);
DEFINE (‘DB_PSWD’, ‘XXX’);
DEFINE (‘DB_HOST’, ‘localhost’);
DEFINE (‘DB_NAME’, ‘XXXXXX’);$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);
If (!$dbcon){
die(‘Error oh oh oh’);
}?>
Noel.
Hi Will,
Tried it and still doesn’t seem to want to work. I changed the Action call and the Include for the connection but it returns the SQL Text on the web page
“select Date_Format(Start_Date,’%d-%b-%Y’) As Start_Date,Day,No_Of_Nights,CONCAT(‘£’, FORMAT(cost, 2)) as Cost ,Status,PageLink from web152-thenorth.Dukes3 WHERE concatc = ‘August 2015’ ORDER BY Start_Date”
Bizarre. Are database connects or SQL declared differently inside wordpress?
Appreciate the help.
Noel
Hi thanks Will, the code runs fine on HERE
with the <?php and ?>
so I’m not sure why it doesn’t work, except for perhaps the “action=” part. In the old code the page was a PHP page, does this matter in WordPress or is their a way around it?Thanks again for the help.
Noel.
Forum: Plugins
In reply to: [Contact Form 7] Required FiledsStrange it’s using Contact Form 7 plugin and the page source references contact-form-7-css.
What makes you believe it’s not a CF7 form?
The tag in my WP page is [contact-form-7 id=”1515″ title=”Provisional Booking (Dukes3)”]Forum: Plugins
In reply to: [Link Data From Another DB] helpHi,
I have downloaded the Plugin and entered all of my db dets etc.
What I’m now struggling with is how to call my results in the WP Page. I’m assuming it uses sort of shortcodes but not sure.
I’m starting with a simple select to begin with and hopefully once I can see the results I can start making my query a little more complicated.
Really appreciate some advice to get through this first step.Thanks.
theNorth
