function verify_email($user, &$result)
{
$dbhost = 'localhost';
$dbusername = '******';
/*usuario de base de datos*/
$dbuserpass = '';
/*contraseña, la deje en blanco para pruebas*/
$dbname = 'practicantes';
/*nombre de la base de datos*/
$con = mysqli_connect($dbhost, $dbusername, $dbuserpass) or die("Error al intentar conectarse a la BD");
/*creamos el enlace a la bd*/
if (!$con) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
$sql = "SELECT email FROM usuarios WHERE email='{$user}'";
$rec = mysqli_query($con, $sql);
$count = 0;
while ($row = mysqli_fetch_object($rec)) {
$count++;
$result = $row;
}
if ($count == 1) {
return 1;
} else {
return 0;
}
}
function __construct($username, $password, $tenantID)
{
if (strlen($username) == 0 || strlen($password) == 0) {
throw new Exception("Invalid username or password.");
}
$userDetails = User::getUserDetails($username);
if ($userDetails["active"] == 0) {
throw new Exception("This user account is inactive. Please check your email for activation instructions.");
} else {
$saltedPassword = Utility::saltAndHash($password, $userDetails["password"]);
//echo 'salted:' . $saltedPassword;
//echo Utility::saltAndHash($password);
$query = 'call validateUser(' . Database::queryString($username);
$query .= ',' . Database::queryString($saltedPassword);
$query .= ',' . Database::queryNumber($tenantID) . ');';
$result = Database::executeQuery($query);
if (!$result) {
throw new Exception('Unable to validate that username/password combination.');
} else {
$userid = 0;
while ($o = mysqli_fetch_object($result)) {
$userid = $o->userid;
$name = $o->name;
}
if ($userid > 0) {
$this->id = $userid;
$this->name = $name;
} else {
throw new Exception("Unable to validate that username/password combination.");
}
}
}
}
static function get_all_server()
{
$db = mysqli_connect($_SESSION['db_host'], $_SESSION['db_user'], $_SESSION['db_password'], $_SESSION['db_database']);
$result = mysqli_query($db, "SELECT * FROM `server` where test_system != 'true'");
while ($row = mysqli_fetch_object($result)) {
$i = $row->server_id;
$obj_name = "server" . $i;
${$obj_name} = new server();
${$obj_name}->server_id = $row->server_id;
${$obj_name}->hostname = $row->hostname;
# Fra Space
$result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-space' order by time desc");
while ($row2 = mysqli_fetch_object($result2)) {
${$obj_name}->fra_space = $row2->value_string;
}
# Fra Used Space
$result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-used-space' order by time desc");
while ($row2 = mysqli_fetch_object($result2)) {
${$obj_name}->fra_used_space = $row2->value_string;
}
# Build all instance objects
${$obj_name}->instances = instance_actions::get_instance_by_server($row->hostname);
$arr_obj[] = ${$obj_name};
}
return $arr_obj;
}
function retourneDevoirs($ele_login)
{
$date_ct1 = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
// On récupère tous les devoirs depuis aujourd'hui 00:00:00
$sql = "SELECT DISTINCT ctde.* FROM ct_devoirs_entry ctde, j_eleves_groupes jeg\r\n\t\t\t\t\t\t\t\tWHERE ctde.id_groupe = jeg.id_groupe\r\n\t\t\t\t\t\t\t\tAND jeg.login = '******'\r\n\t\t\t\t\t\t\t\tAND ctde.date_ct >= '" . $date_ct1 . "'\r\n\t\t\t\t\t\t\tORDER BY ctde.date_ct, ctde.id_groupe;";
//echo "$sql<br />";
$res_ct = mysqli_query($GLOBALS["mysqli"], $sql);
$cpt2 = 0;
// on initialise un compteur pour le while
if (mysqli_num_rows($res_ct) > 0) {
while ($lig_ct = mysqli_fetch_object($res_ct)) {
$tab_ele['cdt_dev'][$cpt2] = array();
$tab_ele['cdt_dev'][$cpt2]['id_ct'] = $lig_ct->id_ct;
$tab_ele['cdt_dev'][$cpt2]['id_groupe'] = $lig_ct->id_groupe;
$tab_ele['cdt_dev'][$cpt2]['date_ct'] = $lig_ct->date_ct;
$tab_ele['cdt_dev'][$cpt2]['id_login'] = $lig_ct->id_login;
$tab_ele['cdt_dev'][$cpt2]['contenu'] = $lig_ct->contenu;
$cpt2++;
}
$tab_ele['cdt_dev']['count'] = $cpt2;
} else {
$tab_ele['cdt_dev']['count'] = 0;
}
return $tab_ele;
}
public function fetchObj()
{
if ($this->_result) {
return $this->_row = mysqli_fetch_object($this->_result);
}
return false;
}
function datapages()
{
if ($_SESSION['userinfo']['status'] === 1) {
$conn = new mysqli('localhost', 'root', '12345password12345', 'main');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$num_rows_res = $conn->query("SELECT count(*) FROM mlib;");
$num_rows = mysqli_fetch_array($num_rows_res, MYSQLI_NUM)[0];
for ($i = 1; $i <= $num_rows; $i++) {
$pages_sql = "Select * FROM mlib WHERE c_id=" . $i . ";";
$pages_res = $conn->query($pages_sql);
$pages[$i] = mysqli_fetch_object($pages_res);
}
$conn->close();
} else {
$conn = new mysqli('localhost', 'root', '12345password12345', 'main');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$num_rows_res = $conn->query("SELECT count(*) FROM mlib WHERE viewers='all';");
$num_rows = mysqli_fetch_array($num_rows_res, MYSQLI_NUM)[0];
for ($i = 1; $i <= $num_rows; $i++) {
$pages_sql = "Select * FROM mlib WHERE c_id=" . $i . " AND viewers='all';";
$pages_res = $conn->query($pages_sql);
$pages[$i] = mysqli_fetch_object($pages_res);
}
$conn->close();
}
return $pages;
}
function getGcmIds($link, $id)
{
$query = "SELECT user_gcm_id FROM device_user WHERE user_id = '{$id}'";
$resultado = mysqli_query($link, $query) or die("Erro na consulta: " . mysqli_error($link));
$gcId = mysqli_fetch_object($resultado);
return $gcId->user_gcm_id;
}
function listDbData()
{
$link = mysqli_connect('localhost', 'root', '') or die(mysql_error());
$db_list = mysql_list_dbs($link);
print "<table width=100% bgcolor='BLACK' cellspacing=1 cellpadding=0>";
print "<tr bgcolor=#BBBBBB><td align='center'>";
print "<b>Database list</b>";
print "</td></tr>";
while ($row = mysqli_fetch_object($link, $db_list)) {
print "<tr bgcolor='WHITE'><td align='center'>";
print $row->Database;
//echo $row->Database . "<br>";
print "</td></tr>";
}
print "<tr bgcolor=#BBBBBB><td align='center'>";
print "<b>Tables</b>";
print "</td></tr>";
$db_selected = mysqli_select_db('maxinedb', $link);
$sql = "SHOW TABLES";
$result = mysqli_query($link, $sql);
if (!$result) {
throw new man_exception('MySQL Error: ' . mysql_error());
}
while ($row = mysqli_fetch_row($link, $result)) {
print "<tr bgcolor='WHITE'><td align='center'>";
print $row[0] . "";
print "</td></tr>";
}
print "</table>";
}
static function replaceEntityURLs(&$object)
{
global $wpdb;
self::mapObjects($object);
$urls = implode("','", array_map(function ($e) {
return addslashes($e[0]->singleUrl);
}, array_filter(self::$objects, function ($e) {
return (bool) $e[0]->singleUrl;
})));
$query = "SELECT post_ID, meta_value FROM {$wpdb->postmeta} WHERE meta_value IN('{$urls}')";
if ($wpdb->use_mysqli) {
$rs = mysqli_query($wpdb->dbh, $query);
while ($obj = @mysqli_fetch_object($rs)) {
$post_permalink = get_permalink($obj->post_ID);
if (isset(self::$objects[$obj->meta_value]) && is_array(self::$objects[$obj->meta_value])) {
foreach (self::$objects[$obj->meta_value] as $o) {
$o->singleUrl = $post_permalink;
}
}
}
} else {
$rs = mysql_query($query);
while ($obj = @mysql_fetch_object($rs)) {
$post_permalink = get_permalink($obj->post_ID);
if (isset(self::$objects[$obj->meta_value]) && is_array(self::$objects[$obj->meta_value])) {
foreach (self::$objects[$obj->meta_value] as $o) {
$o->singleUrl = $post_permalink;
}
}
}
}
}
function MessageGetInfo($idMessage)
{
$query = "SELECT * FROM `message` WHERE `idMessage`='{$idMessage}';";
$result = QueryExcuteWhile($query);
$o = mysqli_fetch_object($result);
return $o;
}
function verif_proportion_garcons_filles()
{
global $projet;
$retour = "";
$sql = "SELECT DISTINCT classe FROM gc_divisions WHERE projet='{$projet}' AND statut='future' ORDER BY classe;";
$res = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res) > 0) {
while ($lig = mysqli_fetch_object($res)) {
$sql = "SELECT 1=1 FROM gc_eleves_options geo, eleves e WHERE projet='" . $projet . "' AND classe_future='" . $lig->classe . "' AND e.sexe='F' AND geo.login=e.login;";
$res_f = mysqli_query($GLOBALS["mysqli"], $sql);
$eff_f = mysqli_num_rows($res_f);
$sql = "SELECT 1=1 FROM gc_eleves_options geo, eleves e WHERE projet='" . $projet . "' AND classe_future='" . $lig->classe . "' AND e.sexe='M' AND geo.login=e.login;";
$res_m = mysqli_query($GLOBALS["mysqli"], $sql);
$eff_m = mysqli_num_rows($res_m);
$eff_total = $eff_m + $eff_f;
if ($eff_total >= 20) {
if ($eff_f / $eff_total >= 2 / 3) {
$retour .= "<br /><strong>ATTENTION :</strong> La sélection courante de {$lig->classe} présente plus de 2/3 de filles.";
} elseif ($eff_m / $eff_total >= 2 / 3) {
$retour .= "<br /><strong>ATTENTION :</strong> La sélection courante de {$lig->classe} présente plus de 2/3 de garçons.";
}
}
}
}
return $retour;
}
function handleForm()
{
global $db;
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$role = $_POST['role'];
$f = $s = $e = $r = "";
if (isset($_POST['save'])) {
//save one record
$statement = "INSERT INTO users (firstname, lastname, email, type) VALUES\n ('{$firstname}','{$lastname}','{$email}','{$role}')";
if ($result = mysqli_query($db, $statement)) {
echo "<h3 style='color: green'>One row added to the database</h3>";
} else {
echo "<h3 style='color: red'>There was a problem saving your data</h3>";
}
} elseif (isset($_POST['amend'])) {
//alter one record
$statement = "UPDATE users SET firstname='{$firstname}', lastname='{$lastname}', type='{$role}' WHERE email='{$email}'";
if ($result = mysqli_query($db, $statement)) {
echo "<h3 style='color: green'>Database updated successfully</h3>";
} else {
echo "<h3 style='color: red'>There was a problem updating your data</h3>";
}
} elseif (isset($_POST['delete'])) {
//delete one record
$statement = "DELETE FROM users WHERE email='{$email}'";
if ($result = mysqli_query($db, $statement)) {
echo "<h3 style='color: green'>One row deleted from the database</h3>";
} else {
echo "<h3 style='color: red'>There was a problem deleting your data. Make sure that you entered the correct email address.</h3>";
}
} elseif (isset($_POST['view'])) {
//view one record
$statement = "SELECT * FROM users WHERE email='{$email}'";
if ($result = mysqli_query($db, $statement)) {
echo "<h3>Your query returned</h3>";
$data = mysqli_fetch_object($result);
$f = $data->firstname;
$s = $data->lastname;
$e = $data->email;
$r = $data->type;
} else {
echo "<h3 style='color: red'>There was a problem finding the row. Please check that you entered the correct email address</h3>";
}
} else {
//must be showall
$statement = "SELECT * FROM users";
if ($result = mysqli_query($db, $statement)) {
echo "<h3>Your query returned</h3><table border='1'>";
while ($data = mysqli_fetch_object($result)) {
echo "<tr><td>{$data->firstname}</td><td>{$data->lastname}</td>\n <td>{$data->email}</td><td>{$data->type}</td></tr>";
}
echo "</table>";
} else {
echo "<h3 style='color: red'>There was a problem retrieving data.</h3>";
}
}
printForm($f, $s, $e, $r);
}
function buildPage()
{
global $mysql;
$MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']);
$MySQLConnection->connect();
if ($result = $MySQLConnection->getQuery('SELECT messageID, messageRecipient, messageSender, messageTime, messageSubject, messageBody, userLogin, userID FROM messages JOIN users ON messageSender = userID WHERE messageRecipient = ' . $_SESSION["userID"] . ' LIMIT 0,25;')) {
echo '
<div class="col-md-2">
';
while ($row = mysqli_fetch_object($result)) {
$messageJSON = (string) json_encode($row);
echo '
<div class="list-group">
<a href="#" onclick="displayMessage(\'' . $row->messageID . '\');"" class="list-group-item">
<p class="list-group-item-text">' . $row->messageTime . ' - ' . $row->userLogin . '</p>
<h4 class="list-group-item-heading">' . $row->messageSubject . '</h4>
</a>
</div>
';
}
echo '</div>';
} else {
echo '<script type="text/javascript">', 'printError(\'Error while getting your messages!\')', '</script>';
}
}
function login($user, $password, &$result)
{
$dbhost = 'localhost';
$dbusername = '******';
/*usuario de base de datos*/
$dbuserpass = '';
/*contraseña, la deje en blanco para pruebas*/
$dbname = 'practicantes';
/*nombre de la base de datos*/
$con = mysqli_connect($dbhost, $dbusername, $dbuserpass, $dbname);
if (!$con) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
$sql = "SELECT usuario, password FROM usuarios WHERE usuario='" . $user . "' AND password='******';";
$rec = mysqli_query($con, $sql);
$count = 0;
while ($row = mysqli_fetch_object($rec)) {
$count++;
$result = $row;
}
if ($count == 1) {
return 1;
} else {
return 0;
}
}
function look_config_default_values($field_name, $like = '', $default_values = '')
{
if ($like == '') {
$sql = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME in ";
$arg_sql = array();
$arg = mysql2_prepare($sql, $arg_sql, $field_name);
} else {
$arg['SQL'] = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME like '%s'";
$arg['ARG'] = $field_name;
}
$resdefaultvalues = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
while ($item = mysqli_fetch_object($resdefaultvalues)) {
$result['name'][$item->NAME] = $item->NAME;
$result['ivalue'][$item->NAME] = $item->IVALUE;
$result['tvalue'][$item->NAME] = $item->TVALUE;
$result['comments'][$item->NAME] = $item->COMMENTS;
}
if (is_array($default_values)) {
foreach ($default_values as $key => $value) {
$key = strtolower($key);
if (is_array($value)) {
foreach ($value as $name => $val) {
if (!isset($result[$key][$name]) or $result[$key][$name] == '') {
$result[$key][$name] = $val;
}
}
}
}
}
return $result;
}
function genera_objeto($data)
{
while ($result = mysqli_fetch_object($data)) {
$query[] = $result;
}
return $query;
}
/**
* Page のAction.
*
* @return void
*/
function action()
{
/*My own query*/
$servername = "localhost";
$username = "******";
$password = "******";
$dbname = "rise_up_shop";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
$sql = "SELECT * FROM dtb_brand";
$result = mysqli_query($conn, $sql);
$arr = [];
$i = 0;
while ($row = mysqli_fetch_object($result)) {
$arr[$i]['brand_id'] = $row->brand_id;
$arr[$i]['name'] = $row->name;
$arr[$i]['address'] = $row->address;
$arr[$i]['email'] = $row->email;
$arr[$i]['image_path'] = $row->image_path;
$arr[$i]['website'] = $row->website;
$arr[$i]['description'] = $row->description;
$i++;
}
$this->tpl_subtitle = "Brand Detail";
$this->arrResults = $arr;
}
function person_by_id($id)
{
include 'dbconnect.php';
$query = "SELECT * FROM Person WHERE id = " . $id;
$mysqli_result = mysqli_query($connection, $query);
return mysqli_fetch_object($mysqli_result);
}
function get_note_by_note_id($id)
{
include 'dbconnect.php';
$query = "SELECT * FROM Notiz WHERE id = " . $id;
$mysqli_result = mysqli_query($connection, $query);
return mysqli_fetch_object($mysqli_result);
}
function listing_bsd_for_manage()
{
$sql = "SHOW DATABASES";
$link_test = mysqli_connect('localhost', 'root', 'darkevengyl');
$test = mysqli_query($link_test, $sql);
$i = '0';
$res_fx = array();
while ($row = mysqli_fetch_object($test)) {
$res_fx[$i] = $row;
$i++;
}
foreach ($res_fx as $row => $values) {
foreach ($values as $row) {
$new_res_fx[$row] = $row;
}
}
if (isset($new_res_fx['information_schema'])) {
unset($new_res_fx['information_schema']);
}
if (isset($new_res_fx['phpmyadmin'])) {
unset($new_res_fx['phpmyadmin']);
}
if (isset($new_res_fx['mysql'])) {
unset($new_res_fx['mysql']);
}
if (isset($new_res_fx['performance_schema'])) {
unset($new_res_fx['performance_schema']);
}
if (isset($new_res_fx['cdcol'])) {
unset($new_res_fx['cdcol']);
}
if (isset($new_res_fx['webauth'])) {
unset($new_res_fx['webauth']);
}
?>
<div class="col-lg-12">
<div class="col-lg-offset-3 col-lg-6">
<form method="post" action="?nav=intranet&nav_intra=manage_bsd">
<?php
foreach ($new_res_fx as $values) {
?>
<div class="checkbox-inline">
<label>
<input name='db_name' onchange="this.form.submit()" type="checkbox" value='<?php
echo $values;
?>
' />
<?php
echo $values;
?>
</label>
</div>
<?php
}
?>
</form>
</div>
</div><?php
}
function login($conn, $user, $pass)
{
//strip all tags from varible
$user = strip_tags(mysqli_real_escape_string($conn, $user));
$pass = strip_tags(mysqli_real_escape_string($conn, $pass));
// check if the user id and password combination exist in database
$sql = "SELECT * FROM users WHERE username = '******' AND password = '******'";
$result = mysqli_query($conn, $sql) or die('Query failed. ' . mysqli_error($conn));
while ($row = mysqli_fetch_object($result)) {
$userID = $row->userID;
$userPrivilege = $row->admin;
}
$_SESSION['admin'] = $userPrivilege;
$_SESSION['userID'] = $userID;
if (mysqli_num_rows($result) == 1) {
// the username and password match,
// set the session
$_SESSION['authorized'] = true;
// direct to admin
header('Location: ' . DIRADMIN);
exit;
} else {
// define an error message
$_SESSION['error'] = 'Sorry, wrong username or password';
}
}
function get_search()
{
$strSQL = '';
if (isset($_POST['searchtext'])) {
$searchtext = $_POST['searchtext'];
if ((string) (int) $searchtext == $searchtext) {
$price = intval($searchtext);
$strSQL = "SELECT m.deviceid,m.model FROM mobiles m, features f\n\t\t\t\t\t\tWHERE f.price BETWEEN {$price}-50 AND {$price}+50 AND m.DeviceID = f.DeviceID;";
} else {
$strSQL = "SELECT m.deviceid,m.model FROM mobiles m WHERE m.manufacture = '" . $searchtext . "' OR m.model = '" . $searchtext . "';";
}
$con = mysqli_connect("127.0.0.1", "root", "", "mobistore") or die(mysql_error());
$rs = mysqli_query($con, $strSQL);
$mobiles = array();
while ($object = mysqli_fetch_object($rs)) {
$mobiles[] = $object;
}
$display_str = "<table><tr> <th>Sl No. </th> <th> DEVICES </th> </tr> ";
$i = 0;
foreach ($mobiles as $mobile) {
if (intval($mobile->deviceid) < 50) {
$display_str .= ' ' . "<tr> <td> " . ++$i . "</td> <td> <a href=" . $mobile->deviceid . ".php>" . $mobile->model . "</a> </td> </tr>";
} else {
$display_str .= ' ' . "<tr> <td> " . ++$i . "</td> <td> <a href=defaultdevice.php>" . $mobile->model . "</a> </td> </tr>";
}
}
$display_str .= ' ' . "</table>";
mysqli_close($con);
return $display_str;
}
}
function PegaHorarios($condicao, $login, $link)
{
echo "<table style='text-align: center; text-align: center;'>\n <tr style='width: 100%'>\n <td></td>\n <td style='width: 18%'><font size='5' color='#556b2f'>Seg</font></td>\n <td style='width: 18%'><font size='5' color='#556b2f'>Ter</font></td>\n <td style='width: 18%'><font size='5' color='#556b2f'>Qua</font></td>\n <td style='width: 18%'><font size='5' color='#556b2f'>Qui</font></td>\n <td style='width: 18%'><font size='5' color='#556b2f'>Sex</font></td>\n </tr>";
$semana = array("seg", "ter", "qua", "qui", "sex");
$h = 8;
$h2 = 9;
for ($i = 0; $i < 8; $i++) {
echo "<tr>";
if ($h == 12) {
$h++;
$h2++;
}
echo "<td><font size='4' color='#556b2f'>{$h}:30-{$h2}:30</font></td>";
for ($j = 0; $j < 5; $j++) {
echo "<td style='width: 18%'><div style='border: 1px solid #556b2f; background-color: #66cdaa; margin-left: 3px; margin-bottom: 3px;'>";
if ($condicao == 1) {
$sql = "select * from ejbsm_horario_bolsista where {$semana[$j]}{$h}{$h2} = '1';";
} else {
$sql = "select * from ejbsm_horario_bolsista where {$semana[$j]}{$h}{$h2} = '1' and login = '******';";
}
$result = $link->query($sql) or die(mysqli_error($link));
while ($r = mysqli_fetch_object($result)) {
$sql2 = "select nome from ejbsm_usuario where login = '******';";
$res = $link->query($sql2);
$nome = mysqli_fetch_object($res);
echo "<font color='white'>{$nome->nome}</font><br>";
}
echo "</div></td>";
}
echo "</tr>";
$h += 1;
$h2 += 1;
}
echo "</table>";
}
public function fetch_object($result)
{
if (!is_resource($result)) {
debug_print_backtrace();
}
return mysqli_fetch_object($result);
}
public function selectLastMessage()
{
$request = "SELECT * FROM tchat ORDER BY id DESC LIMIT 1";
$res = mysqli_query($this->link, $request);
$message = mysqli_fetch_object($res, "Tchat", array($this->link));
return $message;
}
public function query($query)
{
if (isset($this->connection)) {
$result = $this->connection->query($query) or die(mysqli_error($this->connection));
return mysqli_fetch_object($result);
}
}
function fun_select_elemento($nombre_tabla, $campos_get, $condicion, $orderby, $inicio, $numero)
{
//INGRESA UN NUEVO PADRE
$cn = $this->conexion();
if ($cn != "no_conexion") {
$cn->query('BEGIN');
try {
$limitacion = '';
if ($numero > 0) {
$limitacion = ' limit ' . $inicio . ',' . $numero;
}
$sql = 'select ' . $campos_get . ' from ' . $nombre_tabla . ' where ' . $condicion . $orderby . $limitacion;
$rs = $cn->query($sql);
while ($fila = mysqli_fetch_object($rs)) {
$respuesta[] = $fila;
}
$cn->query('COMMIT');
mysqli_close($cn);
return $respuesta;
} catch (Exception $ex) {
$cn->query('ROLLBACK');
mysqli_close($cn);
return 'mysql_no';
}
} else {
return "mysql_no";
}
}
public function getTimeMonitors()
{
$con = new Connection();
$link = $con->link();
$result = $link->query("select * from ejbsm_time_monitors WHERE id = 1") or die(mysqli_error($link));
$row = mysqli_fetch_object($result);
return $row;
}
public function fetch($res)
{
$result = array();
while ($data = mysqli_fetch_object($res)) {
$result[] = $data;
}
return $result;
}
function topic($tempRan)
{
global $tempArea;
global $conn;
$sampQsn = "SELECT {$tempArea} FROM expertisesamplequestion WHERE ID='" . $tempRan . "'";
$con1 = mysqli_fetch_object(mysqli_query($conn, $sampQsn));
return $con1->{$tempArea};
}
