CodeIgniter Forums

multiple inserts into the db

2008-05-13T12:18:27-06:00

Hello all

I’ve got a pretty heavy system working at the minute that uses linking tables.

Now when i’m inserting data into the database i have to then add data into the linking tables.

Say for example i have this set up

MySQL tables

cms_colour
id (pk)
title
swatch

cms_item
id (pk)
title
dscpn

and the linking table

cms_item_colour
item_id (fk)
colour_id (fk)

Everytime i add an item i have to loop through post array and insert the keys into the linking table (cms_item_colour)

I use to do it like this using a custom function in my old none CI system

bare in mind that this is old code but it worked really well

function sqlMulitInsertTwo($table_name, $fk1, $fk2, $primaryKey, $array){
    global $connector;
    $insert = 'INSERT INTO '.$table_name.' ('.$fk1.', '.$fk2.') VALUES ';
    $numberOf = count($array)-1;
    for ($count = 0; $count <= $numberOf; $count++ ){
        $insert .= '(''.$primaryKey.'', ''.$array[$count].'')';
        if($count != ($numberOf)){
            $insert .=',';
        }
    }
    //return true if success false if failure.
    if ($result = $connector->query($insert)){
        return true;
    }else{
        return false;
    }
}

Can this be done using active records or is it best to make it a normal query?

instead of

function addColourToItem($id, $colour)
    {
    $this->db->where('item_id', $id);
    $this->db->delete($this->_item_colour);
    if(!empty($colour))
    {
    foreach($colour as $key=>$value)
    {
    $update = array('colour_id' => $value, 'item_id' => $id);
    $this->db->insert($this->_item_colour, $update);
    }
    }
    }

From what i have read its best to let SQL do the work as thats what its best for.

Any ideas or advice as i really need to clean up my system bit by bit

Cheers

HTML Emails and Yahoo

2008-07-19T19:36:39-06:00

Howdy,

When I send out an HTML email using the built in CI class, in Yahoo the first top of it gets cut off, while the rest is not shown in the email.

I can echo the message out fine and made sure no HTML errors are in my code, but when I send it off and check with Yahoo, only about the top portion gets shown.

Any ideas?

Thanks,
Adam

@$variablename or @$array_name[0] what does @ means???

2008-07-19T04:52:59-06:00

what is the function of @in @$variable_name ?

Organizing the Application Controllers

2008-07-19T23:20:09-06:00

Organizing the applications directory into the default:

APPDIR
->controllers
-->module1
-->module2
-->module3
->models
-->module1
-->module2
-->module3
->views
-->module1
-->module2
-->module3

is more messy in large projects than:

APPDIR
->modules
-->module1
---->controllers
---->models
---->views
-->module2
---->controllers
---->models
---->views
-->module3
---->controllers
---->models
---->views

How can I expect to build a simple drop-in-place “posts” module or “twitter feed” module if the code and views are spread around in different folders? I want to propose a re-write of the codeigniter.php file to something more like this that will allow users to build there site either way.

<?php

//...


// Load the local application controller
// Note: The Router class automatically validates the controller path.  If this include fails it 
// means that the default controller in the Routes.php file is not resolving to something valid.


/* CHANGED!!!!
if ( ! file_exists(APPPATH.'controllers/'.$RTR->fetch_directory().$RTR->fetch_class().EXT))
{
    show_error('Unable to load your default controller.  Please make sure the controller specified in your Routes.php file is valid.');
}

include(APPPATH.'controllers/'.$RTR->fetch_directory().$RTR->fetch_class().EXT);
*/


