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. <\/p>\r\n\r\n

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.<\/p>\r\n\r\n

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.<\/p> \r\n\r\n

Please click on any of the thumbnails below to learn more about the work involved in creating this system.<\/p><\/div>\r\n\r\n

\r\n\r\n\r\n\r\n

\r\n \r\n\t \r\n Web Page Design<\/span><\/a>\r\n\t\t <\/div> \r\n Web Page Design<\/span><\/div> \r\n\t<\/li>\r\n\t \r\n Digital Contest System<\/span><\/a>\r\n\t\t <\/div> \r\n Digital Contest System<\/span><\/div> \r\n\t<\/li>\r\n\t \r\n\t\tCustom Login & Registration<\/span><\/a>\r\n\t\t <\/div>\r\n Custom Login & <\/span>Registration<\/span><\/div> \r\n <\/li>\r\n\t \r\n\t\tUser Role System<\/span><\/a>\r\n\t\t <\/div>\r\n User Role System<\/span><\/div> \r\n\t<\/li>\r\n \r\n\t\tNextGen Gallery Plugin User Interface<\/span><\/a>\r\n\t \t <\/div> \r\n NextGen Gallery Plugin <\/span>User Interface<\/span><\/div> \r\n\t<\/li>\r\n \r\n\t\tPoint Balance System<\/span><\/a>\r\n\t \t <\/div> \r\n Point Balance System<\/span><\/div> \r\n\t<\/li>\r\n<\/ul>\r\n<\/td><\/tr>\r\n

\r\n \r\n <\/div>\r\n \r\n \r\n \r\n <\/div>\r\n Description:<\/b> 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:<\/b> HTML, CSS, graphic design<\/div>\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n\r\n \r\n <\/div>\r\n \r\n \r\n \r\n \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/div>\r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/div>\r\n\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div>\r\n\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div>\r\n\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n\r\n \r\n <\/div>\r\n \r\n \r\n \r\n <\/div>\r\n Description:<\/b> 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:<\/b> HTML, CSS, PHP, graphic design<\/div>\r\n <\/div>\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n\r\n \r\n <\/div>\r\n \r\n \r\n \r\n <\/div>\r\n Description:<\/b> 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.<\/i> Skills:<\/b> HTML, PHP, WordPress function calls<\/div>\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n\r\n \r\n <\/div>\r\n \r\n \r\n \r\n \r\n Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/div><\/div>\r\n\r\n Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div><\/div>\r\n\r\n Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/div><\/div>\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n\r\n \r\n <\/div>\r\n \r\n \r\n \r\n \r\n \r\n <\/div> Description:<\/b> A content management tool for searching and filtering club point balance data was created using a custom web form, Javascript, and JQuery. Skills:<\/b> PHP, JQuery, Javascript<\/div>\r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, PHP, MySQL<\/div>\r\n\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div> \r\n\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div>\r\n\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/div> \r\n\r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n <\/div> \r\n<\/td><\/tr>\r\n<\/table>\r\n<\/div>\r\n \r\n \"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\". \r\n - Jan Gemeinhardt, Jacksonville Camera Club Webmaster<\/div>\r\n<\/div>\r\n\r\n<\/div> \r\n\r\n \r\n\r\n \r\n Latest Project: Jacksonville Camera Club<\/h2><\/div>\r\n \r\n \r\n <\/div><\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n 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. <\/p>\r\n\r\n 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.<\/p>\r\n\r\n 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.<\/p> \r\n\r\n Please click on any of the thumbnails below to learn more about the work involved in creating this system.<\/p><\/div>\r\n\r\n \r\n\r\n \r\n Web Page Design<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n <\/div>\r\n <\/div>\r\n Description:<\/b> 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:<\/b> HTML, CSS, graphic design<\/span>\r\n <\/div> \r\n<\/div> \r\n <\/div>\r\n \r\n Digital Contest System<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n \r\n <\/div>\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/span>\r\n <\/div> \r\n\r\n <\/div> \r\n<\/div> \r\n <\/div>\t\r\n\r\n \r\n Custom Login & Registration<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n \r\n <\/div>\r\n <\/div> <\/div>\r\n <\/div>\r\n Description:<\/b> 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:<\/b> HTML, CSS, PHP, graphic design<\/span>\r\n <\/div>\r\n <\/div> \r\n<\/div> \r\n <\/div>\t\r\n\r\n \r\n User Role Mgmt System<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n \r\n <\/div>\r\n <\/div>\r\n Description:<\/b> 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.<\/i> Skills:<\/b> HTML, PHP, WordPress function calls<\/span>\r\n <\/div>\r\n <\/div> \r\n<\/div> \r\n <\/div>\t\r\n\r\n \r\n NextGen Gallery Plugin User Interface<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n \r\n <\/div>\r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/span>\r\n <\/div> \r\n\r\n <\/div> \r\n<\/div> \r\n <\/div>\t\r\n\r\n \r\n Point Balance System<\/span><\/a>\t \r\n<\/div>\r\n \r\n \r\n \r\n <\/div>\r\n <\/div> Description:<\/b> A content management tool for searching and filtering club point balance data was created using a custom web form, Javascript, and JQuery. Skills:<\/b> PHP, JQuery, Javascript<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, JQuery, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/span>\r\n <\/div> \r\n \r\n <\/div> Description:<\/b> 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:<\/b> HTML, CSS, PHP, MySQL<\/span>\r\n <\/div> \r\n\r\n <\/div> \r\n<\/div> \r\n<\/div> \r\n\r\n \r\n \"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\". \r\n - Jan Gemeinhardt, Jacksonville Camera Club Webmaster<\/div>\r\n<\/div>\r\n<\/div> \r\n Have a question about my web development services? You can contact me using the web inquiry form below, or request a free quote here<\/b><\/a>.<\/i><\/p>\r\n\r\n[my_portfolio]","protected":false},"excerpt":{"rendered":"[my_portfolio]","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/page-full-width.php","meta":[],"yoast_head":"\n