close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Just purchase Data Assist and getting the below issues.

Thread began 6/01/2020 1:45 pm by rogersds267040 | Last modified 6/10/2020 1:18 am by Ray Borduin | 113 views | 26 replies |

rogersds267040

Just purchase Data Assist and getting the below issues.

1: This comes when navigating from result page to Detail page
Notice: Undefined index: WADA_CardType_Insert in C:\xampp1\htdocs\cardgen\binman\binDetails.php on line 17

2: My charts don't load after the conversion. Please see the attachments before and after.

Sign in to reply to this post

Ray BorduinWebAssist

I'd need to see a copy of the binDetails.php page to debug that error. Please attach it to a reply.

I don't see any changed code on the charts pages other than the "after conversion" one missing the connection file at the top. If you add the connection file reference back it will probably continue to work as it did before.

Sign in to reply to this post
Did this help? Tips are appreciated...

rogersds267040

DataAssist issue

Please seethe attached binDetails.php. This happens in all my detail pages. Not sure if it's php version related.

Sorry Ray, please see the attached charts_before.php.

Sign in to reply to this post

Ray BorduinWebAssist

Update line 17 of binDetails.php from:

$cardProductRS->bindParam("i", "".($_SESSION['WADA_CardType_Insert']) ."", "-1"); //ParamSessioncardProductID

to:
$cardProductRS->bindParam("i", "".(isset($_SESSION['WADA_CardType_Insert'])?$_SESSION['WADA_CardType_Insert']:"") ."", "-1"); //ParamSessioncardProductID

The charts page has a lot of hand code. It would have to be updated by hand. If you want I can help with that in a premier support ticket.

Sign in to reply to this post
Did this help? Tips are appreciated...

rogersds267040

Thank you Ray. That changed cleared the error message.
I will reach out for the Premier ticket.

Sign in to reply to this post

rogersds267040

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);
}
?>

Sign in to reply to this post

Ray BorduinWebAssist

This code looks correct to me. Please attach the actual php page? What are the symptoms? Do you get an error or it just doesn't work properly?

Sign in to reply to this post
Did this help? Tips are appreciated...

rogersds267040

The update piece not working. It supposed to update the table when the Status changes.

Please see the original file with and the converted to mysqli.

Sign in to reply to this post

Ray BorduinWebAssist

You mean the insert into the telleractivity table is not taking place at all, but there are no errors and it redirects to the console.php page?

It looks like you didn't add an update server behavior to the mysqli version. It was hand coded on the mysql version, so you would have to add it to the mysqli version, it wouldn't convert automatically.

The equivalent to this code is missing from the mysqli version of the page entirely:

php:
<?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($totalRows_TellerStatus>0){
//echo $row_TellerStatus['ACTIVITY_ID']." ".$row_TellerStatus['Status'];
//exit();
        
if($row_TellerStatus['Status']=="Busy"){
              
$updateSQL sprintf("UPDATE telleractivity SET endDateTime=NOW() WHERE activityID=%s",
                       
GetSQLValueString($row_TellerStatus['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']="";
}
?>
Sign in to reply to this post
Did this help? Tips are appreciated...

rogersds267040

Thank you Ray.

I thought mysqli conversion would of taken care of it.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...