PHP checkbox

[saiful89]

maaf saya budak baru belajar PHP...skang nih saya nak bwat

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

if ($display == 1){
$disable = 'disable';
}

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


saya nak bwat...kalo seatStatus tuh value 1..dia akan disable checkbox tuh...dah lama saya cuba still x dapat2 ag...~ bley minta tunjuk ajar?

 

[apis17]

sekiranya column nama display jadikan macam ni $display['display']

if ($display['display'] == 1){
$disable = 'disabled';
}else{
$disable = '';
}

 

[erro_sennin]

kena paham function mysql_query() untuk apa..
baca sini -> Link

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

mysql_query() hanya return FALSE or TRUE.

Jadi kena guna mysql_fetch_array -> Link

atau guna mysql_fetch_row ->Link

atau guna mysql_fetch_assoc ->Link
untuk dapatkan value column SeatStatus dalam table seats.

cth

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

$row = mysql_fetch_assoc($display );



if ($row['SeatStatus '] == 1){
$disable = 'disable';
}

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

regards.

 

[apis17]

oo lupa2. kena $row = mysql_fetch_assoc dulu