Currency:
Thank you for shopping with us.
Pls. view cart if you have Coupon.

You have no items in your shopping cart.

You have no items to compare.

Search
eBusinessGems.com

phpLD v3.x v4.x Category SQL Dump for US States and Cities

phpLD v3.x v4.x Category SQL Dump for US States and Cities

Be the first to review this product

$0.00

In stock

This is a list of 6,300+ entries to categorize US states and cities to be used in a Php Link Directory (phpLD). The list is compatible with phpLD version 3.x to version 4.x.

Description

Details

This is a list of 6,300+ entries to categorize US states and cities to be used in a Php Link Directory (phpLD). The list is compatible with phpLD version 3.x to version 4.x. That is the list and associated SQL statements will work for all phpLinkDirectory versions from 3.0 to 4.1, versions in between and beyond (that is version 4.x). The categories come in the form of SQL script. The script is ready to be run on any SQL browser or tool such as MySQL query browser.

The list of categories can be installed either as a new category structure of a new php link directory or to append category structure of an existing php link directory.

The SQL script is a set of SQL INSERT commands that will automatically create the category structure for your brand new phpLD directory. All you need is to load the script contents on to your tool (e.g. MySQL QueryBrowser) script window and execute. The detail loading or installation instruction is included in the package.

Structure

Details

The list inserts values in the following fields of the phpld directory categiry table:

  • ID
  • TITLE
  • CACHE_TITLE
  • TITLE_URL
  • CACHE_URL
  • PARENT_ID
  • STATUS
  • META_KEYWORDS

Others

Additional Information

File Format MS Excel 2003 Spread Sheet, MySQL Script
Format Details

The SQL script is a set of SQL INSERT commands that will automatically create the category structure for your brand new phpLD directory. All you need is to load the script contents on to your tool (e.g. MySQL QueryBrowser) script window and execute. The detail loading or installation instruction is included in the package.

The Excel worksheet provided in the package is formula driven. The IDs of category can be started from 1 (for a new directory set up) or any sequence (to append the categories to an existing directory structure). It generates list as a set of SQL INSERT Command statements doing the following:

a) Insert records in the PLD_CATEGORY table
b) Instruction to insert a record in the PLD_CATEGORY_SEQ table

Keywords phpld, phpld4, category, categories, dump
Key Phrases us states and cities, us cities, phpld category dump, phpld4 categories, categories dump phpld, web directory categories, web directory, free categories dump
Specific Terms and Condition Unauthorized copying, distribution and use of this product is strictly prohibited. You can purchase and download this product from www.eBusinessGems.com. You can use this product for your own purpose. You are not entitled to resell it. If you find this product being distributed or sold from any other store, please immediately inform sales@eBusinessGems.com. Thank you.

Sample

Details

INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (197, 'Benson', 'Arizona: Benson', 'Benson', 'index.php?c=197', 4, 2, 'Benson');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (198, 'Bisbee', 'Arizona: Bisbee', 'Bisbee', 'index.php?c=198', 4, 2, 'Bisbee');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (199, 'Buckeye', 'Arizona: Buckeye', 'Buckeye', 'index.php?c=199', 4, 2, 'Buckeye');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (200, 'Bullhead City', 'Arizona: Bullhead City', 'Bullhead_City', 'index.php?c=200', 4, 2, 'Bullhead City');

Tags

Product Tags

Other people marked this product with these tags:

Use spaces to separate tags. Use single quotes (') for phrases.

Reviews

  1. Be the first to review this product

WRITE YOUR REVIEW

Write Your Own Review

Only registered users can write reviews. Please, log in or register