I cannot create php class and use PDO connection

Question

I’m creating a class that fetches data from the database for display. For example, one of the functions of the class is to take the date, of a given, in the database and display on the screen. The way I’m doing, it’s not working.

Follows my code

<?php

class contaEntrada {

var $dataConta;
var $descricaoConta;
var $valorConta;

function conectar(){
    $host = "localhost";
    $user = "root";
    $pass = "root";
    $dbname = "fluxo_de_caixa";

    try {
        $opcoes = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
        $pdo = new PDO("mysql:host=localhost;dbname=fluxo_de_caixa;", "root", "root", $opcoes);
    } catch (Exception $e) {
        echo $e->getMessage();
    }
    return $pdo;
}

function pegaDataConta(){
    $pdo = conectar();
    $pegaData=$pdo->prepare("SELECT data FROM entrada WHERE id_entrada:id");
    $pegaData->bindValue(":id", 30);
    $pegaData->execute();
}

function mostraConta(){
    echo $this->descricaoConta = "Conta de luz";
}

function valorConta(){
    echo $this->valorConta = "50,00";
}
}

And I’m calling the functions in another file. index php.

<?php
require_once "con/conexao.php";
require_once "classes/contaEntrada.php";

$entrada = new contaEntrada();

$entrada->pegaDataConta();
echo " - ";
$entrada->mostraConta();
echo " - ";
$entrada->valorConta();

Answer 1

If this is your complete code, you may have forgotten to call the function pegaDataConta(), if you are already calling her, below the $pegaData->execute() make a var_dump($pegaData->fetchAll()); to show all data on the page.

I took your code and changed it to a mysql database of mine and it works perfectly, try so:

<?php

function conectar(){
    $user = 'root';
    $pass = 'root';
    try {
        $opcoes = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
        $pdo = new PDO('mysql:host=localhost;dbname=fluxo_de_caixa', $user, $pass, $opcoes);
    } catch (Exception $e) {
        echo $e->getMessage();
    }
    return $pdo;
}

function pegaDataConta(){
    $pdo = conectar();
    $pegaData =$pdo->prepare("SELECT * FROM entrada");
    $pegaData->execute();
    var_dump($pegaData->fetchAll());
}

pegaDataConta();

If it’s another problem let me know that I edit the answer, otherwise this is all normal in your code.

Answer 2

function pegaDataConta(){
    $pdo = conectar();
    $pegaData=$pdo->prepare("SELECT data FROM entrada WHERE id_entrada:id");
    $pegaData->bindValue(":id", 30);
    $pegaData->execute();
}

Do not forget to put the operation you want, in case it would be the same, is missing one in the query also make the method return the data obtained with fetch() or fetch()

function pegaDataConta(){
    $pdo = conectar();
    $pegaData=$pdo->prepare("SELECT data FROM entrada WHERE id_entrada = :id");
    $pegaData->bindValue(":id", 30);
    if(!$pegaData->execute()){
       print_r($pdo->errorInfo);
    }
    return $pegaData->fetchAll(PDO::FETCH_ASSOC);

Suggestions:

Don’t use the keyword var it serves to define a class property in the php4, use any of the access modifiers, public, protected or private.

It is better to create a class attribute to save the connection, once created it in the constructor just call.