Go Back   Peoples Republic Of Cork Discussion Forums > Tech Forum
User Name
Password
Reply
 
Thread Tools Display Modes
  #1  
Old 23-09-2009, 03:29 AM
pinklife pinklife is offline
 
Join Date: Jul 2009
Posts: 9
Default Searchable database?

Hi guys, I need some advice on how to set up the following please.

I am making a site that will need a searchable database. I will want a search field on my homepage where people can search for names. I want the search result to show a page as follows:

(thumbnail picture here) Joe Bloggs

(G) Joe Bloggs in this garden
(V) Joe Bloggs in London
(G) Joe Bloggs in Paris
(G) Joe Bloggs working

When a name is searched for I want it to show the following, (persons name, including a small thumbnail of them and on that page a list of all links shown as a description (not the full URL). I would want to categorise each link as either a gallery (G), or a video (V), using a small symbol.

So, basically each person will have their own record, containing their name, thumbnail pic and numerous links

I know how to set up a Mysql database on my server, but thats it! I have no knowledge of PHP or anything else, so I would really appreciate some advice on where to start with this.

Thanks in advance for any help!
Reply With Quote
  #2  
Old 23-09-2009, 10:41 AM
Smeggle Smeggle is offline
 
Join Date: Feb 2005
Location: west cork
Posts: 10,130
Default

goto hotscripts.com and search in the php section for database stuff or adapt one of the free off the shelf scripts....
__________________
Computek Blog Ireland
"There Justified and Ancient and they drive an Ice Cream Van"
☲ ☴ ☵ ☷
Reply With Quote
  #3  
Old 23-09-2009, 11:21 AM
thread_killer thread_killer is offline
 
Join Date: May 2003
Posts: 3,442
Default

You could try something like XAMP to get Apache, PHP and MySQL all setup, easily, on Windows. But for development only. You don't want to run a live system with this. Then in PHP code, connect to the DB, run your command on it, and cycle through the returned data set, printing each row.

You would want lots of data validation also.

Best for you to search for generic codes online, and play with them a little.
__________________
This post has been screened by FOX News for authenticity and impartiality, and has "terror-proof" protection for her pleasure.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump










All times are GMT +1. The time now is 09:12 PM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
All forum comments are the sole responsibility and property of forum users. PeoplesRepublicOfCork.com and its sponsors disclaim all liability for content posted by users of the forum. PeoplesRepublicOfCork.com and its sponsors do not necessarily share the views expressed in this forum. Use the report post system to have comments considered for edit or deletion. All users are IP logged. Website hosted by Hostrocket USA.