Questions tagged as 'mysql'

Tagged questions
1
answer

I can not do insert with array

I have a form with the following elements: <form name="dadosLocacao" action="registra_locacao.php" method="POST"> <div class="form-group"> <label for="filme">Filme</label> <br> <...
asked by 07.03.2018 / 04:30
1
answer

Invalid utf8 character string + LOAD DATA LOCAL INFILE + MYSQL

I'm trying to import an inventory file into CSV and in this files it contains several accents À Á'''' etc etc in the fields Description, Name Vendor. Bank e and the UTF8 fields are in the connection instance as well. so when I import the file I...
asked by 27.02.2018 / 17:14
0
answers

How to run PostgreSQL on my site

I have a site that is in the server hostgator my bank and PostgreSQL and in the c panel only have mysql they said that to run PostgreSQL I need the vps server inside it under PostgreSQL and I do the integration of the bank with my site! What...
asked by 27.02.2018 / 16:44
1
answer

Take the bank data and compare CODEIGNITER

Good afternoon guys, I was trying to create a login system for a college job when I came across the following: I am using Codeigniter and MYSQL I have a user database where you have registered the name (primary key) and a password (with...
asked by 26.02.2018 / 17:29
0
answers

select with relationship in thymeleaf

Good afternoon! I need help from the members of the Forum, as follows. I am developing an application with Java and SpringBoot and I need to implement a view where you will have a select that will bring the information of the Mysql database,...
asked by 27.02.2018 / 19:38
0
answers

Error in returning a SQL query with INNER JOIN in PHP, missing elements in the array that receives Query result

I'm having a problem in receiving the result of a query in an array, when I query the database the result I want works perfectly, but at the time of saving in the array in php it returns only one line that is not any of the lines of the query, b...
asked by 26.02.2018 / 17:52
1
answer

Dashboard with this information

I want to create a simple dashboard. exactly like that! inthe(ORDERS)fieldwouldbetheordercountforthecurrentdayorbydate.inthefield(REVENUE)wouldbethevalueofsalesonthecurrentdayorbydate.inthefield(AVERAGETICKET)wouldbeanaverageofthevaluesofthereq...
asked by 26.02.2018 / 19:03
0
answers

How do I Save this Parameter in My Mysql database using PHP

I have this code that read a QRcod by Web Can and I would like to save the reading of it on a Mysql Bank. However, I do not know how I can save this variable directly. Could someone give me a hand? The variable you would like to save is th...
asked by 27.02.2018 / 13:35
3
answers

Update with PHP variable [closed]

I'm taking a beating with an update with variable. Please, can anyone help me? $servidorBanco = "localhost"; $usuarioBanco = "root"; $senhaBanco = ""; $dadosBanco = "db"; $conexao = new mysqli($servidorBanco, $usuarioBanco, $senhaBanco, $dado...
asked by 26.02.2018 / 23:52
0
answers

Connection to database too slow

I do not know what happened that now the connection to the database is taking a long time. Before it was quick I would give the answer if it was connected or not ... now takes about 15 minutes and my pc does not work right is all mainly locking...
asked by 27.02.2018 / 05:48