Using normal MySQL instead of the query builder in Laravel

You need to learn all of these:

• db see docs
• querybuilder
• orm
• the getPdo() function

The last one getPdo() gives a PDO connection for normal regular pdo queries. Laravel is very very flexible.

Edit last one works like

$postdata = array(
                'dogid' => $dogid,
                'dogpic' => $dogpic,
                'dogname' => $dogname,
                'sex' => $sex,
                'comments' => $comments,
                'adopted' => $adopted,
                'lastedit' => $lastedit
            );

then

$sql = "UPDATE " . PREFIX . "dogs SET dogpic = :dogpic, dogname = :dogname, sex = :sex, comments = :comments, adopted = :adopted, lastedit = :lastedit WHERE dogid = :dogid";
$stmt = DB::getPdo()->prepare($sql);
$stmt->execute($postdata);

Regualr pdo and you can use PDO::FETCH_OBJ or PDO::FETCH_ASSOC whatever you want and need to do.

@jlrdw : You'll probably right, but I hope I can convert some CI projects into Laravel and therefore I hope I can use my mysql queries as the are. (Coded into raw mysql).

You can, but may require small tweaks. I converted once a java jsp/servlet application to php. If you know your code, small tweaking isn't that hard.

But the main question stays:

Can I get a single row, thus not an array with this query?

$task = DB::select('select * from tasks where id = '.$id.''); like this one:

$task = DB::table('tasks')->find($id);)