is it possible to insert the time table in database?
9 3138
Welcome to Bytes!
What is 'time table' in your question? Please explain.
Ronald
i made a website bout reservation for lecture room.then i need to detect the room whether it's available or not.so my lecturer want me to insert the lecture room schedule in database.then i need to create section 'search' by time(lecture room).
Atli 5,058
Expert 4TB
Hi.
Check out the Date and Time types, as well as the Date and Time functions.
When you have two dates in your database, like for example a start and a end date, then you can use the WHERE .. BETWEEN syntax to see if they intersect.
Like, for example: - SELECT * FROM timeTable WHERE NOW() BETWEEN startDate AND endDate
hi too
to atli : i'm sorry..i really don't understand that..can u explain a lil bit more and a lil bit easy for me to understand..tq for helping me.
my question :how to insert the time table in database?
Atli 5,058
Expert 4TB
Could you show us how your current database looks like?
It's kind of hard to see a solution if you can't see the problem ^^
Assuming you already have a table containing the lecture rooms, I would create a second table for the time table. The second table would reference the Primary Key of the first table, so that we know which room we are referring to. I would also create start_time and an end_time Time columns.
This is assuming you want only the Time stored, but not the date.
If you do want the date as well, use the DateTime type instead.
Then you could insert a row into the second table every time each room is reserved, and you could use the query I posted earlier to see if a given time is reserved or not.
hi again..
to atli : thanks for your help..but it's kinda hard for me to understand the explanation.i totally can't imagine how to do that.
i also dunno how to show my database in this forum.
Atli 5,058
Expert 4TB
Ok.
I'm not entirely sure we are talking about the same thing.
Just so I know what page you are on, tell me...
How would you go about getting data from your database?
Do you use some sort of GUI application?
Or do you use the command line interface?
How much experience do you have with SQL databases?
Have you worked with them a lot or are you new to it?
,... so my lecturer want me to insert the lecture room schedule in database.....
I assume you want us to help you with your school/class work. I also assume that your lecturer thinks you have the (theoretical) programming and database background to achieve this, otherwise you would not have gotten this assignment?
But reading your posts I am not so confident that you have that expertise. Maybe it is wiser to do some (PHP) MySQL tutorials to get a better grasp on the matter at hand. See the following links: MySQL introduction Beginning-MySQL-Tutorial PHP/MySQL Tutorial MySQL starter PHP tutorials PHP-MySQL tutorial
Ronald
hi again..
to atli : actually i not really have experience with SQL database.i've learned all of this stuff a few months ago.our lecturer just teaching by theoretical.they didn't show how to do it..so it's kinda hard to understand..i have no idea whether me use GUI application or command line interface..i already ask my lecturer,and she said the whole time table is not possible to insert in database.
to Ronald : thanks for your help.this is not only my class work u know..my final project..actually we not really learned the programming and database in class..then this final semester we need to build a website.
actually we need to submit our project by 28th May 08.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: MyndPhlyp |
last post by:
I am about to completely lose what is left of my poor mynd! The historical
dissertation gets rather verbose, so I hope you can wade through it all. I
really need some help on this one or I'm...
|
by: Steve Miller |
last post by:
hello...
i am a 'user' of access, meaning, i import excel files, join, and
merge....that's about the extent of my expertise with ms-access. my
boss wants me to create an access application that...
|
by: Neil Ginsberg |
last post by:
A while back I posted a message re. using an ADP file with a SQL Server back
end as opposed to MDB file with linked tables, thinking that the ADP file
would be less problematic. The input I got was...
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I have two tables with 5000 entries on them. One is based for regular time
with several variables example (employee name, date,time in and out, code,
customer, building) I have another table that...
|
by: luscus |
last post by:
Thanks for all the responses on my first question. Unfortunately the
answers I was given were too complicated for my small brain , and
neophite condition to understand. So if you could talk down to...
|
by: Jamey Shuemaker |
last post by:
A2k2 with user-level security and all preventive measures, vis a vis,
Security FAQ enabled or enacted.
I've got three DBs, which due to size constraints can't, or rather,
probably shouldn't be...
|
by: richardhodge |
last post by:
I am a VB6 database programmer and have run into a small problem. The company I work for primarily uses Microsoft Access 2000 for the database that is the back end for our software. Well the...
|
by: teddysnips |
last post by:
One of my clients has asked me to make a change to one of their Access
applications.
The application is a Front End/Back End standard app. I didn't
develop it, but looking at it tells me that...
|
by: SilentThunderer |
last post by:
Hey folks,
Let me start out by letting you know what I'm working with. I'm building an application in VB 2005 that is basically a userform that employees can use to "Clock in". The form...
|
by: Charles May |
last post by:
Anyone have a simple concept for the best way to store timeclock information
in a database.
I currently have my table set up like this with a typical daily entry.
tcID empID Type ...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |