Questions tagged as 'mysql'

Tagged questions
1
answer

datepicker date query

Good afternoon guys. How do I display data from the database through the date selected in datepicker? How should the select be used in this case? since it is the user who will choose the date to display the data.     
asked by 10.03.2018 / 19:57
1
answer

Importing .txt using php + mysql

Good evening, I've tried other ways but I could not. I need to run the query from the code below in one go instead of inserting row by row in the database. Would anyone have salvation? <?php set_time_limit(0); if (!isset($seguranca)) { exi...
asked by 03.03.2018 / 22:57
2
answers

Inserting data base register - error

Good afternoon, I have an error when registering some data in my database. Here is a part of the code and the error that appears. include_once("settings.php"); $con = mysqli_connect(HOST, USER, PASS); $query = "SELECT bd_winfo...
asked by 04.03.2018 / 18:02
1
answer

BootStrap 4 Cards and Tables

Good morning, I updated the version of BootStrap for V4, had to change several lines, but the Panel no longer exists, now advise to use the Cards, but the problem is to use the cards with the class table, If using the class table - > table...
asked by 26.02.2018 / 13:49
0
answers

DBDEsigner problem with TYPE = InnoDB;

I use DB_Designer 4.0.5.6 Beta. I discovered a problem when I was generating an sql code to build my database. The last line that appears in the sql code is the "TYPE = InnoDB;" CREATE TABLE cliente ( idCliente INT NOT NULL AUTO_INCREMENT,...
asked by 25.02.2018 / 22:18
1
answer

(SELECT JOIN?) How to get a quantity of records from a specific column, from another table (when there is a foreign key)

My list screen shows the data in the "PERSON" table. There is a table called REGISTRATION that has the column idpessoa referencing. In this registration there is a field called EVADIDO to know if the person escaped from that course tha...
asked by 25.02.2018 / 22:50
0
answers

Replace MariaDB with Mysql in Xampp

I have already researched and found almost nothing related to this, so I came to ask for help, MariaDB is giving a laravel error, so I want to switch to Mysql. MariaDB returns this error to me. Looking for solutions, I found some, but they...
asked by 05.03.2018 / 03:28
0
answers

Differences between how to set the charset in MySQL

What is the difference between these two ways of setting the charset in communication with the bank? $pdo = new PDO("mysql:dbname=qualuqer_db;host=localhost;charset=utf8", "root", ""); and $pdo = new PDO("mysql:dbname=qualuqer_db;host=loc...
asked by 28.02.2018 / 07:03
0
answers

Can Magento connect to an AWS DB with port?

I'm having trouble trying to get my Magento installation running on the AWS server, site and ratification server run normally. When I try to connect without the port in the local.xml it times out on the connection because the default is not r...
asked by 24.02.2018 / 13:25
1
answer

Add values to a mysql count

Good Night, I'm having a doubt I have a system that runs the following query: SELECT IDUsuario ,COUNT('TotalDeUps') as Total, FROM uploads WHERE Time >= '2018-02-20 00:00:00' AND Time < '2018-03-21 00:00:00' GROUP BY IDU...
asked by 24.02.2018 / 02:49