php – Imthiaz Blog

Symfony Doctrine Many to Many Relationship (ManyToMany)

April 24, 2018
Imthiaz
Programming
0 Comments

Many to many relations are one of the mostly used relations in the relational database. It took a while for me to figure how to properly configure this relation in Symfony Doctrine. I am sharing this so it might be useful for someone.

Used very simple example students and course. A student can opt for multiple courses and a single course can be opted by multiple students.

And Entity class should be like this…

namespace AppBundle\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * Student
 *
 * @ORM\Table(name="ab_student")
 * @ORM\Entity(repositoryClass="AppBundle\Repository\StudentRepository")
 */
class Student
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255)
     */
    private $name;

    /**
     * @var string
     *
     * @ORM\Column(name="email", type="string", length=255)
     */
    private $email;

    /**
     * @var \DateTime
     *
     * @ORM\Column(name="dob", type="datetime")
     */
    private $dob;

    /**
     * @var ArrayCollection
     * @ORM\ManyToMany(targetEntity="AppBundle\Entity\Course", inversedBy="students", fetch="EAGER")
     * @ORM\JoinTable(
     *     name="ab_student_2_course",
     *     joinColumns={@ORM\JoinColumn(name="course_id", referencedColumnName="id", nullable=false, onDelete="cascade")},
     *     inverseJoinColumns={@ORM\JoinColumn(name="student_id", referencedColumnName="id", nullable=false, onDelete="cascade")}
     * )
     */
    private $courses;

    public function __construct()
    {
        $this->courses = new ArrayCollection();
    }

    /**
     * Get id
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set name
     *
     * @param string $name
     *
     * @return Student
     */
    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    /**
     * Get name
     *
     * @return string
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * Set email
     *
     * @param string $email
     *
     * @return Student
     */
    public function setEmail($email)
    {
        $this->email = $email;

        return $this;
    }

    /**
     * Get email
     *
     * @return string
     */
    public function getEmail()
    {
        return $this->email;
    }

    /**
     * Set dob
     *
     * @param \DateTime $dob
     *
     * @return Student
     */
    public function setDob($dob)
    {
        $this->dob = $dob;

        return $this;
    }

    /**
     * Get dob
     *
     * @return \DateTime
     */
    public function getDob()
    {
        return $this->dob;
    }

    /**
     * @return ArrayCollection
     */
    public function getCourses()
    {
        return $this->courses;
    }

    /**
     * @param ArrayCollection $courses
     */
    public function setCourses($courses)
    {
        $this->courses = $courses;
    }

}

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

/**

* @var string

*

* @ORM\Column(name="email", type="string", length=255)

*/

private $email;

/**

* @var \DateTime

*

* @ORM\Column(name="dob", type="datetime")

*/

private $dob;

/**

* @var ArrayCollection

* @ORM\ManyToMany(targetEntity="AppBundle\Entity\Course", inversedBy="students", fetch="EAGER")

* @ORM\JoinTable(

* name="ab_student_2_course",

* joinColumns={@ORM\JoinColumn(name="course_id", referencedColumnName="id", nullable=false, onDelete="cascade")},

* inverseJoinColumns={@ORM\JoinColumn(name="student_id", referencedColumnName="id", nullable=false, onDelete="cascade")}

* )

*/

private $courses;

public function __construct()

namespace AppBundle\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * Course
 *
 * @ORM\Table(name="ab_course")
 * @ORM\Entity(repositoryClass="AppBundle\Repository\CourseRepository")
 */
class Course
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255)
     */
    private $name;


    /**
     * @var ArrayCollection
     * @ORM\ManyToMany(targetEntity="AppBundle\Entity\Student", mappedBy="courses", cascade={"all"})
     */
    private $students;

    public function __construct()
    {
        $this->students = new ArrayCollection();
    }

    /**
     * Get id
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set name
     *
     * @param string $name
     *
     * @return Course
     */
    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    /**
     * Get name
     *
     * @return string
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * @return ArrayCollection
     */
    public function getStudents()
    {
        return $this->students;
    }

    /**
     * @param ArrayCollection $students
     */
    public function setStudents($students)
    {
        $this->students = $students;
    }

}

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

/**

* @var string

*

* @ORM\Column(name="name", type="string", length=255)

*/

private $name;

