Datafeed-to-MySQL from PHPmill: Example Usage

Products

	Datafeed-to-MySQL
	PHPmill Webmaster Tools

Forums

About

Client List

PHP Resources

PHPmill » Products » Datafeed-to-MySQL » Example Usage

Datafeed-to-MySQL

Turn this datafeed:

product_url	name	description	price	image_url	category	offer_id
http://www.testurl.com/product_info/auto-emergency-kit-1.html	Auto Emergency Kit	"The Urban Road Warrior 19 piece auto emergency kit fits most all road emergency situations. All items are packed in a heavy-duty backpack.

This 19 Piece Auto Emergency Kit contains: 
– 30 Minute High-Intensity Light Stick 
– Tow Rope (14') 
– Auto Spot Light 
– Jumper Cables 
– First Aid Kit 
– Flashlight with Batteries 
– Fire Extinguisher 
– Solar Blanket 
– Waterproof Poncho 
– Swiss Style Army Knife 
– Flat Tire Fixer 
– Drinking Water 
– Leather Gloves 
– Whistle 
– Duct Tape 
– Utility Knife 
– Emergency Instructions and Help Sign 
– Wet Naps Hand Cleaner.
 The 19 piece Urban Road Warrior is our most popular auto emergency kit."	69.95	http://www.testurl.com/images/products/aa01_s.jpg	Emergency Kits	1
 
http://www.testurl.com/product_info/flat-tire-fixer-12-oz-2.html	Flat Tire Fixer - 12 oz.	Fix-A-Flat® was the first brand of tire inflators and remains the leading tire inflator in the industry. People who carry Fix-A-Flat® know that they are carrying a product that gets them back on the road quickly and safely in a matter of minutes.	4.95	http://www.testurl.com/images/products/aa21_s.jpg	Automobile > Emergency Supplies	2

http://www.testurl.com/product_info/tow-rope-tows-up-to-6500-lbs-3.html	"Tow Rope"	"– Tows up to 6500 lbs.	
 – Poly Braid Extra Super Strength 
 – Super strong, light weight 
 – Stronger than chain
 – 14' length 
 – Excellent stretch to absorb sudden shock
 – Heavy duty forged hooks and plastic guards 
 – 100% rot resistant and handy to store 
 – Ideal for car owners, boat owners, farmers, or anyone who needs a tow"	6.95	http://www.testurl.com/images/products/aa23_s.jpg	Automobile > Emergency Supplies	3

http://www.testurl.com/product_info/battery-jumper-cables-4.html	Battery Jumper Cables	Automobile battery jumper cables. It's a good idea to keep a set of jumper cables in your car at all times "Keeping you charged!"	6.95	http://www.testurl.com/images/products/aa55_s.jpg	Automobile > Emergency Supplies	4

Into this MySQL:

DROP TABLE IF EXISTS `feed_testurl`;
CREATE TABLE `feed_testurl` (`product_url` text NOT NULL,`name` text NOT NULL,`description` text NOT NULL,`price` text NOT NULL,`image_url` text NOT NULL,`category` text NOT NULL,`offer_id` text NOT NULL) TYPE=MyISAM;
INSERT INTO `feed_testurl` VALUES ('http://www.testurl.com/product_info/auto-emergency-kit-1.html','Auto Emergency Kit','The Urban Road Warrior 19 piece auto emergency kit fits most all road emergency situations. All items are packed in a heavy-duty backpack. This 19 Piece Auto Emergency Kit contains: – 30 Minute High-Intensity Light Stick – Tow Rope (14\') – Auto Spot Light – Jumper Cables – First Aid Kit – Flashlight with Batteries – Fire Extinguisher – Solar Blanket – Waterproof Poncho – Swiss Style Army Knife – Flat Tire Fixer – Drinking Water – Leather Gloves – Whistle – Duct Tape – Utility Knife – Emergency Instructions and Help Sign – Wet Naps Hand Cleaner. The 19 piece Urban Road Warrior is our most popular auto emergency kit.','69.95','http://www.testurl.com/images/products/aa01_s.jpg','Emergency Kits','1');
INSERT INTO `feed_testurl` VALUES ('http://www.testurl.com/product_info/flat-tire-fixer-12-oz-2.html','Flat Tire Fixer - 12 oz.','Fix-A-Flat® was the first brand of tire inflators and remains the leading tire inflator in the industry. People who carry Fix-A-Flat® know that they are carrying a product that gets them back on the road quickly and safely in a matter of minutes.','4.95','http://www.testurl.com/images/products/aa21_s.jpg','Automobile > Emergency Supplies','2');
INSERT INTO `feed_testurl` VALUES ('http://www.testurl.com/product_info/tow-rope-tows-up-to-6500-lbs-3.html','Tow Rope','– Tows up to 6500 lbs.	 – Poly Braid Extra Super Strength  – Super strong, light weight  – Stronger than chain – 14\' length  – Excellent stretch to absorb sudden shock – Heavy duty forged hooks and plastic guards  – 100% rot resistant and handy to store  – Ideal for car owners, boat owners, farmers, or anyone who needs a tow','6.95','http://www.testurl.com/images/products/aa23_s.jpg','Automobile > Emergency Supplies','3');
INSERT INTO `feed_testurl` VALUES ('http://www.testurl.com/product_info/battery-jumper-cables-4.html','Battery Jumper Cables','Automobile battery jumper cables. It\'s a good idea to keep a set of jumper cables in your car at all times \"Keeping you charged!\"','6.95','http://www.testurl.com/images/products/aa55_s.jpg','Automobile > Emergency Supplies','4');

Which will form the database table:
NOTE: Datafeed-to-MySQL does not display the table as shown. You must use database managment software such as phpMyAdmin to view the table as shown below.

product_url	name	description	price	image_url	category	offer_id
http://www.testurl.com/...	Auto Emergency Kit	The Urban Road Warrior 19 piece auto emergency kit...	69.95	http://www.testurl.com/...	Emergency Kits	1
http://www.testurl.com/...	Flat Tire Fixer - 12 oz.	Fix-A-Flat® was the first brand of tire inflators ...	4.95	http://www.testurl.com/...	Automobile > Emergency Supplies	2
http://www.testurl.com/...	Tow Rope	– Tows up to 6500 lbs. – Poly Braid Extra Super S...	6.95	http://www.testurl.com/...	Automobile > Emergency Supplies	3
http://www.testurl.com/...	Battery Jumper Cables	Automobile battery jumper cables. It's a good idea...	6.95	http://www.testurl.com/...	Automobile > Emergency Supplies	4

Price: $39.99 USD

Datafeed-to-MySQL Description | Interactive Demo | License | Product Forum | DOWNLOAD

* See License Agreement for full details

Other Great Products from PHPmill

PHPmill Webmaster Tools
Requirements: PHP > 4.0
Add customizable webmaster tools to your website. Tools include DNS, Reverse DNS, HTTP Header Lookup, Keyword Density, Spider Simulator.
Price: FREE or $39.95 | Interactive Demo | Pro Version License | Free Version License

Proudly serving quality US-Made PHP scripts since 2001

Custom PHP Scripts