Questions tagged as 'mysql'

Tagged questions
1
answer

Pass value parameter when clicking input type radio, with php, jquery and mysql propagating

Hello, everyone, I have a question, I do not know how to proceed, I need to send the value that is inside the value input type radio to a jquery variable, remembering that I got it but only works the first one on the list that was propagated wit...
asked by 29.08.2016 / 20:01
1
answer

Select returning Null from the database

I'm trying to make a login page and I'm using JaVA,JPA,WIldfly,Primefaces and the MYSQL database. I'm passing the name and password, but at the time of inspecting it it returns me null , throwing the select in the database...
asked by 30.08.2016 / 16:49
2
answers

MySQLdb - insert value of a variable in the database

I am experiencing problems when trying to insert the values of my variables into the database I am trying to do as follows import MySQLdb id = 4 idade = 18 nome = 'cebolinha' email = '[email protected]' db = MySQLdb.connect("localhost","dev...
asked by 10.06.2016 / 18:14
1
answer

Delete created entity from a ManyToMany relation

I have a ManyToMany relation between users and profiles mapped with Hibernate : user: id name profile: id profile_name user_profile: user_id profile_id The mapping is done as follows: User:...
asked by 09.06.2016 / 18:22
1
answer

Connection Php MySQL PDO in localhost by ip

I have a PHP / MySQL system in which I connect via PDO on the localhost host, but I will need to put the IP of the server "xxx.xxx.xxx.xxx" instead of "localhost", the system works but very slow . I do not know what it can be, both Apache and My...
asked by 10.06.2016 / 22:58
1
answer

Problems with \ no update mysql

I have a field in a table that holds the path to a locally stored file. When I run the following command: UPDATE tabela1 set caminho = 'c:\logs\caminho.txt' where cod_tab = 1 it writes without the backslash. Therefore, it saves as follows:...
asked by 12.06.2016 / 07:03
1
answer

problem inserting unicode value into database

I'm breaking my head with this since yesterday I've done everything to insert the value in utf8 but it is not working and the following I have this code as an example #!/usr/bin python # -*- coding: utf-8 -*- import MySQLdb db = MySQLdb.conn...
asked by 11.06.2016 / 22:31
1
answer

php - Does not update in boolean field

I'm trying to update user data, but the active field is not updated. I have tried several changes and also changed the value of the variable $active from boolean to int , but without success. Another behavior I noticed...
asked by 06.06.2016 / 02:35
2
answers

Mysql query - Two tables and date range

I have two tables, one for the technician registry and one for the tasks. It is a relation 1 -> N. Table 1 (TECHNICAL): cd_tecnico | nome Table 2 (TASK) cd_tarefa | cd_tecnico | dt_inicio | dt_fim I need two filters to check on any...
asked by 01.06.2016 / 16:08
2
answers

PHP - How to compare a date that comes from the MySql database with the current day? [duplicate]

I have a column in the database that is in DATE (Y-m-d) format. In the php code I retrieve this string and I have to compare it with the current date and this is the condition I'm using: $dtEntrega=date("Y-m-d",strtotime($row["dtEnter...
asked by 30.05.2016 / 22:45