Questions tagged as 'mysql'

Tagged questions
1
answer

Retrieve values from dynamically generated checkboxes

I have a form that has some checkboxes with names of cities that are generated dynamically by PHP. I would like to know how to get these values and in what type of structure to store them (Array?) And in what kind of data to save in MySQL. These...
asked by 09.07.2016 / 14:30
1
answer

Convert point to point in mysql

I am learning to work with mysql and in the conversion of a database, in text, I have a column with currency format. I ask. What is the procedure for mysql to accept the variable in DECIMAL? Should I import as text and change this in mysql ??...
asked by 11.07.2016 / 20:35
0
answers

Assign list returned from the database to a combobox

I have an HTML / PHP code where it has a list field that I would like to return the bank records. However, the field or variable appears in the list display instead of the BD values. I can not figure out the cause of the problem. In the im...
asked by 02.07.2016 / 21:17
0
answers

PHP Mysql connection performance on remote server

I'm at all costs trying to improve the loading time of my pages, but I'm suffering with a bottleneck. The connection between the web server (godaddy) and my database server (location with dedicated ip) I ran a test with a simple page that jus...
asked by 21.07.2016 / 01:27
1
answer

How to select a table row and display information in another table relative to the table?

I am using this code but I am not able to interconnect them as it should be ... I wanted to register Payments (payments) so these only appear when you have to select the partner in the (partner) table ... String sql = "SELECT socio.*,...
asked by 01.07.2016 / 02:28
2
answers

Consume .mdb file and write to MySQL with PHP

I have an .mdb file, and I need to inject all its data into MySQL using PHP code. What I do is the following: // Executa comando via shell para upload do banco no mysql $scriptEsquema = shell_exec('mdb-schema uploads/arquivo.mdb mysq...
asked by 01.07.2016 / 04:23
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

How to mount a select from DB

Good afternoon, my personal doubts and the following I have a database that lists me all the dates of delivery of works as follows 2016-07-13 2016-07-01 2016-03-09 2015-09-09 2013-03-06 How do I mount two selects that contain only table dat...
asked by 29.06.2016 / 22:00
1
answer

Join two select, what should I do?

How to merge these two SELECTS? SELECT * FROM doacao d LEFT JOIN foto f ON (d.iddoacao = f.iddoacao) WHERE (d.idbeneficiario IS NULL); SELECT email FROM doador dd INNER JOIN doacao d ON (dd.iddoador = d.iddoador) WHERE (dd.iddoador IS NOT NUL...
asked by 30.06.2016 / 00:53
0
answers

query problem Mysql (subquery) difference between MYSQL versions.

I have a problem in a MYSQL query, I believe it is a difference of versions of MYSQL, the bank of my client is in the hostGator (Database client version: libmysql - 5.1.73 / Server version: 5.6.30 - MySQL Community Server) , I made a backup of...
asked by 27.07.2016 / 05:30