Questions tagged as 'mysql'

Tagged questions
1
answer

Format table date mysql and show in Smarty

I'm developing a page in PHP, using MVC structure and rendering the tamplete files with Smarty. However, you have been struggling to get a date via MySQL (see the format: YEAR-MONTH-DAY HOUR: MINUTE: SECOND I'd like it to appear in the fol...
asked by 16.10.2016 / 05:30
1
answer

mysql transaction error in php

Good morning, guys. I'm trying to do the simultaneous insert, I'm using transaction control in php, but it does not do the first insert, so it generates a foreign key error. public function insert(){ try{ self::getInstance()->b...
asked by 13.10.2016 / 13:52
1
answer

Error: Undefined index: Password in C and error Strict standards: Only variables should be passed by reference

error regarding the same line of code: $stmt->bindParam(':Password', password_hash($_POST ['Password'], PASSWORD_BCRYPT)); That Accumulate and register the information entered in the form with the following line <input type="Passwor...
asked by 01.10.2016 / 21:14
1
answer

Use Date type field in Java with MySQL

I'm having a little problem, I'm doing a test using the Date field in Java, and I'm having trouble executing it. Here are the codes I'm using: 1st the Code to create the table in MySQL Create table clientes ( cli_id Integer NOT NULL AUTO_INCRE...
asked by 11.08.2016 / 22:54
1
answer

Error when comparing MD5 password in PHP

I have a problem with a login form, below the current codes. I'm using the method via POST, which is that it is not sending the post in MD5 for comparison in the DB. In the database the password is already registered in MD5, but when sendi...
asked by 17.10.2016 / 20:59
1
answer

Charts google returning empty php mysql

I'm creating a chart with php mysql, but the same is not returning anything on the screen. Queries are working normally in mysql. <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><script...
asked by 21.09.2016 / 17:24
1
answer

HttpUrlConnection - Use php to connect in Mysql

I am trying to fetch the data of a user saved in an external database to log in / register. But I run the system and there is no exception, but it does not connect. I tested the php that I'm consuming and it's working correctly. If anyone can he...
asked by 21.09.2016 / 23:37
1
answer

How to create a loop between records and the current php date

I have the following combo chart: <div id="vendas_diarias" style="height: 500px;"></div> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><scripttype="text/javascript">...
asked by 23.09.2016 / 08:15
1
answer

Problem with inserting TIMER into MySQL table using JDBC

Speak up! I have the following problem and I'm looking for the best possible solution. The following code when running a time is saved in the CurrentTime (current time) and sent to the database for the time column. This current time is update...
asked by 15.08.2016 / 01:21
1
answer

Error Django csv

Well, I'm having a problem reading csv and entering the data. I believe it's in the foreign key. The code is: View: def csvAih(request): coluna = 1 mes = 1 ano = 2008 while (ano < 2017): with o...
asked by 13.09.2016 / 00:48