/**

* @var ArrayCollection

* @ORM\ManyToMany(targetEntity="AppBundle\Entity\Student", mappedBy="courses", cascade={"all"})

*/

private $students;

public function __construct()

{

$this->students = new ArrayCollection();

}

The above entities will create the following SQL and it will also create the cross-reference table.

CREATE TABLE ab_student 
  ( 
     id    INT auto_increment NOT NULL, 
     name  VARCHAR(255) NOT NULL, 
     email VARCHAR(255) NOT NULL, 
     dob   DATETIME NOT NULL, 
     PRIMARY KEY(id) 
  ) 
DEFAULT CHARACTER SET utf8 
COLLATE utf8_unicode_ci 
engine = innodb; 

CREATE TABLE ab_student_2_course 
  ( 
     course_id  INT NOT NULL, 
     student_id INT NOT NULL, 
     INDEX idx_87d76467591cc992 (course_id), 
     INDEX idx_87d76467cb944f1a (student_id), 
     PRIMARY KEY(course_id, student_id) 
  ) 
DEFAULT CHARACTER SET utf8 
COLLATE utf8_unicode_ci 
engine = innodb; 

CREATE TABLE ab_course 
  ( 
     id   INT auto_increment NOT NULL, 
     name VARCHAR(255) NOT NULL, 
     PRIMARY KEY(id) 
  ) 
DEFAULT CHARACTER SET utf8 
COLLATE utf8_unicode_ci 
engine = innodb; 

ALTER TABLE ab_student_2_course 
  ADD CONSTRAINT fk_87d76467591cc992 FOREIGN KEY (course_id) REFERENCES 
  ab_student (id) ON DELETE CASCADE; 

ALTER TABLE ab_student_2_course 
  ADD CONSTRAINT fk_87d76467cb944f1a FOREIGN KEY (student_id) REFERENCES 
  ab_course (id) ON DELETE CASCADE;

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

COLLATE utf8_unicode_ci

engine = innodb;

CREATE TABLE ab_student_2_course

(

course_id INT NOT NULL,

student_id INT NOT NULL,

INDEX idx_87d76467591cc992 (course_id),

INDEX idx_87d76467cb944f1a (student_id),

PRIMARY KEY(course_id, student_id)

)

DEFAULT CHARACTER SET utf8

COLLATE utf8_unicode_ci

engine = innodb;

CREATE TABLE ab_course

Hope this helps 😉

Why do we need to upgrade PHP 5.6 to PHP 7.2?

April 8, 2018
Imthiaz
Programming
0 Comments

Rest in peace PHP 5.6

The current version of PHP which is 5.6 has reached the end of life on 19th Jan 2017. PHP team has stopped support for 5.6, and no more new features added.
Security support for 5.6 is up to Jan 2019. On Jan 2019 PHP 5.6 officially dead.
The newer version of Linux and server software has already stopped supporting PHP 5.6 which creates a huge security risk.
Updating old server will be hard as it may break the PHP due to compatibility issues.
All major PHP libraries and frameworks will drop support for PHP 5.6
7.2 end of life is in Jan 2021
7.2 is so much faster than 5.6
7.X has new Zend Engine
Reduction in the memory usage
Consistent 64bit support
Better Error handling
More secure & better handling with SSL and cryptography

Install PHP 5.6 on Ubuntu 16.04

April 7, 2018
Imthiaz
Linux
1 Comment

To Install PHP 5.6 on Ubuntu just follow the command one by one bellow.

apt-get update

apt-get install software-properties-common

add-apt-repository ppa:ondrej/php

apt-key del 4F4EA0AAE5267A6C

apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4F4EA0AAE5267A6C

apt-get install apache2 php5.6 php5.6-cgi php5.6-curl php5.6-gd php5.6-intl php5.6-mysql php5.6-json php5.6-bz2 php5.6-mcrypt php5.6-xmlrpc php5.6-xsl php5.6-bcmath php5.6-mbstring php5.6-soap php5.6-xml php5.6-zip

service apache2 restart

1

2

3

4

5

6

7

8

9

10

11

12

13

apt-get update

apt-get install software-properties-common

add-apt-repository ppa:ondrej/php

apt-key del 4F4EA0AAE5267A6C

apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4F4EA0AAE5267A6C

