Questions tagged as 'mysql'

Tagged questions
0
answers

Password Bitnami Moodle

I am trying to access PhpMyAdmin in Moodle from Bitnami and I can not log in, I just installed and do not know the root , I'm waiting for answers ... I have tried to leave without a password and have already tried the "root", "admin" and...
asked by 24.03.2016 / 14:23
1
answer

Place Result Even If Registration Does Not Exist

I'm trying to make a query where the column with the total 0 appears in the table even if there are no records in that particular status. For example: SELECT STATUS, COALESCE(COUNT(ID), 0) AS TOTAL FROM TABELA WHERE ID_CHAVE =...
asked by 23.03.2016 / 13:55
0
answers

How to show informative message to user and follow stream for recording in BD

I have a difficulty that I can not resolve, before registering an information in my BD I make a check to see if what the user is trying to do is allowed, in my case a certain contract must follow some mandatory phases and when the user tr...
asked by 23.02.2016 / 21:26
1
answer

SQL records the largest date of an attribute

I have a table named kanban_card_journals which has the following attributes: id kanban_card_id issue_journal_id created_at Where the first three are numbers and the last date and time. This table saves the date of all change...
asked by 19.02.2016 / 14:10
1
answer

Error checking existing record pdo

I have the following PDO class: <?php abstract class database{ /*Método construtor do banco de dados*/ private function __construct(){} /*Evita que a classe seja clonada*/ private function __clone(){} /*Método que dest...
asked by 15.02.2016 / 14:02
1
answer

Query with Join returning empty

Please help me check my query because it is giving an error that I can not identify.  If I do the simple query: SELECT * FROM respostas WHERE resp_usuario='8'...
asked by 06.04.2016 / 16:54
2
answers

Doubt how to loop in JavaScript

Hello, I have this code below: <div class="center_content" style="background:<?php echo $res['fundosite_cor']; ?>; width:588px; float:left;"> <?php include "conexao.php"; $codigo = $_POST['codigo']; $img0...
asked by 16.03.2016 / 13:27
0
answers

Problem setting value of a mysql BIT field

Using Java + Hibernate on my systems, I created a boolean attribute to determine if a user is an administrator: private boolean isAdmin; The Hibernate generates tables and fields, and this isAdm field becomes type...
asked by 16.03.2016 / 20:42
2
answers

Doubt how to loop in JavaScript

Hello, I have this code below: <div class="center_content" style="background:<?php echo $res['fundosite_cor']; ?>; width:588px; float:left;"> <?php include "conexao.php"; $codigo = $_POST['codigo']; $img0...
asked by 16.03.2016 / 13:27
1
answer

Problems deleting table data with :: PDO

Can anyone explain to me what the error is or if there is any flaw in the script ?? As far as I know this is correct, it does not work. In the script it takes the ID of who followed and the ID of who was followed and should remove by the para...
asked by 10.02.2016 / 14:13