Closed

Form - Add event and modify event - Ajax Php Mysql

This project received 9 bids from talented freelancers with an average bid price of $142 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

I need a page to ADD an event and another to MODIFY the event. You will find the structure of the table.
It is not necessairy to be in AJAX, but it must to be USER FRIENDLY, CLEAN and FAST.

I process must be in 4 step.
1- Choose what type of event ( Category / Venue or adresse of this event )
2- add all stuff
3- add one or 2 flyer about this event.
4- choose your package and buy it with paypal

The user must be able to do NEXT or BACK while the process.
At the end of the form, the user must select the options that wish to add to its event.
Package: Gold, Silver, Bronze --> POSITION(0,1,2)
It will also check on sites that want to display.
Under these options the price will vary and following the user can pay with paypal.

The addition of data must be filtered to be safe

The text in the MANIF (title), DESCRIPTION and ENTREE (cover fee) must be clean and no HTML code.


CREATE TABLE IF NOT EXISTS `event` (
`id` int(10) NOT NULL AUTO_INCREMENT, -- Event ID
`manif` varchar(128) NOT NULL DEFAULT '', -- EVENT TITLE
`nickname` varchar(200) DEFAULT NULL, -- PERMALINK
`keywords` varchar(200) DEFAULT NULL, -- TAG ex: event, tag, city, something
`date_deb` datetime DEFAULT NULL, -- beginning datetime
`date_fin` datetime DEFAULT NULL, -- Ending datetime
`adresse` varchar(128) NOT NULL DEFAULT '', -- address and street
`ville` int(10) NOT NULL DEFAULT '0', -- city ID
`region2` int(10) NOT NULL DEFAULT '0', -- District ID
`province` int(10) NOT NULL DEFAULT '0', -- Province,Etat ID
`pays` int(11) NOT NULL DEFAULT '0', -- Country ID
`region` varchar(100) NOT NULL DEFAULT '', -- district name
`description` longtext NOT NULL, -- description of event
`entree` longtext NOT NULL, -- cover fee
`etat` int(2) NOT NULL DEFAULT '0', -- Status, 0 = not active
`categorie` smallint(3) NOT NULL DEFAULT '0', -- 0 = others,1 = club, 4 = concert, 8= show
`club` smallint(6) NOT NULL DEFAULT '0', -- venue ID 0=others
`guestlist` int(3) NOT NULL DEFAULT '0', -- 1 = guestlist available for the event, 2 = Ticket available for the event
`weekly` int(10) NOT NULL DEFAULT '0', -- Weekly event ID, if the event is each week
`position` smallint(1) NOT NULL DEFAULT '0', -- position on the result 0= Bronze 1=silver 2= Or
`site1` int(2) NOT NULL DEFAULT '0', -- Show event on website 1
`site2` int(2) NOT NULL DEFAULT '0', -- Show event on website 2
`site3` int(2) NOT NULL DEFAULT '0', -- Show event on website 3
`site4` int(2) NOT NULL DEFAULT '0', -- Show event on website 4
`autresite` int(2) NOT NULL DEFAULT '0', -- Show event on others website
`compteur` int(10) NOT NULL DEFAULT '0', -- number of view
`nom` varchar(128) NOT NULL DEFAULT 'vide', -- Contact name
`email` varchar(128) NOT NULL DEFAULT 'vide', -- Contact Email
`telephone` varchar(128) NOT NULL DEFAULT 'vide', -- contact telephone
`url` varchar(128) NOT NULL DEFAULT 'vide', -- URL of event
`user` int(10) NOT NULL DEFAULT '0', -- USER ID
`ip` varchar(15) DEFAULT NULL, -- IP of user
`date` datetime DEFAULT NULL, -- Now
PRIMARY KEY (`id`),
KEY `region` (`region`),
KEY `user` (`user`),
KEY `nickname` (`nickname`,`keywords`),
KEY `ville` (`ville`,`region2`,`province`,`pays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5901 ;

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online