homepage Welcome to WebmasterWorld Guest from 54.204.94.228
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

    
how do I create a searchable address book on a website?
searchable website address book
Evrman




msg:4015890
 9:18 pm on Oct 29, 2009 (gmt 0)

I'm working on a website for a housing development that wants to include the members of it's community in a searchable address book on their website. I haven't been able to find anything that is simple enough for me to work with. I was working with PHP to construct it but have been having a terrible time with it.

I've been told that there is a way I can set one up to use an Excel file as a database, which would be ideal for my uses seeing as how the client sent me an excel file with all their members in it.

Does anyone have a clue as to how I can do this simply? Thanks so much!

 

rocknbil




msg:4016863
 7:09 pm on Oct 31, 2009 (gmt 0)

Welcome aboard Evrman - the first question you need to ask, are the builders familiar with the privacy issues and liabilities they are taking on with this move? Even if it's behind a log in area, there has to be the ability to opt out, etc.

For integration into a web site you are likely going to want to export the Excel as a delimited file and upload it to the site, allowing programming to parse it and populate a database. There are API's for direct integration with Excel, but I've never used them, imprting/exporting makes it easier.

Don't know of any freebies or otherwise, but should be fairly trivial for a moderately experienced coder to put together, if they decide to move forward with it.

Evrman




msg:4016876
 7:33 pm on Oct 31, 2009 (gmt 0)

Thanks rocknbil! I appreciate the help. I've made it painfully clear to the client why I don't think it's a good idea to include all of the communities info in the directory, but they still want to push forward.

I've gotta figure out more of the programming end of things I suppose. I typically do simple web design but my boss is pushing me in the direction of programming lately. I have an existing database with tables created already, my big problem is I don't know how to get the info from the Excel file into the database. I'm sure this is a very trivial issue for someone with more experience but being so new to it I don't have the first clue as to how to get rolling in that direction.

I really appreciate your suggestions and advice!

MrHaan




msg:4017033
 11:53 am on Nov 1, 2009 (gmt 0)

Maybe you can search for Excel-to-MySQL on google. You can have a look at the 2nd result, I haven't tried it but it maybe works for you.

sorry for my bad English

Evrman




msg:4017520
 2:17 pm on Nov 2, 2009 (gmt 0)

Thank you MrHaan! I'll check into it and your English is probably better than mine.

mack




msg:4019440
 5:10 am on Nov 5, 2009 (gmt 0)

You can also export the data from excel as a deliminated (as rocknbil suggested) .csv file. You will be able to import this right into mysql using the phpmyadmin tool.

Mack.

tangor




msg:4019453
 6:35 am on Nov 5, 2009 (gmt 0)

Do speak to your client as regards releasing personal (private?) information on the web. There might be legal issues... and you might get caught in that by direction of the website owners. Beware the bus under which you might be thrown. Meanwhile, Excel to cvs is trivial as that is a function of Excel's SAVE AS. Reading flat files in cvs format via Perl, PHP, or ASP is simple. MySQL makes that possible as well with a bit more bells and whistles, though you must maintain all security (sanitize) access to the database to prevent SQL injection attacks on your server.

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