Zend2 Framework - Skeleton App

how to get row where id X

[bethesda]

Hello everyone, i have question about Sklepeton APP / Zend2 Framework
I need to pass value to variable, i use for this my edit.phtml

Ok, edit.phtml give me values to edit, form database:

- title
- artis
- link

Now i want to pass those values to variable

- $title
- $artist
- $link

And echo them:

echo $title; echo $artist; echo $link;

How can i do that ?

Thanks in advence.

[jatar_k]

best is to find a couple examples of how to pass variables to your views
[google.com...]

[bethesda]

I want to pass (values) from database to variables.
For example (my edit.phtml view script):

EXAMPLE:
For adres: ../framework/public/edit/1

$id = "The code which is able to pull the ID from the database ";
echo $id;

In normal project, that will be:

$query = "SELECT id FROM table WHERE id=1";

ANOTHER EXAMPLE:
For adres: ../framework/public/edit/3

$title ="The code which is able to pull the ID from the database";
echo $title;

In normal project, that will be:

$query = "SELECT id FROM table WHERE id=3";

I hope that I have explained well enough what I mean ..
I intend to make every view script had the opportunity to pass values from the database to a variable.

Thanks.

[bethesda]

ANOTHER EXAMPLE:
For adres: ../framework/public/edit/3

$title ="The code which is able to pull the ID from the database";
echo $title; 

In normal project, that will be:

$query = "SELECT title FROM table WHERE id=3";