分类导航

PHP 发布时间：2022-04-01 发布网站：大佬教程 code.js-code.com

大佬教程收集整理的这篇文章主要介绍了php – Symfony2 Propel Collection undefined offset：2，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我们使用propel和Symfony2形式创建了一个集合.我们可以毫无问题地保存表单,我们可以使用该集合添加第二个选项.如果我们然后保存然后尝试添加第3个集合,我们会收到以下错误：

Notice: Undefined offset: 2

堆栈跟踪

in src/app/MyBundle/Model/om/BaseLabelsLabelsLinesR_217_11845@apsQuery.php at @R_682_5450@1  

$cton0 = $this->getNewCriterion(LabelsLabelsLinesR_217_11845@apsPeer::ID,$key[0],Criteria::EQUAL);
            $cton1 = $this->getNewCriterion(LabelsLabelsLinesR_217_11845@apsPeer::LABEL_ID,$keY[1],Criteria::EQUAL);
            $cton0->addAnd($cton1);
            $cton2 = $this->getNewCriterion(LabelsLabelsLinesR_217_11845@apsPeer::LABEL_LInes_ID,$keY[2],Criteria::EQUAL);
            $cton0->addAnd($cton2);
            $this->addOr($cton0);
        }

我已经在下面发布了相关代码,但是由于存在大量代码.我们想知道是否有人遇到过同样的问题.

我已经使用不同的代码发送了一个错误报告,这会产生相同的错误但是我没有得到回复.错误报告是here.

这是相关架构的片段：

<table name="labels_labels_lines_maps" isCrossRef="true">
    <column name="id"
            type="Integer"
            required="true"
            autoIncrement="true"
            primaryKey="true"/>
    <column name="label_id"
            type="Integer"
            primaryKey="true"/>
    <column name="label_lines_id"
            type="Integer"
            primaryKey="true"/>
    <foreign-key foreignTable="labels" ondelete="cascade">
        <reference local="label_id" foreign="id"/>
    </foreign-key>
    <foreign-key foreignTable="labels_lines" ondelete="cascade">
        <reference local="label_lines_id" foreign="id"/>
    </foreign-key>
    <vendor type="mysql">
        <parameter name="ENGIne" value="InnoDB" />
        <parameter name="Charset" value="utf8" />
    </vendor>
</table>

<table name="labels_lines">
    <column name="id"
            type="Integer"
            required="true"
            autoIncrement="true"
            primaryKey="true"/>
    <column name="placeholder_text"
            type="varchar"
            size="150"/>
    <column name="font_id"
            type="Integer"/>
    <column name="font_size"
            type="Integer"/> 
    <column name="x_axis"
            type="Integer"/>  
    <column name="y_axis"
            type="Integer"/>
    <column name="width"
            type="Integer"/>      
    <column name="height"
            type="Integer"/>       
    <column name="colour"
            type="varchar"
            size="20"/>        
    <column name="angle"
            type="Integer"/> 
    <column name="is_volume"
            type="Boolean"/>
    <column name="is_percentage"
            type="Boolean"/>
    <column name="is_productof"
            type="Boolean"/>
    <column name="is_type"
            type="Boolean"/>
    <column name="is_occasion"
            type="Boolean"/>        
    <foreign-key foreignTable="font" ondelete="cascade">
        <reference local="font_id" foreign="id"/>
    </foreign-key>
    <vendor type="mysql">
        <parameter name="ENGIne" value="InnoDB" />
        <parameter name="Charset" value="utf8" />
    </vendor>
</table>

<table name="occasion">
    <column name="id"
            type="Integer"
            required="true"
            autoIncrement="true"
            primaryKey="true"/>
    <column name="occasion"
            type="varchar"
            size="200"/>

    <vendor type="mysql">
        <parameter name="ENGIne" value="InnoDB" />
        <parameter name="Charset" value="utf8" />
    </vendor>
</table>

