Questions tagged as 'mysql'

Tagged questions
1
answer

What is the best way to create an access report?

I'm setting up a revenue site (PHP and Mysql) and would like to have a backend in the backend where I can find out which recipes each user sees the most, and then suggest other recipes based on those reports. I thought about setting up a tabl...
asked by 12.04.2018 / 13:50
2
answers

jQuery bring value from table Mysql

I am putting together a list of music lists for a karaoke site. It works like this: Search for pre-recorded music Get this input song and insert it into a li list I have the following: <input id="musica" type="text"> <button typ...
asked by 09.04.2018 / 23:17
1
answer

Inserts blank lines when inserting foreach

I am inserting in the same column all the data of my form, which contains checkboxes and inputs type="number": $calendar .= "<td bgcolor='#F5F5F5' align='center' data-semana=''><center><font size='2px'/> <input type='...
asked by 19.04.2018 / 18:50
1
answer

How can I validate current time

How could you develop routine [code block], in order to treat the text field where you have to insert the Hours in real time (current time, arising from the moment). If the user tries to add hours past - issue warning that can not enter daylight...
asked by 19.04.2018 / 22:57
1
answer

Difficulty in listing an invoice and products using PHP and MySQL

I'm having trouble on this page right below. My difficulty is in displaying the products of a particular invoice. Because in statment SELECT * FROM produtos WHERE = ? does not return anything! But when I put the number physically ( S...
asked by 21.04.2018 / 21:19
2
answers

Problems doing simple insert in the bank - Unexpected Token

I'm having trouble inserting into the database, could anyone tell me what the possible problems are? SQL 1: INSERT INTO data_inicio (data_sys, descricao) VALUES (NOW(),'Data de inicio'); Error in sql: Unexpected token near 'Start date'...
asked by 19.04.2018 / 16:08
2
answers

Date function with two variables

I'm trying to concatenate a date and time so that they get the value (ISO) in MySQL so that I can insert them into the database. The line of code is this: Example: datai = 20/04/2018 and horai = 14:27 $data = '$_POST[datai]';...
asked by 20.04.2018 / 12:15
1
answer

How to write data from a checkbox in a MYSQL field [duplicate]

Good evening. I have some checkbox fields, I want to save the selected data in just one field in the Database. Part of the form: <div class="form-group"> <label class="col-md-4 control-label" for="chkrepertorio...
asked by 05.04.2018 / 04:46
1
answer

Where am I going wrong in this select?

I made the Select below only that it is not adding up by the correct column, where am I going wrong? In my structure I have the dtConcat2 field and the dtConcat2 field (these dates are different one is for the date of the request and the othe...
asked by 26.04.2018 / 21:22
1
answer

MySQL version change [duplicate]

I have this table in MySQL called logou: id | idconta | day This query in Mysql always fucnionou on my server: SELECT dia FROM logou GROUP BY YEAR(dia), MONTH(dia) ORDER BY dia DESC But now that the system has been to the client s...
asked by 23.03.2018 / 21:17