Notice: Undefined variable: portfolio in /home/sgcust5/public_html/sgcws_dev/wp-content/themes/circumference-lite-child/portfolio.php on line 7

Featured Project: Jacksonville Camera Club

The Jacksonville Camera Club's original website was outdated and lacked several key features, so the club hired me to build a new database-driven website from the ground up. This was a large project that required many custom-coded features including an online digital contest system and a club member point balance tracking system.

The new site is powered by WordPress and uses the 2011 theme as the foundation of the visual layout. I modified this theme significantly with custom designed images, JQuery, CSS, and HTML to create the club's desired look.

The back-end functionality was developed using PHP programming with a MySQL database. This entailed writing software to warehouse and manage club data such as meeting minutes, newsletters, digital contests, member galleries, member point balances, and more. The site also includes a large administrative section with multiple user roles and permissions.

Please click on any of the thumbnails below to learn more about the work involved in creating this system.

Web Design
Description: The WordPress 2011 theme was used as the foundation of the new look. HTML, CSS, and custom images were then added to achieve the unique look JCC envisioned.

Skills: HTML, CSS, graphic design

Digital Contest Entries

Description: A custom HTML web form, jquery scripts, and PHP programming were used to build a page for creating/updating a new contest.

Logic was applied to connect a new contest to a new gallery provided by the NextGen Gallery plugin. Database programming was used to store contest information in the MySQL database.

Skills: HTML, CSS, JQuery, PHP, MySQL
Digital Contest Entries

Description: A custom HTML web form, jquery scripts, and PHP programming were used to build a page for creating/updating a new contest.

Logic was applied to extract the image meta data and also ensure that certain contest criteria was met.

Skills: HTML, CSS, JQuery, PHP, MySQL
Digital Contest Voting

Description: A custom HTML web form and PHP programming were used to create a voting page for the digital contest.

Logic was applied to ensure that only judges see this page. Logic was also applied to create a dynamic voting drop down box that showed a 4th place and up to five Honor placements if the number of entries warranted it.

Skills: HTML, CSS, PHP, MySQL
Digital Contest Submission

Description: A page was created for displaying contestant entries, judge comments, and image meta data. Logic was applied using PHP programming to ensure that contest results were not shown until a specified date. Database queries were used to retrieve the stored information.

Skills: HTML, CSS, PHP, MySQL

Custom Login
Description: The standard WordPress login and registration screens were customized to match the JCC website design. A custom-designed logo was added above the input fields, and a JCC member notification message was added above the registration fields. A plugin was installed and used to add several additional fields not provided by WordPress that the camera club needed.

Skills: HTML, CSS, PHP, graphic design
Custom Registration

User Role Management System
Description: A JCC user role system was created to extend the default WordPress roles and capabilities to match JCC administrative roles such as Contest Chair and Point Balance Admin.

A custom HTML web form was created to allow the webmaster to assign or remove access to various administrative sections of the system for any given user.

Skills: HTML, PHP, WordPress function calls

NextGen Gallery Plugin Interface

Description: A user interface for the NextGen gallery plugin was created to allow club members to manage their individual NextGen galleries with limited administrative permissions.

A custom HTML web form and PHP programming were used to build a page where club members could upload, modify, and delete personal gallery photos.

Skills: HTML, CSS, JQuery, PHP, MySQL
NextGen Gallery Plugin Interface

Description: A custom web form and PHP programming was used to create a page where club members could preview various gallery style settings offered by the NextGen plugin and save the desired setting as their gallery's style.

Skills: HTML, CSS, PHP, MySQL
NextGen Gallery Plugin Interface

Description: A gallery display page was created where the NextGen gallery of any member or club contest could be selected from a dropdown menu and viewed.

Skills: HTML, CSS, JQuery, PHP, MySQL

Point Balance System

Description: A content management tool for searching and filtering club point balance data was created using a custom web form, Javascript, and JQuery.

Skills: PHP, JQuery, Javascript
Point Balance System

Description: A page for viewing, updating, and deleting the club's point balance data was created using custom HTML web forms and CSS. Database queries were used to retrieve and modify the data.

Skills: HTML, PHP, MySQL
Point Balance System

Description: A point assignment page was created to allow the point balance chair to quickly and easily assign points for various categories such as digital competition winners. This point data is then stored in the database using SQL statements.

Skills: HTML, CSS, PHP, MySQL
Point Balance System

Description: A member point assignment page was created to allow individual club members to easily log their meeting, outing, and annual banquet attendance to receive the commensurate points. This point data is then stored in the database using SQL statements.

Skills: HTML, CSS, PHP, MySQL
Point Balance System

Description: A point balance display page was created to show a member's points by category as well as the category and grand total points accumulated.

Skills: HTML, CSS, PHP, MySQL
"Sarah has been my rock throughout our time working together. Her prompt response to each of my emails is impressive. She either has the answer and fix right away or lets me know she will find the answer and does so with the time limit she sets. I love Sarah's way of explaining each detail so I can understand. The tutorials she has made for each step of building our site and the tutorials the members need for each page of the site has been so much help and totally outstanding".
- Jan Gemeinhardt, Jacksonville Camera Club Webmaster

