Questions tagged as 'mysql'

Tagged questions
1
answer

Blank page when printing a Mysql statement using Laravel

I have this mysql statement public function mayores(Request $req){$taquito=DB::select('select * from clientes where edad = ?', [18]);view('Layouts.mayores',compact('taquito'));} to get all my clients older than 18 years old which is inside...
asked by 23.10.2017 / 12:57
1
answer

Obtain data from different tables in a mysql database

Hello, good evening everyone, I have a problem when making a query on mysql from php. Basically my system will make reports from a database, which is structured like this: Profiles Table +-------------+-------------+------+-----+---------...
asked by 01.09.2017 / 02:02
1
answer

How to add and remove selects with jquery?

Hi, I have a jquery code that works perfectly for me to add new inputs. The problem is that I also need to add dynamic selects for my system and I really do not understand the syntax of jquery. I would greatly appreciate your help. Certainly the...
asked by 01.09.2017 / 15:04
2
answers

INSERT INTO does not work and the code does not give an error

I try to insert data into the database, mysql and it does not give me the else error and no php error or something, 3 days ago I'm trying to find how to do it and nothing, the code is fine, but it throws the error and the database does not recei...
asked by 03.11.2017 / 14:32
1
answer

separate SQL field

I have the following table with the following data select * from archivo_final cs_promocion 3 d_promocion DSCTO NESPRESSO st_promocion A fecha_desde 2017-07-04 fecha_hasta 2017-12-31 almacenes 109,111,1...
asked by 02.11.2017 / 16:19
1
answer

How to prevent certain characters from being entered in a field

I'm with a form, where you have to enter a place of an event. It occurred to me to put in place of the word "Barrio" The characters "B °" and the recording process gave me an error. $lugar = htmlentities(addslashes($_POST['lugar'])); thus "...
asked by 29.08.2017 / 01:35
1
answer

how to filter fields with several and and with or in mysql?

My query is as follows select * from paciente pc join persona per on per.dni=pc.dni join det_pac_tra dp on dp.dni=pc.dni where pc.cod_centro_salud='3' and pc.cod_situacion='1' and dp.frecuencia_fase1 = '1' or dp.frecuencia_fase2='2' I...
asked by 28.08.2017 / 17:53
1
answer

PHP activity log

Greetings to all, I have a small table where everyone can consult, edit and insert and I want to know who has made some movement but without using login rather know through the name of the pc or user of windows.     
asked by 27.08.2017 / 23:54
1
answer

Update with MySQL subquery,

I have a project where I have to do a update of a table field (active) , I practically have something like this: UPDATE t1 INNER JOIN (SELECT MAX(id) FROM t2_copy GROUP BY idq ORDER BY idq DESC)AS x2 SET activa = TRUE WHERE...
asked by 22.11.2017 / 19:13
1
answer

query with LIKE operator mysql java

I am dynamically creating a Select by concatenating a series of parameters that are collected from a form. @Override public List<ResultadoBusquedaEnsayo> buscarEnsayos(BusquedaEnsayo busquedaEnsayo){ List<Object> parametros =...
asked by 23.11.2017 / 10:38