Questions tagged as 'mysql'

Tagged questions
1
answer

Search between date using two columns [duplicate]

What's wrong? SELECT ID_Contrato_Reserva, DATE_FORMAT(STR_TO_DATE(data_ini,"%d/%m/%Y" ), "%Y/%m/%d") AS dataIni, DATE_FORMAT(STR_TO_DATE(data_Fim,"%d/%m/%Y" ), "%Y/%m/%d") AS dataFim FROM contrato_reserva WHERE ( dataIn...
asked by 20.04.2014 / 19:46
1
answer

How is a website published and hosted on the internet? [closed]

My doubt is how a site made with PHP and MySQL is published on the internet? And how do you host it on an online server?     
asked by 26.10.2017 / 00:36
1
answer

System access control [closed]

How does it make for each user to have a product, client, etc. individually in a login? Ex: User John does not see samuel's registry.     
asked by 30.11.2017 / 18:26
2
answers

While not validating last php array

Does anyone know why the button in the last while record does not execute the form's action? <?php while($dados_tabela = $consulta_tabela -> fetchObject()) { ?> <tr> <td><?php echo $dados_tabela->id; ?><...
asked by 30.06.2016 / 19:19
1
answer

mysql mean time, top 10 models

Personal as per the illustration in my table below, I would like to get the following data: ✓ Time the POST spent from DATE_ENTRADE to DATE_SAID ✓ Overall average time all POSTS take from DATE_ENTRATE to DATE_SAID TABELA: OS +---------...
asked by 19.11.2014 / 16:14
1
answer

What is the essence of modeling a system? [closed]

Due to my idleness in the internship and lack of knowledge to work in medium-sized projects, I am looking for a mission that will increase my knowledge in both PHP (mainly) and database (in the MySQL case), but together to this by adding knowled...
asked by 09.04.2014 / 18:31
1
answer

SQL how to create fk int in TABLE

Movie COD (int, pk) name (varchar 20, not null) birth (datetime, not null) obs (tinybit, not null) obs2 (int, fk, not null) I thought of something like create table filme ( COD int PRIMARY KEY AUTO_INCREMENT, nome varchar(200) NO...
asked by 10.10.2018 / 07:06
2
answers

Pass an array to another format

The array is coming in this database format: array (size=12) 0 => array (size=3) 'maquinas' => string '111' (length=3) 'mes' => string '1' (length=1) 'YEAR(data_ordem)' => string '2016' (length=4) 1 =>...
asked by 15.12.2016 / 20:08
1
answer

SQLSTATE [08004] [1040] Too many connections

This is my connection class: / **  * Conn.class [CONNECTION]  * Abstract class of connection. Standard SingleTon.  * Returns a PDO object by the static getConn () method;  *  * @copyright (c) 2017, Horácio Pedro INFINITE CONNECTIONS  * / abs...
asked by 19.06.2018 / 13:38
1
answer

PHP - You have an error in your SQL syntax; [closed]

Hello, I have a bug here! I have the same code as another page but this page works and in this one ... error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea...
asked by 30.05.2018 / 15:34