delete from multiple tables datamapper codeigniter











up vote
0
down vote

favorite












I have a problem with the datamapper on codeigniter, i would like to delete all the records from 3 tables with the relation. Something like:



        $c = new Camp();
$c->where('id', $this->input->post('id'))->get();

$cf = new CF();
$cf->where('camp_id', $this->input->post('id'))->get();

$p = new Pro();
$p->where('camp_id', $this->input->post('id'))->get();

$c->delete(array($cf, $p->all));


This give me a problem, but if i do individually, adding a delete or delete_all after the where:



        $c = new Camp();
$c->where('id', $this->input->post('id'))->get();
$c->delete();

$cf = new CF();
$cf->where('camp_id', $this->input->post('id'))->get();
$cf->delete();

$p = new Pro();
$p->where('camp_id', $this->input->post('id'))->get();
$p->delete_all();


it not delete the records from the table, it just put as null the field camp_id where is more than a record, in this case, in the p->delete_all, and i would like to delete from the table. I could do with codeigniter, but i must do with the datamapper. Someone know how to do it?



Thanks.










share|improve this question




























    up vote
    0
    down vote

    favorite












    I have a problem with the datamapper on codeigniter, i would like to delete all the records from 3 tables with the relation. Something like:



            $c = new Camp();
    $c->where('id', $this->input->post('id'))->get();

    $cf = new CF();
    $cf->where('camp_id', $this->input->post('id'))->get();

    $p = new Pro();
    $p->where('camp_id', $this->input->post('id'))->get();

    $c->delete(array($cf, $p->all));


    This give me a problem, but if i do individually, adding a delete or delete_all after the where:



            $c = new Camp();
    $c->where('id', $this->input->post('id'))->get();
    $c->delete();

    $cf = new CF();
    $cf->where('camp_id', $this->input->post('id'))->get();
    $cf->delete();

    $p = new Pro();
    $p->where('camp_id', $this->input->post('id'))->get();
    $p->delete_all();


    it not delete the records from the table, it just put as null the field camp_id where is more than a record, in this case, in the p->delete_all, and i would like to delete from the table. I could do with codeigniter, but i must do with the datamapper. Someone know how to do it?



    Thanks.










    share|improve this question


























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have a problem with the datamapper on codeigniter, i would like to delete all the records from 3 tables with the relation. Something like:



              $c = new Camp();
      $c->where('id', $this->input->post('id'))->get();

      $cf = new CF();
      $cf->where('camp_id', $this->input->post('id'))->get();

      $p = new Pro();
      $p->where('camp_id', $this->input->post('id'))->get();

      $c->delete(array($cf, $p->all));


      This give me a problem, but if i do individually, adding a delete or delete_all after the where:



              $c = new Camp();
      $c->where('id', $this->input->post('id'))->get();
      $c->delete();

      $cf = new CF();
      $cf->where('camp_id', $this->input->post('id'))->get();
      $cf->delete();

      $p = new Pro();
      $p->where('camp_id', $this->input->post('id'))->get();
      $p->delete_all();


      it not delete the records from the table, it just put as null the field camp_id where is more than a record, in this case, in the p->delete_all, and i would like to delete from the table. I could do with codeigniter, but i must do with the datamapper. Someone know how to do it?



      Thanks.










      share|improve this question















      I have a problem with the datamapper on codeigniter, i would like to delete all the records from 3 tables with the relation. Something like:



              $c = new Camp();
      $c->where('id', $this->input->post('id'))->get();

      $cf = new CF();
      $cf->where('camp_id', $this->input->post('id'))->get();

      $p = new Pro();
      $p->where('camp_id', $this->input->post('id'))->get();

      $c->delete(array($cf, $p->all));


      This give me a problem, but if i do individually, adding a delete or delete_all after the where:



              $c = new Camp();
      $c->where('id', $this->input->post('id'))->get();
      $c->delete();

      $cf = new CF();
      $cf->where('camp_id', $this->input->post('id'))->get();
      $cf->delete();

      $p = new Pro();
      $p->where('camp_id', $this->input->post('id'))->get();
      $p->delete_all();


      it not delete the records from the table, it just put as null the field camp_id where is more than a record, in this case, in the p->delete_all, and i would like to delete from the table. I could do with codeigniter, but i must do with the datamapper. Someone know how to do it?



      Thanks.







      php codeigniter datamapper






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 7 at 12:29

























      asked Nov 7 at 7:53









      Imanol

      12




      12





























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53185388%2fdelete-from-multiple-tables-datamapper-codeigniter%23new-answer', 'question_page');
          }
          );

          Post as a guest





































          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















           

          draft saved


          draft discarded



















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53185388%2fdelete-from-multiple-tables-datamapper-codeigniter%23new-answer', 'question_page');
          }
          );

          Post as a guest




















































































          這個網誌中的熱門文章

          Xamarin.form Move up view when keyboard appear

          Post-Redirect-Get with Spring WebFlux and Thymeleaf

          Anylogic : not able to use stopDelay()