StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14227976
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-01-09T03:46:00.060
FavoriteCount
0
LastActivityDate
2013-01-09T03:46:00.060
LastEditDate
LastEditorUserId
0
OwnerUserId
1171529
ParentId
14216912
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Here is some pseudo code and a few points in the right direction to get you started. Firstly, you will need to remove the index.php from your urls. There must be hundreds of questions on here already answering this part of the question, so I will leave this part up to you. As many have commented, there is no way to achieve this url structure out the box, and it will require quite a lot of code to get working. The way I would implement this particular setup would be to route all requests to a single controller, and handle custom routing within that controller. To do this add a route to the bottom of the <code>routes.php</code> as a catch all. Routes for other controllers (news, events, etc) can then be added above this one. Here is an example routes.php to get you started. config/routes.php <pre><code>// Other routes go up here // Catch all route $route['(:any)'] = 'page/view'; // Home page route $route['default_controller'] = "page/index"; </code></pre> You could then create a <code>view</code> function in <code>controllers/page.php</code> that will check the url (using codeigniters url helper), and load the correct view corresponding to that url. controllers/page.php <pre><code>class Page extends CI_Controller { public function index() { // Do all code for your home page in here } public function view() { // Retrive the url string $url = $this->uri->uri_string(); // Check if the corresponding view file exists if (file_exists(APPPATH.'views/'.$url.'/index.php')){ // Load the view $this->load->view($url.'/index'); } else { show_404(); } } } </code></pre> Say for example, a user went to <code>http://yoursite.com/CI/about-us</code>, the page controllers view function would take the string <code>about-us</code> from the url and set it as the $url variable, and then search your file structure to check if the corresponding view file exists <code>/application/views/about-us/index.php</code>. If it does, it will then load that view file, if it doesn't it will redirect to a 404. The above is all pseudo code typed from memory, so it probably won't work straight off, but hopefully give you a clue as to how to achieve your desired result.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POhow to modify routes in codeigniter
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJeemusu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
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.