: SQL error Unknown column

[dwmusicstore]

Hi, i have made a script for google merchants.

The script works great but instead of using the products_price column in the table PRODUCTS

i want it to use the customers_group_price in the table PRODUCTS_GROUPS

So i altered this line:

FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,

 

into

FORMAT( IFNULL(specials.specials_new_products_price, products_groups.customers_group_price) * " . $taxCalc . ",2) AS price,

 

But all i am getting is this error:

 

 

: SQL error Unknown column 'products_groups.customers_group_price' in 'field list'|

 

I've checked the database_tables.php file and there is a line for the PRODUCTS_GROUPS table and the tables and columns are all there...it is impossible to work, or am i missing something ?

[web-project]

customers_group_price

the above field is missing products_groups table, you probably skipped one of installation steps.

[dwmusicstore]

i am not very good with SQL, can you please tell me how i can solve this ?

[web-project]

you need to find code similar to:

ALTER TABLE products_groups ADD customers_group_price varchar(50);

 

or you can run above code in phpmyadmin utility.

 

Info about adding field to table:

http://forums.mysql.com/read.php?132,201915,201915

[dwmusicstore]

But customers_group_price IS already in the table products_groups and it has values, and those values i needed, but somehow it is not being found when i run the php script

 

phpmyadmin utility returned this error

 

Fout

 

SQL-query:

 

ALTER TABLE products_groups ADD customers_group_price varchar( 50 )

 

MySQL retourneerde: Documentatie

#1060 - Duplicate column name 'customers_group_price'

[dwmusicstore]

Anyone has a idea ?

[Jan Zonjee]

Anyone has a idea ?

You turn this into a guessing game. Why don't you give us the complete query you use.

[dwmusicstore]

Hi, here is the php script i use

 

<?php

 

define('SEO_URLS_GEBRUIKEN','true');

define('BESTANDSNAAM', 'googleshopping_feed.txt');

define('WEBSITE_LINK', ''.$_SERVER['SERVER_NAME'].'/');

define('FTP_USERNAME', 'naam');

define('FTP_PASSWORD', 'password');

define('FTP_ENABLED', (isset($_GET['noftp']) ? '0' : '0'));

define('CONVERT_CURRENCY', '0');

define('VALUTA', 'EUR');

define('TAAL_ID_LANGUAGE', 5);

define('QUOTES_CATEGORY_NAME','');

 

define('OPTIONS_TONEN', 1);

define('OPTIONS_TONEN_AGE_RANGE', 0);

define('OPTIONS_TONEN_ATTRIBUTES', 1);

define('OPTIONS_TONEN_BRAND', 1);

define('OPTIONS_TONEN_CONDITION', 1);

define('OPTIONS_TONEN_CURRENCY', 0);

define('OPTIONS_TONEN_EXPIRATION', 1);

define('OPTIONS_TONEN_FEED_LANGUAGE', 0);

define('OPTIONS_TONEN_FEED_QUANTITY', 1);

define('OPTIONS_TONEN_GTIN', 0);

define('OPTIONS_TONEN_GOOGLE_UTM', 0);

define('OPTIONS_TONEN_ISBN', 0);

define('OPTIONS_TONEN_MADE_IN', 0);

define('OPTIONS_TONEN_MANUFACTURERS_ID', 0);

define('OPTIONS_TONEN_PAYMENT_ACCEPTED', 0);

define('OPTIONS_TONEN_PRODUCT_MODEL', 1);

define('OPTIONS_TONEN_PRODUCT_TYPE', 1);

define('OPTIONS_TONEN_SHIPPING', 1);

define('OPTIONS_TONEN_INCLUDE_TAX', 0);

define('OPTIONS_TONEN_UPC', 0);

define('OPTIONS_TONEN_WEIGHT', 1);

 

define('OPTIONS_AGE_RANGE', '10-50 years');

define('OPTIONS_BRAND', 'Gadgets');

define('OPTIONS_CONDITION', 'Nieuw'); //possible entries are New, Refurbished, Used

define('OPTIONS_DEFAULT_CURRENCY', 'EUR');

define('OPTIONS_DEFAULT_FEED_LANGUAGE', 'NL');

