phpYellow Pages Developer's Guide

Install

If you are reading this from the packaged distribution file this page could be out of date. Browse Dreamriver's most recent online documentation.

Quick Start - how to install quickly
Create Table Definitions - FYI - for reference only
Potential Revenue - earn with phpYellow Pro
Other Software and Resources - more free and retail resources
Support - obtain support for a dreamriver product

Quickstart

Any Install - New, Upgrade or Lite to Pro

download phpyellow^TM from Dreamriver.com
unzip all files to your local machine
browse /phpyellow/install.html with your browser

This is install.html
follow the directions by browsing /phpyellow/install.html with your browser

Create Table Definition - MySQL Database Only

This definition is for your archive. You don't need to do anything with it - it's FYI.


# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: secret
# Generation Time: Sep 23, 2002 at 10:36 AM
# Server version: 3.23.51
# PHP Version: 4.2.3
# Database : `secret`
# --------------------------------------------------------

#
# Table structure for table `pycontact`
#

CREATE TABLE pycontact (
  customerid mediumint(9) unsigned NOT NULL auto_increment,
  password varchar(15) NOT NULL default 'password',
  email varchar(80) default NULL,
  organization varchar(45) default NULL,
  firstname varchar(35) default NULL,
  lastname varchar(45) default NULL,
  address varchar(70) default NULL,
  city varchar(25) default NULL,
  stateprov varchar(25) NOT NULL default '',
  country varchar(40) NOT NULL default 'United States',
  postalcode varchar(10) default NULL,
  areacode varchar(7) default NULL,
  phone varchar(20) default NULL,
  fax varchar(20) default NULL,
  cellphone varchar(20) default NULL,
  website varchar(140) default NULL,
  imagecompany varchar(120) default NULL,
  lastupdate timestamp(14) NOT NULL,
  customersince date default NULL,
  visits int(4) unsigned default NULL,
  role varchar(30) default NULL,
  privacy enum('low','medium','high') default 'medium',
  news enum('yes','no') NOT NULL default 'no',
  newsformat enum('plain','html') default NULL,
  PRIMARY KEY  (customerid,customerid,customerid),
  KEY stateprovidx (stateprov(15)),
  KEY countryidx (country(20)),
  FULLTEXT KEY wholesite (organization,firstname,lastname,address,city,stateprov,country,postalcode,areacode,website,role)
) TYPE=MyISAM;



# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: secret
# Generation Time: Sep 23, 2002 at 10:35 AM
# Server version: 3.23.51
# PHP Version: 4.2.3
# Database : `secret`
# --------------------------------------------------------

#
# Table structure for table `pycategory`
#

CREATE TABLE pycategory (
  ckey int(9) unsigned NOT NULL auto_increment,
  fkcustomerid mediumint(9) unsigned NOT NULL default '0',
  category varchar(80) NOT NULL default 'other',
  description mediumtext,
  rank tinyint(1) unsigned NOT NULL default '0',
  paymentrequired enum('yes','no') default 'no',
  status enum('pending','approved','expired') default 'approved',
  expires date default NULL,
  lastupdate timestamp(14) NOT NULL,
  image2 varchar(120) default NULL,
  image3 varchar(120) default NULL,
  PRIMARY KEY  (ckey),
  KEY catidx (category(15)),
  FULLTEXT KEY description (description)
) TYPE=MyISAM;

Cash is good. Upgrade to a Pro Edition and earn some by charging for the position of listings on YOUR pages. YOU set the rate you charge your customers. phpYellow Pro lets you easily set the page position of any listing, and comes with a wide range of feature rich benefits.

More Info?

For the website owner:

DreamRiver Software Archive
For the advertiser: See improveMyListing.php.
For the webmaster: Insta-Pay^TM

Other Software Products - and resources

Check out our software page for more free and retail Dreamriver.com software products. We've recently added some new free resources - PHP 'how to' articles. There are new products "in the pipeline" and coming soon! Why not subscribe to our infrequent newsletter to help stay informed and get the most out of your software?

http://www.dreamriver.com

??? Support ???

Obtain support for a Free OR Pro version by contacting DreamRiver.

Thank you for your interest in DreamRiver products.