work_it_work Posted May 6, 2008 Share Posted May 6, 2008 It's my first post on this forum, and in php forums too. Hi everyone! I'm trying to build some sort of website, and I'm very confused with php and mysql... I have created before website in php, but very simple, and without mysql, so i'm newbie in mysql, also the php it's not my best So, what exactly I'm trying to build, it's more like an classified add website with a lot of details and informations. This website will contain adds from private owners and company adds... both (private and company) will have to login to post the adds. The main question is how my database will look like? If the seller want to put vehicles for sale, he will have to navigate trough some drop down menus, select the make, model and type. As far as i know this not simple... How can I do that? How the db will register the selections? Other questions like: How user can see the adds submitted from his account? How the search will work with db and bring out the correct or nearby results? Anyone know where to get free host with full access? mysql without any restrictions and also for hosting. which accepts .htaccess upload... I need some suggestions, a lot of help, and I hope to complete my website soon... Does anyone know where I can find this kind of website including db, to see how it look like and how php works with db in this case? Any suggestions where I can find what I am looking for? Waiting for help & suggestions PS: Sorry if i posted the topic in wrong place, moderators please move it where it belongs Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/ Share on other sites More sharing options...
Fadion Posted May 7, 2008 Share Posted May 7, 2008 U seem to need some reading, as what u want to do is fairly complex for a starter. To ask some of your questions: Q: The main question is how my database will look like? A: Have a table for users with their details and another table for ads. The ads table will contain description, category etc and finally the user id which references the id of the users table. Q: If the seller want to put vehicles for sale, he will have to navigate trough some drop down menus, select the make, model and type. As far as i know this not simple... How can I do that? How the db will register the selections? A: Those will be handled by post. U will collect post data in variables and insert a new row into the database. Q: How user can see the adds submitted from his account? A: Make a query in the ads table and search all the ads which have the user_id field as the id of the actual user. Q: How the search will work with db and bring out the correct or nearby results? A: Consider taking a look at the mysql WHERE and LIKE clauses. Q: Anyone know where to get free host with full access? mysql without any restrictions and also for hosting. which accepts .htaccess upload... A: Free host with full access? Dont know what u mean by full access, but that is only possible on dedicated or virtual dedicated. But i think shared hosts (pretty cheap nowdays) should give u all the options u need. Q: Does anyone know where I can find this kind of website including db, to see how it look like and how php works with db in this case? A: Dont know one, but there should be tons of open source scripts. Search for "classified php script" or anything similiar. Anyway usually big and good scripts are coded using classes, templates etc, more like an alien-language then php for a starter. Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-534835 Share on other sites More sharing options...
Barand Posted May 7, 2008 Share Posted May 7, 2008 No problem with the placing of the post, but questions like this are rather all-embracing. A bit like asking a builder "How do I build a house?". The simple answer is "you keep laying one brick on top of another, add some plumbing and the electrics", but in reality it's a little more complex. You need to read some tutorials (Kevin Yank has produced some good ones that got me started - http://www.sitepoint.com/article/publishing-mysql-data-web ) When you have a more specific question we can help. Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-534839 Share on other sites More sharing options...
work_it_work Posted May 7, 2008 Author Share Posted May 7, 2008 Thanks for your reply GuiltyGear, It's very useful for me! I'll start my work today. Barand you're right, but if i don't give a try and ask here i don't know, i'll never finish the "house" Here's how i want my website look like : http://autos.yahoo.com/ this is an example... I'll get back with more specific questions after i start to build, till then anyone who want can write his suggestion here PS: I'm sure if i had a technical map of the website I want to build it was much easier for me, but my brain refuse to outline one if someone can help... Thanks again! Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-535099 Share on other sites More sharing options...
work_it_work Posted May 7, 2008 Author Share Posted May 7, 2008 is there any place on web where i can see old websites structures? I've heard someone speaking about something like a web where you you can see and explore old versions of websites structures and sources... Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-535102 Share on other sites More sharing options...
Fadion Posted May 7, 2008 Share Posted May 7, 2008 Old websites structure=templates? Search for free templates then! If u really have no idea on building a web (even html and css stuff), ud better start reading first or just get the job done by a proffesional. Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-535115 Share on other sites More sharing options...
work_it_work Posted May 7, 2008 Author Share Posted May 7, 2008 No No, Not templates, let me give you an example so you can understand: yahoo.com in the last 5 years the website design and structure changed a few times. The prev. version of the actual yahoo.com can be found on that website I've asked for. This may include php sources and db structures... I'm sure yahoo.com didn't share older versions, maybe others did... so I'm asking if this thing exists ?!? I have idea about building html and css... I'm just confused about mysql and php in this case... Link to comment https://forums.phpfreaks.com/topic/104476-i-need-some-help-some-sugestions/#findComment-535123 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.