define('OPTIONS_DEFAULT_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578

define('OPTIONS_GTIN', '');

define('OPTIONS_ISBN', '');

define('OPTIONS_MADE_IN', 'US');

define('OPTIONS_MANUFACTURERS_NAME', '1');

define('OPTIONS_PAYMENT_ACCEPTED_METHODS', '');

define('OPTIONS_PRODUCT_TYPE', 'full');

//define('OPTIONS_TAX_STRING', '');

 

//the following is for the shipping override option - enter multiple values separated by a comma

//Format entries follow. A colon must be present for each field, whether it is entered or not.

// COUNTRY - OPTIONAL - If country isn't included, we'll assume the shipping price applies to the target country of the item. If region isn't included, the shipping price will apply across the entire country.

// REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*)

// SERVICE - OPTIONAL - The service class or delivery speed, i.e. ground

// PRICE - REQUIRED - Fixed shipping price (assumes the same currency as the price attribute)

//define('OPTIONS_SHIPPING_STRING', 'nl::Ground:19.00'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

 

//the following is for the tax override option - enter multiple values separated by a comma

//Format entries follow. A colon must be present for each field, whether it is entered or not.

// COUNTRY - OPTIONAL - country the tax applies to - only US for now

// REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*)

// TAX - REQUIRED - default = 0 (e.g. for 5.76% tax use 5.76)

// SHIPPING - OPTIONAL - do you charge tax on shipping - choices are y or n

//define('OPTIONS_TAX_STRING', 'NL::19.00:n'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping

 

define('OPTIONS_UPC', '');

define('OPTIONS_WEIGHT_ACCEPTED_METHODS', 'g');

 

//the following allow skipping certain items

define('OPTIONS_IGNORE_PRODUCT_ZERO', 0);

 

$taxRate = 19; // (Prijs tonen inclusief XX BTW. Prijzen worden EX BTW uit de dabase gehaald.)

 

 

 

/***********************************************************************************************/

 

// Configuratie instellingen ophalen

require_once('../includes/configure.php');

 

if (! function_exists("tep_not_null")) {

function tep_not_null($value) {

if (is_array($value)) {

return ((sizeof($value) > 0) ? true : false);

} else {

return ((($value != '') && (strtolower($value) != 'null') && (strlen(trim($value)) > 0)) ? true : false);

}

}

}

 

if(SEO_URLS_GEBRUIKEN=='true'){

//********************

// Modification for SEO

// Since the ultimate SEO was only installed on the public side, we will include our files from there.

require_once('../includes/filenames.php');

require_once('../includes/database_tables.php');

 

include_once('../' .DIR_WS_CLASSES . 'seo.class.php');

$seo_urls = new SEO_URL(TAAL_ID_LANGUAGE);

 

function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {

global $seo_urls;

return $seo_urls->href_link($page, $parameters, $connection, $add_session_id);

}

}

 

// -----------

$stimer = explode( ' ', microtime() );

$stimer = $stimer[1] + $stimer[0];

// -----------

 

 

$OutFile = "../feeds/" . BESTANDSNAAM;

$destination_file = BESTANDSNAAM;

$source_file = $OutFile;

$imageURL = 'http://' . WEBSITE_LINK . 'images/products_large/';

if(SEO_URLS_GEBRUIKEN=='true'){

$productURL = 'product_info.php'; // ***** Revised for SEO

$productParam = "products_id="; // ***** Added for SEO

}else{

$productURL = 'http://' . WEBSITE_LINK . '/product_info.php?products_id=';

}

 

$already_sent = array();

 

if(CONVERT_CURRENCY)

{

if(SEO_URLS_GEBRUIKEN=='true'){

$productParam="currency=" . VALUTA . "&products_id=";

}else{

$productURL = "http://" . WEBSITE_LINK . "/product_info.php?currency=" . VALUTA . "&products_id="; //where VALUTA is your currency type (eg. USD, EUR, GBP)

}

}

 

$taxCalc = ($taxRate/100) + 1;

 

$feed_exp_date = date('Y-m-d', time() + 2419200 );

 

if (!($link=mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD))) {

echo "Error when connecting itself to the data base";

exit();

}

