EllisLab Community Forums

how can i call this template for created table from another file

2013-05-24T06:03:34-05:00

<?php
$tmpl = array ('table_open'=> '<table  border="0" cellpadding="0" cellspacing="1">',

                    'heading_row_start'   => '<tr>',
                    'heading_row_end'     => '</tr>',
                    'heading_cell_start'  => '<th>',
                    'heading_cell_end'    => '</th>',

                    'row_start'           => '<tr>',
                    'row_end'             => '</tr>',
                    'cell_start'          => '<td>',
                    'cell_end'            => '</td>',

                    'row_alt_start'       => '<tr>',
                    'row_alt_end'         => '</tr>',
                    'cell_alt_start'      => '<td>',
                    'cell_alt_end'        => '</td>',

                    'table_close'         => '</table>'
              );
  



   
$this->table->set_template($tmpl);

$dtable = $this->db->query('select * from sys_users');

echo $this->table->generate($dtable);

?> 

how can i call $tmpl from another file ?

Thanksss

Retain values for comment form

2013-04-05T05:34:49-05:00

Hi!

I have a problem with the comment form on a page I’m actually working on. After submittting a incorrect comment form (empty email) I get the normal error page. Then I click on the “return to the last page”-button to fill out the missing email field. Unfortunately the other information I made (name and comment) are not prefilled in the form.

Does anybody has a clue to fix this problem?

Best regards and thanks for your help.

Ion Auth - User groups in users table instead

2013-05-23T17:46:46-05:00

Hi. I would like to know if anyone else has tryed moving the user group from the users_groups table into the users table. I only want a user to be able to belong to one group, so i see no need to store it in a seperate table.

So if someone has tryed, i would like to know if you had any complications, and if you can remember how much you had to change.

avoid escape $this->db->get();

2013-05-21T10:28:15-05:00

Hi,
i have a database with products. It contains: photo, name and a description of each product.
I need to print that in a view, i got results with:


$this->db->get("mytable");

But in description i need some newlines:

for example:
code: 003810391849.

product description 

I put a


<br />

in the description field, after “code: 003810391849.” but it doesn’t work: codeigniter escapes it and print code:


003810391849.<br /> product description

There is a way to put there a newline?

Thank You,
Luca

How can I write this query with Active Records?

2013-05-23T23:35:19-05:00

Hi;

I use this code to send dynamic data to model and run queries:

public function results_products($data, $record_start=0,$number_of_records=50)
  {
   $this->db->select('products_table.id, code, class, category, status, price, production_date, products_status.title AS STATUS');
   $this->db->from('products_table USE INDEX (PRIMARY)');
   $this->db->join('products_status', 'products_status.id = products_table.status');
   $this->db->order_by('products_table.id');
   $this->db->where('products_table.id >', $record_start);
   $this->db->where($data);
   $this->db->limit($number_of_records);
                 } 

Now I need to change my code to a nother query which I have a hard time writing with active records! I still want to send dynamic $data so the part in WHERE is different each time. How can I do that with active records? If I cant, how can I send dynamic $data to this query so the WHERE part is dynamic? Thanks
For example:

SELECT q2.id,
       q2.code,
       q2.class,
       q2.category,
       q4.title
FROM   (SELECT id,
               `code`,
               `class`,
               `category`,
               `status`,
               `price`,
               `production_date`
        FROM   products_table AS q1
        WHERE  q1.id > 0
               AND q1.class = 3
        ORDER  BY q1.id
        LIMIT  50) AS q2
       INNER JOIN products_table AS q3
               ON q3.id = q2.id
       JOIN `products_status` AS q4
         ON q4.id = `q3`.`status` 

Thanks

index.ph on url problem.

2013-05-22T23:10:26-05:00

i having a problem with the index.php on my url. when i removed it, it gives me an error of:

“Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7”

the code inside the .htaccess file located inside the application folder:
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php/$1 [L]

together using this htaccess i remove the index.php inside the config.php “$config[‘index_page’]”

and when i return the index.php. the connection of my css when reload using different function is not working. on homepage the css is working but when i test my code and reload again the login page the css is not working.
heres my controller function:
<?php
Class Administrator extends CI_Controller{
function index(){
$this->load->view(‘administrator_view’);
}
function validate_credentials(){
$this->load->model(‘administrator_model’);
$query = $this->administrator_model->validate();
if($query){
$data = array(
‘username’ => $this->input->post(‘username’),
‘is_logged_in’ => true
);
$this->session->set_userdata($data);
redirect(‘dashboard/home’);
}
else{
$this->index();
}
}
}
?>

thank you, im just a beginner using this framework. and sorry for my bad english

Redirecting predefined urls

2013-05-23T18:28:04-05:00

How would I redirect predefined urls which are


http://EnrollmentServer.mydomain.com/EnrollmentServer/Discovery.svc

to some method of default controller.

Compare data from two different tables using codeigniter

2013-05-23T16:05:09-05:00

I am new to codeigniter and I want to write this mySql query

SELECT COUNT(DISTINCT source) AS NumberOfEvaluations 
FROM COMMENT , EVALUATION
WHERE evaluation_id = EVALUATION.id AND EVALUATION.department_id = '$department_id' ; 

into codeigniter.
This is my try

$this->db->select('t1.count(DISTINCT(source))');  
   $this->db->from('comment t1');
   $this->db->join('evaluation t2', 't2.id = t1.evaluation_id', 'left');    

   $this->db->where();
  
 $query=$this->db->get();  
   return $query->num_rows(); 

Load views in Controller or Model?

2013-05-24T01:57:02-05:00

Yesterday i red a book where the writer advise to load a view inside a model. Then simply call the function in controller like to show the page:

$this->load->model('display');
$this->display->mainpage($data); 

The question is - which way is more proper, to load the views inside controller or model? In my opinion is quite interesting to build the view inside a model…

Member group permissions keep getting reset

2013-05-23T10:13:49-05:00

We have channel that we allow guests to post to via Safecracker - all works fine. However it would appear that every so often the permissions to post to the channel get reset to “NO” via the CMS, though we have not been anywhere near these options in the admin panel.

It looks like a wee bug in EE and I was wondering if anyone else had ever experienced this and if so - are there any fixes please?

Many thanks

Jonathan