<?php
$ajax = (isset($_SERVER['HTTP_X_REQUESTED_WITH']) and strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest');
if ($ajax) {
include '../controller/createConnection.php';
$connection = new createConnection();
$conexion = $connection->connectToDatabase();
//$con = $connection ->selectDatabase($conexion); //creamos la conexion
}
$sql_get_users = "SELECT id, nombre, nickname, edad, id_categoria FROM users";
$consulta_users = $connection->_select_query($sql_get_users);
$elements = array();
//print_r($connection->result);
$cnt = 0;
for ($i = 0; $i < $connection->num_registros; $i++) {
$id = $connection->result[$i]['id'];
$nombre = $connection->result[$i]['nombre'];
$nickname = $connection->result[$i]['nickname'];
$edad = $connection->result[$i]['edad'];
$categoria = $connection->result[$i]['id_categoria'];
$aux = array('Id' => '"' . $id . '"', 'Nombre' => '"' . $nombre . '"', 'Nick' => '"' . $nickname . '"', 'edad' => '"' . $edad . '"', 'id_categoria' => '"' . $categoria . '"');
array_push($elements, $aux);
unset($aux);
//echo "mi array: ";var_dump($elements);
$cnt += 1;
}
/*
$rs_get_users = mysqli_query($conexion, $sql_get_users);
if($rs_get_users){
$num_lineas = mysql_num_rows($rs_get_users);
$elements = array();
<?php
echo ' ' . '<div class="modal fade" id="newUs" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">' . ' <div class="modal-dialog" role="document">' . ' <div class="modal-content" style="height: 400px;">' . ' <div class="modal-header">' . ' <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>' . ' <h4 class="modal-title" id="myModalLabel">Nuevo usuario</h4>' . ' </div>' . ' <div class="modal-body">' . ' <form id="nuevoUser" action="#">' . ' <div class="form-group">' . ' <label for="nombre">Nombre</label>' . ' <input type="text" class="form-control" name="nombre" id="nombre" placeholder="Nombre usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Apodo usuario</label>' . ' <input type="text" class="form-control" name="nickname" id="apodo" placeholder="Apodo usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Edad usuario</label>' . ' <input type="number" class="form-control" name="edad" id="edad" placeholder="Edad usuario">' . ' </div>' . '' . ' <div class="form-group">' . ' <label for="nombre">Categoria usuario</label>' . ' <select class="form-control" name="id_categoria">';
include '/controller/createConnection.php';
$conexion = new createConnection();
$conexion->connectToDatabase();
$sql_get_categ = "SELECT id, name FROM categoria";
$conexion->_select_query($sql_get_categ);
for ($i = 0; $i < $conexion->num_registros; $i++) {
echo '<option value="' . $conexion->result[$i]["id"] . '">' . $conexion->result[$i]["name"] . '</option>';
}
echo ' </select>' . ' </div>' . ' <div class="form-group">' . ' <button id="sendNewUser" class="button button--winona button--border-thin button--round-s" data-text="Crear" style="margin-top: 0px;"><span>Crear</span></button>' . ' </div>' . ' </form>' . ' </div>' . ' </div>' . ' </div>' . '</div>';
/*
include '/controller/modal.php';
$id = "edita_user";
$h = '<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>';
$h .= '<h4 class="modal-title" id="myModalLabel">Editar usuario</h4>';
$b = '<p>cuerpo del editor de usuario</p>';
$f = '<button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>';
$f .= '<button type="button" class="btn btn-primary">Guardar cambios</button>';
$modal = new modal($id, $h, $b, $f);
*/
?>
<div class="modal fade bs-example-modal-lg" id="editUs" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5>Editar usuario</h5>
</div>
<div class="modal-body">
<div class="row">
