I'm trying to do a select in 4 different tables. All are related. It all starts with ID_Morador .
SELECT morador.*
,unidades.*
,grupo.*
,condominios.*
FROM morador
LEFT JOIN unidades
ON id_morador = morador.id_uni...
Colleagues.
I have a table that brings the beginning and the end of an event.
InicioEvento = 2016-06-01 07:00:00
FimEvento = 2016-12-31 00:00:00
I know if I use BETWEEN, I can search between dates, but how would I do between dates with...
I have a page that connects to the database and brings information correctly, however I would like to put information on a form using the select field, but I'm having some difficulties if someone can help me follow my code.
<?php
require_on...
My code when registering for a new user:
$sql1 = "INSERT INTO usuario (login, senha_hash, nome, email, direito_deAcesso)
VALUES ('{$usuario}', '{$senha_hash}', '{$nome}', '{$email}', '{$direito_deAcesso}')";
$query1...
Hello,
I have a table in mysql basically in this format.
id transaction_id name buyer_email transaction_date paymentstatus
1 989Y8DT8S65DS Test [email protected] 17/02/2016 Completed
My...
Hello,
I have an ecommerce and I'm implementing some changes including the express checkout of paypal, the api I'm using is the one provided by paypal. The problem is that by returning the data and picking up the buyer's email variable it ret...
Well my personal question is the following I would like to update a value in the "Database" without losing the value there already allocated, Good for better understanding of my doubt Irie cite an example:
I have a CALLED TABLE: Clients; With co...
How can I get the loop to send every 10 emails or every X seconds? I want to prevent emails from falling on the spam list.
And how can I make the code read a .txt file with the emails listed and in future a database?
<?PHP
require_once(...
I'm learning the ninja arts of PHP and my code has been giving a little headache.
<div class="container">
<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12">
<section class="painel novidades">
<h2>Novidade...
I need to translate the following MySql query to Hibernate:
select sum(TOTAL_MERCADORIA_BRL) from PROCESSO group by PERIODO like 'DEZ-15';
What would be the best way to do this query, but using Hibernate?