Website that has a database attached to go with it?

Question

I am fairly new to webdesign and I do not know much about databases either. I work for an IT company and I am only out of high school less than a year. I have been studying intensively now for quite a few months and I know about html/css/ and java to make an alright website.

My boss wants me to make our company a website that has a database attached to it. Basically what we are trying to do is have user accounts where our few employees have access to like a schedule, trouble tickets, notes, a timeline of where our computer repairs are at..and Im sure more (this is just in the beginning stages). And then we want our customers to have a login ID and when they login it will show their previous repairs, their balance owed, a timeline of the stages their computer has gone through and when it will be finished.

I currently am using Wordpress with Pagelines Design Management System. I don't know if there is a plugin that I could use or if I have to use MySql(which I don't know but I am willing to learn) or whatever process I have to use to build my page in wordpress using the design management system and then somehow linking a database to it.

Like I said I am not to familar with databases so if there was times throughout this post that I didn't make sense that would be why.

Answer 1

This really depends on how much programming experience you have. Since you're asking this on YA, I'm going to assume you have little to none. Honestly, you're in way over your head. I would outsource this to someone that does this for a living. You can checkout freelancers.com or see if there are local development firms in your area. This isn't a small project by any means--be prepared to spend several thousand dollars.

Answer 2

As far as Wordpress goes and Pagelines Design Management System, am thinking, the key first step is to see whether you can access phpMyAdmin, which is the general link between PHP and MySql, because I suspect you already have MySql on this website and phpMyAdmin is the way into understanding it. Do you have cPanel to control your website? If so, it will have a phpMyAdmin icon, and this is the first best idea. If not, is your hosting Linux? If yes, go



find / -name '*hpMyAdmi*' 2> /dev/null



and go from there working your way back getting to phpMyAdmin. The thing is, though, that there will be a password, am hoping you know about, involved. Am going to leave you with some tutorials about the look of phpMyAdmin ( start at http://www.rjmprogramming.com.au/wordpress/?p=492 ), and you need to learn about databases like MySql.



http://www.rjmprogramming.com.au/wordpress/?tag=MySql

http://www.rjmprogramming.com.au/wordpress/?tag=phpMyAdmin

Answer 3

I agree with Robert, phpMyAdmin is the easiest way to tie a database to a website. In order to make this an effective relationship though, you will need to have some database administration skills. Ever worked with a database before? While they seem somewhat straightforward they can be a bit confusing, so I would tell you that you should probably consult with a database person in order to ensure you have a solid understanding about how they work independently and then how they work together. Good luck to you.

Answer 4

I think you should out source the job to a free lancer.. at freelancer.com you can have it done for as little as 30 to 60 dollars.. at the mean time you can learn about databases.. there is more to it then storing data.. there is normalisation of data so you won't have data conflict etc and you should also learn about security .. so it won't be easy to hack into your site and database.. good luck