I have a large HTML list with about 106000 lines of code. Where these lines are records and these records are subdivided into:
6 lines of information about a game (as name and year of publication)
1 line break
So, each "record" in my HT...
I am developing an application using Java Swing + MySQL database, however I am in analysis of making an online platform that talks to the local application, using the database to interconnect the data, because in reality the system itself they t...
I have an application that generates approximately 25000 records per day in DB. This will generate a large amount of id's per day in the user's DB.
According to the user's business rule, only failed inspections ( is_ok = 0 ) must be log...
I have a login system that, in case the user is an administrator, will be redirected to one page and if it is common, for another.
This column ativo is what defines whether a user is admin (1) or not (0).
identifiant | senha |...
I have a table in a MySQL database that has a date column VARCHAR , type 20-09-2017 and I need to migrate this column to a bigint(8) column that uses the Unix date format timestamp .
How to do this?
I'm migrating my php code in which I was using sql query for PDO, but I'm finding it difficult to validate data with this.
NOTE: I already have a functional file that searches the database, my difficulty is really to compare it with POST and...
I noticed that using PDO to execute the query below, the results are conflicting with PhpMyadmin and Console do Mysql :
SELECT a.*, n.* FROM arquivo AS a INNER JOIN numeracao AS n ON
(a.id_numeracao =...
I'm having a problem sending FILE data to DB.
With the help of @zuul I came to this problem.
<?php
require("conectar.php"); //chama o arquivo de conexão ao BD
if (isset($_POST['Nome'])) {
$Nome = $_POST['Nome'];
}
$Morada = $_POST['M...
I'm using PHPMailer to send an email with data when it's 10 days to complete. When I send the email, all records are appearing when the idea is to appear the registrations between today and 10 days in the future.
Inquiry
$sql = "
SELECT t...