Hi,
i have inserted a button and have written a server code to interact with the database but when the button is click it does nothing. please here is my code
global $dal;
// Put your code here.
//$result["txt"] = $params["txt"]." world!";
$user = $_SESSION["UserID"];
$romTble = $dal->Table("room");
$rs = $romTble->Query("isOccupied='YES'");
//$sql = "select price,RoomNumber,Roomcategory from room where isOccupied='YES'";
//$result["sql"]= $sql;
//$rs = CustomQuery($sql);
while($rmData = db_fetch_array($rs)){
$rmprice = $rmData["price"];
$rmnumber = $rmData["RoomNumber"];
$rmcat = $rmData["Roomcategory"];
// select the corresponding data from roombooking table.
$gbktbl = $dal->Table('guestbooking');
$rmbk_rs = $gbktbl->Query("RoomNumber='$rmnumber'");
//$bkSql = "select GuestName,BookingRef,RoomNumber,CheckInDate,CheckOutDate from guestbooking where RoomNumber='$rmnumber'";
//$result["billsql"]= $sql;
//$rmbk_rs = CustomQuery($bkSql);
$rmbkData = db_fetch_array($rmbk_rs);
$name = $rmbkData["GuestName"];
$ref = $rmbkData["BookingRef"];
$room_no = $rmbkData["RoomNumber"];
$InDate = $rmbkData["CheckInDate"];
$OutDate = $rmbkData["CheckOutDate"];
// check if the room have been bill already
$billSql = "select RoomNo,DateCharge from charged where RoomNo='$room_no'";
$charge_rs = CustomQuery($billSql);
if($charge_rs){
$result["response"]="data exist";
}
else{
$result["response"]="data doesn't exist";
$guestId = getGuestId($name);
$chargedTbl = $dal->Table('charged');
$chEvent->Value["RoomNo"]= $room_no;
$chEvent->Value["DateCharged"]= date('Y-m-d');
$chEvent->Value["ChargedStatus"]= "Charged";
$chEvent->Add();
//CustomQuery("insert into charged(RoomNo,DateCharged,ChargedStatus) values('$room_no',now(),'Charged')");
//CustomQuery("insert into acctcustomertransaction(CustomerId,CustomerName,Transactiondate,DebitTransactionAmount,TransactionRef,DatePosted,PostedBy) values('guestId','$name',now(),'$rmprice','$ref',now(),'$user')");
}
}
function getGuestId($username){
$guestTbl = $dal->Table('guest');
$res = $guestTbl->Query("Fullname='$username'");
//$gid = CustomQuery("select GuestId from guest where Fullname='$username'");
//$gData = db_fetch_array($gid);
$gData = db_fetch_array($res);
return $gData["GuestId"];
}
i think there is something i miss please can i get help to rectify it thanks