Questions tagged as 'mysqli'

1
answer

Show other BD mysqli data in a new window in PHP

Well what I would like to do is to call the database data to display only the main data in a table, and in that same table have the preview button where as long as I press it it opens a window with the rest of the database information. The part...
asked by 19.06.2018 / 01:42
1
answer

I can not make a select in a database using PHP

Hi everyone, I'm not able to do a select in my PHP database. I already tried to implement several solutions, however it always returns 0 results, and I have data in my DB. I am using external files to connect to the bank and they are working....
asked by 18.06.2018 / 03:36
1
answer

How to exchange content without changing structure?

I started to make a website in the same code. Except that this site will have several pages on it on every page, the structure is the same, what changes is just the content. To not have to do in the code page by page, make a lot of pages, I want...
asked by 06.05.2018 / 02:36
1
answer

Content on the same line when I pull mysqli

I host a text field in my database, with my space between paragraphs. But when I pull it to insert without being in textarea field it comes all in one line only, no spacing. Goal: Bom dia Bruno Agradecemos pelo seu contato! Segue em anex...
asked by 26.04.2018 / 14:26
1
answer

Where am I going wrong in this select?

I made the Select below only that it is not adding up by the correct column, where am I going wrong? In my structure I have the dtConcat2 field and the dtConcat2 field (these dates are different one is for the date of the request and the othe...
asked by 26.04.2018 / 21:22
1
answer

My form does not send to the bank

I created a form to save data in the MySql database, but it is not working as expected. I'm having trouble identifying the problem because no error appears, the page just refreshes. Table in the Bank: id_contato (int11 aI) , n...
asked by 22.03.2018 / 20:56
1
answer

Compare records between two tables in MYSQL

I need a solution that compares any changes you've made to the products_csv table against the products table ( letter or number ) in some field. I'm using the code below but only works for single records because if there are duplicat...
asked by 22.03.2018 / 20:02
1
answer

Listing all categories with the total number of products

I need to mount a query that displays the names of all categories, and in front of each name the total number of products. The tables are: Categorias (cat_codigo, cat_nome) Produtos (pro_codigo, pro_codigo_categoria pro_nome) Exem...
asked by 08.05.2018 / 14:27
1
answer

Limit amount of pages in PHP MYSQL pagination

I have a page in PHP and MYSQLI, and I would like the links on the pages below to be limited, for example: Pages: 1 2 3 4 5 (up to 100), only the first 5 appear, if I have on page 10, show me 8 9 10 11 12, I do not know if they understood me,...
asked by 29.03.2018 / 21:35
2
answers

Join query returns to populate a combochart

I have 2 queries in the database:    One returns the goals of the day until the last day of the month: DIA META 1 3,23 2 6,45 3 9,68 4 12,9 5 16,13 6 19,35 7 22,58 8 25,81 9 29,03 10 32,26 11 35,48 12 38,71 13 41,94 1...
asked by 13.03.2018 / 20:47