Questions tagged as 'mysql'

Tagged questions
1
answer

How to fill array from a datatable

I'm doing an insertion of data from a sql database to a datatable to then dump that data into an arraylist that will contain and remove the rows, when executing the visual it collects the columns and goes into interruption and I can not find out...
asked by 25.05.2018 / 06:44
1
answer

Notice: Undefined variable: row in C: \ xampp / ... / ... index.php on line

I am trying to make an autocomplete form using an input (text) ... I used this way but I do not know if it will be fine ... I leave the code: (I have a patient table (id, code_pac, name, surname_paterno ) CONNECT.PHP <?php $hostname_strc...
asked by 26.05.2018 / 08:13
1
answer

Confirm before deleting a record?

What I'm looking for is to confirm before doing the deletion. This is my form.    removeClient.php <!DOCTYPE html> <html> <head> <meta http-equiv="Content-type" content="text/html"; charset="utf-8"> <...
asked by 15.05.2018 / 15:40
2
answers

Query in mysql eliminating zero results

Good morning once again I consult the community to see if you can help me, I have the following query: SELECT ncuenta, dcuenta, SUM(-saldo) as monto2 FROM captura WHERE SUBSTR(NCUENTA,1,2) >= '30' and SUBSTR(NCUENTA,1,2) < '39' and fecha...
asked by 16.05.2018 / 19:20
1
answer

Difference of time elapsed between two hours

I am trying to calculate the total hours worked of the day per employee, taking as data, time of entry, meal time, meal time and departure time. Keeping this data like this: Entry: 08:00:00 AM Food: 01:00:00 PM End of meal: 01:45:00 PM...
asked by 15.05.2018 / 03:21
2
answers

Adjust variable text by editing it from the database

I have this code: To edit the path where the image is saved from the database: <?php $host = 'localhost'; $user = 'root'; $pass = ''; $db = 'img'; //creo mi conexion a la base de datos $mysqli = new mysqli($host,...
asked by 07.08.2018 / 00:18
3
answers

Convert local variable to global. PHP

I am trying to collect the fields from a MySQL registry, and for this I use the following: $reg = mysql_query("SELECT * FROM draws WHERE urlID='$urlID'"); while($data = mysql_fetch_array($reg)) { $title = $data ['title']; }...
asked by 20.05.2018 / 11:54
1
answer

Error connect Mysql with SpringBoot

I am trying to access data from the Mysql Database with SpringBoot: But I get an error, I've never accessed, so I'm totally new, I'm following tutorials (5-6), none has worked. The idea is to put an address in the browser and return the lis...
asked by 29.06.2018 / 10:37
2
answers

Query between 3 tables with MySQL

I'm trying to make a query and add the values of two tables to the result so I can bring the inflationary I need tables matches and blocked are related to users using the id's The query I am trying to make is the follo...
asked by 13.07.2018 / 18:51
1
answer

Send variable PHP to table in MySQL

I would like to send these php variables with a INSERT INTO that I print in html tables, but I do not know how to do it or if you can Here is an example of one of the tables I have <!-- Jornada 1 --> <p><b>Jor...
asked by 11.04.2018 / 11:34