Good day. I am looking for a way to do something like this. What I am looking to do is have the front page of a web site change based on the date. What it is is a web site for a local theater that I am helping with and I want to have a table in a database (probably in access unless you can provide another alternative) with dates of the show and then with the run is currently running then the website would be updated with "Now Showing XXX" and if it is between shows have it say "Coming Soon YYY". Can anyone help me get this started, maybe thrown me a website or two that I can look at for some tutorial? Thank you.
2007-10-11 07:19:10 · 4 answers · asked by Icon 7 in Computers & Internet ➔ Programming & Design
Well, breaking your question down a bit, I came up with the following:
1. You need a web page that is date-aware...that is, is capable of knowing what the current date is.
2. You need a web page that is capable of comparing the current date to the date of upcoming or currently running shows.
3. You need a web page that displays a different message depending upon whether or not a show is upcoming or currently running.
This is actually not that difficult to do, but I'll agree with previous answers that recommended MySQL. 99% of web hosting packages have it, and it's pretty easy to use.
Also...you're going to need PHP. Not a lot of PHP...and not complicated PHP, but PHP nonetheless. If you're not comfortable with PHP and MySQL being used in combination, I'm afraid you could be in trouble.
I can give you direct and specific help, just drop me a line at my email: steve@thoughtsandrambles.com
2007-10-11 08:40:50 · answer #1 · answered by poeticjustice72182 3 · 0⤊ 0⤋
I would not use an access database personally. I would choose something like mysql database or cgi bins. You can create a mysql database easily through PhP scripting. Mysql is the most safe and the most secure database in my opinion. Access is how do i say...easily accessible to anyone to get into. Hope this helps on your database problem.
2007-10-11 07:31:26 · answer #2 · answered by Anonymous · 0⤊ 0⤋
From a database attitude, there is not any longer something you pick evaluate. no rely in case you have one table with basically one records container or a hundred tables with various columns in each and every, the cyber web website interacts with the database by using a query. So layout your database to keep the show you how to need, as plenty or as little. Then layout the queries to pick that records, replace it or DELETE it.
2016-11-08 00:28:25 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Does not look easy, may be you can contact a php,mysql expert at http://oktutorial.com/
2007-10-12 03:05:08 · answer #4 · answered by Anonymous · 0⤊ 0⤋