asked on
Simple php scripts for showing / adding /editing contents of database
I need a very simple script to show visitors to my page my upcoming events.
On the front end I need a php script that will read from a mysql database and show all upcoming scheduled classes. It should not show classes who's start date has already passed. This script will be inserted into a table in my index.html page and show up as an "Upcoming Events" module.
On the backend I need an interface that will allow me to input, edit or delete all relevant class information (detailed below). This interface should have a password control.
I'll also need a script to create the mysql database structure (I'll create the database itself).
Each record type should have it's own CSS tag so that its appearance can be controlled via the sites CSS file.
Class information:
Title
Start Date
Start Time
Brief Description (small text box)
Full Description (large text box)
Link (clicked to go to the buy page)
I'm not a programmer (at all) but know that this is all pretty simple stuff. If anyone could show me the way, I'd sure appreciate it! I need this kind of quick.
On the front end I need a php script that will read from a mysql database and show all upcoming scheduled classes. It should not show classes who's start date has already passed. This script will be inserted into a table in my index.html page and show up as an "Upcoming Events" module.
On the backend I need an interface that will allow me to input, edit or delete all relevant class information (detailed below). This interface should have a password control.
I'll also need a script to create the mysql database structure (I'll create the database itself).
Each record type should have it's own CSS tag so that its appearance can be controlled via the sites CSS file.
Class information:
Title
Start Date
Start Time
Brief Description (small text box)
Full Description (large text box)
Link (clicked to go to the buy page)
I'm not a programmer (at all) but know that this is all pretty simple stuff. If anyone could show me the way, I'd sure appreciate it! I need this kind of quick.
PHP
Last Comment
marglar
ASKER
Hey gamebits.
Sorry, I didn't mean to overstep any bounds. I was told it was a simple thing and I'd hoped someone would be able to help me out. I wish I had the time right now to learn php but that would be the straw that breaks the camels back (mind) for sure!
Thanks for what you've shared. Perhaps I'll get enough feedback to piece this thing together!
Sorry, I didn't mean to overstep any bounds. I was told it was a simple thing and I'd hoped someone would be able to help me out. I wish I had the time right now to learn php but that would be the straw that breaks the camels back (mind) for sure!
Thanks for what you've shared. Perhaps I'll get enough feedback to piece this thing together!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Have you considered going to Rent-A-Coder or Scriptlance to have someone create exactly what you need? As gamebits had stated, EE is more of a place to come when you need help wth already existing code. Most of us enjoy helping out as much as possible, but to actually write an entire application is far outside the reaches of the purpose of EE and it's members.
There are tons of good coders on those sites that could easily whip together your project for you and then if you still were having problems with stuff, you could bring those problems here for more fine tuned troubleshooting.
All of us enjoy helping out, but doing actual projects is more of a need for hiring someone or paying a freelancer to do that for you.
Best of luck with you project and hope to see you back here again. :)
There are tons of good coders on those sites that could easily whip together your project for you and then if you still were having problems with stuff, you could bring those problems here for more fine tuned troubleshooting.
All of us enjoy helping out, but doing actual projects is more of a need for hiring someone or paying a freelancer to do that for you.
Best of luck with you project and hope to see you back here again. :)
ASKER
Thats cool Adrian. Thanks
CREATE TABLE `Events` (
`event_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 100 ) NOT NULL ,
`start_date` DATE NOT NULL ,
`start_time` TIME NOT NULL ,
`brief_desc` VARCHAR( 255 ) NOT NULL ,
`full_desc` TEXT NOT NULL ,
`link` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;