How do i add disable a checkbox using php

Question

$query = "SELECT * FROM seats WHERE SeatStatus = 1";
$display = @mysql_query($query);


if ($display){
$disable = "disable";
}


    <input name="ch1" type="checkbox" id="A1" value="" <?php echo $disable ?>/>;

how do i add "disable" inside the code...ive tried many time..but still didnt work.. Im new with php btw...Thanks..~

Tabrez Ahmed · Accepted Answer · 2012-03-25 13:37:24Z

1

The main problem is that you are not checking if the query returned any results or an empty set. You are just checking whether the query is successful. mysql_query() would return false only when the query is wrong. In your case the query is correct, so $display = mysql_query(); will always evaluate to a non-false value.

To solve this, you should check how many rows mysql_query() returns using mysql_num_rows(). So let's rewrite your code.

$query = "SELECT * FROM seats WHERE SeatStatus = 1";
$result = @mysql_query($query);
$display = (mysql_num_rows($result) == 1);

$disable = $display?'':'disabled="disabled"';

   <input name="ch1" type="checkbox" id="A1" value="" <?php echo $disable; ?>/>;

Hope that helps...

Peace...

edited Mar 25, 2012 at 13:37

answered Mar 25, 2012 at 11:37

Tabrez Ahmed

3,0007 gold badges35 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Discharge Over a year ago

I forgot to put the "d" at the end of the code...the thing is i wan to make my checkbox to be disabled if seatStatus is true, else nothing happen..do you know the codes?

Discharge Over a year ago

Seat_ID 1 | 2 | 3 || SeatStatus 0 | 0 | 0....So if i click checkBox and hit reserve...it should be automatically change the SeatStatus to 1[worked] and the checkbox to be disable[still not working]...

Sara Over a year ago

edit your question and give more details and codes about your problem for a better solution.

Discharge Over a year ago

@ahmedtabrez This method WORKS ! Thank BRO ! Ive been solving this for weeks... THANK YOU VERY MUCH...YOU MAKE ME CRY T_T..~ LOL

Discharge Over a year ago

Its my email name btw since saiful was taken..and its my first time here...never explore anything yet...~ btw thank you so much !

Quentin · Accepted Answer · 2012-03-25 11:24:50Z

1

The attribute value is disabled not disable, just add a d.

answered Mar 25, 2012 at 11:24

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

2 Comments

Discharge Over a year ago

oh ya thx btw...its worked..but the thing is i wan to make its if the SeatStatus value is 1 it will disabled the checkbox else nothing happen... this code wrong?

Quentin Over a year ago

Forms only submit successful controls. A checkbox is only a successful control if it is checked and is not disabled.

Sara · Accepted Answer · 2012-03-25 13:27:12Z

0

What you actually want is not clear for me. I think you want to find all seats where its status equals to 1. if seats are available(status = 1) disable checkbox.

$query = "SELECT * FROM seats WHERE SeatStatus = 1";
$result = @mysql_query($query);

$num_rows = @mysql_num_rows($result);

$disable = '';
if (!$num_rows){
$disable = 'disabled="disabled"';
}

<input name="ch1" type="checkbox" id="A1" value="" <?php echo $disable ?>/>;

edited Mar 25, 2012 at 13:27

answered Mar 25, 2012 at 12:10

Sara

14.7k13 gold badges37 silver badges50 bronze badges

6 Comments

Discharge Over a year ago

i have tried it and still failed. am i missing something? $query = "SELECT count(*) FROM seats WHERE SeatStatus = 1"; $display = @mysql_query($query) $disable = ''; if (!$display){ $disable = 'disabled="disabled"'; } <input name="ch1" type="checkbox" id="A1" value="" <?php echo $disable ?>/>;

Sara Over a year ago

at the input end did you put the name you want to display? <input name="ch1" type="checkbox" id="A1" value="" <?php echo $disable ?>/> Display

Discharge Over a year ago

i did not put display...if i use the top method...it will disabled the checkbox straight away...that the problem..

Sara Over a year ago

when the page is load your checking there are seats where status=1( there can be many seats rite). if there are seats ($display>0) available then you want to disable the checkbox. if not which means ($display=0) you want to enable checkbox. am I rite? the code should work if this is the requirement you want. try a echo the $display value and see the SQL query is working correctly.

Discharge Over a year ago

yeah this is exactly what i want...i echo the $display...it display Resources #4...what is that mean?

|

Francis Chen · Accepted Answer · 2012-03-25 13:30:41Z

0

Replacedisable with disabled

answered Mar 25, 2012 at 13:30

Francis Chen

354 bronze badges

Comments

konsolenfreddy · Accepted Answer · 2012-03-26 06:50:17Z

0

<input type="checkbox" <?php echo ($condition) ? ' disabled="disabled"' : '';/>

edited Mar 26, 2012 at 6:50

konsolenfreddy

9,7091 gold badge28 silver badges36 bronze badges

answered Mar 25, 2012 at 11:36

Kishor Kundan

3,1651 gold badge25 silver badges30 bronze badges

2 Comments

Discharge Over a year ago

how do i use this...is it <input type="checkbox" <?php echo ($display) ?> 'disabled' : '';/>

Kishor Kundan Over a year ago

@Ahmad : No that's a ternary if

Collectives™ on Stack Overflow

How do i add disable a checkbox using php

5 Answers 5

5 Comments

2 Comments

6 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

2 Comments

6 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related