I have got Laravel to work for doing simple HTML pages, routing worked, as defined at this question of mine but I am not sure how to get MySQL and PDO working in a view.
I can get 'traditional' Hello world PHP/MySQL queries working in a view, but am not quite sure how to do this with Laravel's framework.
I read through the documentation but couldn't find anything on how to do this - anyone got any ideas?
Currently I have a basic page, but want to get a simple foreach query working, echoing data from this table:
testingdb Tablename: test1
name VARCHAR (255)
town VARCHAR (255)
biography TEXT
How would I get this to work without using the traditional PHP/MySQL methods that are normally mentioned in tutorials and using pdo instead (source, nettuts, why you should use PDO article)?
Is there something I need to do, create a controller etc?
you can find the answer in the documents here http://laravel.com/docs/database/eloquent
to show you an example : 1) first form your model ( eg . test1) 2) make a database table connection and foreach like here:
foreach (test1::all() as $test)
{
echo $test->name;
}