Questions tagged as 'mysql'

Tagged questions
0
answers

Error 404 when inserting Kanjis in the URLs of permanent links (permalinks)

I'm starting a blog about Japanese. When trying to set up URL's with Kanjis (for example link I get a 404 error - page not found. But the post usually appears in the list of posts and the initial feed. How to solve?     
asked by 18.06.2018 / 16:19
1
answer

SimpleDateFormat cast String does not query the database

I'm doing a collaborative application for android, so I made a server in PHP, and I send the data to this server. For a given query I need to pass a date, from a Date Picker, here's the code: String myFormat = "dd-MM-yy"; //In which you nee...
asked by 11.06.2018 / 03:46
1
answer

Query data from two different tables and list without joining data

I am developing cash flow from my company and am encountering a difficulty. I have two different tables. A table is tb_compras (id, nfe, value, date) and then I have another one also tb_compras_pagamentos (id, buy_id, pay_value, date). I n...
asked by 08.06.2018 / 15:10
1
answer

How to register new things in Wordpress without the use of post type?

I've been working on creating themes in Wordpress and found the use of post types very interesting ... But it has certain situations that make it unfeasible and it gets a face of gambiarra ... Is there any other way to register new tables in...
asked by 08.06.2018 / 15:19
1
answer

How to save the custom name of an enum in the database?

I have an Enum TipoPessoa that has LEGAL person and PHYSICAL person. I created a custom (Legal) and (Physical) name. I am getting the custom name to appear on the screen, but in the database you are saving the variable of the LEGAL or PHYSICAL e...
asked by 07.06.2018 / 03:53
1
answer

Feed div after receiving new data

I started to implement a chat and needed to update the div where the messages are inserted, but when I receive new messages I need to update the page to access, and if I set a timeout for every 10 seconds, and I'm still typing something there up...
asked by 07.06.2018 / 06:30
0
answers

What is the best way to save data in real time?

Well, can you tell me the best way to save data in real time? For example, I have a news portal and I need to save each access I receive and display in a private panel, but in case my site has 30,000 simultaneous people running a script that sav...
asked by 20.06.2018 / 01:14
0
answers

Error with fetchAll using order by

I'm doing a task scheduling system. I need to show these tasks to the user, I created a file called tarefas.php to query the MySQL database: <?php include_once 'conexao-calendario.php'; include_once 'VerificarLogin.php';...
asked by 20.06.2018 / 04:15
0
answers

How could better performance of a SELECT with several INNER JOIN

I have SELECT with several INNER JOIN and some functions like replace , if .. This SELECT gets all the info I need, but it takes a long time. Is there any way to optimize this SELECT ? SELECT as_as...
asked by 06.06.2018 / 22:33
0
answers

How to create a total column in PIVOT

I have the following column RA COD_CADASTRO COD_TURMA SEMESTRE SITUACAO ---------- --------------------------------------- ---------- ---------- --------------- 917606337...
asked by 09.06.2018 / 17:47