if (!mysql_select_db( DB_DATABASE , $link )) {

echo "Error the data base does not exist";

exit();

}

 

$quotes = '';

if (QUOTES_CATEGORY_NAME !== '') {

$quotes = " and products.customers_email_address = '' and products.quotes_email_address = ''";

}

 

$extraFields = '';

if (OPTIONS_TONEN_BRAND == 1 && strlen(OPTIONS_BRAND) == 0) { //brand is enabled but not set so load from database

$extraFields .= ' products.products_brand as brand, ';

}

if (OPTIONS_TONEN_GTIN == 1 && strlen(OPTIONS_GTIN) == 0) {

$extraFields .= ' products.products_gtin as gtin, ';

}

if (OPTIONS_TONEN_ISBN == 1 && strlen(OPTIONS_ISBN) == 0) {

$extraFields .= ' products.products_isbn as isbn, ';

}

if (OPTIONS_TONEN_UPC == 1 && strlen(OPTIONS_UPC) == 0) {

$extraFields .= ' products.products_upc as upc, ';

}

 

 

$sql = "

SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,

products_model AS prodModel,

manufacturers.manufacturers_name AS mfgName,

manufacturers.manufacturers_id,

products.products_id AS id,

products_description.products_name AS name,

products_description.products_description AS description,

products.products_quantity AS quantity,

products.products_status AS prodStatus,

products.products_weight AS prodWeight, " . $extraFields . "

 

 

FORMAT( IFNULL(specials.specials_new_products_price, products_groups.customers_group_price) * " . $taxCalc . ",2) AS price,

CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,

products_to_categories.categories_id AS prodCatID,

categories.parent_id AS catParentID,

categories_description.categories_name AS catName

FROM (categories,

categories_description,

products,

products_description,

products_to_categories)

 

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )

left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

 

WHERE products.products_id=products_description.products_id

AND products.products_id=products_to_categories.products_id

AND products_to_categories.categories_id=categories.categories_id

AND categories.categories_id=categories_description.categories_id " . $quotes . "

AND categories_description.language_id = " . TAAL_ID_LANGUAGE . "

AND products_description.language_id = " . TAAL_ID_LANGUAGE . "

ORDER BY

products.products_id ASC

";

 

$quotes = '';

if (QUOTES_CATEGORY_NAME !== '') {

$quotes = " and categories_description.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' ";

}

 

$catInfo = "

SELECT

categories.categories_id AS curCatID,

categories.parent_id AS parentCatID,

categories_description.categories_name AS catName

FROM

categories,

categories_description

WHERE categories.categories_id = categories_description.categories_id " . $quotes . "

AND categories_description.language_id = " . TAAL_ID_LANGUAGE . "";

 

function findCat($curID, $catTempPar, $catTempDes, $catIndex) {

if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) ) {

if(isset($catIndex[$catTempPar[$curID]])) {

$temp=$catIndex[$catTempPar[$curID]];

} else {

$catIndex = findCat($catTempPar[$curID], $catTempPar, $catTempDes, $catIndex);

$temp = $catIndex[$catTempPar[$curID]];

}

}

if( (isset($catTempPar[$curID])) && (isset($catTempDes[$curID])) && ($catTempPar[$curID] == 0) ) {

$catIndex[$curID] = $catTempDes[$curID];

} else {

$catIndex[$curID] = $temp . ", " . $catTempDes[$curID];

}

return $catIndex;

}

 

$catIndex = array();

$catTempDes = array();

$catTempPar = array();

$processCat = mysql_query( $catInfo )or die( $FunctionName . ": SQL error " . mysql_error() . "| catInfo = " . htmlentities($catInfo) );

 

while ( $catRow = mysql_fetch_object( $processCat ) ) {

$catKey = $catRow->curCatID;

$catName = $catRow->catName;

$catParID = $catRow->parentCatID;

if($catName != "") {

$catTempDes[$catKey]=$catName;

$catTempPar[$catKey]=$catParID;

}

}

 

foreach($catTempDes as $curID=>$des) { //don't need the $des

$catIndex = findCat($curID, $catTempPar, $catTempDes, $catIndex);

}

 

$_strip_search = array(

"![~ ]+$|^[~ ]+!m", // remove leading/trailing space chars

'%[\r\n]+%m'); // remove CRs and newlines

