CodeIgniter Forums

Subquery does not show up in statement

2012-02-09T23:37:34Z

You have created something that should be part of the core, I think. But unfortunately it doesn’t work (yet) for me.

What I try to achieve is in the comment in the code piece below.

/** 
    SELECT * FROM `t_ingredient` WHERE `RECIPE_ID` NOT IN (SELECT `RECIPE_ID` FROM `t_recipe`)
    **/
    
    $this->db->select('*');
    $this->db->from('t_ingredient');
    $sub = $this->subquery->start_subquery('where_in');
      $sub->select('RECIPE_ID');
      $sub->from('t_recipe');
    $this->subquery->end_subquery('RECIPE_ID', FALSE);
    $result = $this->db->get();
    log_message("info", $this->db->last_query()); 

What I get in my log file is:


SELECT * FROM (`t_ingredient`)

So basically the sub query is not put in place. I have upgraded to the latest development release (EllisLab-CodeIgniter-v2.1.0-917-g0209c70) of CodeIgniter to make sure everything would work. Given that the system does not complain about $this->subquery I also think I have installed Subquery correctly.

Any suggestions as to the cause of this (not) happening?

Added to original post:
Why didn’t this post show up in the article’s discussion? I am quite new aren’t I?

Anyway, the following works:

/**SELECT * FROM `t_ingredient` WHERE `RECIPE_ID` NOT IN (SELECT `RECIPE_ID` FROM `t_recipe`)
    **/
    
    $this->db->select('*');
    $this->subquery->defaultDB($this->db);
    $sub = $this->subquery->start_subquery('where_in');
      $sub->select('RECIPE_ID');
      $sub->from(`t_recipe`);
    $this->subquery->end_subquery('RECIPE_ID', FALSE);
    $result = $this->db->get(`t_ingredient`);
    log_message('debug', __METHOD__." last query=".$this->db->last_query()); 

See the difference? The move of tablename from to get is probably not the most important impovement.
Subquery assumes that it can take $this->db as a default database, however for some reason there is a mismatch between what subquery assumes is the default and what the object itself thinks is the default database. I found the difference by tracking $this->db->conn_id throughout my code. I am unit testing my code, so I create a lot of instances of the class. Although the object creates new connections with every instantiation, subquery still uses the original one.


$this->subquery->defaultDB($this->db);

solved the problem.
Now I have to find out why this class creates new connections all the time. How are my other classes doing? I like unit testing.

SimpleTester - Unit testing library

2012-02-09T18:33:25Z

Following the instructions in this article doesn’t work. I suspect the simpletester1.1.zip is out of sync with the framework. Everything’s fine until step 6, when you add “simpletester” to the list of libraries that are autoloaded. As soon as you do that, visiting any page simply results in:

Fatal error: Class 'GroupTest' not found in /path/to/app/application/libraries/simpletester.php on line 84 

Grepping through the code for GroupTest you’ll only see it referenced in comments, and in a readme file which states the following:

The GroupTest has been renamed TestSuite (see below). It was removed completely in 1.1 in favour of this name.

If you try modifying line 84 to replace GroupTest with TestSuite, it still won’t work, this time erroring out with:

Fatal error: Call to undefined method TestSuite::addTestFile() in /path/to/app/application/libraries/simpletester.php on line 96 

kaptcha ajax jquery block

2012-02-09T07:51:13Z

hi there, i have a problem about validating form which has a kaptcha fields. everytime i validate the kaptcha, it return false, but everything’s oke when i commented out the form_validation for the kaptcha.

here’s the generated form code

<form action="http://localhost/eqci/site/send" method="post" accept-charset="utf-8" class="form">
<table>
   <tr>
     <td colspan="2"><input type="text" name="name" id="name" placeholder="Name"/>td>
   tr>
   <tr>
     <td colspan="2">
     <label for="kaptcha">
     <span>*span> Math question: <span id="kaptcha_question">9 + 9 = span>label>

     <input type="text" name="kaptcha" id="kaptcha" maxlength="5" />
     <input type="hidden" name="kaptcha_answer" id="kaptcha_answer" 
value="/3qnGe/nm3MyJymvWygUJGH+yciCkcKJP5Q6P6JcjVxjV/WeRcKQIlzbZWhZNxMjJ1tfo1L90Meffs3rIxn3ww==" /> 
     td>
   tr>
   <tr>
     <td><input type="submit" value="Send"/>td>
     <td><input type="reset" value="Clear"/>td>
   tr>
form> 

here’s the javscript to send ajax

