Questions tagged as 'mysql'

Tagged questions
1
answer

How to save form data only if it comes from a particular site?

Hello, I have a form that is being used in another site and saving in my database, through a php action that is on my server. But I would just like to save the data if the form comes from the domain of this site. How can I do it?     
asked by 16.12.2016 / 20:29
1
answer

count with LEFT JOIN does not return when zero or null

I'm having a problem in a select where I need to get the data from 3 tables (search, users, and query_research). Where search_response can or does not have data. The current query is: SELECT usuarios.nome AS nome_autor, pc_pesquisa.*, COUNT(p...
asked by 18.12.2016 / 14:32
1
answer

Get all the INNER JOIN data

My problem is that I'm making a query but I'm not able to list all the data in the table. SELECT * FROM suporte s INNER JOIN login l ON l.cliente_id = s.cliente_id INNER JOIN radius_acct r ON r.USERNAME = l.user WHERE s.CLOSEDATA = '0000-00-00...
asked by 24.12.2016 / 19:14
0
answers

How to make a form with the number of variable fields and insert this data in the database? [closed]

Hello. I want to create a CRUD that manages words and their synonyms. A word has multiple synonyms (1: N). I would like a solution to dynamically include the inputs, according to the demand of each user. For example, a word to be registere...
asked by 02.10.2015 / 19:20
1
answer

SQL does not return all results

I have 2 tables in MySQL, one called municipalities and another called municipios_ibge both have a column named municipio that holds the municipality of each city of Brazil. I have to do the following: I need to check if the municipalities...
asked by 15.08.2016 / 01:28
2
answers

Ajax returning [object Object]

HTML index.html <!DOCTYPE html> <html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script><scriptsrc="script.js"></script> <link hre...
asked by 20.08.2016 / 21:09
1
answer

Problem generating report between dates

I have a DATETIME field with a date and time: 2015-08-06 08:50:28 . I'm trying to generate a report by passing two parameters, Data_Inicial and Data_Final so I can get all the bank dates that are in that period. The condi...
asked by 06.08.2015 / 14:39
1
answer

How to execute PHP file from function in JavaScript?

I have the following structure for registering a new MySQL database account (register.php): <?php $con = mysqli_connect("meu_host","meu_user","minha_senha","banco"); mysqli_query($con,"INSERT INTO contas VALUES (" + $id + ", " + $pass...
asked by 25.03.2014 / 04:09
2
answers

Help with JOINS in 3 tables

I found a tutorial talking about JOINS and implanted in the search for the sales made. But it did almost all right, but at the time of the search for the sales code, instead of bringing me only the result referring to the code consulted, it b...
asked by 21.12.2015 / 03:17
2
answers

Looping on an array to always choose the next value

I have an array of users and I need to loop between them. It will work like this, every time someone makes a request on the page, I need the next user to be saved in the database of the one that was previously chosen. This is my array, which...
asked by 11.03.2014 / 22:52