$_strip_replace = array(

'',

' ');

$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "~" => "", " " => "", """ => "\"");

 

 

if ( file_exists( $OutFile ) ) {

unlink( $OutFile );

}

 

$output = "link~titel~beschrijving~prijs~afbeeldingslink~id";

$attributesColumns = array();

 

//create optional section

if(OPTIONS_TONEN == 1) {

if(OPTIONS_TONEN_AGE_RANGE == 1) $output .= "~age_range";

if(OPTIONS_TONEN_BRAND == 1) $output .= "~merk";

if(OPTIONS_TONEN_CONDITION == 1) $output .= "~staat";

if(OPTIONS_TONEN_CURRENCY == 1) $output .= "~currency";

if(OPTIONS_TONEN_EXPIRATION == 1) $output .= "~vervaldatum";

if(OPTIONS_TONEN_FEED_LANGUAGE == 1) $output .= "~language";

if(OPTIONS_TONEN_FEED_QUANTITY == 1) $output .= "~hoeveelheid";

if(OPTIONS_TONEN_GTIN == 1) $output .= "~gtin";

if(OPTIONS_TONEN_ISBN == 1) $output .= "~isbn";

if(OPTIONS_TONEN_MADE_IN == 1) $output .= "~made_in";

if(OPTIONS_TONEN_MANUFACTURERS_ID == 1) $output .= "~manufacturer";

if(OPTIONS_TONEN_PAYMENT_ACCEPTED == 1) $output .= "~payment_accepted";

if(OPTIONS_TONEN_PRODUCT_MODEL == 1) $output .= "~mpn";

if(OPTIONS_TONEN_PRODUCT_TYPE == 1) $output .= "~producttype";

if(OPTIONS_TONEN_SHIPPING == 1) $output .= "~Google productcategorie ";

if(OPTIONS_TONEN_INCLUDE_TAX == 1) $output .= "~tax";

if(OPTIONS_TONEN_UPC == 1) $output .= "~upc";

if(OPTIONS_TONEN_WEIGHT == 1) $output .= "~verzendgewicht";

 

 

 

if (OPTIONS_TONEN_ATTRIBUTES == 1) {

$products_options_name_query = mysql_query("select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where popt.language_id = '" . (int)1 . "' order by popt.products_options_name") or die(mysql_error());

while ($products_options_name = mysql_fetch_object($products_options_name_query)) {

$attributesColumns[] = $products_options_name->products_options_name;

$name = strtolower($products_options_name->products_options_name);

$name = str_replace(" ","_", $name);

$output .= "~c:" . $name;

}

 

/*

//If you want to only show particular attributes, comment out the above and uncomment this section.

//Then enter two lines for each one you want to show. For example, if the atttributes you want to

//show are named Color and Fabric, the entries would appear as follows:

 

$attributesColumns[] = "Color";

$attributesColumns[] = "Fabric";

 

$output .= "~c:" . strtolower("Color");

$output .= "~c:" . strtolower("Fabric");

*/

}

}

$output .= "\n";

 

 

$result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) );

 

//Currency Information

if(CONVERT_CURRENCY) {

$sql3 = "

SELECT

currencies.value AS curEUR

FROM

currencies

WHERE currencies.code = '" . VALUTA . "'";

 

$result3=mysql_query( $sql3 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql3 = " . htmlentities($sql3) );

$row3 = mysql_fetch_object( $result3 );

}

 

$loop_counter = 0;

 

while( $row = mysql_fetch_object( $result ) ) {

if (OPTIONS_IGNORE_PRODUCT_ZERO > 0 && $row->quantity < 1) continue; //skip products with 0 qty

if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop

 

if ( $row->prodStatus == 1 ) {

if (CONVERT_CURRENCY) {

$row->price = preg_replace("/[^.0-9]/", "", $row->price);

$row->price = $row->price * $row3->curEUR;

$row->price = number_format($row->price, 2, '.', ',');

}

 

 

$google_utm = (OPTIONS_TONEN_GOOGLE_UTM ? OPTIONS_DEFAULT_GOOGLE_UTM : '');

 

if(SEO_URLS_GEBRUIKEN=='true'){

$output .= tep_href_link($productURL,$productParam . $row->id) . $google_utm . "~" .

 

 

strip_tags($row->name) . "~" .

 

 

preg_replace("/\s+[^a-zA-Z0-9]/", "", $row->description) . "~" .

 

 

$row->price . "~" .

$row->image_url . "~" .

// $catIndex[$row->prodCatID] . "~" .

$row->id;

} else {

$output .= $row->product_url . $google_utm . "~" .

 

 

strip_tags($row->name) . "~" .

preg_replace("/\s+[^a-zA-Z0-9]/", "", $row->description) . "~" .

 

$row->price . "~" .

$row->image_url . "~" .

// $catIndex[$row->prodCatID] . "~" .

$row->id;

}

 

//optional values section

if(OPTIONS_TONEN == 1) {

if(OPTIONS_TONEN_AGE_RANGE == 1)

$output .= "~" . OPTIONS_AGE_RANGE;

if(OPTIONS_TONEN_BRAND == 1)

// $output .= "~" . (isset($row->brand) ? $row->brand : (strlen(OPTIONS_BRAND) ? OPTIONS_BRAND : "Not Supported"));

 

// $output .= "~" . (isset($row->mfgName) ? $row->mfgName : (strlen(OPTIONS_BRAND) ? OPTIONS_BRAND : "Not Supported"));

 

 

$output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);

 

 

// $output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);

if(OPTIONS_TONEN_CONDITION == 1)

$output .= "~" . OPTIONS_CONDITION;

if(OPTIONS_TONEN_CURRENCY == 1)

$output .= "~" . OPTIONS_DEFAULT_CURRENCY;

if(OPTIONS_TONEN_EXPIRATION == 1)

$output .= "~" . $feed_exp_date;

if(OPTIONS_TONEN_FEED_LANGUAGE == 1)

$output .= "~" . OPTIONS_DEFAULT_FEED_LANGUAGE;

if(OPTIONS_TONEN_FEED_QUANTITY == 1)

$output .= "~" . $row->quantity;

if(OPTIONS_TONEN_GTIN == 1)

$output .= "~" . (isset($row->gtin) ? $row->gtin : (strlen(OPTIONS_GTIN) ? OPTIONS_GTIN : "Not Supported"));

if(OPTIONS_TONEN_ISBN == 1)

$output .= "~" . (isset($row->isbn) ? $row->isbn : (strlen(OPTIONS_ISBN) ? OPTIONS_ISBN : "Not Supported"));

if(OPTIONS_TONEN_MADE_IN == 1)

$output .= "~" . OPTIONS_MADE_IN;

if(OPTIONS_TONEN_MANUFACTURERS_ID == 1)

 

//$output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);

$output .= "~" . nl2br($row->prodModel);

 

if(OPTIONS_TONEN_PAYMENT_ACCEPTED == 1)

$output .= "~" . OPTIONS_PAYMENT_ACCEPTED_METHODS;

if(OPTIONS_TONEN_PRODUCT_MODEL == 1)

$output .= "~" . $row->prodModel;

if(OPTIONS_TONEN_PRODUCT_TYPE == 1)

$output .= "~" . ((OPTIONS_PRODUCT_TYPE == strtolower('full')) ? $catIndex[$row->prodCatID] : $row->catName);

if(OPTIONS_TONEN_SHIPPING == 1)

$output .= "~" . ((OPTIONS_PRODUCT_TYPE == strtolower('full')) ? $catIndex[$row->prodCatID] : $row->catName);

if(OPTIONS_TONEN_INCLUDE_TAX == 1)

$output .= "~" . OPTIONS_TAX_STRING;

if(OPTIONS_TONEN_UPC == 1)

$output .= "~" . (isset($row->upc) ? $row->upc : (strlen(OPTIONS_UPC) ? OPTIONS_UPC : "Not Supported"));

if(OPTIONS_TONEN_WEIGHT == 1)

$output .= "~" . $row->prodWeight . ' ' .OPTIONS_WEIGHT_ACCEPTED_METHODS;

 

/******************* BEGIN HANDLING THE ATTRIBUTES ********************/

if (OPTIONS_TONEN_ATTRIBUTES == 1)

{

$products_attributes_query = mysql_query("select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='" . $row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "'");

$products_attributes = mysql_fetch_object($products_attributes_query);

if ($products_attributes->total > 0) {

$products_options_name_query = mysql_query("select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='" . (int)$row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "' order by popt.products_options_name") or die(mysql_error());

 

$trackTabs = '';

 

while ($products_options_name = mysql_fetch_object($products_options_name_query)) {

$products_options_array = array();

$products_options_query = mysql_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from products_attributes pa, products_options_values pov where pa.products_id = '" . (int)$row->id . "' and pa.options_id = '" . $products_options_name->products_options_id . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)1 . "'");

while ($products_options = mysql_fetch_object($products_options_query)) {

$products_options_array[] = array('id' => $products_options->products_options_values_id, 'text' => $products_options->products_options_values_name);

}

 

for ($a = 0; $a < count($attributesColumns); ++$a)

{

if ($products_options_name->products_options_name == $attributesColumns[$a])

{

if ($a == 0)

$trackTabs = "~";

else

{

if (empty($trackTabs))

$trackTabs = str_repeat("~", $a);

$trackTabs .= "~";

}

 

$output .= $trackTabs;

foreach ($products_options_array as $arr)

$output .= $arr['text'] . ',';

$output = substr($output, 0, -1);

}

}

}

}

}

/******************* END HANDLING THE ATTRIBUTES ********************/

}

$output .= " \n";

}

 

$already_sent[$row->id] = 1;

$loop_counter++;

 

if ($loop_counter>750) {

$fp = fopen( $OutFile , "a" );

$fout = fwrite( $fp , $output );

fclose( $fp );

$loop_counter = 0;

$output = "";

}

}

 

$fp = fopen( $OutFile , "a" );

$fout = fwrite( $fp , $output );

fclose( $fp );

echo "<table><tr><td><img src=\"images/google-shopping.jpg\" alt=\"Google Shopping\" align=\"left\"></td><td style=\"font-family: verdana; font-size:11px;\"><b>Google shopping feed is geupdate!</b><br><br>Bestand: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a></td></tr></table>\n";

chmod($OutFile, 0777);

 

 

//Start FTP

 

function ftp_file( $ftpservername, $ftpusername, $ftppassword, $ftpsourcefile, $ftpdirectory, $ftpdestinationfile ) {

// set up basic connection

$conn_id = ftp_connect($ftpservername);

if ( $conn_id == false ) {

echo "FTP open connection failed to $ftpservername <BR>\n" ;

return false;

}

 

// login with username and password

$login_result = ftp_login($conn_id, $ftpusername, $ftppassword);

 

// check connection

if ((!$conn_id) || (!$login_result)) {

echo "FTP connection has failed!<BR>\n";

echo "Attempted to connect to " . $ftpservername . " for user " . $ftpusername . "<BR>\n";

return false;

} else {

echo "Connected to " . $ftpservername . ", for user " . $ftpusername . "<BR>\n";

}

 

if ( strlen( $ftpdirectory ) > 0 ) {

if (ftp_chdir($conn_id, $ftpdirectory )) {

echo "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n";

} else {

echo "Couldn't change directory on $ftpservername<BR>\n";

return false;

}

}

 

ftp_pasv ( $conn_id, true ) ;

// upload the file

$upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII );

 

// check upload status

if (!$upload) {

echo "$ftpservername: FTP upload is mislukt!<BR>\n";

return false;

} else {

echo "Uploaded " . $ftpsourcefile . " naar " . $ftpservername . " als " . $ftpdestinationfile . "<BR>\n";

}

 

// close the FTP stream

ftp_close($conn_id);

 

return true;

}

 

if (FTP_ENABLED)

ftp_file( "uploads.google.com", FTP_USERNAME, FTP_PASSWORD, $source_file, "", $destination_file);

 

//End FTP

 

 

// ---------

$etimer = explode( ' ', microtime() );

$etimer = $etimer[1] + $etimer[0];

echo '<p style="font-family: verdana; font-size:11px; margin:auto; text-align:center">';

printf( "Feed is gemaakt in: <b>%f</b> seconden.", ($etimer-$stimer) );

echo '</p>';

 

 

?>