Questions tagged as 'mysql'

Tagged questions
0
answers

Function within an if else

I have the following function in PHP function verificar_status(){ global $db, $username, $usua, $ci_nro_cuenta, $monto, $nro_transf, $banco_emisor, $banco_destino, $fecha_transf, $status_pedido, $fecha_pedido, $status_pag...
asked by 08.09.2018 / 15:53
1
answer

query of 1 table related to 3 mysql

I have 3 tables: 1. contributions 2. contributions_volunteers 3. contributions_multas All these tables have an import field, and they are all related to the table: 4. associates What I want is to show the partner and the sum of their amounts in...
asked by 08.09.2018 / 14:45
0
answers

Problem with .get with php using ajax

I have the following form on my website: I am trying to make sure that, in the selection of subjects, the subjects are loaded according to the chosen career. I read that you can do this type of operation, without reloading the page, thr...
asked by 08.09.2018 / 03:00
0
answers

MySQL Wildcards in Android Studio

I have made a query in MySQL and it works perfectly until the wildcard% is introduced in front of the text to be searched with LIKE (behind it goes well) This is the query: SELECT id_ave, DATE_FORMAT(fch_ave,'%d/%m/%Y') AS 'fecha', zon_a...
asked by 27.08.2018 / 08:02
0
answers

MySQL -How can I change the id to the username?

I am trying to make a query with the following 2 tables: ************ *************** * Usuarios * * Seguidores * ************ *************** * id * * id * * username * * user...
asked by 25.08.2018 / 02:34
0
answers

Error importing to phpmyadmin from mysql workbench

I need your help and your knowledge .. I am new programming. I was starting with something simple like forming categories in MySql workbench based on structures, then export it in sql format and import it in phpmyadmin to start working it. The e...
asked by 24.08.2018 / 04:31
1
answer

how to show images that I have in a database

such friends I ask for your help, I have a table in my database where I save the images and I want to show them on my html page, but when you show them they are arranged horizontally in a row, instead of showing them down $query = mysqli_query...
asked by 24.08.2018 / 02:14
0
answers

Take the value out of an input id

I am passing data from a table to a modal to edit it, all this happened: So I send it to the modal: <td class="otrotdfgaz" id="Producto<?php echo $res['pedID']; ?>"><?php echo $res['producto']; ?> <?php echo $res['ali...
asked by 29.08.2018 / 09:18
1
answer

Problem in mysql stored procedure (Illegal mix of collations (utf8_unicode_ci, IMPLICIT) and (utf8_general_ci, IMPLICIT) for operation '=')

I have a stored procedure, which tries to validate that the user and the mail that is being entered does not exist in the database before creating the record (inserting them) in the database. The code I have is this: CREATE DEFINER='root'@'loc...
asked by 29.08.2018 / 02:35
0
answers

Where do I share the folder of a MySQL container in docker so as not to lose the connection?

I have created two containers, one from wordpress and another from mysql. They were working perfectly until I shared a folder between the mysql container and the pc. In doing so I lost the connection in the wordpress, and the folder I share from...
asked by 21.08.2018 / 08:48