Forum Moderators: coopster

Message Too Old, No Replies

Address book database

Creating database that each user can update their own info.

         

KernalSanders

1:01 am on Dec 18, 2007 (gmt 0)

10+ Year Member



Greetings everyone.

I am pretty new to php. I have recently undertaken the task of creating a website for my family. My intention is to allow each family member to register on the site, and once I verify that they are a family member, they can login and update their contact information like their address, phone number, email, etc. Then there will be a page that will display (collectively) all the contact information for all registered members. As of now, I am simply using a form method to collect the data and manually inputting the data into an htm file that has user login restrictions set to that file, to try and keep the data safe.

Well I hope I explained that properly and clearly. Here is the link to my site so you can get an idea of how I have things set up.

<snip>

Also, here is the link to a "Test" Address Book so you can see how I am currently putting the info into the page.
<snip>

Now on the actual link to the real address book, a user name and password is required, but that part of the site has real info on it so that is why I made up a test one.

Anyways, I hope someone can help me with this endeavor. I am willing to listen and learn from everyone!

Thanks in advance for your help!

[edited by: eelixduppy at 1:13 am (utc) on Dec. 18, 2007]
[edit reason] no URLs, please [/edit]

jatar_k

4:58 am on Dec 18, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld KernalSanders,

you might want to think about using a database to store the info, that way you could get rid of the whole manual input step.

What specific issue are you having that we could maybe help with?

phparion

6:22 am on Dec 18, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Welcome to WebmasterWorld :)

Besides traditional databases, for this small task you can also consider using XML or flat files which will be quick to process information comparatively. Also do check sourceforge.net you might get something very close to what you require there.

You can also use Open Source softwares like joomla or drupal and customize them for your use. They both have the features you are looking for.

KernalSanders

5:34 pm on Dec 18, 2007 (gmt 0)

10+ Year Member



First off,sorry about the URL's as I said before I am new to this, and didn't realize that it was not allowed.

Moving On.

Yes I do want to use a database. I guess my basic question here, is how to create this database and how to implement it into my site.

I do have drupal and joomla, but have never used them. I am about to load them into a temp directory on my server so I can test them. Once I do this, I will post back here on my findings, but in the mean time, can we discuss my erlier question?

Thanks

eelixduppy

6:40 pm on Dec 18, 2007 (gmt 0)



Welcome to WebmasterWorld

There are a few things that you should read up on to get a good understanding of what is required to do what you want successfully. First off, since we are dealing with databases, and I'd imagine MySQL, you are going to want to keep the documentation for the MySQL Functions [php.net] handy during your implementation stage.

Alright, now from here, we have a few great threads that will get you started on your way:
PHP User Authentication [webmasterworld.com]
Commonly Used MySQL Commands [webmasterworld.com]
Basics of Extracting Data from MySQL [webmasterworld.com]

Start off with that and see where you can get yourself. Of course, if you need help along the way, we're here :)

KernalSanders

8:01 pm on Dec 18, 2007 (gmt 0)

10+ Year Member



Thanks....I will do!

phparion

5:44 am on Dec 20, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Softwares like joomla and drupal have user management systems in them. You can tweak them to get your required functionalities easily. However, for a newbie it might be lots of work so lets forget about these softwares. Did you search PHP Address Book on sourceforge.net? I still believe you will get something very close to your requirements on this site.

At the same time I encourage you to learn PHP-MySQL properly before you install or customize any of these ready made softwares.

KernalSanders

4:11 pm on Dec 20, 2007 (gmt 0)

10+ Year Member



Well, I have been playing around with Joomla, and I have figured out how to do most of it but I am still having trouble with some portions, like the newsflash feature. I can't seem to get it to display the text I put in for the newsflash.

Anyways, I have done a little reading on mysql/php and I am definitely going to have to do some reviewing of the material because I quickly found myself lost.

[edited by: KernalSanders at 4:13 pm (utc) on Dec. 20, 2007]