A Rolodex Called Subscription


I’ll give you a copy of my database (gxsam11_SAMEH_R_LABIB_LLC).

Playing with existing site will give you an idea of how existing form elements look. I have prepared a zip file for this called sameh_website.zip. You will need to:

  • redirect HTTP requests to the directory called: web
  • register an account named administrator (case insensitive)
  • edit the include script which logs into the database

You will add a top menu item to the left navigation bar. Call it Subscription. Its menu sub-items will be the links to the scripts below.

Every step in the script will display the step number at the top. I.e. Step One, Step Two, Step Three, etc.

Any page content, other than the form itself, must appear below the form.

Display on step two and beyond the name of the subscription so that the user doesn’t forget which subscription is being dealt with.

Make all strings in the HTML which relate to *required with the same CSS class used in the rest of the forms in my web site so its font will appear blue. Use span tag. Class is formcomment

Any time a database table column is text we are losing the line-feeds and whitespace in the formatting of its display. Put this data in some HTML tag which preserves text formatting.

Every piece of data in the subscription database table is there for a reason. It must get used for its intended purpose.

Use OOP whenever possible.

We are going to be using PDO (PHP Database Object — a PHP built-in class) for database interactions.

Consider this post (about what I look for during a QA check) on my blog: https://samehramzylabib.wordpress.com/2012/04/09/qa-test-what-i-look-for/


  • View Subscription
  • Delete Subscription
  • Add Subscription
  • Modify Subscription
  • Delete Field
  • Add Field
  • Modify Field
  • Create Association
  • Remove Association

View Subscription

  1. User *chooses a subscription.
  2. Browser displays a well formatted and categorized display of all fields related to the
    subscription which the user has chosen. Also, display all tags associated with the subscription. And, URLs appear as hyperlinks.

* Scripts which assist user in selecting a subscription, require the first JavaScript/jQuery based drop down to narrow choices for the second drop down. Emphasis: Dynamically generate second drop down. The first drop-down is populated with existing Tag-it! tags.

Delete Subscription

  1. User chooses a subscription.
  2. Ask to confirm deletion.
  3. Delete the subscription.

Add Subscription

  1. User supplies a name for the new subscription.
  2. User adds tags for the subscription. User can choose an existing tag or create a new one.
  3. Create the database record for the subscription.
  4. Add any newly specified tag to the database.

I believe the functionality of Tag-it is to:

  • Create new tag for subscription.
  • Associate established tag with subscription.

Modify Subscription

  1. User chooses a subscription.
  2. Allow user to modify the name of the subscription.
  3. Allow user to add tags for the subscription.
  4. Allow user to remove tags for the subscription.
  5. Allow user to create new tags.
  6. Update the database.

Delete Field

  1. User chooses a subscription.
  2. User chooses a subscription field.
  3. Ask to confirm deletion.
  4. Delete the field from the database.

Add Field

  1. User chooses a subscription.
  2. User chooses the type of subscription field.
  3. User supplies field data.
  4. Add database record for the field.

Modify Field

  1. User chooses a subscription.
  2. User is presented with a view of the subscription with buttons to allow for making a selection of the field to be modified.
  3. User is presented with modifiable text in a form.
  4. New field data gets stored in the database.

Create Association

Remove Association


About samehramzylabib

See About on https://samehramzylabib.wordpress.com
This entry was posted in Freelancing Work. Bookmark the permalink.


Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s