This topic is locked

btton server code not working

6/18/2014 5:52:58 AM
PHPRunner General questions
U
U.M.Mbanaso author

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

Sergey Kornilov admin 6/18/2014

Check this article for inspiration:

http://xlinesoft.com/blog/2012/05/16/troubleshooting-custom-buttons-in-phprunner-and-asprunnerpro-applications/
If you need more help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.