Chapters

29 Chapters | 1:34:37 |

01

Introduction

1:00
02

ManyToOne Doctrine Relationships

4:40
03

Sharing Data between Fixture Classes

1:49
04

Restricting Edit Access to Owners

1:53
05

Using a shortcut Base Controller Class

2:30
06

Using PHPDoc for Auto-Completion

1:26
07

OneToMany: The Inverse Side of a Relationship

5:37
08

Doctrine Extensions: Sluggable and Timestampable

4:30
09

Using the slug in the Event URL

2:04
10

Adding createdAt and updatedAt Timestampable Fields

1:41
11

Creating a Custom orderBy Query

2:11
12

ManyToMany Relationship

2:37
13

Using the ManyToMany so Users can Attend an Event

4:53
14

More with ManyToMany: Avoiding Duplicates

2:51
15

JSON up in your Response

2:50
16

Come on, Set the Content-Type Header!

3:19
17

Adding the AJAX Touch: JavaScript

2:16
18

Customizing Error Pages and How Errors are Handled

6:01
19

Render another Controller in Twig

4:28
20

Creating a Pretty CSV Download

4:19
21

Your Very First Service

4:42
22

Symfony Overlord: The Service Container

4:58
23

Configuration Loading and Type-Hinting

2:01
24

Dependency Inject All the Things

3:14
25

Twig Extensions and Dependency Injection Tags

4:33
26

Doctrine is in your Lifecycle (with Callbacks)

2:08
27

Doctrine Event Listeners

5:59
28

Doctrine Listeners on Update

2:48
29

Keep Going!

1:19

This tutorial has a new version, check it out!

> Symfony 2 > Starting in Symfony2: Course 3 (2.4+)

Buy Access to Course

11.

Creating a Custom orderBy Query

|

Autoplay

Keep on Learning!

If you liked what you've learned so far, dive in! Subscribe to get
access to this tutorial plus video, code and script downloads.

Start your All-Access Pass

Buy just this tutorial for $12.00

Previous Chapter

Next Chapter

Login or register to check out the script

6 Comments

Sort By

Login or Register to join the conversation

Enkhbilguun E. 8 years ago

Hi Ryan,

How can I call a stored procedure in MSSQL database? Connection between my Symfony v2.6 and SQL Server 2008R2 has been established, and I can do some basics.

|

Enkhbilguun E. 8 years ago

Ryan,

I'm sorry. I've found the answer. I should have just execute the stored procedure in the same way as I run in the SQL management studio.

Error I was getting was because of the permission issue. The passing credentials running Symfony to the Linked Server was not right user.

I'm using getEntityManager(), and Symfony says is deprecated since v2.1. Can you tell me the current method I should use for plain SQL query?

===
$conn = $container->get('doctrine')->getEntityManager()->getConnection();
$sql = 'SELECT * FROM yoda_event';
$stmt = $conn->prepare($sql);
$stmt->execute();
var_dump($stmt->fetchAll());die;
===

|

weaverryan SFCASTS Enkhbilguun E. 8 years ago

Hey!

Thanks for posting the solution to your question here for others :).

About getEntityManager() being deprecated, just use getManger() instead - it returns the same exact thing (so nothing else needs to change) - we just renamed the method in 2.1.

Cheers!

|

Enkhbilguun E. weaverryan 8 years ago

getManager() work. Thanks Ryan. :-)

|

Enkhbilguun E. 8 years ago

Hi everyone,

I can run a stored procedure or just plain query from my Symfony 2.6. I've written a stored procedure that calls another stored procedure that interacts with a historian. It looks the historian wants me provide a domain user. I can't make it work.

Do you know how I can use Windows domain user (my web server is IIS 7.5) as my database (pdo_sqlsrv) access credential?

I tried empty username/password and domain\user_account & password in the parameters without changing anything. It looks it's working.

|

weaverryan SFCASTS Enkhbilguun E. 8 years ago

Hi there!

I'll admit, I don't know anything about Windows and SQL server stuff :). But I will say that the stuff in parameters.yml (which is just being passed to the doctrine.dbal key in app/config/config.yml) is passed to the constructor of Doctrine Connection object: http://doctrine-dbal.readth.... So, if you're a bit brave, you might be able to debug it there. Also, in config.yml, here is the valid config you can put, in addition to dbname, password, etc: http://symfony.com/doc/curr... (look under doctrine.dbal.connections.default - all the keys you see there are valid for you to use).

I hope that helps, at least a little :).

Cheers!

|

Symfony 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=5.3.3",
        "symfony/symfony": "~2.4", // v2.4.2
        "doctrine/orm": "~2.2,>=2.2.3", // v2.4.2
        "doctrine/doctrine-bundle": "~1.2", // v1.2.0
        "twig/extensions": "~1.0", // v1.0.1
        "symfony/assetic-bundle": "~2.3", // v2.3.0
        "symfony/swiftmailer-bundle": "~2.3", // v2.3.5
        "symfony/monolog-bundle": "~2.4", // v2.5.0
        "sensio/distribution-bundle": "~2.3", // v2.3.4
        "sensio/framework-extra-bundle": "~3.0", // v3.0.0
        "sensio/generator-bundle": "~2.3", // v2.3.4
        "incenteev/composer-parameter-handler": "~2.0", // v2.1.0
        "doctrine/doctrine-fixtures-bundle": "~2.2.0", // v2.2.0
        "ircmaxell/password-compat": "~1.0.3", // 1.0.3
        "phpunit/phpunit": "~4.1", // 4.1.0
        "stof/doctrine-extensions-bundle": "~1.1.0" // v1.1.0
    }
}

Previous Chapter

Next Chapter