//If the structure is module based
if (file_exists(APPPATH.'modules/'. $RTR->fetch_module(). '/controllers/'
    . $RTR->fetch_directory(). $RTR->fetch_class().EXT)) {
    
    include(APPPATH. 'modules/'. $RTR->fetch_module(). '/controllers/'
        . $RTR->fetch_directory().$RTR->fetch_class().EXT);

//Else it must be the default CI structure
} else {
    if (!file_exists(APPPATH.'controllers/'.$RTR->fetch_directory().$RTR->fetch_class().EXT)) {
    //show_error('Unable to load your default controller.  Please make sure the controller specified in your Routes.php file is valid.');
        show_error('Unable to load the '. $RTR->fetch_class(). ' controller. '
        . 'Please make sure the controller specified in your Routes.php file is valid.');
    }
    include(APPPATH.'controllers/'.$RTR->fetch_directory().$RTR->fetch_class().EXT);
}

//...

?>

Does anyone else think this is a better way to organize the system?

XSS attack from Exceptions Lib?

2008-07-19T22:35:13-06:00

I modified the Exceptions Lib to protect the user from XSS. However, I am not sure if this is necessary. Is the var $page ever composed from URL chars that are not cleaned?

If the values that make $page are just pulled from the URL path - this means that someone could send someone to site.com/path/[removed]xssattack[removed] and use it for a CSFR/XSS.

<?php
class MY_Exceptions extends CI_Exceptions {
    
    /**
     * Constructor
     *
     */    
    function MY_Exceptions(){
        parent::CI_Exceptions();
    }

    /**
     * 404 Page Not Found Handler
     *
     * @access    private
     * @param    string
     * @return    string
     */
    function show_404($page = '') {    
        //Make the $page name XSS safe
        parent::show_404(htmlentities($page, ENT_QUOTES, 'UTF-8'));
    }

}
?>

HowTo: Array/multiple words in POST that goes to a searchfunction

2008-07-19T19:00:06-06:00

Hello CI community,

I am hoping that someone can point me in the right direction here. I have my paginated search class working properly when searching for 1 word. However, when I attempt to search for more than 1 word, it all goes to hell and it throws back an invalid/empty search.

Here is the code:

CONTROLLER:

function index()

    {

        $data['title'] = "Arcade Cow Better Search";

        if ($this->input->post('keyword') != '') {

            $keyword = $this->input->xss_clean($this->input->post('keyword'));

            $keyword = trim($keyword);

        }

        else {

            $keyword = $this->uri->segment(2);

            if(explode("-", $keyword) != FALSE) {

                $keyword_pieces = explode("-", $keyword);

                $keyword = implode(" ", $keyword_pieces);

            }    

        }

        $data['count_results'] = $this->mdl_search->countResults($keyword);

        $this->load->library('pagination');

        $config['base_url'] = site_url('search/' . url_title($keyword));

        $config['total_rows'] = $data['count_results'];

        $config['uri_segment'] = '3';

        $config['per_page'] = '10';

        $this->pagination->initialize($config);

        $offset = $this->uri->segment(3);

        $data['search_results'] = $this->mdl_search->getSearchResults($keyword, $config['per_page'], $offset);

        $this->load->view('arcade/header');

        $this->load->view('arcade/search', $data);

        $this->load->view('arcade/footer');

    }

Currently, the variable is passed via post to the search controller and once it goes into pagination it is stored in the url for retrieval later.

MODEL:

class mdl_search extends Model {

    function mdl_search()

    {

        parent::Model();

    }

    function getSearchResults ($keyword, $limit, $offset)

    {

        if($keyword != ''){

            $this->db->like('name', $keyword);

            $this->db->or_like('desc', $keyword);

            $this->db->or_like('cat', $keyword);

            $this->db->or_like('instructions', $keyword);

            $this->db->orderby('name', 'ASC');

            $result = $this->db->get('games',  $limit, $offset);

            $output = $result->result_array();

            return $output;

        }

        else { return 0; }

    }

    function countResults ($keyword){

        $this->db->like('name', $keyword);

        $this->db->or_like('desc', $keyword);

        $this->db->or_like('cat', $keyword);

        $this->db->or_like('instructions', $keyword);

        $this->db->orderby('name', 'ASC');

        $this->db->from('games');

        $query = $this->db->count_all_results();

        return $query;

    }

}

