PHPmill -- Custom PHP Scripts
PHP | mill -- Datafeed-to-MySQL v. 2.11 DEMO

Products
  Datafeed-to-MySQL
  PHPmill Webmaster Tools
Forums
About
Client List
Contact Us
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 » Interactive Demo
INSTRUCTIONS:
  1. Datafeed-to-MySQL version 2.11 DEMO.
  2. Input up to 20 rows of your datafeed in the large textbox below. Maximum of 24000 bytes allowed. (DEMO ONLY)
  3. Fill out the form below and submit. Required fields are shown in red. Demo-disabled fields are shown in gray.
  4. Your SQL feed will be created and shown to you on the next screen (maximum of 20 rows in demo version.)
  5. If you do not know what to input for the optional fields, leave them AS-IS. Try adjusting them if errors result.
  6. For support, comments, suggestions, or bug reports visit our online forums.
Price: $39.99 USD


FEED FORM:
Data to Parse:
characters remaining
Text box does not appear in standard version.
Enter up to 20 complete rows of data, max 24000 bytes (DEMO ONLY).
Feed Filename: e.g. myfeed.txt
Delimiter: TAB
COMMA ,
PIPE |
SEMI-COLON ;
COLON :
STAR *
TILDE ~
Which character separates the columns in your feed?
First Row: Use for MySQL column names.
It contains the first row of data.
Delete it.
How do you want the top row of the feed handled?
Error Handling: FIX
DELETE
Fix or delete rows that contain the wrong number of columns?
Auto-Increment
ID Column:
YES
NO
Would you like to include an auto-increment column as the first column of the MySQL table?
SQL Execution: No, generate SQL file only.
Yes, execute the SQL on the database.
Do you want to create the MySQL table or just the SQL file?
Line Breaks: YES
NO
Would you like to allow line breaks within a row?
Table Name: Optional: Input a name for the MySQL table generated.
Custom Replacement:
Find
Replace
Optional: Performs a find and replace throughout the file. cAsE-sEnSiTiVe
Fields Enclosed By: Optional: Beginning and ending character that encloses a column. Remove this character if it is not used by your feed.
Fields Escaped By: Optional: Character used to escape an enclosing character that is non-enclosing. Remove this character if it is not used by your feed.
Your IP Address: (Logged for security, demo only.)
Tip: if you often execute the same values in the form above, you can set them as defaults in the configure.php file.
Tip: using the wrong settings may cause numerous errors. Be sure to examine the feed to determine the proper values to enter above.

Reload this page | Logout and Start Over
Runtime: 0.0000 second.


Price: $39.99 USD
PHPmill

Copyright © 2005 PHPmill, All Rights Reserved

Custom PHP Scripts