Questions tagged as 'mysqli'

Tagged questions
0
answers

Display an image if value "7" is in row "Codes"

Thank you for the help you will offer me. I have tried many things, but now I am not advancing at all. I was able to put this code but it does not show me any image. There on top in my $results = $query->fetchAll( PDO::FETCH_ASSOC );...
asked by 23.11.2017 / 13:19
1
answer

I can not find the login error

I'm logging in, but even when I put the data of a registered user, invalid data appears. login.php <?php session_start(); require_once "Classes/UsuariosDAO.php"; require_once "Classes/UsuariosVO.php"; $objUsuario= new UsuariosVO(); $o...
asked by 29.11.2017 / 12:26
2
answers

How to find the data of the respective month

I'd like to know how to get only the data for the month we're in. For example: I have the date 2017-05-10 and I have the date 2017-11-05 , as I do to get the data only from a date with MySQL. I only want the date data 2017-11-...
asked by 17.11.2017 / 12:55
1
answer

Redirect to another page when logging error!

I have a registration system, which does not allow the user to register with an email already registered, but when I register with an existing email, it does not redirect the user to the registration page. I used the header='Location(cadastro...
asked by 17.11.2017 / 15:06
2
answers

Error returning database from php + mysqli

I'm filling in the select with data from the bank it gets to the select part in the neighborhoods table and returns the ids of the city however it does not enter the loop of the clients table where it fetches the ID_UF and if I put an existing id...
asked by 13.11.2017 / 18:23
1
answer

how to get database names with object-oriented php

Good morning I have a question as to how to get all the data registered in the database with my code. because I'm trying and my while is entering loop infinite could anyone help me? class code: require_once 'banco.php'; cl...
asked by 07.11.2017 / 10:44
1
answer

Reorder the id of a table [PHP & Mysqli]

Hello, I'm in a project where the order of the id's is quite important for the final result, but when I remove a line from the table, there's an empty id left over ... Ex: IfIdeleteid2itwilllooklikethis... Iwantthecodeafterdeletingittochangea...
asked by 15.11.2017 / 23:45
1
answer

Prevent duplicate records in left outer join

I have tried to use distinct but without success ... result should be SELECT distinct prd.ID_CPF_EMPRESA, prd.prd_codigo , prd.cat_codigo , prd.prd_descricao, prd.prd_preco , prd.prd_img , prd.prd_det_1 , prd.prd_det_2 , prd.prd_ativo , IFNULL...
asked by 31.10.2017 / 19:26
0
answers

Problems with Php and Mysqli

I recently emulated an old code for Mysqli and it is giving errors. Erro: Notice: Undefined variable: connection in /var/www/public_html/includes/functions.php on line 8 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, n...
asked by 29.10.2017 / 19:32
0
answers

Does Mysqli only execute if it has a submit?

Hello, I have a code, explained below, where I want to make available the files that users uploaded for download, so I made a php code, but the query is only executed if I upload a file, but I wanted it to execute when loading the page, does any...
asked by 25.10.2017 / 22:47