var link = "/eqci/index.php";
    $("form.form").submit(function(){

        var name = $(this).find('input[name=name]').val();
        var kaptcha = $(this).find('input[id=kaptcha]').val();
        
        $.post(link + "site/send", { name: name, kaptcha: kaptcha, ajax: '1' },  
                function(data){
                    if(data == 'true'){  
                        $.growlUI("","thanks for your concern, we'll be in touch");
                        $.blockUI({ 
                            message: $('div.growlUI'), 
                            fadeIn: 300, 
                            fadeOut: 500, 
                            timeout: 1000, 
                            showOverlay: false, 
                            centerY: true,
                            centerX: true, 
                            css: { 
                                width: '350px', 
                                margin: '10px auto',
                                border: '3px solid white', 
                                padding: '5px', 
                                backgroundColor: '#000', 
                                'border-radius': '10px', 
                                '-webkit-border-radius': '10px', 
                                '-moz-border-radius': '10px', 
                                opacity: .8, 
                                color: '#ffffff' 
                            } 
                        }); 
                        
                    }else if(data=='false'){  
                        $.growlUI("","some fields not filled correctly");
                        $.blockUI({ 
                            message: $('div.growlUI'), 
                            fadeIn: 300, 
                            fadeOut: 500, 
                            timeout: 1000, 
                            showOverlay: false, 
                            centerY: true,
                            centerX: true, 
                            css: { 
                                width: '350px', 
                                margin: '10px auto',
                                border: '3px solid white', 
                                padding: '5px', 
                                backgroundColor: '#000', 
                                'border-radius': '10px', 
                                '-webkit-border-radius': '10px', 
                                '-moz-border-radius': '10px', 
                                opacity: .8, 
                                color: '#ffffff' 
                            } 
                        });
                        else{
                            alert"gagal";
                        } 
                    } 
             }); 
        return false; //stop browser load the aim page
    }); 

and the controller

function send()
 {
  $this->load->library('form_validation'); 
  $this->form_validation->set_rules('name', 'Name','trim|required|alpha_numeric|min_length[6]');
  $this->form_validation->set_rules('kaptcha', 'Math Question', 'trim|required|is_numeric|kaptcha');
  if ($this->form_validation->run() ==  false){
   
   //redirect("site");
   echo 'false';
   

  }
  else{
   echo 'true'; 
  }
  
 } 

my code keep gives me false return, is there something wrong in my controller??

what is the use of wiki article?

2012-02-08T10:33:06Z

can anyone explain me what are the advantages of wiki article submissions? Is that reaally helpful?

French localisation unavailable

2012-02-07T17:00:13Z

Hi,

When I go to this page,

http://codeigniter.com/wiki/French

I click on the link Version v2.1.0 or any other version. There is an error message : Not found.

Regards,

Xavier

Database Migrations in CodeIgniter

2012-02-05T09:21:23Z

Migrations is a simple utility inspired by its Ruby on Rails counterpart that makes working with database changes a lot easier to development teams.
The concept is really simple: abstract each change to your database schema to a “migration” class in a way that other team members can apply (and undo) each change easily.
Common usage
* Each individual in a team is suposedly working on their own installation of your system.
* Whenever a team member makes a change to their database schema, he extracts that change into a class called a “migration”.
* When he is done working, he can move those “changes” to any other environment (the “live” environment, for example) and “install” each migration
Installation
Download and unzip the package: File:migrations.1.0.zip
Move its contents to your application folder.
A Database Utilities helper is included to make your migrations code a lot cleaner.
Edit config/migrations.php file in order to enable migrations and setting your migrations path.
Note: It is recommended that migrations are disabled on your live environment when you are not migrating your schema. It is intended to add further security measures in future realeses.
Note 2: Your migrations path should be write-enabled.

Codeigniter is a very efficient framework for developing webapplicatoin

2012-02-05T05:20:14Z

Codeigniter is wonderful framework for developing a web application with efficient and security in the web desingn.

Editing wiki articles

2012-01-19T02:42:39Z

Hello!

How to get the rights to edit the wiki?

I translated new User Guide and language files for 2.1.0 into russian: http://cidocs.ru/

It would be nice to place links to new localized materials on that page: http://codeigniter.com/wiki/Russian

Not work

2012-01-17T17:25:31Z

this dont work to me, can you help me?.

i dont see, where we configured the helper and where we interacted whit hem.

I dont speak much english … sorry for my french

thanks

template->build() causees ss; error for mysite

2012-01-17T05:43:01Z

Hi
I have downloaded the template library from the github it is in modular structure.

I am loading the template using template->build() it causes the ssl error in in IE but if it is placed in views and using load->view() it is not showing ssl error.