Save link information on string
When I try to save information of a link on a string, it sabes like this --->. https://www.google.com.mx/ instead of ---> https://www.google.com.mx/ Even the InsertGoTo variable is not working...
+++++++++++++++++
<?php require_once('Connections/qrcore.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php
$qr_search = new WA_MySQLi_RS("qr_search",$qrcore,1);
$qr_search->setQuery("SELECT qr_control.* FROM qr_control WHERE qr_control.print_qr = ?");
$qr_search->bindParam("s", "".(isset($_GET['qrcode'])?$_GET['qrcode']:"") ."", "-1"); //WAQB_Param1
$qr_search->execute();
?>
<?php
$data_link = $qr_search->getColumnVal("link");
if (($qr_search->TotalRows > 0) AND ($data_link != "") ){
$id_qr = $qr_search->getColumnVal("print_qr");
$linkqr = $qr_search->getColumnVal("link");
$InsertQuery = new WA_MySQLi_Query($qrcore);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "qr_scans";
$InsertQuery->bindColumn("qr_code", "s", "".($id_qr) ."", "WA_DEFAULT");
$InsertQuery->bindColumn("link", "s", "".($linkqr) ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = $linkqr;
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>