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) . "' ";