<table name="font">
    <column name="id"
            type="Integer"
            required="true"
            autoIncrement="true"
            primaryKey="true"/>
    <column name="name"
            type="varchar"
            size="100"/>
    <column name="LOCATIOn"
            size="300"/>
    <vendor type="mysql">
        <parameter name="ENGIne" value="InnoDB" />
        <parameter name="Charset" value="utf8" />
    </vendor>
</table>

下面是视图(没有任何样式)：

{{ form_start(form) }}
{{ form_row(form._token) }}
<ul class="labelsliness list-group" data-prototype="{{ form_widget(form.labelsliness.vars.prototypE)|e }}">
                    {% for lines in form.labelsliness %}
                        <li>{{ form(lines) }}</li>
                    {% endfor %}
                </ul>

                {{ form_row(form.savE) }}

{{ form_end(form) }}

<script>
                    var $collectionHolder;

                    var $addLinesLink = $('<button class="add_line_link btn btn-priMary">Add a line</button>');
                    var $newLinkLi = $('<li></li>').append($addLinesLink);

                    $(document).ready(function(){
                       $collectionHolder = $('ul.labelsliness');

                       $collectionHolder.append($newLinkLi);

                       $collectionHolder.data('index',$collectionHolder.find(':input').length);

                       $addLinesLink.on('click',function(E) {
                          e.preventDefault();

                          addLineForm($collectionHolder,$newLinkLi);
                       });
                    });

                    function addLineForm($collectionHolder,$newLinkLi) {
                        var prototype = $collectionHolder.data('prototype');

                        var index = $collectionHolder.data('index');

                        var newForm = prototype.replace('/__name__/g',indeX);

                        $collectionHolder.data('index',index + 1);

                        var $newFormLi = $('<li></li>').append(newForm);

                        $newFormLi.append('<button class="remove-line btn btn-danger">Remove</button>');

                        $newLinkLi.before($newFormLi);

                        $('.remove-line').click(function(E){
                           e.preventDefault();

                           $(this).parent().remove();

                           return false;
                        });
                    }
                </script>

表格处理：

public function buildForm(FormBuilderInterface $builder,array $options)
    {
       $builder
               ->add("labelsliness","collection",array(
                   "type" => new LabelsLinesType(),"allow_add" => true,"allow_delete" => true,"by_reference" => false
               ))
               ->add("save","submit");
    }

    public function configureOptions(OptionsResolver $resolver)
    {
        $resolver->setDefaults(array(
            'data_class' => 'AJSharp\EPCBundle\Model\Labels',));
    }

    public function getName()
    {
        return "label_form";
    }

最后,下面是控制器.

public function editAction(request $request,$id = null)
    {

        $labels = LabelsQuery::create()->findPk($id);

        $form = $this->createForm(new EditLabelType(),$labels);

        $form->handlerequest($request);

        if ($form->isValid()) {

            $labels->save();
            return $this->redirect($this->generateUrl("_admin_labels"));
        }

        return $this->render("AppLabelBundle:Admin:edit.html.twig",array("form" => $form->createView()));
    }

解决方法

您的架构对我来说有点混乱.下面的这一位包括三个主键,其中两个作为外键,其中一个作为行的唯一标识符：

<table name="labels_labels_lines_maps" isCrossRef="true">
    <column name="id"
            type="Integer"
            required="true"
            autoIncrement="true"
            primaryKey="true"/>
    <column name="label_id"
            type="Integer"
            primaryKey="true"/>
    <column name="label_lines_id"
            type="Integer"
            primaryKey="true"/>
    <foreign-key foreignTable="labels" ondelete="cascade">
        <reference local="label_id" foreign="id"/>
    </foreign-key>
    <foreign-key foreignTable="labels_lines" ondelete="cascade">
        <reference local="label_lines_id" foreign="id"/>
    </foreign-key>
    <vendor type="mysql">
        <parameter name="ENGIne" value="InnoDB" />
        <parameter name="Charset" value="utf8" />
    </vendor>
</table>