Roguish Posted February 25, 2008 Share Posted February 25, 2008 Hi I am the owner of the largets Top Trumps reference site currently onlline (www.ultimate-top-trumps.co.uk) and becasue it is so big I need to have some method that allows people to find exactly what they are looking for and obviously need some kind of database. The other thing that I need is a member login for members only. Can someone please help me with this because I have spent days trying to do this after downloading so much such as MySQL and Spider that I am completely confused and it does not help matters when a so called help file is so jargon bloated that it is an instance problem before you start. Can someone please tell me what I need to do, step - by - step in its most simplest of terms. Thanks!! Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 I have no idea what you want... perhaps you meant to post thisin the freelance section? Help with what? According to your post, there isn't even a db? Quote Link to comment Share on other sites More sharing options...
Roguish Posted February 25, 2008 Author Share Posted February 25, 2008 That is what I would like help with, how to get started, what do I need? I don't have a db as yet. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 This doesn't seem like a small project... Quote Link to comment Share on other sites More sharing options...
Roguish Posted February 25, 2008 Author Share Posted February 25, 2008 So where would I start? Once I have a clear path forward then I will be able to sort things out, I did after all work out the forum on my site after a few attempts. I really need to have at least a search facility and a friends site also needs one so I really want to do this. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 If you describe what time of information you plan to store, and how you envision your members querying it, I'm sure we can help with a DB design. As for the implementation, you'd have to refer to the php help section or a good tutorial. Quote Link to comment Share on other sites More sharing options...
Roguish Posted February 25, 2008 Author Share Posted February 25, 2008 So I would need php as opposed to MySQL? Queries for the Search would be by Country Producer Series Year Ref number Title I would like the search to be able to look for each of these to make it precise or any one with choices as results. I think the site itself is explanatory as to how best to search it but the listed items would be sufficient. As far as a db goes I assume that Access is the choice which I do understand, to a point. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 That can't possibly be it... are they no other details pertaining to each of these search fields? What about the member info? Don't even think about using access, mysql is the way to go for the db... but you'll have to access the db from your website, and this forum is dedicated to using PHP as the method of choice. Quote Link to comment Share on other sites More sharing options...
Roguish Posted February 25, 2008 Author Share Posted February 25, 2008 The info for the search was for the site search. Do you mean that the member details and site search would be on the same db? You see why I am so confused! Surely there has to be a basic tutorial that can be recommended that I could use? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 Yes, everything should be on the same db, unless there are very exotic requirements. I was specifically referring to the info you could store about your "widgets", not specifically what can be searched, as the former dictates the latter. There are many stickies on this board about mysql/php... and I'm sure the php forum has a similar set. I can't personally recommend any, maybe someone else can? Quote Link to comment Share on other sites More sharing options...
aschk Posted February 27, 2008 Share Posted February 27, 2008 Sounds like you need to start from scratch. Have you read the stickies? Have you installed MySQL, have you installed Apache, have you installed PHP? If not then I suggest googling all three of those phrases and installing said products first. Once you have that sorted out, learn how to write your first "hello world" php program. There are plenty of tutorials out there to help you do that. After that consider learning about MySQL, the SQL syntax, and how to create databases, tables within those database, and normalising the information you are storing. Once you've done there, head over to php.net and read the documentation regarding connecting PHP to a database (MySQL) and use the samples that are provided to get yourself a good idea of what you are doing. note: for someone who knows "not a lot" about PHP/MySQL i think this might be a bit of a big task for yourself. Consider using external help, or spending many hours of the day reading/learning. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.