Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try
- {
- $q=$em->createQueryBuilder('i')
- ->from('AppBundle:Images','i')
- ->innerJoin('AppBundle:ImageGroups', 'g')
- ->innerJoin('AppBundle:Users','u')
- ->select('i')
- ->where('i.id=:iid')
- ->andWhere('u.id=:uid')
- ->setParameter(':uid', $user_id)
- ->setParameter(':iid', $image_id)
- ->setMaxResults(1)
- ->getQuery();
- $data=$q->getOneOrNullResult();
- if(empty($data)) return -3;
- /*Delete Image Stuff*/
- /*End Of: Delete Image Stuff*/
- /*Do some stuff here*/
- return true;
- }
- catch (Exception $e)
- {
- echo $e->getMessage();
- return false;
- }
- [Syntax Error] line 0, col 74: Error: Expected Literal, got 'JOIN'
- <?php
- namespace AppBundleEntity;
- use DoctrineORMMapping as ORM;
- /**
- * @ORMEntity
- * @ORMTable(name="images")
- * @ORMEntity(repositoryClass="AppBundleEntityImagesRepository")
- */
- class Images
- {
- /**
- * @ORMColumn(type="string", length=60)
- * @ORMId
- * @ORMGeneratedValue(strategy="CUSTOM")
- * @ORMCustomIdGenerator(class="AppBundleDoctrineAutoIdGenerate")
- */
- private $id;
- /**
- * Filename of the Image
- * @ORMColumn(type="string", length=100)
- */
- private $name;
- /**
- * Filename of the Thumbnail
- * @ORMColumn(type="string", length=100)
- */
- private $name_small;
- /**
- * ImageGroup og the Image
- * @ORMManyToOne(targetEntity="AppBundleEntityImageGroups", inversedBy="images")
- */
- private $group;
- /**
- * Get id
- *
- * @return string
- */
- public function getId()
- {
- return $this->id;
- }
- /**
- * Set name
- *
- * @param string $name
- *
- * @return Images
- */
- public function setName($name)
- {
- $this->name = $name;
- return $this;
- }
- /**
- * Get name
- *
- * @return string
- */
- public function getName()
- {
- return $this->name;
- }
- /**
- * Set nameSmall
- *
- * @param string $nameSmall
- *
- * @return Images
- */
- public function setNameSmall($nameSmall)
- {
- $this->name_small = $nameSmall;
- return $this;
- }
- /**
- * Get nameSmall
- *
- * @return string
- */
- public function getNameSmall()
- {
- return $this->name_small;
- }
- /**
- * Set group
- *
- * @param AppBundleEntityImageGroups $group
- *
- * @return Images
- */
- public function setGroup(AppBundleEntityImageGroups $group = null)
- {
- $this->group = $group;
- return $this;
- }
- /**
- * Get group
- *
- * @return AppBundleEntityImageGroups
- */
- public function getGroup()
- {
- return $this->group;
- }
- }
- <?php
- namespace AppBundleEntity;
- use DoctrineORMMapping as ORM;
- /**
- * @ORMEntity
- * @ORMTable(name="image_groups")
- * @ORMEntity(repositoryClass="AppBundleEntityImageGroupsRepository")
- */
- class ImageGroups
- {
- /**
- * @ORMColumn(type="string", length=60)
- * @ORMId
- * @ORMGeneratedValue(strategy="CUSTOM")
- * @ORMCustomIdGenerator(class="AppBundleDoctrineAutoIdGenerate")
- */
- private $id;
- /**
- * @ORMColumn(type="string", length=20)
- */
- private $groupname;
- /**
- * @ORMManyToOne(targetEntity="AppBundleEntityUsers", inversedBy="imagegroups")
- */
- private $users;
- /**
- * Constructor
- */
- public function __construct()
- {
- $this->user = new DoctrineCommonCollectionsArrayCollection();
- }
- /**
- * Get id
- *
- * @return string
- */
- public function getId()
- {
- return $this->id;
- }
- /**
- * Set groupname
- *
- * @param string $groupname
- *
- * @return ImageGroups
- */
- public function setGroupname($groupname)
- {
- $this->groupname = strip_tags($groupname);
- return $this;
- }
- /**
- * Get groupname
- *
- * @return string
- */
- public function getGroupname()
- {
- return $this->groupname;
- }
- /**
- * Set users
- *
- * @param AppBundleEntityUsers $users
- *
- * @return ImageGroups
- */
- public function setUsers(AppBundleEntityUsers $users = null)
- {
- $this->users = $users;
- return $this;
- }
- /**
- * Get users
- *
- * @return ppBundleEntityUsers
- */
- public function getUsers()
- {
- return $this->users;
- }
- /**
- * Add image
- *
- * @param AppBundleEntityImages $image
- *
- * @return ImageGroups
- */
- public function addImage(AppBundleEntityImages $image)
- {
- $this->images[] = $image;
- return $this;
- }
- /**
- * Remove image
- *
- * @param AppBundleEntityImages $image
- */
- public function removeImage(AppBundleEntityImages $image)
- {
- $this->images->removeElement($image);
- }
- /**
- * Get images
- *
- * @return DoctrineCommonCollectionsCollection
- */
- public function getImages()
- {
- return $this->images;
- }
- }
- <?php
- namespace AppBundleEntity;
- use DoctrineORMMapping as ORM;
- /**
- * @ORMEntity
- * @ORMTable(name="users")
- * @ORMEntity(repositoryClass="AppBundleEntityUserRepository")
- */
- class Users
- {
- /**
- * @ORMColumn(type="string", length=60)
- * @ORMId
- * @ORMGeneratedValue(strategy="CUSTOM")
- * @ORMCustomIdGenerator(class="AppBundleDoctrineAutoIdGenerate")
- */
- private $id;
- /**
- * @ORMColumn(type="string", length=15, unique = true)
- */
- private $username;
- /**
- * @ORMColumn(type="string", length=80)
- */
- private $password;
- /**
- * @ORMColumn(type="string", length=60, unique = true)
- */
- private $token;
- /**
- * @ORMColumn(type="boolean", options={"default"=false}, nullable=true)
- */
- private $activated=false;
- /**
- * @ORMColumn(type="string", length=30, unique = true)
- */
- private $email;
- /**
- * Get id
- *
- * @return string
- */
- public function getId()
- {
- return $this->id;
- }
- /**
- * Set username
- *
- * @param string $username
- *
- * @return Users
- */
- public function setUsername($username)
- {
- $this->username = strip_tags($username);
- return $this;
- }
- /**
- * Get username
- *
- * @return string
- */
- public function getUsername()
- {
- return $this->username;
- }
- /**
- * Set password
- *
- * @param string $password
- *
- * @return Users
- */
- public function setPassword($password)
- {
- $this->password = password_hash ($password,CRYPT_BLOWFISH);
- return $this;
- }
- /**
- * Get password
- *
- * @return string
- */
- public function getPassword()
- {
- return $this->password;
- }
- /**
- * Set token
- *
- * @param string $token
- *
- * @return Users
- */
- public function setToken($token)
- {
- $this->token = $token;
- return $this;
- }
- /**
- * Get token
- *
- * @return string
- */
- public function getToken()
- {
- return $this->token;
- }
- /**
- * Set activated
- *
- * @param boolean $activated
- *
- * @return Users
- */
- public function setActivated($activated)
- {
- $this->activated = $activated;
- return $this;
- }
- /**
- * Get activated
- *
- * @return boolean
- */
- public function getActivated()
- {
- return $this->activated;
- }
- /**
- * Set email
- *
- * @param string $email
- *
- * @return Users
- */
- public function setEmail($email)
- {
- $this->email = $email;
- return $this;
- }
- /**
- * Get email
- *
- * @return string
- */
- public function getEmail()
- {
- return $this->email;
- }
- }
- // I presume it's in a repository class
- // so the select and from parts are not required
- return $this->createQueryBuilder('i')
- ->innerJoin('i.group', 'g')
- ->innerJoin('g.users', 'u')
- ->where('i.id = :iid')
- ->andWhere('u.id = :uid')
- ->setParameter('uid', $user_id)
- ->setParameter('iid', $image_id)
- ->setMaxResults(1)
- ->getQuery()
- ->getOneOrNullResult();
- // or if it is not in a repository
- $em->createQueryBuilder()
- ->select('i')
- ->from('AppBundle:Images','i')
- // -> ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement