Questions tagged as 'mysql'

Tagged questions
1
answer

fadeIn jquery in the calling of a function

the problem is that I need to apply fadeIn a function success: function(data){ console.log(data); viewUser(); } when the success occurs the viewUser(); will update the user table, the problem is that I would like...
asked by 07.02.2017 / 14:51
3
answers

Problem with fetch_all (), does not get rows

I'm doing an exercise with fetch_all() , it's supposed to show the data of the BD in an array but it does not show anything. <?php try { require_once ('includes/funciones/bd_conexion.php'); $sql = "SELECT * FROM 'registros';...
asked by 19.02.2017 / 20:11
1
answer

Dates stored and date retrieved vary in mysql DB

In my database I have the date stored 01/02/2017 15:17:34 p.m. Inserted as follows: objBD.query('SELECT u.ID_U, u.nombre from USUARIO u where u.nombre=?',[nombre], function(err, rows, fields) { var created = new Date(); cons...
asked by 03.02.2017 / 05:23
1
answer

Change sql query

I have the following query to obtain an average of some data of the 52 weeks of the year in the following way: $dates = array(); $firstDate = date("Y-m-d", strtotime('first day of January 2016')); $lastDate = date("Y-m-d", strtotime('last day...
asked by 03.02.2017 / 20:42
2
answers

php make a web with login and navigate inside without losing the logeo of the web

Hi chic @ s I have this script: <?php session_start(); include_once "conexion.php"; function verificar_login($user,$password,&$result) { $sql = "SELECT * FROM usuarios WHERE usuario = '$user' and password = '$password'"; $r...
asked by 02.01.2017 / 22:56
1
answer

Modify several tables with a join

Currently in my project I own 5 tables that are related to each other through a series of primary and foreign keys. Now I have a section where I can modify the data of all the tables but I would like to do it with an inner join. Is this possible...
asked by 29.12.2016 / 05:25
1
answer

Decompose the result of a MySql query that is in JSON to new indexable fields in elasticsearch with logstash

I want to put the result of a query from mysql to elasticsearch through logstash, I have a field called Detail that contains a string that is a JSON, which can contain the following: { "interna": true, "ContactoNombre": "Marvel", "Contac...
asked by 28.12.2016 / 16:49
0
answers

Nginx does not recognize php 7 [closed]

I have installed Nginx, MySQL and PHP 7, but when I do the phpinfo () test I only download the file and do not deploy it in the browser, I followed the installation steps of this link: link I do not know what the error could be.     
asked by 26.02.2017 / 16:49
1
answer

Help with creating a php record and insert in database

I do not understand much about this, but what I'm doing is an android project. Create a login with facebook, which leads to a user registry, in which only the users enter a user, and the rest of the data I subtract from the profile. The fu...
asked by 31.12.2016 / 07:47
1
answer

Query between 4 mysql tables with foreign keys (foreign key)

I have these tables in my database to assign roles to my users: tbl usuario id nombre contraseña correo fk_rol -------------------- tbl rol id_rol nombre descripcion -------------------- tbl pagina...
asked by 21.01.2017 / 21:50