apt-get install apache2 php5.6 php5.6-cgi php5.6-curl php5.6-gd php5.6-intl php5.6-mysql php5.6-json php5.6-bz2 php5.6-mcrypt php5.6-xmlrpc php5.6-xsl php5.6-bcmath php5.6-mbstring php5.6-soap php5.6-xml php5.6-zip

service apache2 restart

Symfony: Adding custom route by code during runtime

March 4, 2017
Imthiaz
Programming

During development we always come across situation where you need to add custom routes based on some settings based from the user. In this case we cannot use any of the standard methods like annotation and configuration files in symfony.

In this case you need to use a services and hooks to inject your custom route rules during runtime.

1) In your bundles under Resources\Config\services.yml add the following

services:
  Custom.Router:
    class: [BundleNamespace]\Classes\RoutingService
    arguments: [@service_container,@request_stack]
    tags:
      - { name: routing.loader }

1

2

3

4

5

6

services:

Custom.Router:

class: [BundleNamespace]\Classes\RoutingService

arguments: [@service_container,@request_stack]

tags:

- { name: routing.loader }

2) Now we need to create a class RoutingService.php

< ?php
namespace [BundleNamespace]\Classes\Service;

use Symfony\Component\DependencyInjection\ContainerAwareInterface;
use Symfony\Component\DependencyInjection\ContainerAwareTrait;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Symfony\Component\HttpFoundation\RequestStack;
use Symfony\Component\Config\Loader\LoaderInterface;
use Symfony\Component\Config\Loader\LoaderResolverInterface;
use Symfony\Component\Routing\Route;
use Symfony\Component\Routing\RouteCollection;

class RoutingService implements LoaderInterface , ContainerAwareInterface
{
    use ContainerAwareTrait;

    function __construct(ContainerInterface $container = null, RequestStack $request_stack = null)
    {
        $this->setContainer($container);
        $this->setRequestStack($request_stack);
    }

    public function load($resource, $type = null)
    {
        $routes = new RouteCollection();

        $searchRoute = new Route('/{siteSlug}/search/index.php', array(
            '_controller' => '[BundleNamespace]:[Controller]:[Action]',
        ), array(
            'siteSlug' => '[a-zA-Z0-9-]+'
        ));
        $routes->add('search_page', $searchRoute);

        return routes;
    }

    public function supports($resource, $type = null)
    {
        return 'dynamic' === $type;
    }

    public function getResolver()
    {
        // needed, but can be blank, unless you want to load other resources
        // and if you do, using the Loader base class is easier (see below)
    }

    public function setResolver(LoaderResolverInterface $resolver)
    {
        // same as above
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

< ?php

namespace [BundleNamespace]\Classes\Service;

use Symfony\Component\DependencyInjection\ContainerAwareInterface;

use Symfony\Component\DependencyInjection\ContainerAwareTrait;

use Symfony\Component\DependencyInjection\ContainerInterface;

use Symfony\Component\HttpFoundation\RequestStack;

use Symfony\Component\Config\Loader\LoaderInterface;

use Symfony\Component\Config\Loader\LoaderResolverInterface;

use Symfony\Component\Routing\Route;

use Symfony\Component\Routing\RouteCollection;

class RoutingService implements LoaderInterface , ContainerAwareInterface

{

use ContainerAwareTrait;

function __construct(ContainerInterface $container = null, RequestStack $request_stack = null)

{

$this->setContainer($container);

$this->setRequestStack($request_stack);

}

public function load($resource, $type = null)

{

$routes = new RouteCollection();

$searchRoute = new Route('/{siteSlug}/search/index.php', array(

'_controller' => '[BundleNamespace]:[Controller]:[Action]',

), array(

'siteSlug' => '[a-zA-Z0-9-]+'

));

$routes->add('search_page', $searchRoute);

return routes;

}

public function supports($resource, $type = null)

{

return 'dynamic' === $type;

}

public function getResolver()

{

// needed, but can be blank, unless you want to load other resources

// and if you do, using the Loader base class is easier (see below)

}

public function setResolver(LoaderResolverInterface $resolver)

{

// same as above

}

3) Now in your main routing.yml please include these lines

custom_dynamic:
    resource: .
    type: dynamic

1

2

3

custom_dynamic:

resource: .

type: dynamic

4) Once you are done please make sure you clear cache both env

./app/console cache:clear
./app/console cache:clear --env=prod

1 2	./app/console cache:clear ./app/console cache:clear --env=prod

5) Now the custom route should be loaded in.. Please make sure if you add more routes make sure the cache is cleared.

