Questions tagged as 'mysql'

Tagged questions
1
answer

Group Query Results

The procedure below makes a query per day between the start and end dates, so it brings up multiple queries, is there a way to group all queries generated in just one? Also, how to eliminate the empty results? DELIMITER // CREATE PROCEDURE pro...
asked by 23.06.2015 / 01:42
1
answer

Differences between SELECT, count, and empty to work DB data

I, out of curiosity, liked to know the differences between 3 seemingly equal things to count (rows, lines) and get data from a table, in MySql / PHP: 1st: Return the number of rows first, and then work the data of those rows, EX with PDO: f...
asked by 12.06.2015 / 15:35
3
answers

mysql UPDATE, does not get the value of the function in PHP

I have this function: $id = pega_assunto_por_nome_menu($_GET['assunto'])['id']; That returns the value of the id, if I use echo $id; But when I do the update in mysql, it does not work. This error appears:    You have an error...
asked by 10.06.2015 / 08:04
4
answers

Error saving form data in php

I'm having trouble passing data from an html form to be rendered in a .php file No error message. ' <html> <head> <title>Cadastro</title> </head> <body> <form method="POST" action="cadastro_aluno_e...
asked by 31.08.2015 / 21:14
1
answer

Search for records from a date to Another [closed]

The company has the base closure of "21 to 20" each month. I would like to know how do I make SQL search only the records that are within the closing? Ex: my closing this month is: 05/21 to 06/06, but I do not want to get the last 30 days ... I...
asked by 11.06.2015 / 07:15
1
answer

SQL query normalize accents, tilde

I often have to search for product names that have accents .. how to normalize this? In my table I use collation utf8_general_ci, which is good for uppercase and lowercase (IC). Now, accents, are being a problem, this collation already ign...
asked by 11.06.2015 / 16:02
1
answer

How to load data from a specific mysql user in xcode?

My code is working, I'm getting the data I need, but I have to write the email of the user who wants the data in my php file. I wanted to receive the user data that the email is typed into a textField in my project. How could I do that? My ph...
asked by 19.06.2015 / 10:13
1
answer

Array php loop [closed]

For the array: Array ( [45] => Array ( [car] => stdClass Object ( [consortiums] => stdClass Object ( ), [92] => Array ( [ca...
asked by 18.06.2015 / 15:37
2
answers

How to export CSV query with each column in a cell? [closed]

Good afternoon, guys. I am already able to export the query to CSV, but I need the value of each column to be in a different cell. EX: Id in cell A, Name in cell B ... Any ideas?     
asked by 02.09.2015 / 19:03
2
answers

How to pull database information in php code

Hello, I have a code in PHP, and inside it I would like to pull information. @$host = "23.98.102.87"; @$port = "9498"; Where's the number s where I wanted to pull the data, I've done the select, but I'd like to know, how could I pull inform...
asked by 26.06.2015 / 23:56