StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5739898
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2011-04-21T05:23:25.470
FavoriteCount
0
LastActivityDate
2011-04-21T05:23:25.470
LastEditDate
LastEditorUserId
0
OwnerUserId
317975
ParentId
5736609
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
Alright, let me see if I can break this down into pieces and help you out. Firstly It isn't clear the consistancy of your terminology, so I'm going to build a small glossary here so I am certain you understand what I mean: <ul> <li>Request Lifecycle The entirety of a HTTP Request through your application. Ajax calls are lifecycles, page loads are lifecycles, once the document is sent and the connection closed, the lifecycle ends.</li> <li>Controller Code reponsible for controlling a request lifecylce's execution through your website.</li> <li>View The actual output code for any page/request. This is the code in <code>application/views</code>, and is used practically every time there is a request lifecycle (except perhaps redirects & ajax).</li> <li>Client Code The Javascript logic happening once the page is loaded. Ajax calls are made by the client code.</li> </ul> I am going to answer your questions a little out of order, so bear with me: <hr> <blockquote> This brings forward my first, ridiculously simple, question. Is this okay? One of my main concerns is of course users who don't have javascript enabled; the application simply doesn't work. I have read about graceful degradation and progressive enhancement, but I'm just not sure if this application is do-able without JS. </blockquote> The fact of the matter is, Javascript is a pretty intrinsic part of what we call "Web Applications" now. The difference between a web application & a web site is that the former is intelligent. Most sites usually just process requests and display the relevant data, applications however usually make decisions, update the state of the system and modify the output based on the input. What you appear to be building I would classify as a web application. I do not believe in this day and age of HTML5 (kinda) with the facebooks & youtubes of today that it is unreasonable to require the use of javascript to use the web application. People who disable thier javascript these days do it through plugins like AdBlock & NoScript which usually allow you to selectively disable things. The best way to combat this is to seperate your javascript into easily recognizable components so users will know which scripts to allow. Example <ul> <li><code>Site.js</code> - Responsible for the site's function & operation.</li> <li><code>Ads.js</code> - Responsible for your advertisements</li> </ul> You can't stop people from blocking your ads, if you try they usually just wont use your service. (Assuming you plan on ads) So build your graceful degradation to inform your users that your application requires JavaScript to function, you can even let them know which files are required to help ease the process. <hr> <blockquote> The actual 'planner' page is a whole different story though. One of the first things I was wondering about is whether or not I can use/call functions from a view. If I follow the MVC guidelines, I would say I cannot. So what I'm doing now is stacking all the data in $data arrays in my controller and then echo'ing those out through jQuery AJAX calls, straight into my webpage. </blockquote> The key to remember is: MVC is a guideline not a rule. While it's best to stick to your system, you have to apply it where it's relevant. You probably shouldn't be pulling database records from your view but when presented with some out-of-the-box situations, it leaves you with two options: <ol> <li>Break the paradigm slightly where it makes sense (for a good reason)</li> <li>Refactor your system to accomidate the paradigm</li> </ol> A good example: Re-usable widget blocks like a tag-cloud or recent-posts block The bottom line is that you probably don't want to have to keep providing the data to <code>$this->load->vars(...)</code> or even worse in each <code>$this->load->view</code> in each controller function. One approach is to re-design your system so you have a common theme library responsible for collecting common information & providing it, then passing your view data (<code>$this->load->view("someview", array(),</code><code>true</code><code>)</code> will render your view to a string instead of the page). Another approach is to design a special view that has a simple job, using a model load the relevant data (Cache if you can) & display it. Like a widget, or self contained thing. This breaks MVC but you need to examine the reasons we use MVC. The key is that the view shouldn't be responsible for the implementation, this way you can swap out the view and the controller logic remains unchanged. Does that apply? this could be a highly view-implementation specific component, the controller may not know it needs this information. So if you keep a handle on it and mark it so you remember it's responsible for itself, you should be able to accommodate it just fine. <hr> <blockquote> Another thing I'm not sure about (AJAX-wise) is the fact that I have two different AJAX-calls on $(document).ready, and then like four more when the user clicks on different elements. It also bothers me that jQuery .html() doesn't actually put the contents inside my html tags (when I view source). </blockquote> This sounds like you're trying to do too much in the client code. Can any of those ajax calls @ the start be provided by the view? Four ajax calls when a user clicks on stuff? Most clicks represent a single action, usually only one ajax should suffice, maybe two if you need to process the response and request more information, but rarely more than that. <code>$.fn.html(...)</code> in jQuery puts the first parameter inside the element selected. If you're looking to replace the HTML of the entire page (not reccomended, ever... that should be a page load). You would call this: <pre><code>var theHtmlToPutInPage = "... whatever ..."; $("body").html(theHtmlToPutInPage); </code></pre> <hr> <blockquote> My main problem, where I'm stuck now, is the part beneath the days. I have those 'Woe, 20 april' table headers, but then underneath that I need to get my actual events. I'm not sure what would be the best approach to creating this feature. Should I put it in a table? But then how would I put certain events on the right place? For now, all I have achieved is a function which outputs all events for a certain day into an array, like so: </blockquote> There are many approaches to this problem. You could build the entire thing as a big table of time-blocks, but this could get rather confusing. Also, tables are nasty, <a href="http://www.hotdesign.com/seybold/everything.html" rel="nofollow">There</a> are <a href="http://webdesign.about.com/od/layout/a/aa111102a.htm" rel="nofollow">many</a> well-written <a href="http://www.webdesignfromscratch.com/html-css/html-tables/" rel="nofollow">articles</a> on when & where to use tables. You could set up the visuals as a uniform grid with CSS Divs & float the appointments overtop using <code>position: absolute</code> and controlled from your Client Code (javascript). This is a rather complex part of your project, there's many answers and I don't have time to really deep-dive any solutions here, you'll just have to prototype & experiment. <hr> <blockquote> I'm willing to provide a link to my source code (github) if anyone would like to take a look at my mess and perhaps try to put me on the right track again. Perhaps I AM on the right track, still; I just don't feel that way. I got stuck at the displaying-events part, and I just feel horrible because I'm not happy with what I wrote (even though most of it works, at this point). </blockquote> I would be willing to look it over & give suggestions, as I'm sure some others here would too. <blockquote> As I'm on Easter break at the moment, I can't contact my teacher for another week, so I'm willing to provide a 100-150 rep bounty for a good, helpful answer to this huge rant/question. </blockquote> Generally bounty should be used as a motivator to get your question answered correctly. The kind of thing that gets people to go in depth (like perhaps this answer, it's getting mega long now). You're welcome to offer a bounty, it's your rep, however do not feel like you have to offer a bounty. If this answer is satisfactory (or any other one someone else might post, simply accepting an answer should be more than enough). <hr> Summary & Final Thoughts Alright, so in the course of writing this monstrosity of an answer (does it count as a novella yet?) I think I may have deduced where you might be going wrong. It might be by design, but it might be accidental. I think you might be mistaking the view for the client code. When we talk about MVC we do not neccesarily mean, it should all be loaded in via ajax, and the view is the javascript & dom running on the client's browser. If this is not the case, then please disregard that last paragraph. It really sounds like you've got the wrong weighting of responsibilities. It looks like you're tasking too much of your application to javascript. Page loads are not the devil, ajax is trendy but often can be <a href="http://blog.realmofzod.com/blog/2009/06/23/ajax-too-much-of-a-good-thing/" rel="nofollow">Too Much</a>. You have to find the right fit for your app. It really seems like you could benefit simplifying your problems by tasking more responsibility to the view instead of the client code. I hope this answer has helped you, sorry it took so long for me to post this, I saw your question when you posted it but didn't have the time to go in-depth like this then.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCodeIgniter calendar/planning application, structuring and execution
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAren
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCodeIgniter calendar/planning application, structuring and execution
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId

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.