Questions tagged as 'mysql'

Tagged questions
0
answers

How to use bind_param without repeating variables

This code here inserts the parcels of a payment, the m1, m2, m3 and etc are variables that add a month to the current date, for example $m1 = date('Y-m-d',strtotime("+1 month")); $stmt20 = $conexao->prepare(" INSERT INTO esc_...
asked by 07.12.2018 / 15:52
1
answer

Procedure in MySql to clone products, using CURSOR FOR SELECT

I need to clone the data from a table EST_PROD_PRECO_CUSTO_EMPRESA of the company of id x to the same table but of the company with id and. in Pl / Sql I did it that way. DECLARE CURSOR v_precos IS SELECT ID_PRODUTO, PRECO_CUSTO, PRECO_CUST...
asked by 07.12.2018 / 19:29
0
answers

Error using Join and Count

Hello, the error now is that it is adding the CodSetor. The values would be 6 and 3, however 6 and 6 are coming. Follow photos and codes. SELECT *, COUNT('funcionario'.'funcionario_CodSetor') AS total FROM 'funcionario' JOIN 'setor' ON '...
asked by 22.12.2018 / 18:18
1
answer

Bring result of a sum on screen

I'm trying to create a sum and display it on screen. But almost all of the examples I see use the $conn call and in my case I'm using a file that already has the connection to the database and the query + row p> Follow the code...
asked by 23.12.2018 / 02:21
0
answers

java.sql.SQLFeatureNotSupportedException error attempting to retrieve data from a table

I'm having this difficulty retrieving data from a table. The recovery code I'm doing on my own because I do not find any examples to try to follow, but I've been breaking my head for a long time and I can not seem to get out of the way. Does any...
asked by 15.12.2018 / 23:42
0
answers

Line graph Chart, js

Good morning, I've been trying to get the chart.js graph for two weeks to grab the data from the database and display it in real time. Follow my database. CREATE TABLE 'tab_clientes' ( 'id' int(11) NOT NULL, 'data_nascimento' date...
asked by 16.12.2018 / 16:39
1
answer

Get the tr value that the user clicked on a PivotTable

Hello ... I have a problem for many days and I can not resolve it. The situation is as follows: I have a table that is created dynamically from the data in the database: Whentheuserhoveroveranoption,itishighlighted: Ineedtoclickonasele...
asked by 12.12.2018 / 04:42
0
answers

Update with PHP and MYSQL division

How do I UPDATE for all users of a database? For example: UPDATE usuarios SET juros=investimento + investimento * 30 /100 WHERE id='89' The bank will take the investment data and add 30%, but if I take the WHERE to add this v...
asked by 12.12.2018 / 03:47
0
answers

Indexes database - Problem with queries that use many tables

My database is slow, I activated slow queries, and the only query executed with more than 1 second of response (this is too much for my server) is as follows: SELECT 'user_id' FROM Wo_Users WHERE 'user_id' IN (SELECT 'following_id' FROM Wo_F...
asked by 12.12.2018 / 12:02
1
answer

Questions about installing the existing project in Laravel

Hello everyone! I started messing with Laravel today and until I can create a new project, but I need to open and run an existing project and I can not do it. It asks for the autoload.php file that is not in the project, nor is the vendor fol...
asked by 05.12.2018 / 17:49