Questions tagged as 'mysql'

Tagged questions
1
answer

Database + java [closed]

How do I check if a database exists in java? Example: If you have one, create a new one.     
asked by 05.01.2017 / 21:41
1
answer

In a SELECT-dependent, with city data from a table how to leave a city in evidence?

In a database, I have the States table and the Cities table. On the site, when I choose a state, the list of cities is populated according to it. In my code, it's about to appear alphabetically, but I wanted the city of Ribeirão Preto to be at t...
asked by 12.08.2016 / 21:19
1
answer

Problem with insert using mysql_query ()

I'm working on an old system, where it makes the connection to the bank still with mysql_query . I've used too little mysql_query and the last time I used it, it's got a lot of time, I'm more accustomed to PDO . I am try...
asked by 24.05.2017 / 15:05
1
answer

I can not load fields [closed]

This is my screen <h:panelGrid columns="6"> <h:outputText value="Nome: * " /> <p:inputText id="nome" value="#{funcionarioController.funcionario.nome}" size="18" maxlength="80" required="true" label="Nom...
asked by 01.08.2016 / 19:09
1
answer

Query to return only the records of the last 24h (Codeigniter)

Hello I need to do a query that returns me the values of only the last 24h I have the following query: $date = date("Y-m-d H:i:s"); $this->db->select('*'); $this->db->from('inscricoes');...
asked by 03.08.2016 / 13:24
1
answer

How do I visualize the person in charge with the dependents

My select is wrong. How do I view the dependents of this user: I have 1 user: (Mauro Santos) and 2 Dependents: (Thiago and Dhalila), how do I view it in view . Select SELECT * FROM cad_lideranca WHERE numerocontrato = :numerocontrato...
asked by 26.12.2016 / 14:27
1
answer

Login and wrong password with php

Good afternoon, I'm creating a simple login and password system but I came across some strange errors, when I put the email and the password and I try to enter it it accuses me that the password is wrong, and I check the database the information...
asked by 24.12.2016 / 19:17
2
answers

Querying a lot of MySQL and PHP data

Personal the code below makes the parser of the data that are in the openvpn log and stores it in the database that by other codes are shown in a page with table. However, there are many records in a log file! There are over 6 thousand (and it w...
asked by 09.08.2016 / 17:24
1
answer

Javascript possibly disrupting MySQL query [closed]

Recently I started working with SQL databases and I have had problems storing date type columns in my tables. Basically what happens when I try to store a variable in the format yyyy-mm-dd , for example 2016-12-23 , something happens...
asked by 23.12.2016 / 20:44
2
answers

UTF-8 problems in PHP project [duplicate]

I'm learning PHP and am experiencing some problems with special characters, see: Thefunnythingisthatinthetableitemsitdisplaysaccentandspecialcharacters.Andyes,I'vetriedusingthe<metacharset="UTF-8"/> and also <?php ini_s...
asked by 03.06.2016 / 15:59