Questions tagged as 'mysql'

Tagged questions
1
answer

How to perform a mysql table search with two filters?

I have a page where it returns a table from my database, but as this table receives several data I am trying to mount a filter for it, I made a form and from it a filter, follows example: $busca1 = $_POST['input001']; if ($busca1 != "") {...
asked by 27.09.2018 / 20:50
1
answer

Script does not save full word if you have accent

I have a script that works great on my dashboard, but I put it on another page and it is not working. When a word has an accent, eg "Natália" the system is saving in the bd just "Nat" excluding the rest that is part of the word. include "pa...
asked by 28.09.2018 / 21:15
2
answers

Bank registration via Ajax

Good afternoon. I'm a beginner in the programming world, and I'm developing a web app and I'm having trouble making a sales record in the database. The system must insert new inputs to register more than 1 product per sale. When I press the r...
asked by 04.12.2018 / 18:30
1
answer

Database structure note-breaking

I have a note assignment system where it is allowed to reply, replica and / or rejoinder, what is the best way to store it in the database? Create three tables ( contestacao , replica , treplica ) Create a table with all...
asked by 10.03.2014 / 01:34
1
answer

Different result between select, after applying SUM () and Grop By [closed]

I am making an elastix bind report and I have a problem here in the output. Theoretically, if I do not touch Where , the result would have to be the same. select distinct (case left( devices.id ,2) when '10' then 'SAC' when '40' then 'SA...
asked by 20.02.2014 / 20:13
1
answer

Change the order of a result in PHP WHILE from MySQL [duplicate]

I have the following difficulty, in a table are stored product category records, I made the connection mysqli, SELECT and WHILE, and everything is fine until then, but what I'm having is leaving a record of WHILE Finally, in the case it would...
asked by 27.08.2018 / 20:02
1
answer

How to implement encryption in the password?

I want to implement password encryption in the user registry. I found here on stackoverflow this post teaching how to use encryption, but I'm in doubt where I should add the code. Should this method be used in the class or controller? pub...
asked by 22.10.2018 / 18:24
1
answer

How do I save an array on separate lines in DB [duplicate]

How can I send a textarea containing multiple names, one per line, so that each row is a record in the database? Also, each line receives the value sent by school and class, I'm trying to do this, but only one record and in the field nome...
asked by 08.08.2018 / 16:06
2
answers

Do one or more searches on the database with php

I'm having a hard time searching my database with PHP code where I can search for an "item" but with more than one keyword. For example: I have a bank that shelters main information such as ip's, username, etc. I was able to do a search code...
asked by 12.12.2018 / 13:55
1
answer

Inserting a Foreign Key Id into a Relational Database

Good morning. I am a beginner in Database and programming and I have a question, what is the query to retrieve the id to insert into a foreign key table? I'm using the MYSQL database. Example, I have the "post" table, the post table has...
asked by 10.12.2018 / 13:25