Questions tagged as 'mysql'

Tagged questions
0
answers

Calculate answer time for Progress Bar

I have a function in AJAX that returns a file. What I want to do is implement a Progress Bar with a percentage so that the user knows how the download of their file is going. Use C # MVC4 , my method in the controller is a FileResult , and...
asked by 13.01.2017 / 05:07
1
answer

Compare two tables in Mysql [closed]

I am uploading two files from Excel to a JSP to save it in MySQL the first file with its columns: |------------------| | Archivos_nombres | |------------------| | identificación | | nombre_j | | nombre_n | |-----------...
asked by 12.01.2017 / 15:53
2
answers

Display date format in "d-m-y" and save to a database in "y-m-d" format

I have to show the format D-M-Y but it must be saved in the MySQL database, Y-M-D . I am using Bootstrap for the calendar of dates and PHP to perform the maintenance on the table. Code HTML and PHP : <div class="form-...
asked by 17.01.2017 / 21:50
1
answer

Get Array within Json

I have two tables on MySql one Blog and another Carouser unit on a foreing key. How can I get a json like the one I see at the end? An array inside an object. In PHP. CREATE TABLE 'Blog' ( 'blogId' int(11) NOT NULL, 'blogTitulo' varchar...
asked by 17.01.2017 / 11:08
0
answers

Save data in MySQL using JavaFX [closed]

I need to insert data in mysql into a customer table, using a graphical interface with JFX . The problem is that you can not access to capture the data of this form in my connection class. <?import com.jfoenix.controls.JFX...
asked by 31.07.2017 / 00:07
1
answer

How can I insert data from an xml to mysql with php?

What happens, generate a .bat that will collect the data of my cpu and the data will be geared to me in an xml format with the following code wmic cpu get /all /format:rawxml.xsl >cpu.xml and I generate the following xml <COMMAND SE...
asked by 30.07.2017 / 02:38
1
answer

Doubt relating three tables

I have a question about how to relate several tables. I explain a little what I want to relate: User table: user_name (primary key) Table Computer: computer_name (primary key), user_name (foreign key that refers to user_name of the User...
asked by 29.01.2017 / 19:47
0
answers

How can I get the id in the modal window? [closed]

How can I get the id in the modal window? var items = [ <?php while($reg= mysql_fetch_array($order)){ ?> { id: <?php echo $reg["id"]; ?>, title: '<?php echo $reg["titulo"]; ?>', }, <?...
asked by 19.12.2016 / 22:12
1
answer

Generate a SELECT to verify the success of a game of chance with MySQL

I have the following tables. Table JUGADOS | Field | Type | Null | Key | Default | Extra +------------+------------------+------+-----+---------+---------------- | FECHA | date | YES | | NULL...
asked by 04.01.2017 / 20:36
1
answer

How to make queries to a mysql backup without having to raise this one?

I have a DB that has backups every 24hr, in which a data was modified and I need to verify when the change occurred and I need to be raising each backup and make the query to see if on that day it suffered the modification or not and that's why...
asked by 06.01.2017 / 17:48