Good morning,
I have a problem in listing data in ionic 3 using mysql. The problem is the following, I have an app that lists the comodo of a house and the consumption of each comodo, but I can not get the specific id of each room so that I can...
I have a code that is for inserting / changing / deleting Columns and rows from a database table, it worked very well when it was for MySQL, I tried to make some changes to MySQLi, at first it does not show any errors, more also does not perform...
I have table A with the id and user fields
and table B with id, data and id_A;
In the PHP page I want the contents of table B to appear, and with the id_A to search for the name in table A.
The main thing for me would be to search for a table...
I have in a table the columns:
codigo, cliente, token_md, val, cartcodigo, clientenome, clientesobrenome, clientecpf, clientenascimento
I need to delete exactly 46,550 rows from this table, with no worries of order.
I need to generate a dynamic report through JasperSoft, the result of querying three MySQL tables. The tables are:
CREATE TABLE IF NOT EXISTS 'tcc'.'Catalogo' (
'idCatalogo' INT NOT NULL,
'titulo' LONGTEXT NULL,
'Autor' LONGTEXT NULL,...
I'm developing a site for a musical project and I'm having difficulty with select, it's the following, I have 2 tables a call album that contains cd information (artwork, disc title, songs name, etc), the other table calls album_links that has t...
Friends, how are you?
I'm learning about PHP and testing connections to MySQL I noticed a curious problem:
If I am using phpMyAdmin and through it I insert records, with accentuation, in my table the information is normally displayed whe...
Someone with MYSQL knowledge to help me in this case?
How to transform a query that generates multiple rows in just one row with all records side by side in the MySql database.
Example in the image below:
I have five tables, cis with the fields id , id_referencia , tipoci and numci , the others are cigeral , ciintercambio , cihoraextra cicompensacao .
When I create one of the cis I give inse...
I'm having trouble calling a modal based on my database, for example:
A user chooses the store category, and each category has an ID
and in the modal, I want to appear the names of the stores that are of the respective category
And how do...