Questions tagged as 'mysql'

Tagged questions
1
answer

Login via facebook SDK

Well recently I made a login page where you have the normal login and the facebook login, but the facebook login when you click redirects the application to allow access, okay until then, okay, only when it clicks and lets it returns to the page...
asked by 11.05.2017 / 15:19
1
answer

Return of "?" instead of special characters in a SELECT [duplicate]

I have a problem, I have already coded everything with utf-8, I tried in many ways to sort this out and I can not, in a% of HTML, I pull a table from the database, but it returns with a symbol of special characters instead of the accents as in...
asked by 30.06.2017 / 20:55
1
answer

Calculate percentage MySQL

I want to do a percentage calculation. Taking the value that was received in that selected month (received = 1), divide by the total value of that selected month, and multiply by 100 to return the percentage. The logic I used below is working pe...
asked by 18.06.2017 / 14:15
1
answer

"mysqli_connect" does not work

I can not use the "mysqli_connect" function. Can someone help me? You are returning the following error:    Fatal error: Constant expression contains invalid operations in   /home/vagrant/Projects/products/app/Database/Connection.php on line...
asked by 06.05.2017 / 17:00
1
answer

How to retrieve only 1 URL value with CodeIgniter?

I'm passing two parameters link public function votar($id) { echo $id; die; } And it returns me 4-slug-of-something. I just wanted to retrieve the ID but displaying the two parameters in the url, how do I do that? My route lo...
asked by 24.01.2017 / 14:49
1
answer

MySQL does not install

I am trying to install MySQL on Windows 10 and is required as a requirement in Microsoft Visual C ++ 2013. I am having the latest version of Visual Studio installed and as a consequence have also been installed Microsoft Visual C ++ 2017 and als...
asked by 31.05.2017 / 04:13
2
answers

Join bringing wrong value

I have two tables Company: id_empresa id_usuario vl_honorario dt_honorario id_honorario 86 1 200 2017-01-04 7 86 1 600 2016-12-01 6 86...
asked by 02.12.2016 / 12:12
1
answer

Error opening MySQL connection via ADODB

I am trying to connect a VB application, Visual Studio 2017, using ADODB as connection, but it has several errors for different connection options. I have already checked the drivers for the ODBC data sources and there is the MySQL 64bit Driver...
asked by 02.06.2017 / 03:38
1
answer

Update on more than one line

I'm trying to mount a update like this: UPDATE cad_vendas SET canal ='9', parceiro ='9' WHERE cpf_vendedor ='CPF_VENDEDOR' and status_proposta_producao ='90' and forma_pagamento <> ''; but it does not accept if I do not pass the...
asked by 05.06.2017 / 15:25
1
answer

How can I transform a BLOB file into an image using PHP?

I need to transform a BLOB file that comes from a MYSQL database to the Image type, to use on my site, I need to do the conversion using PHP, when I use the image in BLOB format, it goes to the whole site in binary .     
asked by 18.11.2016 / 18:08