Datafeed-to-MySQL from PHPmill: Example Usage

Products

	Datafeed-to-MySQL
	PHPmill Webmaster Tools

Forums

About

Client List

PHP Resources

Tips & Tricks

Microsoft Outlook 2003 Thorconnwndclass error

Has Yahoo got it right?

PHP Wildcard Match in an Array

Wordpress PHP Code Display

MySQL Injection Attacks

Get users IP address with PHP

Find and Replace with MySQL

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