php - Symfony 3 - 如何从 Ajax 响应中插入数据到数据库

Question

我刚开始使用 Symfony 就遇到了这个问题，即使在网上研究了几个小时之后我也无法弄清楚。

我正在尝试将来自 ajax 请求的数据插入到我的数据库中。 ajax 请求到目前为止有效并发送以下字符串

{"description":"","location":"","subject":"asdfasdfdsf","allDay":false,"endTime":"2016-11-22T07:00:00.000Z","startTime":"2016-11-22T06:30:00.000Z","user":"6","calendar":"1","offer":"1","status":"open"}

这是我的ajax请求

$.ajax({
                        type: 'POST',
                        url: '{{ path('calendar_new') }}',
                        contentType: 'application/json; charset=utf-8',
                        data: JSON.stringify(newAppointment),
                        dataType: 'json',
                        success: function(response) {
                            console.log(response);
                        }
                    });

我的 Controller 看起来像这样

/**
 * @Route("/calendar/new", name="calendar_new")
 * @Method({"GET", "POST"})
 */
public function calenderNewAction(Request $request)
{


    if ($request->isXMLHttpRequest()) {
        $content = $request->getContent();
        if (!empty($content)) {
            $params = json_decode($content, true);
            $new = new timeEntry;
            $new->setDescription($params->get('description'));
            $new->setLocation($params->get('location'));
            $new->setSubject($params->get('subject'));
            $new->setAllDay($params->get('allDay'));
            $new->setEndTime($params->get('endTime'));
            $new->setStartTime($params->get('startTime'));

            $em = $this->getDoctrine()->getManager();
            $calendar = $em->getRepository('AppBundle:calendar')
                ->findOneBy(['id' => 1]);

            $offers = $em->getRepository('AppBundle:offer')
                ->findOneBy(['id' => 1]);

            $new->setCalendar($calendar);
            $new->setOffer($offers);
            $new->setUser($this->getUser());

            $em->persist($new);
            $em->flush();
        }

        return new JsonResponse(array('data' => $params));
    }

    return new Response('Error!', 400);
}

在我尝试之后，我得到了以下错误

Call to a member function get() on array 

所以 $params 变量实际上返回一个包含所有数据的对象，但我不知道如何使用这些值设置我的数据库变量。

Answer 1

我想通了。正如 Cerad 所提到的，我在一个数组上调用了一个方法，这是一个错误。

这是我现在可以使用的 Controller 。

 /**
 * @Route("/calendar/new", name="calendar_new")
 * @Method({"GET", "POST"})
 */
public function calenderNewAction(Request $request)
{


    if ($request->isXMLHttpRequest()) {
        $content = $request->getContent();
        if (!empty($content)) {
            $params = json_decode($content, true);
            $new = new timeEntry;
            $new->setDescription($params['description']);
            $new->setLocation($params['location']);
            $new->setSubject($params['subject']);
            $new->setAllDay($params['allDay']);
            $new->setEndTime(new \DateTime($params['endTime']));
            $new->setStartTime(new \DateTime($params['startTime']));

            $em = $this->getDoctrine()->getManager();
            $calendar = $em->getRepository('AppBundle:calendar')
                ->findOneBy(['id' => 1]);

            $offers = $em->getRepository('AppBundle:offer')
                ->findOneBy(['id' => 1]);

            $new->setCalendar($calendar);
            $new->setOffer($offers);
            $new->setStatus('Open');
            $new->setUser($this->getUser());

            $em->persist($new);
            $em->flush();
        }

        return new JsonResponse(array('data' => $params));
    }

    return new Response('Error!', 400);
}