Closed

Landing Page and Custom PHP Data Module in Joomla

Goal:

There are two goals for this project:

1. Model landing page that allows me to easily create individual registration pages for each sponsor.

2. Display MySQL data from a table into a custom HTML module in Joomla

Model Landing Page Details

Form code needs to be provided that can be added to a landing page so data is posted to the ezs_users table in MySQL. The existing fields for the Joomla registration page are satisfactory. You will also be adding one hidden field to record the sponsor's ID number as in <input type="hidden" name="sponsor" value="XXXXXXXXXX" /> where the X's reflect the ID number to be added by me as I create each landing page.

You need only create the code as it pertains to the form and its processing (<form></form>) as well as anything in the HEADER that is needed. I will create the remainder of the landing page myself (I can also revise the form layout as needed so you needn't spend a lot of time on that either). I can't find where to make the changes to the registration form or I could probably figure this out myself.

NOTE: If recommended I can host all of the landing pages on my server but prefer a method where they are be placed in another person's website.

Display MySQL Data

This desired result is to display sponsor data in a Joomla template from the ezs_sponsors table based on a foreign key found in the ezs_users table. You need only create the PHP code as it pertains to the display of such data. I will insert the code into a custom HTML module to determine its position in my Joomla template. Fields (enclosed by { }) are as follows:

NOTE: Line Breaks unless <p> tag is used

{tagline}

{picture} Note: Link to a file on the server

{firstname} {lastname}

<p></p>

Cell: {cell}

E-mail: {email} Note: Display as a hyperlink going to mailto: {email}

<p></p>

Logo Note: Link to a file on the server

*** The following company information can be entered into the ezs_sponsors table or into the ezs_companies table ***

{company}

<p></p>

Office: {phone}

Fax: {fax}

{address}

{city} (space) {st} (two spaces) {zip}

*** See above ***

<p></p>

Website: {website} Note: Display as a hyperlink going to the HTTP address as a new window (_blank target)

*** I don't object to placing the website into ezs_sponsors since the link will usually go to a person's direct page ***

NOTE: If a particular field is blank, the entire line should be deleted - as in no fax number.

Other Things:

Ideally, to normalize my data I should create a third table ezs_companies to record data about each sponsor's employer. In this way, each user would have one sponsor and each sponsor would work for one company. While this would increase the complexity of the JOIN clause it would make it easier to update records later. For example. we could easily change the address for every sponsor working at a particular company in the esz_companies table when it moves rather than doing it one at a time in the ezs_sponsors table. If this wouldn't impact the bid greatly I did create the ezs_companies table and placed a companyid field as a foreign key in the ezs_sponsors table.

You will be provided with a superuser account login for Joomla, FTP account for the website and system account with all privileges for the MySQL [url removed, login to view] last vendor I used wanted my cPanel login. HostGator told me not to provide someone with my cPanel login.

Thanks,

Mark

Skills: MySQL, PHP

See more: working target, value city, time complexity code, time complexity, php find person, one key data, office layout company, note page, mark fields, make create page logo, make picture, login php code mysql, login page create php, joomla one page template, ftp server zip, foreign website company, find someone create logo, find php website, find page, find custom logo, data host, custom logo company, custom code joomla, create table php, create sponsor logo

About the Employer:
( 0 reviews ) Wesley Chapel, United States

Project ID: #1145048

4 freelancers are bidding on average $82 for this job

Visionary009

Hello sir, I have expertise in PHP and MySQL. Kindly check PM.

$50 USD in 2 days
(11 Reviews)
3.8
joomlaexpert4yrs

Please check PMB.

$80 USD in 2 days
(20 Reviews)
3.8
icoresystem

I have 8+ years of experienced. presently we start a project on like ebay, which is under construction. kindly see www.newegg.com & www.scan.co.uk these two websites full feature are there. I design & developed the who More

$99 USD in 1 day
(0 Reviews)
0.0
Arrinsolution

Hello, Yes, Our in house technical team of experts can assist you on all kind of web development verticals. We have expertise in PHP, WordPress, Joomla, Photoshop, e-commerce based applications. Few of our b More

$100 USD in 12 days
(0 Reviews)
0.0