StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSymfony2: Show IP as string and save IP as INT
primarykey
Id
11409554
data
AcceptedAnswerId
11409675
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-07-10T08:38:21.763
FavoriteCount
0
LastActivityDate
2012-07-10T21:08:49.997
LastEditDate
LastEditorUserId
0
OwnerUserId
1448709
ParentId
0
PostTypeId
1
Score
0
ViewCount
2838
LastEditorDisplayName
text
Body
I have an Entity in Symfony called Ip and I save my IP address as integer - I use the IP as primary key, too. But when I display and enter the IP in a form or list I want to convert it to a IP, e.g. 127.0.0.1 is saved as 2130706433. I created the forms with the CRUD generator. My entity comes here: <pre><code><?php namespace IS\ClearanceBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * IS\ClearanceBundle\Entity\Ip */ class Ip { /** * @var bigint $ip */ private $ip; /** * @var integer $high */ private $high; /** * @var string $hoster */ private $hoster; /** * @var datetime $scandate */ private $scandate; /** * @var integer $id */ private $id; /** * @var IS\ClearanceBundle\Entity\Clearance */ private $clearance; public function __construct() { $this->clearance = new \Doctrine\Common\Collections\ArrayCollection(); } /** * Set ip * * @param bigint $ip */ public function setIp($ip) { $this->ip = $ip; } /** * Get ip * * @return bigint */ public function getIp() { return $this->ip; } /** * Set high * * @param integer $high */ public function setHigh($high) { $this->high = $high; } /** * Get high * * @return integer */ public function getHigh() { return $this->high; } /** * Set hoster * * @param string $hoster */ public function setHoster($hoster) { $this->hoster = $hoster; } /** * Get hoster * * @return string */ public function getHoster() { return $this->hoster; } /** * Set scandate * * @param datetime $scandate */ public function setScandate($scandate) { $this->scandate = $scandate; } /** * Get scandate * * @return datetime */ public function getScandate() { return $this->scandate; } /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Add clearance * * @param IS\ClearanceBundle\Entity\Clearance $clearance */ public function addClearance(\IS\ClearanceBundle\Entity\Clearance $clearance) { $this->clearance[] = $clearance; } /** * Get clearance * * @return Doctrine\Common\Collections\Collection */ public function getClearance() { return $this->clearance; } } </code></pre> And here is my Controller: <pre><code><?php namespace IS\ClearanceBundle\Controller; use Symfony\Bundle\FrameworkBundle\Controller\Controller; use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method; use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route; use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template; use IS\ClearanceBundle\Entity\Ip; use IS\ClearanceBundle\Form\IpType; /** * Ip controller. * * @Route("/ip") */ class IpController extends Controller { /** * Lists all Ip entities. * * @Route("/", name="ip") * @Template() */ public function indexAction() { $em = $this->getDoctrine()->getEntityManager(); $entities = $em->getRepository('ISClearanceBundle:Ip')->findAll(); return array('entities' => $entities); } /** * Finds and displays a Ip entity. * * @Route("/{id}/show", name="ip_show") * @Template() */ public function showAction($id) { $em = $this->getDoctrine()->getEntityManager(); $entity = $em->getRepository('ISClearanceBundle:Ip')->find($id); if (!$entity) { throw $this->createNotFoundException('Unable to find Ip entity.'); } $deleteForm = $this->createDeleteForm($id); return array( 'entity' => $entity, 'delete_form' => $deleteForm->createView(), ); } /** * Displays a form to create a new Ip entity. * * @Route("/new", name="ip_new") * @Template() */ public function newAction() { $entity = new Ip(); $form = $this->createForm(new IpType(), $entity); return array( 'entity' => $entity, 'form' => $form->createView() ); } /** * Creates a new Ip entity. * * @Route("/create", name="ip_create") * @Method("post") * @Template("ISClearanceBundle:Ip:new.html.twig") */ public function createAction() { $entity = new Ip(); $request = $this->getRequest(); $form = $this->createForm(new IpType(), $entity); $form->bindRequest($request); if ($form->isValid()) { $em = $this->getDoctrine()->getEntityManager(); $em->persist($entity); $em->flush(); return $this->redirect($this->generateUrl('ip_show', array('id' => $ entity->getId()))); } return array( 'entity' => $entity, 'form' => $form->createView() ); } /** * Displays a form to edit an existing Ip entity. * * @Route("/{id}/edit", name="ip_edit") * @Template() */ public function editAction($id) { $em = $this->getDoctrine()->getEntityManager(); $entity = $em->getRepository('ISClearanceBundle:Ip')->find($id); if (!$entity) { throw $this->createNotFoundException('Unable to find Ip entity.'); } $editForm = $this->createForm(new IpType(), $entity); $deleteForm = $this->createDeleteForm($id); return array( 'entity' => $entity, 'edit_form' => $editForm->createView(), 'delete_form' => $deleteForm->createView(), ); } /** * Edits an existing Ip entity. * * @Route("/{id}/update", name="ip_update") * @Method("post") * @Template("ISClearanceBundle:Ip:edit.html.twig") */ public function updateAction($id) { $em = $this->getDoctrine()->getEntityManager(); $entity = $em->getRepository('ISClearanceBundle:Ip')->find($id); if (!$entity) { throw $this->createNotFoundException('Unable to find Ip entity.'); } $editForm = $this->createForm(new IpType(), $entity); $deleteForm = $this->createDeleteForm($id); $request = $this->getRequest(); $editForm->bindRequest($request); if ($editForm->isValid()) { $em->persist($entity); $em->flush(); return $this->redirect($this->generateUrl('ip_edit', array('id' => $ id))); } return array( 'entity' => $entity, 'edit_form' => $editForm->createView(), 'delete_form' => $deleteForm->createView(), ); } /** * Deletes a Ip entity. * * @Route("/{id}/delete", name="ip_delete") * @Method("post") */ public function deleteAction($id) { $form = $this->createDeleteForm($id); $request = $this->getRequest(); $form->bindRequest($request); if ($form->isValid()) { $em = $this->getDoctrine()->getEntityManager(); $entity = $em->getRepository('ISClearanceBundle:Ip')->find($id); if (!$entity) { throw $this->createNotFoundException('Unable to find Ip entity.' ); } $em->remove($entity); $em->flush(); } return $this->redirect($this->generateUrl('ip')); } private function createDeleteForm($id) { return $this->createFormBuilder(array('id' => $id)) ->add('id', 'hidden') ->getForm() ; } } </code></pre> And here the form: <pre><code> <?php namespace IS\ClearanceBundle\Form; use Symfony\Component\Form\AbstractType; use Symfony\Component\Form\FormBuilder; class IpType extends AbstractType { public function buildForm(FormBuilder $builder, array $options) { $builder ->add('ip') ->add('high') ->add('hoster') ->add('scandate') ->add('clearance','entity', array('class'=>'IS\ClearanceBundle\Entity\Clearance', 'property'=>'id','required'=>false, 'multiple'=>true)) ; } public function getName() { return 'is_clearancebundle_iptype'; } } </code></pre> Thanks for any help!
Tags
<symfony><doctrine2><ip>
Title
Symfony2: Show IP as string and save IP as INT
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USmbs
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.