I am tring to have a user click the submit buttion and the status of that row/room will become closed and the user can reserve more than 1 room at a time

//include database configuration
include 'config_open_db.php';

//selecting records
$sql="select RoomNumber, Type, Cost, Status from Rooms";

//query the database
$rs=mysql_query($sql) or die($sql.">>".mysql_error());

//count how many records found

if($num>0){ //check if more than 0 record found

    echo "<table border='1'>";//start table

        //creating  table heading
        echo "<tr>";
            echo "<th>RoomNumber</th>";
            echo "<th>Type Of Room</th>";
            echo "<th>Cost</th>";
            echo "<th>Status</th>";
        echo "</tr>";

        //retrieve our table contents
            //extract row


            //creating new table row per record
            echo "<tr>";
                echo "<td>{$RoomNumber}</td>";
                echo "<td>{$Type}</td>";
                echo "<td>{$Cost}</td>";
        echo "<td>{$Status}</td>";
                echo "<td>" . '<input type="submit" name="submit" value=" Reserve">' . "</td>";               
            echo "</tr>";

    echo "</table>";//end table

}else{ //if no records found
    echo "No records found.";

4 Years
Discussion Span
Last Post by masterjiraya

Ok, so with what bit are you having trouble?

I can't see any form tags around the bunch of buttons, and none of the submit buttons have a unique id or value to grab the room_id, so I'm assuming you'll be using javascript to run a separate php script (ajax)?

You have no $_POST variable checking (check which button is being pressed) - so I'm assuming that your (form) data handling is happening in a different file?

Sorry, not trying to be unhelpful, but the main components of the functionality that you're asking about seem to be missing from your code.


so i need to add id's would that mean create a new coloum in the database? create a form file and from there what i need maianly direction


so i need to add id's would that mean create a new coloum in the database?

Not necessarily, but I would. It's pretty standard to create a PRIMARY KEY - usually an INT datatype which should be set to AUTOINCREMENT.

This means that you can then search the table very quickly as it's INDEXED and you can efficiently JOIN related tables.
In addition, your html buttons need to be able to reference the room that they're linked to somehow.


Let me also explain what Join tables can do. I assume you have a little background or just staring up relational database programming. I would rather like to read the subject title "sets" in discrete mathematics because they are the same with database programming. let's say in SETS, there was set A and set B, in database there is table and table B.

Union- combination of 2 or more sets in SETS. in database is called syntax as Union, it combines 2 o more tables.
Intersection- finding the common between 2 or more sets. In database it is called syntax Join, it finds common databetwwen 2 or more sets (this should be assigned).

select * from tableA left join tableB on tableB.id=tableA.id
the type of join that is commonly used is left join. in SETS it called subset, in this manner mentioned in the example program above, it is a subset of tableB (meaning to say finding common data in tableB with tableA)

the on clause is used always as the connector to the logic to which shall the program triggers.


so do i need to make another table and yes I am extremly new this is my first project I created a primary key and been looking up buttons and $_POST variable checking (check which button is being pressed) i just need an ideal on how to put this together


Whether you want to make another table depends upon your usage. Obvious tables to include could be 'bookings' and 'users', where you have something like:


booking_id (PK, autoincrement)
start_booking (datetime)
end_booking (datetime)



But, as I mentioned, that depends on your usage (case use).

Edited by diafol


would it be better to get replace the buttons with checkboxes and how would that work or should i start from scratch


frankey bailey... we are open to lend you a helping hand, share us your logic and we will also share our comments and hints that you need to do.

we should start first from the database tables you want to have. just like the example what diafol has posted. diafol has just posted a brief preview on that.

Edited by masterjiraya


What I am trying to do is have a web page that connects to a mysqldata base i want to have the user click a button and change that room status to closed am i good on the columuns or do i need to make new columns and a new table i like the bookings table he thought of my backgound is in cisco routers so i will be unfaimlar with terms and i have a php/mysql book to reference and if you can include links to explain things that would be geat


mr frankey bailey we don't know excatly what you want, whether it is checkbox or not. all we have to do is find a possible way to solve your questions.

share us your database tables and we will fix it.


here is my question. u mentioned, mr. bailey, that you want to use check box. well it dpends to your design.

consider this things between checkbox and dropdowns.

checkbox could be user firendly because checkbox can be used as userfriendly GUI that can be used to display that these checkboxes with this color legend can be reserved already or it is vacant. while drop downs are easier also when it comes to server computation speed.

could you lend us the design?

Edited by masterjiraya


lets use checkboxes and erase the cost column and add
start_booking (datetime) end_booking (datetime) I included a text file of the data and columns

RoomNumber Type	Status	start_booking	end_booking 	Room_Id Primarykey
100	 Single	Open			
101	 Single	Open			
102	 Single	Open			
103	 Single	Open			
104	 Single	Open			
105	 Single	Open			
106	 Single	Open			
107	 Single	Open			
108	 Single	Open			
109	 Single	Open			
110	 Double	Open			
112	 Double	Open			
113	 Double	Open			
114	 Double	Open			
115	 Double	Open			
116	 Single	Open			
117	 Single	Open			
118	 Single	Open			
119	 Single	Open			
120	 Single	Open			
200	 Single	Open			
201	 Double	Open			
202	 Double	Open			
203	 Double	Open			
204	 Double	Open			
205	 Double	Open			
206	 Single	Open			
207	 Single	Open			
208	 Single	Open			
209	 Single	Open			
210	 Double	Open			
212	 Double	Open			
213	 Double	Open			
214	 Double	Open			
215	 Double	Open			
216	 Single	Open			
217	 Single	Open			
218	 Single	Open			
219	 Single	Open			
220	 Single	Open			
300	 Single	Open			
301	 Single	Open			
302	 Single	Open			
303	 Single	Open			
304	 Single	Open			
305	 Single	Open			
306	 Single	Open			
307	 Single	Open			
308	 Single	Open			
309	 Single	Open			
310	 Double	Open			
312	 Double	Open			
313	 Double	Open			
314	 Double	Open			
315	 Double	Open			
316	 Single	Open			
317	 Single	Open			
318	 Single	Open			
319	 Single	Open			
320	 Single	Open			
400	 Single	Open			
401	 Double	Open			
402	 Double	Open			
403	 Double	Open			
404	 Double	Open			
405	 Double	Open			
406	 Single	Open			
407	 Single	Open			
408	 Single	Open			
409	 Single	Open			
410	 Double	Open			
412	 Double	Open			
413	 Double	Open			
414	 Double	Open			
415	 Double	Open			
416	 Single	Open			
417	 Single	Open			
418	 Single	Open			
419	 Single	Open			
420	 Single	Open

frankey bailey, I apologize for a late reply. I'm late to reply on you because I have corporate business conference with CISCO just a few minutes passed away.

Now... back to the topic.

I can lend a help to you with that.
Insert those details you have right now in your database. we all have to do is design everything first. that is called the front-end programming methodology. (100% pure design) back-end is (100% pure logic)

I think you can start constructing HTML for now. we'll do first (100% pure design)


on your initial post, that is back-end programming already.

draw a design of your image of your website and we will convert it to a code of html and css.


remember the foundation of the project relies on the quality but the attraction of the project relies on eye-popping design


honstely i just neeed a table that has the included colums and when a rooom is reserved the status is changed to close and the according table row changes from green to red and a text input field for the book dates

Attachments Untitled.png 106.9 KB

You'll probably want to think this through a little bit.
The status field is an odd one - what's the purpose of red/green? Is this for current time (booked or not). Can rooms have multiple bookings (on different non-overlapping datetimes)? If so, 'status' loses meaning. Well, it loses meaning anyway if you book for a set amount of time.

IMO, the colour should be set by whether the room has been booked for that particular period


yes the status color is for current status, No the the rooms cant have multiple bookings on different non-overlapping datetimes Click Here i read this it looks like what im doing except i want to edit 3 field instead of two can i follow the same logic


i am also having problem with buttons. Can you please give an example of html form's 2 button with elseif statement. which shows how to control two buttons through php. i mean when i click "insert" button so it inserts data to DB and when i click "delete" button in html, so it delete the selected record form DB.



wow. I got big hole of a problem in your project mr. frankie bailey. You mentioned to have checkboxes and buttons earlier this post.

what it hinderes me right now are:

1.) what is the process of booking here? do customers have to contact the staff and change the status of their desired room(s)?

2.) how do the customers pay the hotel rooms?

3.) how do the staff check that the customer is not a fraud or not a prank poster?


You should perhaps have this done by professionals. I am talking about people who have done similar job. Unless you have time to do it on your own.

Edited by 3alphatech


Mr akkbkht, please don't hijack other peoples threads, you are unlikely to get a reply, start your own thread if you cannot find your answer by searching.


Im trying everything to be done by web the status change booking dates i forgot to put in a submit button at the bottom and checkboxes in the pictureand staff only has to check it i shout be able to fine out how to auto delete so it doesnt have to be done manully iv done a shopping cart before so the payment part shouldn't be hard and for the fraud part honestly I don't know


in your part of the questioned "auto delete", what are the rules for having auto delete?
can you post your new interface along with the submit button and check boxes as well? so we can innovate the design.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.