Questions tagged as 'mysql'

Tagged questions
1
answer

DB Access Security with PHP [closed]

I'm creating a website, and I'm not sure how to ensure the security of my database. I currently have a "Security" folder with the connection.php file that connects to the DB. I give include to this file on every page that I need to...
asked by 28.06.2017 / 16:31
1
answer

MySQL - Update column with Brazilian date value

I'm updating a table in a bank with more than 100,000 records to be able to perform future SELECTS to generate a statistical report. The table currently has a 'Birth' column of type varchar (10) that stores the client's date of birth in the f...
asked by 28.06.2017 / 21:47
2
answers

accent problem in the bank

Friends, I'm having trouble writing with accent on the database as soon as I changed the version to PHP 5.6 I know you have a lot of questions on this subject, but I have tested several of them and it does not work at all, recreate the entire...
asked by 28.06.2017 / 04:15
1
answer

How to search a word in 10 tables in MySQL

I'm making a form for a search, and when I look for something, I want it to return various values from several tables that exist. As such, I would like to know the easiest way to do a query, which is not too heavy and can read all tables with...
asked by 20.06.2017 / 13:35
2
answers

Concatenate data from a table

I have the following sql statement: SELECT a.alunonome AS aluno, m.materianome AS disciplina, AVG(CASE n.notabimestre WHEN 1 THEN n.nota ELSE null END) AS bim1,...
asked by 19.06.2017 / 23:57
2
answers

multi upload php

How do I get this script to receive multiple images, at the moment it only takes one at a time. <?php include 'connection.php'; $album_id = $_GET['album_id']; if ($_FILES['photo']['name'] != null) { move_uploaded_fi...
asked by 19.07.2017 / 02:12
1
answer

UPDATE on two PHP tables

In my database I have a table called register id_cadastro username_user email_user age_user sobre_user fb_user tt_user in_user avatar_user These are the information I use for login. But after registering in this table...
asked by 12.07.2017 / 03:59
1
answer

How to select multiple data from related tables

I have created three tables in the student, book and loan database, I would like to list all the books that were loaned to each student, however, when the student takes more than one borrowed book the command I use to make the search in the bank...
asked by 19.06.2017 / 00:19
1
answer

Data being multiplied in the table

I have a recipe book and in this register has a button that clones the fields "quantity of ingredients" and "combo box of ingredients". If I add only a quantity and ingredient, the registration is saved correctly. But the same does not happen wi...
asked by 18.06.2017 / 04:34
1
answer

Doubt request blank webservice PHP

Hello, I have a problem with a part of the code: function obterBD($nome){ // Conecatar banco de dados if(!$conn = connectBD()){ return false; } // Incluir/Atualizar retorno no banco de dados $arrayReturn = getnota($conn, $nome); if(i...
asked by 06.06.2017 / 14:37