OOP selecting data mysql

Question

I'm new to OOP and just trying to migrate from mysql_, but I'm running into some issues while migrating.

$konek = new PDO('mysql:host=localhost;dbname=mydatabase', root, root);$hasil = $konek->query("SELECT * FROM `tabel`");
while ($data = $hasil->fetch_object()) {
echo '<td>'.$data->something.'</td>';}

It doesn't work or show an error, but when I replace the first line with mysqli it works:

konek = new mysqli('localhost','root','root','mydatabase');

Any help would be really appreciated.

I suspect you aren't getting errors because: 1) You haven't configured PHP in general to do so. 2) You don't have any PDO specific error checking code. — Álvaro González
– Álvaro González, Commented Jun 28, 2014 at 15:25

score 2 · Accepted Answer · 2014-06-28 15:31:38Z

2

I assume in your code, it is coded as string: (or is root defined?)

$konek = new PDO('mysql:host=localhost;dbname=mydatabase', root, root);

Clearly, in your example, if it's a type change it to:

$konek = new PDO('mysql:host=localhost;dbname=mydatabase', 'root', 'root', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));

Refactor your code into this:

error_reporting(E_ALL);
ini_set("display_errors", 1);

try {
    $konek = new PDO('mysql:host=localhost;dbname=mydatabase', 'root', 'root', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

$hasil = $konek->query("SELECT * FROM `tabel`");
echo '<table>';
while ($row = $hasil->fetch(PDO::FETCH_OBJ)) {
    echo '<tr>';
        echo '<td>' . $row->column_name . '</td>';
    echo '</tr>';
}
echo '</table>';

edited Jun 28, 2014 at 15:31

answered Jun 28, 2014 at 15:23

user3778553

Sign up to request clarification or add additional context in comments.

2 Comments

mbuhasu Over a year ago

thanks for the help , now every error is displayed , i use MAMP and i think error is hidden by default

user3778553 Over a year ago

@user3181160 yes even in other environment, its usually off as default you really have to set it first, glad it helped

Awlad Liton · Accepted Answer · 2014-06-28 15:37:44Z

0

1)User name and password should be quoted string

2) use try catch

3) use prepare and execute the query

4) then fetch

try like this:

try {
    $konek = new PDO('mysql:host=localhost;dbname=mydatabase', 'root', 'root');
    $konek->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    die( 'ERROR: ' . $e->getMessage());
}

try {
    $hasil = $konek->prepare("SELECT * FROM `tabel`");
    $hasil->execute();
    while ($data = $hasil->fetch(PDO::FETCH_OBJ)) {
    echo '<td>'.$data->something.'</td>';
    }

}
catch(PDOException $e) {
        die( 'ERROR: ' . $e->getMessage());
    }

edited Jun 28, 2014 at 15:37

answered Jun 28, 2014 at 15:31

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

2 Comments

mbuhasu Over a year ago

try { $konek = new PDO('mysql:host=localhost;dbname=jwcrm2', 'root', 'root'); $konek->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { die( 'ERROR: ' . $e->getMessage()); } try{} $hasil = $konek->query("SELECT * FROM kontak"); while ($data = $hasil->fetch_object()) { echo '<td>'.$data->nomer.'</td>'; } catch(PDOException $e) { die( 'ERROR: ' . $e->getMessage()); }

mbuhasu Over a year ago

Ok thanks this is works :) , i just try to edit the tabel that doesnt exist but it doesnt show error , is it supposed to be that way ?

Sergio Mattei · Accepted Answer · 2014-06-28 15:26:53Z

-1

Please provide an error message it echoes.

MY best guess:

http://www.php.net/manual/en/pdostatement.fetchall.php

Try replacing

while ($data = $hasil->fetch_object()) {
echo '<td>'.$data->something.'</td>';}

with

while ($data = $hasil->fetchAll()) {
echo '<td>'.$data->something.'</td>';}

answered Jun 28, 2014 at 15:26

Sergio Mattei

4144 silver badges15 bronze badges

2 Comments

Sergio Mattei Over a year ago

Please try putting error_reporting into E_ALL mode php.net/manual/en/function.error-reporting.php

Sergio Mattei Over a year ago

Also please do var_dump on the $data variable and put the error here.

Collectives™ on Stack Overflow

OOP selecting data mysql

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related