I have an application in development in Java using Hibernate and PrimeFaces, in the list of items I have the option to do a search for some information in real time using several filters.
However when I run the application and perform some te...
I'm having trouble converting the strings coming from the database (Mysql - latin1) to UTF8.
The case is that I need to get the data in the database encoding for UTF8 to generate an XML with that enconding.
I tried some conversions for UTF...
I would like to know if there is any way to use MySQL.Data.Entities with the version of MySQL.Data 5.3.7.
In the here statement that works with MySQL.Data (≥ 6.4. 4.0).
Is there any other way to use Entity Framewo...
I have this code that generates a json file to me
header("Content-Type: application/json; charset=utf-8;");
$codigo = $_GET['cod']; //variável para parametro que será passado ao servidor via
URL
$sql1 = mysql_query("Select nome, valor fro...
Good morning, I'm doing a query (mysql) and I have four dates periodo1inicio , periodo1final , periodo2inicio and periodo2final . I need to count how many days of period 2 is contained in period 1.
Can anyone help me...
Good afternoon, I wanted to implement a system that would cause my database to automatically change the value of one of the fields of an element when the expiration date field was higher than the current system date. I've already tried to implem...
In my project I have on a page a form to collect data that will be inserted in the database and in a folder of the server. My problem is that in this form I have a support for uploading images. Then in the PHP part to move this information to th...
I have a field in a table with data separated by a comma:
id_regioes: 1,2,3,4,5,6 .
When I do the query "SELECT * FROM 'tb_operadora' WHERE 'id_regioes' = 1" , or "= 6" returns ok, but not when they are in 2,3,4,5. Eve...
I have in mysql two tables (subjects and pages), the page table has a field (subject_id), which relates what subject is that page.
I would like to mount a menu with submenu in bootstrap
This is Table Subjects
ID nome_menu_assunto
1 Ti...