Thanks for your option, though I doubt I'll be able to do this, considering the time i have.
How much time do you have, why are you so rushed this close to the start of the academic year?
tbh, I'm pretty clueless myself as to what I'm doing at the moment, i took a week thinking of a project, and this is the only idea I came up with which I think is pretty much do-able
As for pros/cons well, i haven't got into that yet..
You need to sit down and have a proper think about this. What is the actual brief for your project? I can't imagine that it's simply to develop something and that's all there is to it; you probably need to produce a good deal of technical documentation as well, which would usually include a section on technology choice - why you chose desktop vs. web, Java vs. C#, MySQL vs. Oracle, etc. For a final year project I'd also expect you to produce a proper specification and design before you start, which means at the very simplest a list of features that you're going to include, with details on what they are, why they're included, and how they'll work.
As for "pretty much do-able", that's a dangerous phrase. Anything is "pretty much do-able" if the specification is compact enough. You're talking about building a hotel management system. At a basic level, you could summarise this as follows:
- room booking by staff (search by date and make booking, not customer-facing)
- check customers in
- check customers out
- print invoice
But if you actually wanted it to be useful, you would say this:
- room booking (both staff and customer-facing, search by date, availability, room type and room rate, place booking, cancel booking, amend booking)
- checking in and checking out (whole party inc. multiple rooms or split)
- printing invoice and amending charges as necessary
- catering; running breakfast and/or room service (adding charges to rooms, notifying kitchen, etc.)
- running housekeeping, including reporting on how many staff are required, which rooms to make up and/or clean out, schedule or rota of staff, adding notes on rooms which weren't completed (eg. DND sign)
- other hotel facilities (concierge service, gym, restaurant, etc.)
- ... and so on, and on, there's simply dozens more features that could be added here.
And that's not even covering topics such as scalability, security, testing, maintenance and updates, many of which will influence or be influenced by the feature list above as well as your choice of technologies.
Oracle, i have used it once, it was an annoying database to use at first, but i guess i can handle it with this project.
When you say "used", do you mean that you've used SQL queries to read/write to an Oracle database that someone else provided for you? Or do you mean that you've installed and configured Oracle yourself? I'm strongly suspecting it's the first of those. Do you appreciate what SQL (the query language) actually is, and how it would be used via Java or PHP to communicate with a database engine (Oracle or otherwise)?
As for my skill in programming languages:
I am great at using HTML/CSS and PHP. Created a website with it. php is pretty simple, and easy to understand
Java, not so much, tbh java is one of the worse languages I have ever encountered, I just can't seem to understand much about it.
I'm not sure what to say here - I can't believe you'd consider using a language you don't really understand for your final year project, especially when you say that you're rushed for time! Ditch the Java idea now.
As to PHP and the web-based solution, if you've got some knowledge there then that's a start - but to be honest I'm not getting the impression that you have a great deal of experience. Have you actually built any web applications before, or are we just talking simple websites? Have you done anything with PHP and web applications as part of your course?
Overall - best of luck! I don't mean to come across as harsh, just want to try and get a better idea of what your goal is and what the best tools will be for you to complete your project!