Questions tagged as 'mysql'

1
answer

insert in the table only the line that receives value in the date column

I have this code: <?php $result_cursos = "SELECT nome, Quarto FROM centrodb.utentes WHERE descricaovalencia = 'LAR' AND nome <> 'CLASSE' AND ativo = '1' ORDER BY nome ASC;"; $resultado_cursos = mysqli_...
asked by 22.03.2018 / 19:15
1
answer

Error in post registration with empty text

The post registration code is this: <?php if(isset($_POST['cadastrar'])){ $titulo = trim(strip_tags($_POST['titulo'])); $data = trim(strip_tags($_POST['data'])); $descricao...
asked by 22.04.2018 / 06:07
1
answer

Return all results of a query with mysqli_fetch_array

Hello,I'mtryingtoimplementablockschedulingsystemwheretheuserchoosesthedateandlocationoftheirchoice.Afterthat,hewillchoosethetimesaccordingtoavailabilityandneedtoblockschedulesthatareunavailable.Itriedtosearchthedatabaseandcreateanarrayofallpos...
asked by 08.05.2018 / 02:18
1
answer

Query system

I have this form to consult only for a period of time or just by the name of the client or to consult for a period of time and a specific client: <form method="POST" action=""> <strong>Data Início:</strong> <input type...
asked by 07.05.2018 / 11:46
1
answer

How to determine the most suitable data type for a fixed-size numeric field?

I have a question about the characteristics of some attributes of my table. Problem: I have to store an identification number of my items, this is always composed of 3 digits (zero left in case of numbers less than 3 digits). I can literally...
asked by 20.03.2018 / 15:55
1
answer

Doctrine prepare-execute

Hello, I'm doing this query with Doctrine $retorno = $em->getConnection()->prepare(" SELECT t.id_programa_fidelidade_diario, t.loja, t.nota, t.data, t.ecf, t.operador, o.nom...
asked by 12.03.2018 / 21:50
1
answer

Receive array method POST form

Good afternoon, I'm trying to get a Form as an array, but I'm not able to handle this array correctly. I have 6 fields 3 ID fields and 3 text fields, I tried to do so but to no avail. But it runs 6 times the array, not 3 as it should be. r...
asked by 08.03.2018 / 17:26
2
answers

Help with Multi Array

Hello, can anyone help me with how to create a list with php this type of array. The data comes from two tables, Categories and Products. I'm using MySQL to fetch the data from the two tables. My tables: Categories = > id, name Pr...
asked by 17.03.2018 / 20:35
1
answer

Generate Script MySql Workbench

Good afternoon. I use MySql Workbench 6.3. I need to generate the script to create the local database to publish to the server. It is completely impractical to create everything again in the hand because the base is huge. How can I do this...
asked by 15.05.2018 / 20:12
1
answer

Problem with tables

I'm trying to make a series site, but I'm suffering to hit the logic of the tables, first I'll explain how I want it to work, the person enters the site, there are the series that pulls the following information from the% so my link that accesse...
asked by 15.05.2018 / 20:36