Questions tagged as 'mysql'

Tagged questions
4
answers

Doubt with logic: How to find out if a time is in the range of hours (independent of the day)

Regardless of what time it is, I need to find out if a time is in the range of an initial and final time, given the 24-hour format. The logic can be in both PHP and MYSQL, since in any case you should stop a Stored Procedure. Ex: Inicio...
asked by 19.03.2017 / 14:10
1
answer

How to display an image stored in the mysql BLOB field on a php page? [duplicate]

I have a saved image in my mysql blob encoded in base 64. However, I can not display the image on a simple php page. Actually what I want is for the user to click on a product category, to be returned a search done in php that returns the valu...
asked by 27.07.2016 / 04:08
1
answer

Create Trigger update MySQL

I have two tables one apartment to another contract. When the status of the contract is changed to off . The status of the apartment is free. I have a foreign key in the contract table to relate to apartment. I would like to know how to...
asked by 01.08.2016 / 02:57
1
answer

Select dates based on the total sum of a given column [closed]

Good evening. Based on the example sample file attached, I would have to select all the dates that are the same and are in the same restaurant and that the sum of the quantity is > 10, because I need to disable those dates from my datepicker....
asked by 20.07.2016 / 03:18
1
answer

MySQL does not connect through getConnection () Netbeans Java

I'm already trying to make my MySQL database connect at getConnection() . I have tried several different ways, to put the name of the bank, I have seen several tutorials including the tutorials that are from the MySQL website itself, video...
asked by 20.07.2016 / 04:23
1
answer

MySQL not connecting connects by error in socket

Good afternoon friends, after correctly installing MySQL 5.7 on my Ubuntu 16.04, when trying to connect to the database, I get an error message saying that it was not possible to connect through the socket. Execution: mysql -u root -p...
asked by 24.07.2016 / 20:28
1
answer

Slow JFrame Opening with Hibernate

Good morning everyone. I have a Swing application that has a JFrame using Hibernate 3 for persistence in MySQL BD on the network. When I go through NetBeans, it opens up pretty fast. But when I run jar built on another computer, this JFram...
asked by 26.07.2016 / 14:33
1
answer

Transform array and String

How do I transform an array similar to this and Strings to write each row in the Mysql database. I will only need the data of each array (date, site and Status) print_r($arrayOut); Array ( [1] => Array ( [date] =...
asked by 20.12.2016 / 15:50
1
answer

Transform result into array and get all values in "select"

I'm having a problem when creating a system, I need to do a select: $select = $mysqli->query("SELECT * FROM 'guild' WHERE 'user_id'='$userid'"); $row = $select->num_rows; $get = $select->fetch_array(); $guild = $get['guild']; Trans...
asked by 19.12.2016 / 21:19
1
answer

JSON in PHP with existing fields printing as Null, how to solve? [duplicate]

I have a SELECT that is not returning me some fields, such as "Notes". In the following image I'm ready the array and see that it is like "Null" the observations field: MyreturnSQListhis:<?phpheader('Content-type:application/json');head...
asked by 27.03.2017 / 20:59