Questions tagged as 'mysql'

Tagged questions
3
answers

Average time in seconds

Hello, in my select I need to find the average service time (TMA) between two BIGINT format columns:    Date: DtBegin and DtEnd
asked by 24.05.2017 / 19:40
1
answer

Explode and compare value in a Select?

In my MySql I have the following column data_id it stores values in this 120-01-01 format, as would be SELECT that would make a EXPLODE in that field and check if the first value of array than in case would...
asked by 30.05.2017 / 21:35
1
answer

Help to display bank data on screen

I'm doing an INNER JOIN between two tables in my bank. But I'm having trouble showing the result organized on the screen, could anyone help me? The tables are category and service (related to category). In the category table I have only the id a...
asked by 30.05.2017 / 21:03
0
answers

unset () being executed within a wrong conditional

I have an interesting problem: my unset ($ _ SESSION ['x']) is running inside an IF that is not true. Look at my code: <?php // Codigo do estado $cod_estado = $_GET['s']; // Função da classe Usuario $cont_resultado = count(Usuario::CS_Get...
asked by 22.05.2017 / 15:37
0
answers

Error calculating fields in IOS safari

I have a problem in developing a small calculation system where the user needs to put a value in a field and the system returns the results according to a specific account. In all browsers for windows on computers and Android works correctly,...
asked by 22.05.2017 / 15:01
2
answers

Edit MySQL database with php

I'm doing a registration system in php, and using mysql as db, I've already been able to do the registration page and it's working normally. The problem is that now I need a link to be created when the database is created and clicking on it to e...
asked by 23.05.2017 / 00:43
1
answer

Using LastInsertId () more than once

I need to use lastInsertId () more than once in my application. Here is an example of such an event: <?php //CONEXÃO COM O BANCO DE DADOS $pdo=new PDO("mysql:host=localhost;dbname=xxx","xxx","xxx"); //VARIÁVEIS COM DADOS DO FORMULÁRIO $nom...
asked by 20.05.2017 / 03:23
1
answer

Doubt Mysql + PHP

Hello, I'm developing an online management system (fifa, pes) and I'm having a problem, now I'm doing the part where the user will post the result of the game, informing the scoreboard and the players who made the goals , for this I need to acce...
asked by 18.05.2017 / 23:27
2
answers

Delay in loading some records

Hello! We work with SugarCrm. Who does not know Sugarcrm is a CRM made in mysql and php that uses the Zend framework. We used the opensource version and did some customization. I'm having trouble where some customer records take too long to l...
asked by 18.05.2017 / 14:18
1
answer

Page does not load because of transaction

I'm trying to implement a transaction in my SQLs, but because of them, my page does not load. Here is the code: <?php //CONEXÃO COM O BANCO DE DADOS include_once("conexao.php"); //VARIÁVEIS COM DADOS DO FORMULÁRIO $nome = $_POST["nome"]; $...
asked by 17.05.2017 / 21:02