Questions tagged as 'mysql'

Tagged questions
1
answer

Is it imperative to use captcha in the form?

I am completing a registration form, and I took some precautions against SQL injection. And for an aesthetic question, I would not like to enter a captcha. The form in question is for user registration, which will be logged in later. My co...
asked by 13.06.2016 / 19:40
1
answer

How to convert search result in mysql into columns

Good evening guys, I do not know if anyone has gone through this, but I need to convert the result of a mysql search into columns, not to change the rows through the columns, but to make some results become the titles of column. Being: NOME...
asked by 14.06.2016 / 23:25
1
answer

PHP and javascript - Getting javascript value in PHP (session usage)

In the site that I assumed from another developer, made in PHP and Javascript, there is a search for created events (all registered in MySQL database table). In each event that I searched for, I created a button to delete it: <input name="e...
asked by 14.06.2016 / 15:59
1
answer

How to return results with integers and nulls?

I'm trying to set up a Query but they are not having success, in my database I have 28 information with code 32, and 62 information with code 23, but there is information with the null code, and I wanted to bring them all together , the problem...
asked by 16.08.2016 / 13:30
2
answers

Treating Many-to-Many Query

I got into a doubt about Many-to-Many relationships and I hope I'm not asking a repeat question, but I did not find the solution to my question in the least. It turns out that I have an image table, a job table, and a relationship table that...
asked by 23.06.2016 / 05:16
1
answer

PHP and MySQL Search Engine - Listing Problems

Hello, good evening, everyone. This is my first question on the forum and I would like to resolve a problem with my small web application. This is a final semester work of my course, and I need to create a small system of product registration...
asked by 23.06.2016 / 05:24
1
answer

How to insert data using query in a for loop?

I'm trying to insert data into the mysql DB, and some data is repeated, and others not so who would command the number of executions would be for , but not executing the query inside the for. I already did some test of echo and the...
asked by 19.06.2016 / 22:49
2
answers

How to make a load bar inside a load () Javascript?

I have a php page index.php that loads another php page page.php with a load (): $("#div").load('pagina.php'); On this page I have a For loop with a lengthy sql and I have to show the progress of this query. The problem is that this pag...
asked by 21.06.2016 / 20:15
1
answer

How to join 4 tables in SQL that is returning empty? (Inner, outer, or left join)

I have 4 tables with the following relationships: Products have N Variations Sizes have N Variations Colors have N Variations Variations belongs to Products, Sizes and Colors The structure of the tables looks like this: Variatio...
asked by 02.06.2016 / 19:21
2
answers

Check the number of people per age

How do you check the total number of people in the 0-5 age group, and if you do not have any children with a certain age, please report 0; select idade, count(*) as qtd from pessoa group by idade order by idade example of the curren...
asked by 17.06.2016 / 21:43