?>

VIEW:

<div class="standard">

    <div class="search-container">

        <?php if(isset($search_results) && !empty($search_results)) { ?>

            <h2><?= $title;?></h2>

            <div class="search-pagination"><?php echo $this->pagination->create_links(); ?></div>

            <table class="search-results">

                    <tr class="headerRow">

                        <th class="gameTitle"><a href="#"><span>Game Title</span></a></th>

                        <th class="active"><a href="#"><span>Players</span></a></th>

                        <th><a href="#"><span>Rating</span></a></th>

                        <th><a href="#"><span>Reviews</span></a></th>

                        <th><a href="#"><span>Play Type</span></a></th>

                    </tr>

                        <? foreach ($search_results as $search_result): ?>

                            <tr class="alt">

                                <td class="title"><a href="#"><img src="<?php echo base_url() ?>images/img/<?php echo $search_result['nameid'];?>.png" alt="<?php echo $search_result['name'];?>" width="60" height="50"></a><div class="fltLft"><a href="#"><?php echo $search_result['name'];?></a><br /><?php echo $search_result['desc'];?></div></td>

                                <td class="players">1,262</td>

                                <td class="ratings"><b>5.00</b><br />out of 5.0</td>

                                <td class="reviews"><span class="up">72%</span><br />491 reviews</td>

                                <td><a href="#" class="btnSearchPlayNow clearLink">play now</a><a href="/servlet/DownloadEcommTracker?sku=texttwist&promoCode=SearchList" class="#">download</a></td>

                            </tr>

                        <? endforeach; ?>

            </table>

        <?php } else { 

            ?>

            <h3>You didn't enter a search result, please re-renter.</h3>

<p><?php 

            //keeping this here for testing right now.

            print_r($_POST); ?></p>

        <?php } 

        ?>

    </div>

</div>

Wierd URL dissapearing[resolved]

2008-07-19T16:57:56-06:00

Hey guys,

I am making a form in CI. This form action works in the other CI application I made but for some reason, in the new one, the url disappears.


<?=form_open('admin/city/insert', array('class' => 'listForm')); ?>

That is the form code.

When the form is submitted, the url becomes “index.php/city”. There is now “index.php/admin/city/insert”. I do not know how to trouble shoot for this. There are no errors and I do not understand this redirect.

SOLVED:

MY URI CONFIGURATIONS WERE INCORRECT

How to load a view for the error page?

2008-06-07T21:57:58-06:00

Hi, I’m new to CI. I’m very impressed so far but have a question - could anyone help out?

I want error messages from my site to appear as messages in one of my normal views, rather than as hard-coded messages from the /errors folder. Is there a way to load a view within/instead of an error message?

Thanks.

URL Forwarding and CodeIgniter

2008-07-19T13:32:03-06:00

I need to forward a web address like this:


http://homesite.com/some_text

to this


http://homesite.com/CI_class/CI_function/more_data

At first I thought to use .htaccess rewrites, however the list of possible values of some_text will be growing/changing/shrinking. That means I would need to regenerate .htaccess every time the list of some_text changes, which does not seem appealing. Does anyone have any ideas?

Using an multidimensional array in a language file

2008-07-19T14:08:35-06:00

Hello,

I have pulldownitem in my form and would like to translate the values coming from the database. My database looks like this:

#id        #country
1        abc
2        def
3        ghi
4        jkl

Now I would like to create a language file which translates the countrynames, something like this:

$lang['language_abc'] = 'translation of abc';
$lang['language_def'] = 'translation of def';
$lang['language_ghi'] = 'translation of ghi';
$lang['languge_jkl'] = 'translation of jkl';

This is my first project with Codeigniter and I have no idea if this is possible or if I have to customize the language library. Maybe you know a solution for this? (My suggestion doesn’t seem to work).

Thanks,
Daniel