function getProducto($idProducto) { //Realiza el query en la base de datos $mysqli = makeSqlConnection(); $sql = "SELECT * FROM psg_productos a LEFT JOIN psg_productos_cstm ac ON a.id = ac.id_c WHERE id = '{$idProducto}'"; $res = $mysqli->query($sql); $rows = array(); while ($r = mysqli_fetch_assoc($res)) { $obj = (object) $r; $cantProducts = searchInfo($r['codigo_c']); $obj->saldo = $cantProducts; $a = (array) $obj; $rows[] = $a; } if (empty($rows)) { return '{"results" :[]}'; } else { //Convierte el arreglo en json y lo retorna $temp = json_encode(utf8ize($rows)); return '{"results" :' . $temp . '}'; } }
<?php defined('_JEXEC') or die("Restricted Access"); switch (JRequest::getVar('task')) { case 'search': searchInfo(); break; default: entryForm(); } function entryForm() { ?> <form id="form1" name="form1" method="post" action= "index.php?option=com_student&task=search" > <p> Enter Enrollment No : <input type="text" name="enl" /> <br><br> <input type ="submit" name="submit" value="Display Info" /> </p> </form> <?php } function searchInfo() { $db =& JFactory::getDBO(); $fldID = "'" . $db->getEscaped(JRequest::getVar('enl')) . "'"; $db =& JFactory::getDBO();
unset($_SESSION['value']); } else { $value = mysql_real_escape_string($_REQUEST['value']); } $id = (int) $_REQUEST['id']; mysql_query("UPDATE incoming SET `{$field}`='{$value}' WHERE ID={$id}"); break; case "searchinfo": correctConfigForParser(); $id = (int) $_REQUEST['id']; $result = mysql_query("SELECT * FROM incoming WHERE ID={$id}"); if ($result && ($field = mysql_fetch_assoc($result))) { $_RESULT["ok"] = 1; $rusname = $field["RusName"]; $engname = $field["EngName"]; $res = searchInfo($rusname, $engname); $ImdbSearch = count($res["imdb"]); $RusSearch = count($res["rus"]); $gimdb = array(); foreach ($res["imdb"] as $value) { $gimdb[] = str_replace(array("\r\n", "\r", "\n"), "", implode("|", $value)); } $grus = array(); foreach ($res["rus"] as $value) { $grus[] = str_replace(array("\r\n", "\r", "\n"), "", implode("|", $value)); } $ImdbVariants = addslashes(implode("\r\n", $gimdb)); $RusVariants = addslashes(implode("\r\n", $grus)); if (!$engname && count($res["imdb"]) > 0) { list($n) = explode("(", $res["imdb"][0]["name"]); $setEngname = " ,EngName='" . addslashes($n) . "' ";