Questions tagged as 'mysql'

Tagged questions
0
answers

Error changing password (MYSQL_ROOT_PASSWORD) in MySQL docker.compose.yml file

I recently had to change the administrator password for my database (I currently use MySQL), I changed the password 'MYSQL_ROOT_PASSWORD' but it did not reflect changes in my container. I have already tried to delete, build and try a forced refr...
asked by 16.03.2018 / 14:15
0
answers

Create filter on a chart

I have the following graphic that works with the following code: <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><scripttype="text/javascript"> goog...
asked by 16.03.2018 / 09:40
0
answers

Procedure does not execute its loop and not the syntax error

The PROCEDURE below does not display a syntax error, but when running the LOOP it does not update the records correctly, only some are updated. CREATE PROCEDURE 'SP_ATU_ITEM_NF' () BEGIN DECLARE v_nota_antiga INT default 0; DECLARE v_itm...
asked by 11.04.2018 / 19:36
1
answer

Insert data into related tables using PDO

Hello, I have 2 tables with a foreign key, I need to insert data into it using the PDO library. OBS: I'm newbie so do not get heavy .. Tables: FormCode:<?phprequire'connect.php';?><html><head><title>CadastrodeCurso...
asked by 11.03.2018 / 17:48
0
answers

HTML, JS - Creating Form with Subform

I've created this java script to Select State and City with FORM SELECT What I have is ... I would like to get the state data through MYSQL instead of being write them ... How can I do this in JS? dgCidadesEstados.prototype = { estado: docu...
asked by 03.04.2018 / 12:16
0
answers

MySQL Error - request has expired

I'm using MySQL, however I'm having to reset the password every time I restart my notebook. I use Sequel pro to access the bank and give the following error:    Can not connect to host 127.0.0.1, or request has expired.       Make sure the a...
asked by 22.04.2018 / 16:31
2
answers

Save name and image extension and upload to a specific folder in php and then show in a table

When displaying a query in a table I create these three fields for the user to update to the line that shows the query data: <?php $tabela1 .= '<td> <input type="file" name= "Imagem['.$rows_cursos['Id'].']" value="'.$rows_cursos['I...
asked by 20.02.2018 / 10:05
2
answers

Update with foreach in the database

I show this data with select and after the user queries you can edit three fields: Image, Treatment and Status . The State field is doing the update correct in the table, but the input type="file" and input type="text"...
asked by 19.02.2018 / 16:18
2
answers

Search with a null value, mysql

I'm a beginner in programming and I'm trying to find something new, in this case, I have two selects fields that tell my values, but I'd like the search to be done even if a field is null This is the request code if($_SERVER['REQUEST_METHOD...
asked by 14.03.2018 / 13:38
1
answer

Insert multiple products + a rental date for each

I have a tremendous doubt and no way to solve it. I need to select products to rent for a client and give them a rental date, but I do not know how to present it in the system in a simple and functional way. Example: DB Products 1 -...
asked by 15.02.2018 / 14:37