Questions tagged as 'mysql'

Tagged questions
4
answers

Next record. PHP + Mysql

I'm a beginner in programming and would like to know how I would make my $ id = 1 , turn 2, 3 and so on. The code at the end means that it needs to compare that value and only then $id++ occurs. I know I need to insert within while...
asked by 12.08.2015 / 00:22
2
answers

Get date before 2000 MySql

I need to select all employees with a contracted date prior to the year 2000. How can I put this condition in the Where clause? SELECT nome_funcionario FROM funcionario WHERE data_contratacao...     
asked by 01.03.2018 / 00:41
1
answer

Concatenate date in PHP to insert into MySQL

Good morning, my question is the method of concatenating and creating a Datetime to insert into a database. Having the variables: $dia = '2018-04-11'; $hora = '09:36'; The desired format is: AAAA-MM-DD HH:MM:SS How do I merge and...
asked by 11.04.2018 / 10:42
2
answers

Login to a web site for the program

I have a site programmed in PHP with login and I'm making a desktop application (Windows) and I'm trying to login to it from those system on the web. My system in PHP works as follows: it creates a session in PHP and stores session-relevant d...
asked by 20.09.2014 / 23:18
2
answers

Search for texts in DB without '/ br'

I'm working on a CMS that does text editing already in the database, it works as follows: there is a series of inputs[type="radio"] each one of them is a project, and when one of them is clicked appear 4 textareas (via Ajax) with t...
asked by 16.10.2014 / 16:13
3
answers

Filing Birthday Anniversaries

I'm trying to filter out the day's birthdays, but I can not. I can only put the date of birth exactly; to be sure you had to filter the dates of birth the same day and month (discarding the year of birth) SELECT NomeCompleto, Telefone FROM tbl...
asked by 20.11.2017 / 14:45
3
answers

How to get around an accent in mysql + Php

I have in my database words with accents and when I want to call I use this SQL below. But if a word in the database has an accent I also need to use the word accented in my search, otherwise it returns nothing. How do I get around this si...
asked by 15.12.2014 / 13:46
3
answers

Protocol for documents

I'm doing a program in php, mysql and would like to generate a protocol with some argument. The protocol would be automatically generated in the system, without user interference, however it would have to be the following standards: Numbe...
asked by 18.08.2017 / 20:48
1
answer

Table size does not decrease

A mysql table had 10.2Gb of data, I circled a script that deleted old data that was no longer needed, After deleting half of the data from this table, it still continues with 10.2Gb. Consuming the HD from my server. Home How or what do I do to...
asked by 27.01.2017 / 18:43
1
answer

How to show the number of MySQL replicates?

I have a bank where names and last names are registered, I can group the results as follows: SELECT DISTINCT * FROM usuarios GROUP BY sobrenome So if you have 80 records repeated for the last name "Jose" for example, obviously it groups...
asked by 19.12.2015 / 15:02