Questions tagged as 'mysql'

Tagged questions
1
answer

E Secure to make mysql queries using cookie values? [closed]

Hello, the next I made a system that works, but I'm sure it's safe to use it to make sure it's safer or at least try to get it. I'm using a function that only reads numbers in mysql , but I'm still a beginner and would like a second opinion abo...
asked by 26.02.2018 / 14:04
1
answer

foreach returning empty data non existent

I have the following form: <form class="form-horizontal" action="perguntas.php" method="GET"> <fieldset> <?php $StringPerguntaLoja = "SELECT * FROM sug_pergunta_fixa AS p inner join sug_area a...
asked by 03.08.2017 / 16:39
1
answer

Select with users who most sent messages

I'm making a system and I have to know which user sent the most messages. My tables look something like this: User id|nome|sobrenome|email| ... Messages id|uid|nome|email|assunto|msg| ... I just need to know which user sent more...
asked by 12.08.2017 / 21:56
4
answers

How to make a Select from two 1-N tables and return only one record from the second?

I'm having trouble creating a select that fetches data in two tables, the description follows: Tabela produto ( id_produto, nome_produto, preco, categoria ) Tabela imagem ( id_imagem, id_produto, nome_imagem, ca...
asked by 19.08.2016 / 18:27
1
answer

how do I grab a line from a field that has no boundaries and break in array?

I have the code that takes a string from a field in the example below:    material plant part vazo light This string has no boundaries and, as you can see, the string words I need to break have distinct characters running my code below th...
asked by 19.04.2016 / 18:59
1
answer

How to have more than one value referring to another table?

Good people, I come with a doubt that has been chasing me for a long time. Let's go to what I have: I have the table X but values from the table X I get in the Y table . How to store more than one value in the Y table for X table...
asked by 31.03.2016 / 04:32
1
answer

Database Data Collection accent error [duplicate]

Well, I have a query that takes the data from a database table and stores it in an array, however, the data in the database has accents. When I print on the screen the data with <?php echo $array["nome"]; ?> How can I fix t...
asked by 27.03.2016 / 17:40
1
answer

How to update table with foreign key

I have table discipline and teacher table. The teacher contains discipline. How do I change the name of the course and automatically change the tb teachers? I'm kind of confused about using On update cascade and delete Casdade .. It deletes a...
asked by 05.07.2016 / 20:24
1
answer

I am creating a school system, I want together a list of linked teachers and materials Bank (MySql)

I am creating a school system, I want to list a list of teachers linked to subjects and come and go. I use Mysql Bank Example: Professor 1 - Materia 1 Professor 1 - Materia 2 Professor 1 - Materia 3 Professor 2 - Materia 1 Professor 2 - Mat...
asked by 02.09.2017 / 20:21
2
answers

Mysqli INSERT INTO Not working [closed]

I have a code that inserts records into the database, it is not displaying any errors, it simply is not sending the data to the database The code worked before, but as mysql_ * became obsolete, I had to update, and then it stopped working....
asked by 01.11.2015 / 05:31