Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I personally would have the application perform all of the necessary routing logic instead of relying on .htaccess. This is how <em>I</em> would do it:</p> <p>I would start by using a pre-built router class/module/library. If you are coding in PHP, use something like <a href="http://alloyframework.org/manual/url-router/" rel="nofollow">Alloy Router</a>. If you are using a framework of some sort, routing might already be built in. </p> <p>Next step would be to make a "catch all" profile route that catches all routes that haven't previously been "caught". You might have a bunch of other routes such as "website.com/about", "website.com/contact", etc, which will get caught first and then the catch-all route will get all others.</p> <p>The catch-all route will route your application to a "profile" controller. This controller looks at the given route and checks to see if the "username" within the route matches a username in your database. If so, create the profile of that particular user. If not, provide a 404.</p> <p>You'll have to make sure all usernames are unique and they don't conflict with other routes (i.e. a user can't have the username "about" otherwise their url will be caught by the "about" route).</p> <p>Finally, within your application you will have to make all of your links go to the proper urls. If you have a "profile" button in a top navigation bar, you will want to make sure it actually goes to "website.com/username" where username is the actual username of the currently logged in user. All links to other user's profiles will be dynamically created to go to the correct url that includes their usernames.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to Build a User Profile URL for Website?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USmbosecke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWow, thanks for the response. I failed to mention that I am new to php, so all that you just said is a little over my head. I guess I should have someone look at my code to see if what you said can be done. Thanks
      singulars
      1. PO
      1. USJo Anne
 

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