Latest Project: Jacksonville Camera Club

The Jacksonville Camera Club's original website was outdated and lacked several key features, so the club hired me to build a new database-driven website from the ground up. This was a large project that required many custom-coded features including an online digital contest system and a club member point balance tracking system.

The new site is powered by WordPress and uses the 2011 theme as the foundation of the visual layout. I modified this theme significantly with custom designed images, JQuery, CSS, and HTML to create the club's desired look.

The back-end functionality was developed using PHP programming with a MySQL database. This entailed writing software to warehouse and manage club data such as meeting minutes, newsletters, digital contests, member galleries, member point balances, and more. The site also includes a large administrative section with multiple user roles and permissions.

Please click on any of the thumbnails below to learn more about the work involved in creating this system.

Web Design
Description: The WordPress 2011 theme was used as the foundation of the new look. HTML, CSS, and custom images were then added to achieve the unique look JCC envisioned.

Skills: HTML, CSS, graphic design
Digital Contest Entries

Description: A custom HTML web form, jquery scripts, and PHP programming were used to build a page for creating and updating a new contest.

Logic was applied to connect a new contest to a new gallery provided by the NextGen Gallery plugin. Database programming was used to store contest information in the MySQL database.

Skills: HTML, CSS, JQuery, PHP, MySQL
Digital Contest Entries

Description: A custom HTML web form, jquery scripts, and PHP programming were used to build a page for uploading images and entrant information to an open digital contest.

Logic was applied to extract the image meta data and also ensure that certain contest criteria was met.

Skills: HTML, CSS, JQuery, PHP, MySQL
Digital Contest Voting

Description: A custom HTML web form and PHP programming were used to create a voting page for the digital contest.

Logic was applied to ensure that only judges see this page. Logic was also applied to create a dynamic voting drop down box that showed a 4th place and up to five Honor placements if the number of entries warranted it.

Skills: HTML, CSS, PHP, MySQL
Digital Contest Submission

Description: A page was created for displaying contestant entries, judge comments, and image meta data. Logic was applied using PHP programming to ensure that contest results were not shown until a specified date. Database queries were used to retrieve the stored information.

Skills: HTML, CSS, PHP, MySQL
Custom Login
Custom Registration
Description: The standard WordPress login and registration screens were customized to match the JCC website design. A custom-designed logo was added above the input fields, and a JCC member notification message was added above the registration fields. A plugin was installed and used to add several additional fields not provided by WordPress that the camera club needed.

Skills: HTML, CSS, PHP, graphic design
User Role Management System
Description: A JCC user role system was created to extend the default WordPress roles and capabilities to match JCC administrative roles such as Contest Chair and Point Balance Admin.

A custom HTML web form was created to allow the webmaster to assign or remove access to various administrative sections of the system for any given user.

Skills: HTML, PHP, WordPress function calls
NextGen Gallery Plugin Interface

Description: A user interface for the NextGen gallery plugin was created to allow club members to manage their individual NextGen galleries with limited administrative permissions.

A custom HTML web form and PHP programming were used to build a page where club members could upload, modify, and delete personal gallery photos.

Skills: HTML, CSS, JQuery, PHP, MySQL
NextGen Gallery Plugin Interface

Description: A custom web form and PHP programming was used to create a page where club members could preview various gallery style settings offered by the NextGen plugin and save the desired setting as their gallery's style.

Skills: HTML, CSS, PHP, MySQL
NextGen Gallery Plugin Interface

Description: A gallery display page was created where the NextGen gallery of any member or club contest could be selected from a dropdown menu and viewed.

Skills: HTML, CSS, JQuery, PHP, MySQL
Point Balance System

Description: A content management tool for searching and filtering club point balance data was created using a custom web form, Javascript, and JQuery.

Skills: PHP, JQuery, Javascript
Point Balance System

Description: A page for viewing, updating, and deleting the club's point balance data was created using custom HTML web forms and CSS. Database queries were used to retrieve and modify the data.

Skills: HTML, PHP, MySQL
Point Balance System

Description: A gallery display page was created where the NextGen gallery of any member or club contest could be selected from a dropdown menu and viewed.

Skills: HTML, CSS, JQuery, PHP, MySQL
Point Balance System

Description: A member point assignment page was created to allow individual club members to easily log their meeting, outing, and annual banquet attendance to receive the commensurate points. This point data is then stored in the database using SQL statements.

Skills: HTML, CSS, PHP, MySQL
Point Balance System

Description: A point balance display page was created to show a member's points by category as well as the category and grand total points accumulated.

Skills: HTML, CSS, PHP, MySQL
"Sarah has been my rock throughout our time working together. Her prompt response to each of my emails is impressive. She either has the answer and fix right away or lets me know she will find the answer and does so with the time limit she sets. I love Sarah's way of explaining each detail so I can understand. The tutorials she has made for each step of building our site and the tutorials the members need for each page of the site has been so much help and totally outstanding".
- Jan Gemeinhardt, Jacksonville Camera Club Webmaster



Have a question about my web development services? You can contact me using the web inquiry form below, or request a free quote here.