Showing search and price comparison tables on other sites
Hi everyone;
Just thought i'd collate information from several recent threads regarding showing search and / or price comparison results from your Price Tapestry database within the content of other websites running on the same web server (for example a site running Wordpress, Drupal or Joomla).
To facilitate this, I have created new versions of the main search script (search.php) and the price comparison script (products.php) that do not rely on being called from within the directory in which Price Tapestry is installed.
Search Results
Unzip, and upload searchExternal.php to your Price Tapestry installation folder. Then, to show search results within any other PHP script running on the same web server (it doesn't have to be the same domain name or even a sub-domain, it can be completely different), simply insert the following PHP code into your script:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
$_GET["q"] = "Search Terms";
require($common_path."searchExternal.php");
?>
Simply edit "Search Terms" to be the query you want to include search results for. Remember that you can use the various search modifiers; for example "merchant:Some Merchant" or "category:Widgets" or "brand:Megacorp" etc.
$common_baseHREF must contain the full URL of the Price Tapestry installation, and is used to overwrite $config_baseHREF which otherwise would only generate a relative URL, which would cause the links to be incorrect if being called from another site.
$common_path must contain the actual file system path to the Price Tapestry installation, starting at the root directory ("/"). If you are not sure what this should be, you can discover it using the following trick. Create a file in your Price Tapestry installation directory called whereami.php with the following code:
<?php
$path = $_SERVER["SCRIPT_FILENAME"];
$path = str_replace("whereami.php","",$path);
print $path;
?>
Then, browse to this script, for example (if Price Tapestry is installed in a directory called /shopping/):
http://www.example.com/shopping/whereami.php
...and something like this will be displayed:
/home/someuser/htdocs/shopping/...and that is what you would enter for $common_path; for example:
$common_path = "/home/someuser/htdocs/shopping/";Price Results
Again, simply unzip and upload pricesExternal.php. Invocation code from any other PHP script on the same server is almost identical to the above, for example:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
$_GET["q"] = "Product Name";
require($common_path."pricesExternal.php");
?>
In this case, replace "Product Name" with the exact product name that you wish to display the price comparison table for.
Search Form
Several users have asked how to create a search form from a higher level directory on their site than that in which Price Tapestry is installed. Since the search form dynamically generates a fully qualified URL, the easiest way to do this is to browse to the Price Tapestry folder and then use View > Source in your web browser to view the HTML. Then, simply copy the code between (and including) the <form> tags; and paste this into the HTML (or a "content unit" if using a CSM) of your higher level website.
If you wanted to use the search form on another domain; you would need to replace the action='' attribute of the form tag with the full URL; so if the existing code contained:
action='/shopping/search.php'...then simply replace this with:
action='http://www.example.com/shopping/search.php'Hi Neil,
If any Price Tapestry external module that calls in the require()'d includes is called twice, you will get this re-declaration error.
What you will need to do is modify the code in pricesExternal.php to check for a previous include and only include the files if necessary. The easiest way to do this would be to check for one of the configuration variables. To do this, simply change the following block of code - right at the top:
require($common_path."config.php");
require($common_path."includes/javascript.php");
require($common_path."includes/tapestry.php");
require($common_path."includes/translate.php");
require($common_path."includes/database.php");to the following:
if (!$config_databaseServer)
{
require($common_path."config.php");
require($common_path."includes/javascript.php");
require($common_path."includes/tapestry.php");
require($common_path."includes/translate.php");
require($common_path."includes/database.php");
}That should fix it!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
Still having problems after changing pricesExternal.php
Fatal error: Cannot redeclare translate() (previously declared in /homepages/2/d242783625/htdocs/wp-includes/l10n.php:67) in /homepages/2/d242783625/htdocs/shopping/includes/translate.php on line 5It seems to be conflicting with Wordpress includes file l10n.php:67 - code down to line 67 below:
<?php
/**
* WordPress Translation API
*
* @package WordPress
* @subpackage i18n
*/
/**
* get_locale() - Gets the current locale
*
* If the locale is set, then it will filter the locale
* in the 'locale' filter hook and return the value.
*
* If the locale is not set already, then the WPLANG
* constant is used if it is defined. Then it is filtered
* through the 'locale' filter hook and the value for the
* locale global set and the locale is returned.
*
* The process to get the locale should only be done once
* but the locale will always be filtered using the
* 'locale' hook.
*
* @since 1.5.0
* @uses apply_filters() Calls 'locale' hook on locale value
* @uses $locale Gets the locale stored in the global
*
* @return string The locale of the blog or from the 'locale' hook
*/
function get_locale() {
global $locale;
if (isset($locale))
return apply_filters( 'locale', $locale );
// WPLANG is defined in wp-config.
if (defined('WPLANG'))
$locale = WPLANG;
if (empty($locale))
$locale = 'en_US';
$locale = apply_filters('locale', $locale);
return $locale;
}
/**
* translate() - Retrieve the translated text
*
* If the domain is set in the $l10n global, then the text is run
* through the domain's translate method. After it is passed to
* the 'gettext' filter hook, along with the untranslated text as
* the second parameter.
*
* If the domain is not set, the $text is just returned.
*
* @since 2.2.0
* @uses $l10n Gets list of domain translated string (gettext_reader) objects
* @uses apply_filters() Calls 'gettext' on domain translated text
* with the untranslated text as second parameter
*
* @param string $text Text to translate
* @param string $domain Domain to retrieve the translated text
* @return string Translated text
*/
function translate($text, $domain = 'default') {Any further thoughts?
Neil
Hello Neil,
The first thing I would do is check to see whether the WordPress installation relies on the translate function by editing that file, and just changing the function name with an underscore - for example:
function _translate($text, $domain = 'default') {If that stops WordPress from working at all; then the only thing to do will be to modify the pricesExternal parts of Price Tapestry so that they do not require the translate function.
To do this, first edit pricesExternal.php and delete the following code from line 8:
require($common_path."includes/translate.php");..and then remove the calls to translate("text") within the file to just "text". (use your editors search function to find them) - for example on line 41 you will find:
translate("Reviews")...replace this with just:
"Reviews"Then do the same in html/prices.php, and this will remove the need for Price Tapestry to use translate() and it should work fine!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David, how can i do the same but with the featured items? so they display on an upper level/or another site
Hi Jonny,
I just made a featuredExternal.php that works in exactly the same way. Invoke using:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
require($common_path."featuredExternal.php");
?>
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
any ideas where i add the below when using the featuredexternal.php?
$sql = "SELECT merchant FROM `".$config_databaseTablePrefix."feeds` ORDER BY RAND() LIMIT 1";
database_querySelect($sql,$result);
$merchant = $result[0]["merchant"];
$sql = "SELECT name,1 AS sequence FROM `".$config_databaseTablePrefix."products` WHERE merchant='".database_safe($merchant)."' ORDER BY RAND() LIMIT 3";
Hi Jonny,
Just replace line 47:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."featured` ORDER BY sequence";...with that block of code - that should do the trick!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
ok that works , but i also need the count to work , ie show 1 item then start a new line , this is in the featureed.php but not working with the above mod now
Hi jonny,
Did you have a different HTML moduled called at the bottom of index.php? featuredExternal.php calls in html/featured.php; so it should display in the same way; but if you have a different version - you could just replace the call at the end of featuredExternal.php to the new version...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David.
I've managed to get pricesExternal working on my Wordpress site by doing as you suggested and removing the 'translate' references, so thank you.
However, I can get any results to appear, even when adding query terms that I know work on the actual PT site.
Thoughts?
Hi Mark,
I just followed up by email a little while ago...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Remember that you can use the various search modifiers; for example "merchant:Some Merchant" or "category:Widgets" or "brand:Megacorp" etc.
Hello David, I dont understand... How should I apply modifiers if I want to call Category + brand?
I tried something like:
$_GET["q"] = "category:Category Name:brand:Brand name";
and
$_GET["q"] = "category:Category Name&brand:Brand name";
but none of those worked...
Thanks in advance!
Pasha
Hi Pasha,
It won't work quite like that i'm afraid, but is easy to do. In your calling code, to do a category & brand combination search, specify the brand separately, like this:
$_GET["q"] = "category:Some Category";
$_GET["brand"] = "Brand";Then, in searchExternal.php, look for the following code on line 87:
$where = " ".$parts[0]."='".database_safe($parts[1])."' ";...and REPLACE this with:
$where = " ".$parts[0]."='".database_safe($parts[1])."' ";
if ($_GET["brand"]) $where .= " AND brand='".database_safe($_GET["brand"])."' ";Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Thanks a lot! - As usual, it works like a charm!
Cheers!
Hello David
I've tried adding the above code but I'm getting this error, any idea's?
Warning: require() [function.require]: open_basedir restriction in effect. File(/home/******/public_html/searchExternal.php) is not within the allowed path(s): (/home/*****:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/*****/public_html/index.php on line 38
Fatal error: Can't load /home/******/public_html/searchExternal.php, open_basedir restriction. in /home/******/public_html/index.php on line 38Hi Mally,
This is a security setting within the PHP configuration that is preventing PHP from being allowed to open (require) a file outside of it's own user / directory structure. If you have control over your PHP configuration (which I think you do from our previous emails) look for the open_basedir directive in php.ini (or an equivalent php_flag in .htaccess) and either comment out or delete that line to remove the restriction. You would need to restart Apache/PHP for the changes to take effect...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hello David
Not sure if there's a solution for this but my hosting company have said no to the above saying it would give access to my folders for other people on my server
Cheers
Mally
Hi Mally,
It should still work with a relative path, for example, instead of:
$common_path = "/path/to/pricetapestry/";...something like:
$common_path = "../pricetapestry/";...or even just:
$common_path = "pricetapestry/";...if your CMS is in the root directory and Price Tapestry is installed in a directory called /pricetapestry/...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David
Just what I was looking for! But to take it one step further, can I display those from a specific merchant? So when I am writing about a merchant on a level above price tapestry I can feature just their products randomly?
hmm, thinking about it, it might be nice in future to be able to feature a merchant's product on a keyword too if I wanted to!
---------
Jill
Hi Jill,
Sure - just a couple of changes to searchExternal.php and then adding a sort parameter to your calling code should do the trick. Firstly, in searchExternal.php, replace the following code on line 54:
$sort = "relevance";...with:
$sort = (isset($_GET["sort"])?$_GET["sort"]:"relevance");Then, look for the following code on line 60:
$orderByDefault = array();...and REPLACE this with
$orderByDefault = array();
$orderByDefault["rand"] = "RAND()";Having made those changes, in your calling code where you currently have:
$_GET["q"] = "merchant:Some Merchant";...you can now use:
$_GET["q"] = "merchant:Some Merchant";
$_GET["sort"] = "rand";You can already add a keyword to the merchant search using:
$_GET["q"] = "merchant:Some Merchant:Keyword";Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David , im just looking into using PT and wordpress together.
Ive got featured items displayed ok on the front of the wordpress site , I have the search form on the wordpress site and that works , but what i was wondering was how can the Product.php and the searchresult.php be displayed in wordpress , ie. when u click the featured item or search for a product it will just display in the pricetapestry site and not the wordpress.
not sure if this is possible or if it has already been covered but would be great to be able to do.
thanks in advance
Hello Jonny,
I am currently working on a combined external script that will display the entire Price Tapestry generated content within your WordPress / Joomla page etc. I would be happy to let you try a "beta" version. Could you perhaps email me with the exact calling code that you are currently pasting into your WordPress page(s), and I'll email you back something to try...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David
I too have dropped you an email w.r.t beta test, hope that is ok!
Regards
Richard
Hi David,
Finally got back to this and got it working by stripping out the translate() in the various files.
I have a number of Wordpress posts where I've written say a top 10 products article and wanted to display particular PT information after each product section in the article. Like below
Product 1
Some text here talking about how wonderful product 1 is:
(PT code to show following details for Product 1)
Title
Image
price
more informationProduct 2
Some text here talking about how wonderful product 2 is:
(PT code to show following details for Product 2)
Title
Image
price
more informationand so on.....
The problem I've got at the minute is I can't seem to get the desired display result I'm after using searchExternal.php or pricesExternal.php
Using searchExternal.php:
This formats it properly but the search result pulls in too many products. In my case I just want to pull in product 1 or product 2.
Perhaps there's a way I can write more specific searches to get search result to the exact product?
Using priceExternal.php:
This gives me the exact product but displays as a table of prices which isn't really what I'm after here.
Hope there's a simple fix to this?
Best,
Neil
Hi Neil,
I've just replied to your email regarding the "full" version - that will enable you to show the product page for a specified product (or you can include it more than once for multiple products). As it stands, it will show the prices table, but that can be easily remove - i'll indicate how in my email...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
Thanks for sending me the "full" version - just sent you an email with problem! Please don't spend too much time tring to fix.
The main thing I'm interested in right now is being able to display just:
TITLE
IMAGE
PRICE
MORE INFO LINKsearchExternal.php does exactly what I'm looking for. Only problem is I can't seem to filter to just a single product.
Make sense?
Thanks,
Neil
Hi Neil,
I sent a follow up to your email regarding the full version.
With regards searchExternal.php, you could modify this to only return 1 result (i'm assuming the product you want is always first). In that file, look for the following code on line 52:
$page = 1;...and REPLACE with:
$page = 1;
$config_resultsPerPage = 1;...and that should do the trick!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
That works well!
I've actually created two file searchExternal.php and searchExternal_single.php, the second of which returns just the 1 search result. That way I have more options for writing posts.
Thanks again David - brilliant support!
One more thing David!
When using searchExternal.php is it possible to make the images of the products displayed larger. At the minute I get images that are 75x75. For Wordpress posts it would look much nicer if I could make them larger say 200x200.
Thanks,
Neil
Hi Neil,
Sure. As it stands, searchExternal.php calls the existing html/searchresults.php, in which the image size is dicated on line 10 (look for width='80' but may have changed in your template).
What I would do if you want to keep the current sizes on the main site but use a larger image for the external version, is to make a copy of html/searchresults.php and call it, say, html/searchresults_external.php. In that version, change the image size as required.
Then, in searchExternal.php, look for the following code around line 255:
require($common_path."html/searchresults.php");...and REPLACE that with:
require($common_path."html/searchresults_external.php");Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
You're a mind-reader! That's exactly what I'm after.
Many thanks,
Neil
Hi David
not really pricetapestry related but I have used the same idea to display in wordpress some other info and it displays fine but when i click a link it dosent work , i guess i need a php file like external.php so that the link clicks through and displays in the post where the script is.
any idea what I would need to add to a external php file to make it display in the same post ?
Hi Jonny,
When I developed external.php, I found that using a parameter called "p" in the URL broke Wordpress, because it used the $p variable itself - so look out for the that.
Subsequent versions of the script will use a prefix in the URL variables, just like with the database settings.
Basically, you need to look at the URL when you click on one of your embedded links, and then try to understand how the embedded script is seeing those variables. Make sure you are using $_GET["varname"] instead of just $varname etc..!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
I have the searchform in the header of a wordpress website and yesterday I noticed the search doesn´t work. I´ve made alot of changes to search.php so I dont know how it will end if I use your searchexternal.php. Is there alot of work involved, or could you make the neccessary changes to make my search.php into a searchexternal.php? As it is now, I get this error:
Fatal error: Call to undefined function database_queryselect() in /home/daw/public_html/mysite.org/html/footer.php on line 29
Hi Daniel,
Sure - if you want to email me the searchexternal.php that you are currently using, and your modified search.php from your site i'll try and retro-fit all your mods to search.php into searchexternal.php for you (it's a reasonably distinct block so should be straight forward).
Regarding the error in footer.php - that's strange - is that happening on your normal Price Tapestry install, and if so what page? It implies that the common includes have not been "required()" at the top of whatever script is calling html/footer.php - if you could let me know the URL where this is being displayed that will help...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
It seems the saerch in pricesExternal is an Exact Phrase search in the product name. Can I have a board search instead? Thanks.
Hi,
It's exact match because prices.php is essential the product page from within Price Tapestry, so it needs an actual product to select the prices for. Is possible to use searchExternal.php instead of pricesExternal.php in this case?
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
Yes, no problem. I might use searchExternal.php to do price comparison.
One more question for pricesExternal.php, different merchants call the product differently. For example:
1. Product A
2. Product A very good
3. Prodcut A the best
If 3 merchants call product A differently (they are actually the same product), how can I includes all these 3 in pricesExternal.php?
Thanks.
Hi,
Have you looked at using Product Mapping to give all those products the same name? In this case, if "Product A" is he most obvious name for the product, in /admin/, go to Product Mapping and add "Product A" as a new product. Then, on the next page, enter
Product A very good
Product A the best
(on separate lines) and then Save the mapping. After you have then imported all affected feeds, they will all be called "Product A"
Hope this helps!
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Thanks a lot David. I missed the product mapping part. I will check it out.
David , now that im using the searchexternal file the product url is as below , would you know what changes to make to the HTaccess to have SEO urls? I have tried a number of things but they do not work.
/website/?product=Apple+iPhone+3G+8GB
thanks in advance
Hi Jonny,
Could you email me your external.php and also the .htaccess that will be in scope from wherever it is running and I'll try and work out what you'll need...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
I'm getting this also...
I'm using your external.php wordpress/joomla beta plugin
Thanks
Paul
Hi guys,
Thanks for the feedback - i'll look at how search engine friendly URLs can be incorporated when being called from an external script - it's not straight forward as I'm sure you can imagine as the calling script (e.g. WordPress or Joomla) is ultimately responsible for the URL and how it is handled, but there should be ways round it...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum
Hi David,
Don't know whether it helps, but another Wordpress site that you helped me with last year where I am using SearchExternal.php has a more friendly URL www.mydomain/store/jump.php?id=123456
thanks
Paul
Hi David , wondering if you may have had any other ideas on the seo urls , ive been searching for a solution but no luck , can either get seo urls of the wordpress installation or seo urls of the products from pricetapestr but not both together.
or has anyone else had any luck?
Hello Jonny,
It would involve re-writing the search engine friendly URLs within your WordPress pages to the appropriate internal WordPress URL that is displaying products via pricesExternal.php. If you could perhaps email me an example of the URLs you would like and the equivalent WordPress URL I'll work out the rules for you...
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
David , many thanks for the emails regarding the SEO friendly urls , i was a right pain bugging u :) i have now got it working and will send u the details in a email when i get 5 mins, as u will understand unlike me :) and then if others need to know then u have the info
cheers for all the help
Hi David - is there a way to add a search box to a site on a different server from the one that the database is?
Mark
I've resolved the last question I asked on this thanks
Hi David,
Quick question regarding using PricesExternal.
Just started using this again and I think it's great. However, I'd like to have the merchant logos appear in the PricesExternal results in Wordpress, just like they do in Price Tapestry.
I've managed in get everything else looking similar in Wordpress by wrapping the table in prices.php with a DIV and styling it accordingly in my Wordpress css file.
<div class="PricesExternal">
<table>
<tr>
<th><?php print "Store"; ?></th>
<th> </th>
<th><?php print "Description"; ?></th>
<th><?php print "Price"; ?></th>
</tr>
<?php foreach($prices["products"] as $product): ?>
<tr>
<td><a href='<?php print $product["merchantHREF"]; ?>' title='<?php print $product["merchant"]; ?>'><?php print $product["merchant"]; ?></a></td>
<td>
<?php
if (file_exists("logos/".$product["merchant"]))
{
print "<img src='".$config_baseHREF."logos/".$product["merchant"]."' />";
}
else
{
print " ";
}
?>
</td>
<td><a href='<?php print tapestry_buyURL($product); ?>' title='<?php print "Visit Store"; ?>' <?php print javascript_statusBar("Go to ".$product["merchant"]); ?>><?php print $product["name"]; ?></a></td>
<td><a href='<?php print tapestry_buyURL($product); ?>' title='<?php print "Visit Store"; ?>' <?php print javascript_statusBar("Go to ".$product["merchant"]); ?>><?php print $config_currencyHTML.$product["price"]; ?></a></td>
</tr>
<?php endforeach; ?>
</table>
</div>But, how do I get the logos to appear? They're sitting in a subfolder /logos/ of my Price Tapestry install.
Thanks,
NEil
Hi Neil,
It should just be a case of changing:
if (file_exists("logos/".$product["merchant"]))to...
if (file_exists($common_path."logos/".$product["merchant"]))Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
HI David,
That worked great for PricesExternal, BUT, it made the logos disappear on my PT site! Is there a way to make logos appear on both?
Thanks,
Neil
Hi Neil,
I was expecting that to work in both instances, because when viewing
the normal Price Tapestry site $common_path should be empty, so the
tested file will be the same.
Perhaps the easiest thing to do is to make the file_exists() call use
the full path regardless, so in other words, take the value that you
are using as $common_path in your calling code, and prefix that to
logos/, so that you have:
if (file_exists("/full/path/to/logos/".$product["merchant"]))That should do the trick!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
mmmhh....Now the logos have dissapeared from both Wordpress & Price Tapestry!
Further thoughts?
Thanks Neil
Hi Neil,
Could you email me the file over i'll check it out!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Hi David,
I can't seem to be able to add two separate price comparison tables (with different products) on the same page.
When I add the second code block below, the second "q" phrase is ignored and it just duplicates the product table of the first bit of code.
<?php
$common_baseHREF = "http://www.domain.co.uk/comparison/";
$common_path = "/home/www/domain.co.uk/comparison/";
$_GET["q"] = "second phrase";
require($common_path."pricesExternal.php");
?>
Thanks in advance :-)
Steven
Hi Steve,
Try using:
<?php
$prices = array();
$common_baseHREF = "http://www.domain.co.uk/comparison/";
$common_path = "/home/www/domain.co.uk/comparison/";
$_GET["q"] = "second phrase";
require($common_path."pricesExternal.php");
?>
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Hi David,
Trying to get PT to show on my WordPress site. I've uploaded searchExternal.php to the PT installation folder on my site. Using your whereami.php script I've identified the common path and I've set the query string to a test query I know works. Here's my config:
<?php
$common_baseHREF = "http://www.fashionhype.co.uk/comparison/";
$common_path = "/var/www/vhosts/fashionhype.co.uk/httpdocs/comparison/";
$_GET["q"] = "merchant:Boohoopoo:";
require($common_path."searchExternal.php");
?>
I've added this to my home.php (hompage) just to test, but it's not working and causes the sidebar not to show. Same thing happens if I add the above code to an individual post (using Exec-PHP).
Any ideas?
Thanks,
Peter.
Hi Peter,
It may be a conflict of the translate function. In your searchExternal.php, look for the following code on line 40:
require($common_path."includes/translate.php");...and either comment our delete that line. That should do the trick...
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Hi David,
That worked! Thanks for you help.
Peter.
Hi David
I have externalfeatured in a sidebar and in a post i have pricesExternal
the prices in the post display but the featured items i get
Fatal error: Cannot redeclare javascript_focus() (previously declared in
any ideas? i know some of the include files are being declared again to get this error
Hi Jonny,
Without seeing the code that you are using to incorporate featured products as well as prices being displayed by pricesExternal.php; check the code that you are using and simply replace each instance of:
require...with:
require_onceThat should sort it!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
This might be a dumb question, but when using the Prices External wrapped in your wordpress CSS, is the URL of the price results still SEO friendly...
i.e. when you display a price within wordpress, is the URL created still by PT or do you have to make your own with WP?
Hi,
The URL is created by WordPress - in fact it's the same URL of the page that you place the calling code into, so it can be made search engine friendly by way of WordPress' built in clean URL features...
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
At the moment the searchExternal.php displays the results in alphabetical order. Is it possible to show them in price - low to high order?
---------
Jill
Hi Jill,
In searchExternal.php you should find on line 54:
$sort = "relevance";(relevance doesn't actually apply if the search code does not end up using the full text index which is why you will see alphabetical results)
...change that to:
$sort = "priceAsc";That should do the trick!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Perfect! As usual! Thanks David!
---------
Jill
Hi David
Get same error as Mally with 2 different domains on same server (reseller account)
Have no access to php ini, guess not easy to use than on different domains?
Greets,
Leo
Hi Leo,
Did you try changing $common_path from an absolute to a relative path, described in this comment...
http://www.pricetapestry.com/node/2289#comment-10205
If you're not sure what the values should be; if perhaps you could email me a links to both the Price Tapestry installation and the page on which you are including the "calling code"; and also a copy of the calling code that you are using I'll check it out for you...
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Hi David,
I have a similar problem as jonny5 posted on Tue, 2009-09-08 19:36
I have two separate PT installs in:
example.com/folder1/
example.com/folder2/
Then, on a completely different website I am trying to use two searchExternal.php bits
The second one won't work, it displays results from /folder1/ in both cases.
- I tried changing all occurences of require to require_once in both versions searchExternal.php files
- I also tried adding the $prices = array(); trick to the 2nd block
- I tried the extra code you suggested: if (!$config_databaseServer) {require_once($common_path."config.php"); require_once($common_path."includes/javascript.php"); etc... }
<?php
$common_baseHREF = "http://www.example.com/folder1/";
$common_path = "/home/xxx/public_html/folder1/";
$_GET["q"] = "redwidgets";
require($common_path."searchExternal.php");
?><?php
$prices = array();
$common_baseHREF = "http://www.example.com/folder2/";
$common_path = "/home/xxx/public_html/folder2/";
$_GET["q"] = "bluewidgets";
require($common_path."searchExternal-grid.php");
?>any ideas what I'm doing wrong?
Hi Jim,
I'm assuming that both snippets are on the same page - in which case what is happening is that that config.php is not being re-loaded the second time; so searchExternal.php will continue to use the /folder1/ installation's database.
To fix this; replace your second snippet with:
<?php
$common_baseHREF = "http://www.example.com/folder2/";
$common_path = "/home/xxx/public_html/folder2/";
$_GET["q"] = "bluewidgets";
require($common_path."config.php");
require($common_path."searchExternal-grid.php");
?>
Hope this helps!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
thanks David, that solved the problem :)
Hi everyone,
Here are updated external scripts for use with the latest distribution
of Price Tapestry...
Inline with the latest distribution, searchExternal.php may include
minPrice and/or maxPrice parameters, for example:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
$_GET["q"] = "Search Terms";
$_GET["minPrice"] = "50.00";
$_GET["maxPrice"] = "100.00";
require($common_path."searchExternal.php");
?>
Example calling code for the new featuredExternal.php script:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
require($common_path."featuredExternal.php");
?>
featuredExternal.php also supports the section modification from
this thread. The section name should supplied through the
$common_featuredSection variable; for example:
<?php
$common_baseHREF = "http://www.example.com/pricetapestry/";
$common_path = "/path/to/pricetapestry/";
$common_featuredSection = "PS3";
require($common_path."featuredExternal.php");
?>
...which will display only Featured Products specified as, for
example:
PS3/Product NameCheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
having trouble gettign results to show on another site, on the same server. I nave not yet upgraded to the latest version of PT.
error:
Warning: require(/home/XXXXXX/public_html/searchExternal.php) [function.require]: failed to open stream: Permission denied in /home/XXXXXX/public_html/index.php on line 153
Fatal error: require() [function.require]: Failed opening required '/home/XXXXXX/public_html/searchExternal.php' (include_path='.:/usr/local/php5/lib/php') in /home/XXXXXXX/public_html/index.php on line 153
Not sure how to proceed.
The paths are correct in the bit of code I added to the external site:
<?php
$common_baseHREF = "http://www.hockeyshopper.com/";
$common_path = "/home/XXXXXX/public_html/";
$_GET["q"] = "goalie pads";
require($common_path."searchExternal.php");
?>
PT installed in root directory.
Thanks!
Don
Hi Don,
This implies that the 2 sites are configured under separate user IDs and they do not have read access to other user's directories. I'm assuming for example that you have this kind of setup:
/home/user1/public_html/ (existing Price Tapestry site)
/home/user2/public_html/ (site where you are trying the external code)
...and that user2 does not have READ access to user1's home directory.
First check whether your hosting control panel has a permissions area from which you can modify user1 permissions to give user2 read access - that should do the trick; but check with your host if you're not sure.
If it doesn't look like it would be possible; there is an alternative method; and that is to create a "ghost" installation of Price Tapestry in a sub-directory, e.g. "pt". In config.php; simply use the same database settings as your main Price Tapestry site; not forgetting to make $config_baseHREF = "pt";
In the calling code; leave $common_baseHREF as it is (so that the links go to your main Price Tapestry site); but simply change $common_path to be the path to the ghost installation; which then shouldn't have any permission issues...
Hope this helps!
Cheers,
David.
--
Developer, Price Tapestry
General PHP, MySQL and Affiliate Marketing tech help for Price Tapestry customers at davidmorison.com
Turns out my host has disabled account sharing due to security concerns. I may try method 2. Or perhaps use some sort of ajax httprequest. Thought about making rss feeds from the main installation and parsing them using magicparser on the other sites. Thanks for the quick response.
Hi David,
I tested your pricesExternal.php script above in a higher level folder from my Price Tapestry installation and it works fine.
As I'm using Wordpress in top level folder, I've installed a Wordpress plugin (Exec-PHP) which allows you to execute php code in Wordpress posts - I tested it with some simple php code and it seems to work fine. However, when I try to run the prices code in a Wordpress post I get the following error in the displayed post:
Fatal error: Cannot redeclare translate() (previously declared in /homepages/2/**********/htdocs/wp-includes/l10n.php:67) in /homepages/2/**********/htdocs/shopping/includes/translate.php on line 5Any thoughts?
Thanks,
Neil