Beaker_Studio does not currently provide support for this item.

30 comments found.

I wish you used a PDO (for more different DB’s)

This library does use PDO, so it’s possible to modify it to use another database system. However this library only supports MySQL because it wouldn’t be worth my time to support more than one system.

Does this support subquerys?

No, sorry.

Sorry really new to PDO!

How would I do the following with your class

$db = new pdo("mysql:host=localhost;dbname=cms", "root", ""); $query = "SELECT * FROM users"; $result = $db->query($query); if ($result != false) { while ($row = $result->fetch(PDO::FETCH_ASSOC)) { echo date("Y/m/d", strtotime($row['date_joined'])); echo "<br />"; echo $row['firstname'] . " " . $row['lastname']; echo "<br />"; echo $row['id']; echo "<br />"; } }

Refer to the select documentation for simple select queries:

The variable $result from that example is an array, so it can be iterated using a foreach loop like so:

foreach($result as $row) { /* Do something... */ }

Is there any way we can get a SET function coded in?

ie: UPDATE CATEGORY SET count = count + 1 WHERE category_id = 5

There are no planned feature additions for this library. The only updates will be bug fixes.

Running into an odd issue, on UPDATE query, regardless if it succeeds or fails it always returns 1. Any idea why this would happen? It has made this class useless for me in it’s current state.

It is also not returning any PDOException errors, as it is succeeding even if it fails.

I think I figured it out, you have $this->last_result = $res->execute(); under the execute() function, it should be $res->execute(); $this->last_result = $res->rowCount();

So that it returns the number of rows modified..

it’s suitable for completely newbie ?

I’m a few steps behind, where do I insert this code, and where do the files go? Thanks in advance for helping a newby.

$host = 'localhost';
$database = 'bitnami_wordpress';
$username = 'root';
$password = '1';

$con = new MysqlConnection($host, $database, $username, $password);

hi is it possible to save query ? and export it ?

demo is offline

ahh man, even documentation is down.