Questions tagged as 'mysql'

Tagged questions
2
answers

How can I insert data into related tables using MySql and PHP

My problem is that I do not know how I can insert data into my related tables. What I can think of is to insert data first into the table erp_far_cab and then make a selection to the same table to get the last id or record inserted so t...
asked by 27.07.2017 / 22:42
1
answer

Script php to receive wifi data

I have a Wi-Fi sender sensor (CC3200 from texas instruments) and I want to send the data via wifi to a database MySQL local (local PC). The sensor metric is configured as a http client. In the PC I have installed XAMPP...
asked by 27.06.2017 / 10:43
1
answer

Create Table Foreign key failure

I want to create 3 foreign keys in a table such as this: DROP TABLE IF EXISTS puo;CREATE TABLE IF NOT EXISTS puo ( ano INT ( 4 )NOT NULL, empresa CHAR ( 8 )NOT NULL, acro_proyecto CHAR ( 10 )NOT NULL, partida VARCHAR ( 100 ) NO...
asked by 21.07.2017 / 00:28
1
answer

List the selected values in an array in PHP, AngularJS and MySQL

I want to list the data in checkbox by enabling select through AngularJS and PHP. I leave the codes: app.js: $scope.getPhase0 = function(){ var dataSend = { "service": "getPhase0", "token": token }...
asked by 20.07.2017 / 23:55
0
answers

NullPointerException with Ucanaccess

I have a problem, which is that the following code throws me a NullPointerException in: pstm = connection.prepareStatement("SELECT * FROM usuarios"); I enclose the complete code: package com.gmail.brunodiazmartin5.banco.mysql; imp...
asked by 27.06.2017 / 22:01
2
answers

Calling two PHP functions in an HTML file

I have some information in a database in MySql . I want to show this information on a HTML page supporting me with PHP . When I show the information of only one table there is no problem. The problem comes when I want to sh...
asked by 04.07.2017 / 18:19
1
answer

Laravel 5.4 - Insert data from Droplist and Checkbox in BD

I already have the migrations of three tables, TABLE1: 'names' that contains 'id' and 'name'. TABLE 2: 'sports' containing 'id' and 'name', these two tables already contain names and sports. TABLE 3: 'ids' contains 'id', 'names_id' and 'sports_i...
asked by 28.06.2017 / 20:08
0
answers

How to get date stored in MYSQL and show it in a JDATECHOOSER from java

my question is how can I show a date already stored in my BD in a JDATECHOOSER? I have a JFRAME in which it has a series of fields and I have a JDATECHOOSER in which I need to load the stored date previously. The method I use to load the data...
asked by 26.06.2017 / 00:38
0
answers

Error inserting row laravel 5.1 ORM mysql

I have this code in a laravel model: Log::info($this->TAG.'.trySave ('.session()->getId().')', ['msg' => 'We are gonna to save an order with shopify_id: '.$this->shopify_id]); $this->save(); Log::info($this->TAG.'.trySave ('....
asked by 22.06.2017 / 18:54
2
answers

mysql show records per hour

Greetings I need to group records per hour in a range (from 7 to 16) in mysql but I also need to show the hours where there is no record if there was at 7, 8, 9 but at 10 there are no records I need to leave the time and maybe a zero if there ar...
asked by 17.06.2017 / 00:23