CodeIgniter Forums

How to stop execution of a script midway ?

2010-03-19T17:35:11-06:00

I had a question about abruptly stopping script execution using die() and also displaying content before ‘dying’

class MyClass extends Controller {
 
     function doThis()
     {
         $this->mylibrary->checkIfExists();
         // some code 
         // some more code
     }

} 

And in the mylibrary i were to write

class Mylibrary
{
   function checkIfExists()
    {
        echo "something something";
        die();
    }
} 

nothing shows up on the screen. Anyway i can output the content on the screen and STOP script execution in the library itself without executing the //some code and //somemorecode lines ?

Loading models in helpers.

2010-03-20T01:54:25-06:00

I want to load a model in helper, but I have recursive function and it loads the model 100 times again and again if I load that page. How can I take the loading out of mu funcion.

My helper:

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
function get_main_category($category_id) {
    $CI = get_instance();
    $CI->load->model('categories_model');
    static $category, $up_category;
    //get category
    $category = $CI->categories_model->get_category($category_id);
    //get upper level category
    $up_category = $CI->categories_model->get_category($category->parent_id);
    //if upper category parent_id is 0, return category name
    if(empty($up_category->parent_id))
        return $category->name;
    //if upper category parent_id isn't 0, return get_main_category($category->parent_id)
    else
        return get_main_category($category->parent_id);
}

/* End of file categories_helper.php */
/* Location: ./system/application/helpers/categories_helper.php */ 

Preventing CMS Code Theft

2010-03-19T06:09:06-06:00

I’m in the process of developing a CMS. Once complete I would like to offer my application as either:

1) A hosted solution
2) A solution hosted by the clients themselves

What is the best way to prevent clients with PHP knowledge from taking my codebase and modifying/rebranding it, then selling it on as ‘their own’?

How could one prevent this from happening? Encryption springs to mind but I’m not a fan! Are there any other methods one can use to prevent clients/users with PHP knowledge from sealing all my hard work?

Captcha Plugin Manual

2010-02-25T23:13:34-06:00

CodeIgniter needs to add a page for using the built-in captcha plugin in the user guide. There aren’t many even halfway decent tutorials on using this feature so it makes it almost useless.

Advanced MySQL Question - Retrieving Similar Items Based on Tags

2010-03-19T10:35:47-06:00

I have products on my website and I show similar items based on the tags for those products. The problem is, the larger the database gets the more of a bottleneck query this becomes. Right now it sorts the results by items having the most matching tags as being most relevant. Does anyone know how to fix this query so it is more scalable? Is there an easy fix that I’m not seeing? The query and tag table structures are below:

SELECT distinct item_id, count(*) as matches
FROM (item_tags)
WHERE tag_id IN ('11196', '18447', '10479', '10003', '10010', '11197', '10080', '13401', '10059', '18790', '11123', '17837', '18435', '18428', '16590', '11875', '16566', '12514', '11553', '11210', '12751', '13225', '10019', '22981', '11388', '14425', '10270', '14278', '18455', '13895', '10860', '10844', '13183', '18022', '10023', '11206', '19271', '18444', '12362', '10071', '10069') 
AND `item_id` != "125400"
GROUP BY item_id
ORDER BY matches desc, item_id desc
LIMIT 10 

mysql> describe tags;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| id    | int(11)      | NO   | PRI | NULL    | auto_increment | 
| tag   | varchar(255) | YES  | UNI | NULL    |                | 
| count | int(11)      | YES  |     | 1       |                | 
+-------+--------------+------+-----+---------+----------------+ 

and…

mysql> describe item_tags;
+---------+---------+------+-----+---------+----------------+
| Field   | Type    | Null | Key | Default | Extra          |
+---------+---------+------+-----+---------+----------------+
| id      | int(11) | NO   | PRI | NULL    | auto_increment | 
| item_id | int(11) | YES  | MUL | NULL    |                | 
| tag_id  | int(11) | YES  | MUL | NULL    |                | 
+---------+---------+------+-----+---------+----------------+ 

item_tags indexes:

mysql> show indexes from item_tags;
+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table     | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| item_tags |          0 | PRIMARY          |            1 | id          | A         |     3803470 |     NULL | NULL   |      | BTREE      |         | 
| item_tags |          1 | index_items      |            1 | item_id     | A         |      118858 |     NULL | NULL   | YES  | BTREE      |         | 
| item_tags |          1 | index_items_tags |            1 | tag_id      | A         |       52102 |     NULL | NULL   | YES  | BTREE      |         | 
| item_tags |          1 | index_items_tags |            2 | item_id     | A         |     3803470 |     NULL | NULL   | YES  | BTREE      |         | 
| item_tags |          1 | index_tags       |            1 | tag_id      | A         |       52102 |     NULL | NULL   | YES  | BTREE      |         | 
+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 

The query takes from 1-3 seconds consistently in the codeigniter profiler and ties up system resources while processing. It can really bring our server to a crawl especially with high traffic! Can anyone help? Thanks!

Problems with the CI Twitter API Library

2010-03-15T16:25:58-06:00

Hi all

I use the library of Elliot Haughig (http://www.haughin.com/code/twitter) and now I can’t update my twitter status with this class

My Code:

$this->twitter->call(‘statuses/update’, array(‘status’ => “test-tweet”));

reading the timeline or other requests aren’t a problem but updating the status gives me back an error:

Incorrect signature

Can someone help me? I wrote an E-Mail to Elliot but he doesn’t answer.

Thank you

Is loading libraries within models a good idea?

2010-03-19T06:35:15-06:00

I’m using a customly created MySQL input-sanitizer library in one of my controllers, which makes a mess, using it in the model would be much easier, but I don’t wan’t to defy any best-practice principles out there either. So is it a good idea?

Having Trouble Using A URL As A Parameter

2010-03-19T16:39:15-06:00

Is it possible to use the URI segment method when you are trying to want a parameter to be a url? Or does the path need to use query strings? Or something I’m missing? What do folks recommend?

Would be nice to have something like this:

http://example.com/some_class_name/some_function_name/http://somesite.com/something!23.xml

But I get an Apache 404 error, which, by the way, seems to prematurely decodes the url parameter:

“The requested URL /some_class_name/some_function_name/http://somesite.com/something/2123.xml was not found on this server.”

Thanks for any help!

iScaffold v1.1 - CRUD Generator

2009-05-01T12:46:57-06:00

Hello friends,

This tool will generate the Controller Model and View from a given table.
I tried to be as generic as possible so this should work for everybody.

This is an updated release, it should work out of the box. Just put it into your htdocs/www
directory and configure the database.php file.

Info
1. After you download extract the content to your htdocs directory.
2. Change the config/database.php and enter the details of the database,
you want to generate.
3. Generate the code with the app.
4. Your code is ready at /output

If you want to change the output or put your styling in it, you have to
change the files located at /templates directory to fit it your own needs.

Have fun!
- Ömür & Yorick

Download
iScaffold v1.1 - Download
iScaffold @ Goole Code

Feel free to report issues our your feature requests in the google code project page too.
Issue/Feature request

ExpressionEngine 2.0 Public Beta Released !!!

2009-12-05T01:03:54-06:00

So this is exciting. Wait, wait and wait is finally over now. Got to see the thing I have been waiting for long, ever since the first talks about it. I am already download the PB 1 and will be looking at the code base first to have a peek into how Codeigniter 2.0 will look like . This is going to be the day when either I will have to go the whole new way with PHP from here on or look at it the old way. Maybe as expected it will allow me do things better.

Hope for the best.

Expression Engine 2.0 Public Beta