个人中心
gpt4 book ai didi

php - SQLSTATE[42000] : Syntax error or access violation: 1064 Symfony 2. 7.3 应用

转载 作者：可可西里 更新时间：2023-11-01 07:48:06 26 4
gpt4 key购买 nike

<分区>

当我尝试创建我的产品实体时出现以下错误:

An exception occurred while executing 'INSERT INTO products (code, name, description, order, stock, entry, created, manufactured, expire, opening_quantity, purchase_price, opening_price, price, visible, discontinue, view, about, brand_id, groups_id, measurement_id, gender_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [432211, "trolly bag", "description", 0, 2, "2016-02-01 15:02:57", "2016-02-01 15:02:57", "2011-03-08", "2016-09-12", 2, 100, 100, 100, 1, 0, 0, "about", 2, 2, null, null]:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order, stock, entry, created, manufactured, expire, opening_quantity, purchase_p' at line 1

产品实体:

在此处输入代码命名空间 AppBundle\Entity；

use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Symfony\Component\HttpFoundation\File\UploadedFile;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Validator\Constraints as Assert;

/**
 * @ORM\Entity
 * @ORM\Table(name="products")
 * @ORM\HasLifecycleCallbacks
 * @ORM\Entity(repositoryClass="AppBundle\Repository\ProductRepository")
 */

class Product
{
/**
 * @ORM\Column(type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
protected $id;
/**
 * @ORM\Column(type="integer")
 */
protected $code;
/**
 * @ORM\Column(type="string", length=100)
 */
protected $name;
/**
 * @ORM\Column(type="text")
 */
protected $description;
/**
 * @ORM\Column(type="integer")
 */
protected $order;
/**
 * @ORM\Column(type="integer")
 */
protected $stock;
/**
 * @ORM\Column(type="datetime")
 */
protected $entry;
/**
 * @ORM\Column(type="datetime")
 */
protected $created;
/**
 * @ORM\Column(type="date")
 */
protected $manufactured;
/**
 * @ORM\Column(type="date")
 *
 */
protected $expire;
/**
 * @ORM\Column(type="integer")
 */
protected $openingQuantity;
/**
 * @ORM\Column(type="integer")
 */
protected $purchasePrice;
/**
 * @ORM\Column(type="integer")
 */
protected $openingPrice;
/**
 * @ORM\Column(type="integer")
 */
protected $price;
/**
 * @ORM\Column(type="smallint")
 */
protected $visible;
/**
 * @ORM\Column(type="smallint")
 */
protected $discontinue;
/**
 * @ORM\Column(type="integer")
 */
protected $view;
/**
 * @ORM\Column(type="text")
 */
protected $about;

/**
 * @ORM\ManyToOne(targetEntity="Brand", inversedBy="product")
 * @ORM\JoinColumn(name="brand_id", referencedColumnName="id")
 */
protected $brand;

/**
 * @ORM\ManyToOne(targetEntity="Group", inversedBy="product")
 * @ORM\JoinColumn(name="groups_id", referencedColumnName="id")
 */
protected $group;

/**
 * @ORM\ManyToOne(targetEntity="Measurement", inversedBy="product")
 * @ORM\JoinColumn(name="measurement_id", referencedColumnName="id")
 */
protected $measurement;
/**
 * @ORM\ManyToOne(targetEntity="Gender", inversedBy="product")
 * @ORM\JoinColumn(name="gender_id", referencedColumnName="id")
 */
protected $gender;


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

/**
 * Set code
 *
 * @param integer $code
 * @return Product
 */
public function setCode($code)
{
    $this->code = $code;

    return $this;
}

/**
 * Get code
 *
 * @return integer 
 */
public function getCode()
{
    return $this->code;
}

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

    return $this;
}

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

/**
 * Set description
 *
 * @param string $description
 * @return Product
 */
public function setDescription($description)
{
    $this->description = $description;

    return $this;
}

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

/**
 * Set order
 *
 * @param integer $order
 * @return Product
 */
public function setOrder($order)
{
    $this->order = $order;

    return $this;
}

/**
 * Get order
 *
 * @return integer 
 */
public function getOrder()
{
    return $this->order;
}

/**
 * Set stock
 *
 * @param integer $stock
 * @return Product
 */
public function setStock($stock)
{
    $this->stock = $stock;

    return $this;
}

/**
 * Get stock
 *
 * @return integer 
 */
public function getStock()
{
    return $this->stock;
}

/**
 * Set entry
 *
 * @param \DateTime $entry
 * @return Product
 */
public function setEntry($entry)
{
    $this->entry = $entry;

    return $this;
}

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

/**
 * Set created
 *
 * @param \DateTime $created
 * @return Product
 */
public function setCreated($created)
{
    $this->created = $created;

    return $this;
}

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

/**
 * Set manufactured
 *
 * @param \DateTime $manufactured
 * @return Product
 */
public function setManufactured($manufactured)
{
    $this->manufactured = $manufactured;

    return $this;
}

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

/**
 * Set expire
 *
 * @param \DateTime $expire
 * @return Product
 */
public function setExpire($expire)
{
    $this->expire = $expire;

    return $this;
}

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

/**
 * Set openingQuantity
 *
 * @param integer $openingQuantity
 * @return Product
 */
public function setOpeningQuantity($openingQuantity)
{
    $this->openingQuantity = $openingQuantity;

    return $this;
}

/**
 * Get openingQuantity
 *
 * @return integer 
 */
