Questions tagged as 'mysql'

Tagged questions
1
answer

Data counting in php

I have a problem and I can not solve it, I need to make a code that searches the data in the bank and counts the total of this data, then I need to separate them from the largest to the smallest, the big problem is that the data repeats , so I n...
asked by 19.10.2017 / 03:41
2
answers

UPDATE SET in a record [closed]

I have a table that lists records in the database and in front of each record has a button like that <a href="index.php?mod=pedidos&funcao=editar&id=<?=$lnped['protocolo']?>" class="ls-btn-primary ls-ico-user"></a>...
asked by 31.10.2015 / 06:12
2
answers

Insert in MySQL does not execute

I'm having problems in SQL when doing a small insertion in DB. I have a table with 4 fields: id_match -> int id_usuario1 -> int id_usuario2 -> int situation -> varchar(5) When I make the following insertion, it does not enter th...
asked by 23.07.2015 / 21:02
2
answers

Error executing mysql_query [closed]

When I run mysql_query it gives the following error (even though I can connect to the database without any problems) Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in C:\xampp\htdocs\LuckTor\index.php...
asked by 24.01.2017 / 14:49
1
answer

Search for an image in a MySQL database with php and then save that image to another table in the same database

I am making an application to save images, when the user does not choose any image is saved in the database a default image that is selected in another table of the database, however at the time of saving the image in the database, php returns t...
asked by 22.02.2017 / 18:52
1
answer

Get database specific data

Good luck, I'm doing a project with the following pages pedidos.php and anexa.php . The action of the requests goes to the attached page, in which I have the content sent to the database and email, through the function mail()...
asked by 12.04.2017 / 20:41
1
answer

How to make form in stages?

I am creating a system and wanted to know how to make a form per step, it works by checkbox and input and type just wanted to know how to pass the data from the first form to the two to be inserted into mysql. </tr> <tr>...
asked by 27.01.2017 / 01:57
1
answer

What does it mean in PHP when mysqli_num_rows returns -1? [closed]

In a query to MySQL the result return brings the value of -1, what does this mean? I know 0 is when it does not yield any results.     
asked by 09.07.2018 / 01:15
1
answer

How to display in html the data of all the columns obtained through a mysql query? [duplicate]

I have a table with 1000 columns (example), how to display the content, of all the columns of a line obtained through the "ID"? SELECT * FROM 'tabela_1000_colunas' WHERE id = 1; After this select, how do I display the contents of these 10...
asked by 17.05.2016 / 19:23
1
answer

Doubt IF with SQL

It is calling only an if option. 1 => all users per data = if user is empty and data is filled (only this one is calling msm so a user has to be selected, which is wrong the user had to be empty) 2 = > user by date = user filled and dat...
asked by 29.04.2016 / 15:36