WHM / cPanel – Compile PHP 5.3 to work with PHP 5.2

December 18, 2012
Imthiaz
Linux

This is one of major issue lot of web masters face now. As PHP 5.2 has reached end of life we are forced to seek options to migrate and test PHP applications in PHP 5.2 and 5.3. Raj COO from WebHostRepo.com has posted a nice blog post on how to achieve this.

Running PHP 5.3 along with PHP 5.2.x in cPanel servers. webhostrepo

I did all the steps as mentioned on the blog post except for one, I had a lengthier configure statement 😉

./configure --prefix=/usr/local/php53 --enable-cgi --disable-phar --enable-bcmath --enable-calendar --enable-exif --enable-ftp --enable-gd-native-ttf --enable-libxml --enable-magic-quotes --enable-mbstring --enable-pdo --enable-soap --enable-sockets --enable-wddx --enable-zip --with-curl=/opt/curlssl/ --with-freetype-dir=/usr --with-gd --with-gettext --with-imap=/opt/php_with_imap_client/ --with-imap-ssl=/usr --with-jpeg-dir=/usr --with-kerberos --with-libdir=lib64 --with-libexpat-dir=/usr --with-libxml-dir=/opt/xml2 --with-libxml-dir=/opt/xml2/ --with-mysql=/usr --with-mysql-sock=/var/lib/mysql/mysql.sock --with-mysqli=/usr/bin/mysql_config --with-openssl=/usr --with-openssl-dir=/usr --with-pcre-regex=/opt/pcre --with-pdo-mysql --with-pdo-sqlite --with-pic --with-png-dir=/usr --with-sqlite=shared --with-tidy=/opt/tidy/ --with-xmlrpc --with-xpm-dir=/usr --with-xsl=/opt/xslt/ --with-zlib --with-zlib-dir=/usr

1

./configure --prefix=/usr/local/php53 --enable-cgi --disable-phar --enable-bcmath --enable-calendar --enable-exif --enable-ftp --enable-gd-native-ttf --enable-libxml --enable-magic-quotes --enable-mbstring --enable-pdo --enable-soap --enable-sockets --enable-wddx --enable-zip --with-curl=/opt/curlssl/ --with-freetype-dir=/usr --with-gd --with-gettext --with-imap=/opt/php_with_imap_client/ --with-imap-ssl=/usr --with-jpeg-dir=/usr --with-kerberos --with-libdir=lib64 --with-libexpat-dir=/usr --with-libxml-dir=/opt/xml2 --with-libxml-dir=/opt/xml2/ --with-mysql=/usr --with-mysql-sock=/var/lib/mysql/mysql.sock --with-mysqli=/usr/bin/mysql_config --with-openssl=/usr --with-openssl-dir=/usr --with-pcre-regex=/opt/pcre --with-pdo-mysql --with-pdo-sqlite --with-pic --with-png-dir=/usr --with-sqlite=shared --with-tidy=/opt/tidy/ --with-xmlrpc --with-xpm-dir=/usr --with-xsl=/opt/xslt/ --with-zlib --with-zlib-dir=/usr

Install ZendGuardLoader

# cd
# wget http://downloads.zend.com/guard/5.5.0/ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
# tar xvzf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
# cd ZendGuardLoader-php-5.3-linux-glibc23-x86_64/
# mv php-5.3.x/ /usr/lib64

1

2

3

4

5

# cd

# wget http://downloads.zend.com/guard/5.5.0/ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz

# tar xvzf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz

# cd ZendGuardLoader-php-5.3-linux-glibc23-x86_64/

# mv php-5.3.x/ /usr/lib64

Edit /usr/local/php53/lib/php.ini and add these lines to end

[Zend]
zend_extension="/usr/lib64/php-5.3.x/ZendGuardLoader.so"
zend_loader.enable=1

1

2

3

[Zend]

zend_extension="/usr/lib64/php-5.3.x/ZendGuardLoader.so"

zend_loader.enable=1

Happy migration 😉