public function getOpeningQuantity()
{
    return $this->openingQuantity;
}

/**
 * Set purchasePrice
 *
 * @param integer $purchasePrice
 * @return Product
 */
public function setPurchasePrice($purchasePrice)
{
    $this->purchasePrice = $purchasePrice;

    return $this;
}

/**
 * Get purchasePrice
 *
 * @return integer 
 */
public function getPurchasePrice()
{
    return $this->purchasePrice;
}

/**
 * Set openingPrice
 *
 * @param integer $openingPrice
 * @return Product
 */
public function setOpeningPrice($openingPrice)
{
    $this->openingPrice = $openingPrice;

    return $this;
}

/**
 * Get openingPrice
 *
 * @return integer 
 */
public function getOpeningPrice()
{
    return $this->openingPrice;
}

/**
 * Set price
 *
 * @param integer $price
 * @return Product
 */
public function setPrice($price)
{
    $this->price = $price;

    return $this;
}

/**
 * Get price
 *
 * @return integer 
 */
public function getPrice()
{
    return $this->price;
}

/**
 * Set visible
 *
 * @param integer $visible
 * @return Product
 */
public function setVisible($visible)
{
    $this->visible = $visible;

    return $this;
}

/**
 * Get visible
 *
 * @return integer 
 */
public function getVisible()
{
    return $this->visible;
}

/**
 * Set discontinue
 *
 * @param integer $discontinue
 * @return Product
 */
public function setDiscontinue($discontinue)
{
    $this->discontinue = $discontinue;

    return $this;
}

/**
 * Get discontinue
 *
 * @return integer 
 */
public function getDiscontinue()
{
    return $this->discontinue;
}

/**
 * Set view
 *
 * @param integer $view
 * @return Product
 */
public function setView($view)
{
    $this->view = $view;

    return $this;
}

/**
 * Get view
 *
 * @return integer 
 */
public function getView()
{
    return $this->view;
}

/**
 * Set about
 *
 * @param string $about
 * @return Product
 */
public function setAbout($about)
{
    $this->about = $about;

    return $this;
}

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

/**
 * Set brand
 *
 * @param \AppBundle\Entity\Brand $brand
 * @return Product
 */
public function setBrand(\AppBundle\Entity\Brand $brand = null)
{
    $this->brand = $brand;

    return $this;
}

/**
 * Get brand
 *
 * @return \AppBundle\Entity\Brand 
 */
public function getBrand()
{
    return $this->brand;
}

/**
 * Set measurement
 *
 * @param \AppBundle\Entity\Measurement $measurement
 * @return Product
 */
public function setMeasurement(\AppBundle\Entity\Measurement $measurement = null)
{
    $this->measurement = $measurement;

    return $this;
}

/**
 * Get measurement
 *
 * @return \AppBundle\Entity\Measurement 
 */
public function getMeasurement()
{
    return $this->measurement;
}

/**
 * Set gender
 *
 * @param \AppBundle\Entity\Gender $gender
 * @return Product
 */
public function setGender(\AppBundle\Entity\Gender $gender = null)
{
    $this->gender = $gender;

    return $this;
}

/**
 * Get gender
 *
 * @return \AppBundle\Entity\Gender 
 */
public function getGender()
{
    return $this->gender;
}

/**
 * Set group
 *
 * @param \AppBundle\Entity\Group $group
 * @return Product
 */
public function setGroup(\AppBundle\Entity\Group $group = null)
{
    $this->group = $group;

    return $this;
}

/**
 * Get group
 *
 * @return \AppBundle\Entity\Group 
 */
public function getGroup()
{
    return $this->group;
}
}

Controller :

namespace AppBundle\Controller\admin;

use AppBundle\Entity\Product;

use AppBundle\Form\Type\ProductType;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\File\UploadedFile;
use Symfony\Component\HttpFoundation\Request;


class ProductController extends Controller
{
/**
 * @Route("/admin/product/create/{group_id}", name="create group         product")
 */
public function groupProductCreateAction(Request $request,$group_id)
{

    $Group = $this->getDoctrine()->getRepository('AppBundle:Group');

    $group =  $Group->findOneById($group_id);

    $product = new Product();

    $form = $this->createForm(new ProductType(), $product)
        ->add('save', 'submit', array(
            'label' => 'Save',
            'attr'=>array('class'=>'btn btn-md btn-info')
        ));

    $form->handleRequest($request);

    if ($form->isValid()) {
        $openingStock = $product->getOpeningQuantity();
        $openingPrice = $product->getPrice();
        $product->setOrder(0);
        $product->setStock($openingStock);
        $product->setEntry(new \DateTime());
        $product->setCreated(new \DateTime());
        $product->setOpeningPrice($openingPrice);
        $product->setDiscontinue(0);
        $product->setView(0);
        $product->setGroup($group);


        $em = $this->getDoctrine()->getManager();
        $em->persist($product);
        $em->flush();
        return $this->redirect($this->generateUrl('create category       group',
            array('category_id' => $group_id, )));
    }

    return $this->render('admin/product.html.twig', array(
        'form' => $form ->createView(),
    ));
}

26 4 0
文章推荐： c# - 覆盖方法中的默认参数值
文章推荐： mysql - 如何更改MySQL错误日志文件的时区？
文章推荐： c# - Windows 8 - 如何关闭触摸键盘？
文章推荐： android - 将 gradle 依赖项 9.4.0 更新为 9.6.1 时生成错误
可可西里
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com