Questions tagged as 'mysql'

Tagged questions
2
answers

Consult two or more columns of two or more tables in a single statement

I have two tables Usuarios and Logs . In the Logs table I have ID, fecha, hora, usuario, estado, estaciòn . In the table Usuarios I have ID, Empleado, Nombre, Apellido, permisos, ID_Campaña, horario ....
asked by 14.01.2018 / 06:45
1
answer

Connect database site php5 to php7 [duplicated]

I'm trying to move my site to a server with php7 with mysqli: I have a conexion.php file that I modified and now looks like this: <?php $hostname_conexion = "localhost"; $database_conexion = "opentach"; $username_conexion = "root"; $p...
asked by 12.01.2018 / 11:50
3
answers

JMSSerializer Bundle does not serialize relationships

Controller: public function newUserAction(Request $request) { $errores = array(); $usuario = new Usuario(); $foto = $request->files->get('foto'); $email = $request->request->get('email'); $username = $request-&...
asked by 12.01.2018 / 09:14
0
answers

How to upload an image to the server with php and at the same time create the folder of each logged in user?

<?php //Recibimos los datos de la imagen $nombre_imagen=$_FILES['file']['name']; $tipo_imagen=$_FILES['file'] ['type']; $tamagno_imagen=$_FILES['file']['size']; //aqui va el nombre de la carpeta del usuario logueado $nombre ='nombreCarpet...
asked by 24.01.2018 / 17:54
0
answers

Generate file ".sql" from CODEIGNITER

How about, someone who can help me generate a file ".sql" a backup of my database from php using codeigniter, which are only some tables which are in an array $ tables = array (                 "table1", "table2", "table3"); and that the f...
asked by 10.01.2018 / 22:35
0
answers

Problem when grouping data in query

I have 3 tables: "Clients" with id, client_code, c_id (client's CRM code), name, and cif. "Machines", with the fields id, id_maq (CRM code), install_date, duration, tariff_id, serial_num, customer_code, customer_id (crm code), cost_id and...
asked by 11.01.2018 / 19:07
1
answer

Procedure stored in mysql

Hi guys, good morning again here with new questions. I'm doing a maintainer in java Desktop and in the search part I have a text field where I would enter the value to search, but I also have a radiobuttons that would allow me to choose the f...
asked by 11.01.2018 / 18:43
1
answer

# 1064 - You have an error in your SQL syntax;

There are some sales that no longer exist and I want to delete the installments that were made with those nonexistent sales, my code was this: DELETE Abonos_Creditos FROM Abonos_Creditos ac LEFT JOIN Venta_Gas vg ON ac.id_credito=vg.idVenta W...
asked by 10.01.2018 / 00:31
1
answer

Optimize tables in Database

Good morning, I'm modifying an app where access to different user types is required, the app has a table for each type of user (if the app works) but if you create N types of users you would have to create N tables which I do not see as feasible...
asked by 18.01.2018 / 16:52
0
answers

search php and mysql

I have a search engine with a normal form and everything, but in my bd I have some words with ñ and others without ñ in case the client enters it wrong. The problem is that let's say I look for the word "estreñimiento"...
asked by 09.01.2018 / 15:40