CodeIgniter Forums - Search Results

Pages (10): 1 2 3 4 5 … 10 Next »

Search Results

Thread: why is this code failing?
Post: RE: why is this code failing?

As error says it is a SYNTAX error. Remove quote character before $this

Thread: CI3, active record contain $offset,$limit
Post: RE: CI3, active record contain $offset,$limit

`$this->db->select('*') ->from('employee e') ->group_start() //this is not necessary, just added in case you will need in future. it will wrap query like statements in parentheses. there is also or_gr...

Thread: how to get logged_in session status in native php
Post: RE: how to get logged_in session status in native ...

Hi, This is the code I used in some of my project: update your CI index.php: PHP Code: -- //$system_path = 'system'; $system_path = dirname(__FILE__) . DIRECTORY_SEPARATOR . 'system'; //$applicati...

Thread: Cookies Misusing the Recommended “sameSite“ Attribute
Post: RE: Cookies Misusing the Recommended “sameSite“ At...

As far as I know it is not CI related issue. I similar issue in my website (CI v3). I use some embedded charts such as Google Trends which causes this issue because it does requests to another domain....

Thread: Delete with Join or Where_in not working
Post: RE: Delete with Join or Where_in not working

1. You should do inner join in this case instead of left join (unless $profile_id can be null). 2. In MySQL if you specifying alias for table name you should use alias in delete statement not a table ...

Thread: Transaction
Post: RE: Transaction

Error is not CI related, it is a general PHP error. Code: -- function control_record_of_user($id_record,$user_id){ $device = $this->get_Device($id_record) ;//get record //here ...

Thread: Deletes are not allowed unless they contain a "where" or "like" clause.
Post: RE: Deletes are not allowed unless they contain a ...

I am sorry :), I don't why I did not have look to your code, before answering. I never did delete with using QB, so I am not sure your code produces the right SQL code. try running Code: -- echo ...

Thread: Deletes are not allowed unless they contain a "where" or "like" clause.
Post: RE: Deletes are not allowed unless they contain a ...

I see it is hard coded in the system QB, you can either implement your custom QB and override delete method or implement your own method, or you can add dummy where $this->db->where('1=1', NULL, FAL...

Thread: csrf error
Post: RE: csrf error

pippuccio76 Wrote: (12-26-2019, 04:01 AM) -- The action you have requested is not allowed. -- The errors comes from system/libraries/Security.php, you can find it there if you search this error mes...

Thread: Halt execution on any error
Post: Halt execution on any error

Hi, I want to stop execution, whenever error occurs. Currently, for example, I have a variable undefined error, but script continues running after this line. Thanks in advance.

Thread: creating a form_validators for dates
Post: RE: creating a form_validators for dates

You can extend CI's Form_validation library and write your own method to validate dates https://www.codeigniter.com/user_guide/general/creating_libraries.html

Thread: How to get data from 2 related tables in the same controller?
Post: RE: How to get data from 2 related tables in the s...

PHP Code: -- $this->db->select('d.*, o.*') ->from('departments d') ->join('occupations o', 'o.department_id = d.department_id', 'LEFT') -- Simple join it is all you have to do, and you should l...

Thread: ->result() not showing all rows/data
Post: RE: ->result() not showing all rows/data

[quote pid='365920' dateline='1562724737'] PHP Code: -- foreach ($query as $value) { $this->db->where('category_lists_id', $value->category_lists_id); $querys = $this->db->get('cate...

Thread: Anchor setup wih a php echo
Post: RE: Anchor setup wih a php echo

You don't have to use CI's anchor function. Personally I don't use it. If you want to use it: PHP Code: -- echo anchor('news/local/123?id=' . , 'My News', array( 'title' => 'The best news!', 'cla...

Thread: query problem
Post: RE: query problem

[quote pid='365734' dateline='1562061900'] here's the error Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_codeignite.fb_usr.id_fb_us' which is not f...

Thread: Help- Session on Ajax
Post: RE: Help- Session on Ajax

Once I was given a cheap shared hosting, where customer asked me to deploy website. I got session errors in this hosting. I created ticket, then they solved it. I mean that this error might me...

Thread: i need to know the 2 kind of forms , which one is More functional ?
Post: RE: i need to know the 2 kind of forms , which one...

use form_open function mainly for the reason that has CSRF protection if you ever will need it. https://www.codeigniter.com/user_guide/libraries/security.html?highlight=csrf#id2 if in future y...

Thread: How to fix a Num_row error
Post: RE: How to fix a Num_row error

also remove semicolon: if($result->num_rows() > 0);{

Thread: Pagination problem, How I can remove the current page from right side ?
Post: RE: Pagination problem, How I can remove the curre...

it looks like it is a CSS styling problem not related to backend code. some styles given to .active class making it to display in this way

Thread: DB design help
Post: RE: DB design help

kilishan Wrote: (06-07-2019, 07:18 AM) -- You could have a customer table that has nullable user_id and [b]company_id[/id] columns. Fill in the one that's relevant and leave the other blank and build...