Skip to content

Instantly share code, notes, and snippets.

@wridgers
Created August 14, 2011 11:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wridgers/1144802 to your computer and use it in GitHub Desktop.
Save wridgers/1144802 to your computer and use it in GitHub Desktop.
Converting a CubeCart install to a PrestaShop install. Part 2.
<?php
$source_database = 'dbname';
$source_server = 'dbserver';
$source_user = 'dbuser';
$source_pass = 'dbpass';
$source = mysql_connect( $source_server, $source_user, $source_pass );
mysql_select_db($source_database);
$result = mysql_query("SELECT productId, disabled, productCode, description, image, price, name, cat_id, stock_level, prod_metatitle, prod_metadesc, prod_metakeywords FROM `cubecart_inventory`;");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo "wget \"http://www.yourside.co.uk/images/uploads/".$row[4]."\" -O download.jpg";
echo "<br/>";
echo "./go.sh download.jpg ".$row[0];
echo "<br/>";
}
mysql_free_result($result);
mysql_close($source);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment