CodeIgniter Forums

possible mistype

2012-02-12T08:20:28+00:00

on this page
http://codeigniter.com/user_guide/libraries/file_uploading.html

scroll down to the title “the Controller”
look at this code , i think $this->upload->do_upload() inside of the do_upload() function may be a mistype and it trows an error for me.

function do_upload()
 {
  $config['upload_path'] = './uploads/';
  $config['allowed_types'] = 'gif|jpg|png';
  $config['max_size'] = '100';
  $config['max_width']  = '1024';
  $config['max_height']  = '768';

  $this->load->library('upload', $config);

  if ( ! $this->upload->do_upload())
  {
   $error = array('error' => $this->upload->display_errors());

   $this->load->view('upload_form', $error);
  }
  else
  {
   $data = array('upload_data' => $this->upload->data());

   $this->load->view('upload_success', $data);
  }
 } 

Gravatars

2012-02-11T16:42:08+00:00

Nice!

Subquery does not show up in statement

2012-02-09T23:37:34+00:00

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:25+00:00

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:13+00:00

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:06+00:00

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

French localisation unavailable

2012-02-07T17:00:13+00:00

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:23+00:00

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:14+00:00

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

Editing wiki articles

2012-01-19T02:42:39+00:00

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