Questions tagged as 'mysql'

Tagged questions
1
answer

Check only the last record of multiple users

Good day. In a Log table, multiple users check in and check out several times during the day. I want to determine the "Total" time in which the users were "inside" the system (the time comprised from the first check in and the last check o...
asked by 17.01.2018 / 20:43
1
answer

Error Only variables should be passed by reference when Inserting data by query parameterized with PHP and MySQL

I have the following code: public function nuevoUsuario($id_empleado, $username, $correo, $pass, $id_tipo_usuario) { //tiempo de espera sleep(1); try { $this->Conectar_BD(); $this->query = "INSERT INTO us...
asked by 02.02.2018 / 21:56
2
answers

How to bring data without registration in an sql query? [closed]

In a query sql would like to bring users who are not registered in a defined group, EXAMPLE: I have 10 registered users in my database, but of those 10 there are 5 registered in the GRUPO1 , the idea is to show the other 5 that a...
asked by 18.01.2018 / 18:51
1
answer

make a variable query generated within another variable

I have this query to see if the file exists inside a folder called _sellos <?php $nombre_fichero = 'C:\xampp\htdocs\_sellos92-2018-E01-sellos.pdf'; if (file_exists($nombre_fichero)) { this name 7992-2018-E01-sellos.pdf is obtained...
asked by 22.01.2018 / 15:34
2
answers

How to add different actions to the buttons generated in php

Good, You are trying to add an action to each button that is generated with a query, as you can see I do 3 actions for each items : modify | See | Approvals . See PDF files in How can I add one action to each button for each record...
asked by 18.01.2018 / 21:00
1
answer

Group and add in mysql. to create a report

I have the following table and I want to Group and add as in the following example that I put to you. I commented that this table I will have in a view since it is the result of several tables. =) DESIRED RESULT ... I do...
asked by 23.01.2018 / 06:13
1
answer

Error uploading data to MySQL using PDO

Today I am trying to upload data from a registration form to my db using PDO, I get "Error" which is the return that I have established when sending data. <?php require_once('models/connection.php'); class Data extends Connection {...
asked by 14.01.2018 / 00:21
1
answer

Problem to connect Visual Studio project to MySQL database

My problem is as follows, and I can not find a solution. I have a MySQL database, which I want to manage from my application. I have a project in C # with Visual Studio, in which I am using the MVVM architecture, and I am trying to use the...
asked by 12.01.2018 / 17:22
1
answer

Extract table data from one bbdd to another

I need to extract some data from some tables and be able to save them in other tables within a different database. And this must happen every so often to update the records of the destination table (it's the one I should use). The truth is th...
asked by 07.03.2018 / 06:16
2
answers

MySQL database performance [closed]

Good evening I have a query, I am creating a sales management system in c # for 3 branches with multiple users and all will be connected at the same time and to the same server, is my query that the data flow is too much saturated? or that depen...
asked by 08.01.2018 / 03:44