Questions tagged as 'pdo'

Tagged questions
1
answer

Login with PDO does not check number of results of select

I'm starting a new system only that instead of procedural I'm using O.O. and PDO, I started to login, but even to select returning the value, PHP shows that user or password is wrong ... Login method: static function login($usuario, $senha)...
asked by 05.07.2018 / 03:50
0
answers

Problem with Request via GET

I'm successfully using the script below to open in the Visual DIV the products for the selected brand: Trademark Link: <a class="marca" style="cursor:pointer;" id="'.$res['codigo'].'">'.$res['nome_marca'].'</a> Script...
asked by 06.07.2018 / 12:54
0
answers

PHP PDO relationship between tables - FK

Hello. I have two tables. In the table "cadastre" I have the fields: id - primary key - AUTO_INCREMENT ---- field name - VARCHAR 50 ---- field type - INT (11) - (field related to the "Type" table) ---- and field description - TEXT And...
asked by 28.06.2018 / 04:36
1
answer

Validate Login PHP PDO MYSQL

Hello, I'm starting with php already engaged in the PDO world and I have a question in my code    I want to check if the login exists and is the same one that was entered, if   for returns "existing login" if not "login not exist" Most e...
asked by 27.06.2018 / 04:42
0
answers

PDO - Session Authentication

Hello, I'm creating a form using PDO SESSIONS authentication. Connection to the database is OK, but when I do the following test of the logar.php file the code always goes to the else "Gave error!" I am trying to make a simple login with admi...
asked by 27.06.2018 / 06:36
1
answer

Select two columns also showing what is not related [duplicate]

Hello, I'm having the following difficulty: I'm using a Select that encompasses two tables tb_doenca and tb_vacina , but it does not display all values. EXAMPLE Thereare33recordsinthetb_doencatable,butwhenIusethefollowingquerry:select...
asked by 18.06.2018 / 19:29
0
answers

Error with fetchAll using order by

I'm doing a task scheduling system. I need to show these tasks to the user, I created a file called tarefas.php to query the MySQL database: <?php include_once 'conexao-calendario.php'; include_once 'VerificarLogin.php';...
asked by 20.06.2018 / 04:15
0
answers

How to search for the product by title?

I am trying to search for the product title, but regardless of the title consulted, it always returns me the last record of the Product table. I'm using the following code below to perform the search: <?php include "conexao.php"; $buscar...
asked by 09.06.2018 / 15:36
2
answers

Help Foreach stdClass

Good morning: D I need a light! I need to get all the 'ids' of users from a table and move to another table, but when I give a foreach it returns only 1 result like stdClass. Follow the code: $stmt = $PDO->prepare("SELECT usuario_id F...
asked by 02.06.2018 / 16:15
0
answers

Use PDO with PHP

Good morning, I created a function to get the ids of all the processes of a table, as shown in the code below function getProcessos() { $conecta = new PDO('mysql:host=localhost; dbname=processos','root','root'); $sql = "SELECT id fr...
asked by 24.05.2018 / 15:35