homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

Create different urls from database
How and what to use

Msg#: 4629499 posted 2:26 am on Dec 11, 2013 (gmt 0)

Hello Guys.-

First of all thank you for having a place like this for people like me who is starting to develop.

I'm trying to create a site that generates different urls for each an every one of the values on a Data Base previously created with all the info that should be displayed in that url.

It's an application / website that people could get to by scanning a QR code with their phones or typing the url on the address bar (the las part of the url is the employee's number) and retrieving their (insurance) information, it's information that most likely will remain static for the most part of the year unless an event (accident) has to be reported, only then the administrator should be updating the data.

I already have my html / css template set and I have a basic knowledge of php and python (django) and have no problems with the DB (MySQL) for the server side, I'm also considering using Angularjs since it's just one page but changing according to the request made.

Any help will be really appreciated.

Thanks in advance.



WebmasterWorld Administrator 5+ Year Member Top Contributors Of The Month

Msg#: 4629499 posted 2:10 pm on Dec 16, 2013 (gmt 0)

Hi CarlosV and welcome to WebmasterWorld!

I am not understanding what is your question.

Perhaps if you clarify what aspect do you need the help with, we could try to help?


WebmasterWorld Administrator phranque us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

Msg#: 4629499 posted 10:52 pm on Dec 16, 2013 (gmt 0)

welcome to WebmasterWorld, CarlosV!

the simplest thing to do would be to generate a url based on the employee id which is presumably unique.
something like:

however there are probably other requirements you haven't mentioned.
the first thing i would be concerned about is how to prevent unauthorized access to private information.


WebmasterWorld Administrator ergophobe us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

Msg#: 4629499 posted 2:18 pm on Mar 26, 2014 (gmt 0)

Ditto what phranque said - I would want some type of authentication rather than having that out there in the clear.

Some big companies have a shocking disregard for this sort of thing, but it doesn't mean it's okay. One example: as of a couple of months ago, if I knew your email address I could pull up all your Jet Blue flights from the past couple of years. Based on an email inquiry from a complete stranger and using only the email address, I learned his full name and determined that he had traveled from city A to city B round trip on certain dates, from which I also learned that he had run a marathon while there.


Msg#: 4629499 posted 12:23 am on Mar 30, 2014 (gmt 0)

Thank you all, I'm sorry for taking this long but my client decided to drop the project and then I went to San Francisco, come back to Mexico, changed job so I took a while to get back on my feet and then my client decided to retake the project.

Anyways, phranque is right, what I'm planning to use is Oauth for each and every user that way only the ones with a valid email account (Yahoo, Hotmail, Gmail) can access it; I have used it on different occasions and apps that I use and everything seem fine to me.

Also phranque is right about the forming of the url: www.myapp.com/1234567, that's exactly what I was thinking, that way the employees only have to remember the site url and then add their employee's number.

Any thoughts are welcome

Thanks again.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / New To Web Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved