Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I advise against creating multiple controller directories. Controller logic will most likely be the same for a large portion of your site. You can create separate functions in the controller for when the mobile and desktop versions diverge. </p> <p>First, I recommend making all controllers inherit from a custom controller. See Phil Sturgeon's post on <a href="http://philsturgeon.co.uk/blog/2010/02/CodeIgniter-base-Classes-Keeping-it-DRY" rel="nofollow noreferrer">Keeping It Dry</a>. Once this is implemented, you can check whether the request comes from mobile or desktop in this custom 'mother' controller and all descendent controllers will know about it. Use <a href="http://codeigniter.com/user_guide/libraries/user_agent.html" rel="nofollow noreferrer">CodeIgniter's native</a> <code>$this-&gt;agent-&gt;is_mobile()</code>:</p> <pre><code>class MY_Controller extends CI_Controller{ function __construct(){ parent::__construct(); $this-&gt;data['agent'] = ($this-&gt;agent-&gt;is_mobile())? 'mobile' : 'desktop'; $this-&gt;load-&gt;vars($this-&gt;data); } } </code></pre> <p>It's your presentation that will change, Not your controllers. Now that you know the origin (agent) of the request, you can render the appropriate content:</p> <p>Create two directories in your <code>views</code> directory.</p> <pre><code>views desktop mobile </code></pre> <p>And when calling your views:</p> <p><code>$this-&gt;load-&gt;view($this-&gt;data['agent'] . "/theview");</code></p> <p>Regarding the ajax requests you mentioned in a comment -- you can check for those using <a href="http://codeigniter.com/user_guide/libraries/input.html" rel="nofollow noreferrer">CodeIgniter's native</a> <code>$this-&gt;input-&gt;is_ajax_request()</code> function. When users click links or buttons on your site and a controller is fired, whether on mobile or desktop, they will often share similar functionality (database writes for example)... but you can use the <code>is_ajax_request()</code> function to diverge and provide a response that suits the platform.</p> <p>Recommend checking out <a href="https://stackoverflow.com/a/9540985/568884">my answer</a> to another StackOverflow question on view structure for more information.</p> <p>Hope this helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POChange CodeIgniter controllers directory depending on url
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USJordan Arseno
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POChange CodeIgniter controllers directory depending on url
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COYou answer is awesome Jordan, thank you so much! I will accept it of course! I have a 2 questions if you can help me: On the mobile site, if I want to put a link to show the desktop version, the best practice would be session in that custom controller right? And also, to manage images and CSS, is there a best practice regarding this case? I truly appreciate your help and helpful response, thank you again!
      singulars
      1. PO
      1. USJeff B.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload