Just purchase Data Assist and getting the below issues.
I have before and after code from mysql to mysqli which isn't working.
Is there something that wasn't converted properly with mysqli?
Before DataAssist (Mysql to Mysqli) conversion
<?php
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "set_teller_status_form")) {
//If updating and not a first record and lhe last status was Busy updated the End Date of the last record
if($TellerStatus->TotalRows>0){
//echo $TellerStatus->getColumnVal('ACTIVITY_ID')." ".$TellerStatus->getColumnVal('Status');
//exit();
if($TellerStatus->getColumnVal('Status')=="Busy"){
$updateSQL = sprintf("UPDATE telleractivity SET endDateTime=NOW() WHERE activityID=%s",
GetSQLValueString($TellerStatus->getColumnVal('activityID'), "int"));
mysql_select_db($database_cardNumDS, $cardNumDS);
$Result1 = mysql_query($updateSQL, $cardNumDS) or die(mysql_error());
}
}
}
if(($_POST['Status']=="Unavailable") || ($_POST['Status']=="Available")){
$_POST['serviceID']="";
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "set_teller_status_form")) {
$insertSQL = sprintf("INSERT INTO telleractivity (userID, serviceID, Status, displayName, branchNum, userName) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString($_SESSION['userID'], "int"),
GetSQLValueString($_POST['serviceID'], "text"),
GetSQLValueString($_POST['Status'], "text"),
GetSQLValueString($row_WAATKusers ['displayName'], "text"),
GetSQLValueString($WAATKusers->getColumnVal('branchNum'), "text"),
GetSQLValueString($WAATKusers->getColumnVal('userName'), "text"));
mysql_select_db($database_cardNumDS, $cardNumDS);
$Result1 = mysql_query($insertSQL, $cardNumDS) or die(mysql_error());
$insertGoTo = "console.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
After DataAssist (Mysql to Mysqli) conversion
<?php
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "set_teller_status_form")) {
$InsertQuery = new WA_MySQLi_Query($cardNumDS);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "telleractivity";
$InsertQuery->bindColumn("userID", "d", "".($_SESSION['userID']) ."", "WA_BLANK");
$InsertQuery->bindColumn("serviceID", "d", "".($_POST['serviceID']) ."", "WA_BLANK");
$InsertQuery->bindColumn("Status", "s", "".($_POST['Status']) ."", "WA_BLANK");
$InsertQuery->saveInSession("telleractivityID");
$InsertQuery->execute();
$InsertGoTo = "console.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>