Questions tagged as 'mysql'

Tagged questions
1
answer

Catch the next event with Mysql

I have a system from which to get the current day schedule and the next schedule, see: Togetthescheduleforthecurrentday,Ididthis://DataAgenda=NOW()mysqli_query($this-conexao,"SELECT * FROM agenda WHERE DATE(DataAgenda) = CURDATE()"); And...
asked by 13.07.2018 / 16:10
0
answers

What is the difference between the MySql.Data.Entity Vs MySql.Data.EntityFramework

I created an application using EF 6.2.0 using MySql When I use the MySql.Data 8.0.11 package together with MySql.Data.EntityFramework 8.0.11 it works normally. When I use the MySql.Data 6.10.7 package together with MySql.Data.Entity 6.10.7...
asked by 04.07.2018 / 20:07
0
answers

I need to limit results of each column in 4 items only in MySQL

I'm using this select SELECT * FROM (SELECT * FROM clientescontatos t1 WHERE codcliente = 'teste' AND tecnicoFlag = 1 LIMIT 4 UNION ALL SELECT * FROM clientescont...
asked by 04.07.2018 / 20:55
1
answer

Save checkbox in mysql with php

I'm trying to save this form to the database but when I got to the checkbox I could not save it to the database. Here are the codes I tried to use. HTML: <div class="col-sm-12"> <label><b>Como você ficou sabendo do empreen...
asked by 10.07.2018 / 14:24
2
answers

Receiving HTTP POST Json with PHP MYSQL PDO

I'm having trouble solving a problem and I'm counting on your help. I am getting, from an external API, an HTTP POST request in JSON format with some information. I need to get this information separately and do an UPDATE on MYSQL using PDO. The...
asked by 10.07.2018 / 16:52
0
answers

Queries for reports in Java With JasperSoft

I need to create a dynamic report with queries involving more than one MySQL table. Whenever I run a new query, the fields in the previous query are replaced by those in the new query. Is there any solution to this? Is it possible to do more tha...
asked by 10.07.2018 / 16:24
1
answer

Modal receiving data from the database

My product page displays all registered products from the database as div below. <?php $id_up = $GET["id"]; require("funcoes/conexao.php"); $quantidade = 10;...
asked by 04.07.2018 / 15:44
0
answers

Heavier queries in MYSQL [duplicate]

How do I know which queries are being weighted in my mysql bd? Is there any command I can give that will bring me this data?     
asked by 05.07.2018 / 03:52
0
answers

PHP / Database, add MD5 and verify [duplicate]

Well, I use the following code to check if the user exists and log in: <?PHP include('config.php'); include('menu.php'); # Validar os dados do usuário function anti_sql_injection($string) { include('config.php'); $string = strips...
asked by 02.07.2018 / 00:17
0
answers

MySQL: Database page corruption on disk or a failed

Well, my mysql gave a problem before the daily backup. Would you solve it? 180629 17:14:08 [Note] 'FEDERATED' plugin is disabled. InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on InnoDB: Skipping log redo 180629 17:14:08 InnoDB: Error: space...
asked by 29.06.2018 / 22:16