Resend my activation email : Register : Log in 
BCF: Bike Chat Forums


I maybe asked before..

Reply to topic
Bike Chat Forums Index -> The Geek Zone Goto page 1, 2  Next
View previous topic : View next topic  
Author Message

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 18:28 - 27 Feb 2016    Post subject: I maybe asked before.. Reply with quote

But, back then I was curious to learn and a few years later I have confirmed that I don't have any of the patience or much of the understanding.

I need an SQL based classifieds website, to sell cars and bikes.
Nothing fancy or groundbreaking, just something someone could list a car/bike for sale for free, maybe if no too difficult, share said proud advert to some social media profile.

Anyone reading able to give me a quote? (it will need some editing later, and I have a VPS package with OVH if that matters).
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

J.M.
World Chat Champion



Joined: 27 Mar 2011
Karma :

PostPosted: 14:55 - 28 Feb 2016    Post subject: Reply with quote

What you're asking for would price up quite quickly. Learn how yourself, it's quite rewarding.

Simple steps:
- Design the HTML site with some fake adverts
- Figure out how to use PHP to populate the data in those adverts using variables
- Figure out how to pass in a variable to PHP to get it to change which advert it loaded
- Create a simple database (PhpMyAdmin makes it easy) and write some simple queries from PHP to get the data.
- Use the data to fill the site as you've already done
- Read up on SQL injection to make sure someone from BCF doesn't drop your database once you post it

It should be achievable with a few months work (of a few hours each week) and a lot of copy/paste from Google.
____________________
2004 R1 & 2018 XSR900
 Back to top
View user's profile Send private message You must be logged in to rate posts

Andy_Pagin
World Chat Champion



Joined: 08 Nov 2010
Karma :

PostPosted: 15:59 - 28 Feb 2016    Post subject: Reply with quote

I suspect there are off the shelf products that would do what you need, you just bung your own graphics & whatnot onto a template.

Take a look at existing websites that do roughly what you want then look at the small print at the bottom of the screen, it usually says who designed the site. As J.M. said having a site custom built will get very expensive very quickly.
____________________
They're coming to take me away, ho-ho, hee-hee, ha-haaa, hey-hey,
the men in white coats are coming to take me away.
Yamaha Vity -> YBR125 -> FZS600 Fazer -> FZ1-S Fazer
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 18:13 - 29 Feb 2016    Post subject: Reply with quote

My old man is a fan of telling me I should be learning it, but I've tried for a few weeks (as well as when I first posted years ago) and I just can't, I understand roughly how it all fits together but I'm not able to sit patiently for weeks and plod along at it. I wish I could, patience is not a strong point.

I've google for classifieds websites, many results are wordpress related, is this normal? a simple template I can tweak images of and in time have bits built around sounds ideal.

Kickstart once spent many hours sending various snippets over messages educating me, but it doesn't sink in. Crying or Very sad I really need something as a base to use, before it can be built up
(without that sounding like 'gimme the keys to the ferrari before I bother learning to drive')

J.M. wrote:

- Read up on SQL injection to make sure someone from BCF doesn't drop your database once you post it
Why would anyone bother?
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 18:27 - 29 Feb 2016    Post subject: Reply with quote

Did a search, found this:
J.M. wrote:
Create a simple database using your favoured SQL variant.

Make sure it makes use of Primary Keys, Foreign Keys, Hard Constraints and proper naming conventions.

Then use some queries to select data out of it and put data in to it. You'll want to familiarise yourself with:
- Select
- Insert
- Where (And & Or are useful in these)
- Inner Join
- Group By
- Order By
- Unique
- Count
- Avg
- Nested Statements

If you can familiarise yourself with using those commands, you'll be in a good place to do a lot of tasks that they want you to do, or to learn something extra.

TQ wrote:


Add DISTINCT, UNION and OUTER JOIN to that list as well as using IN within a WHERE clause.
Thinking Embarassed Thinking
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

goto10
World Chat Champion



Joined: 16 Oct 2011
Karma :

PostPosted: 19:00 - 29 Feb 2016    Post subject: Reply with quote

st3v3 wrote:
J.M. wrote:

- Read up on SQL injection to make sure someone from BCF doesn't drop your database once you post it
Why would anyone bother?


For the lulz.
Never concatenate SQL statements (i.e. SELECT X,Y from Z WHERE A='" & txt_dodgyinput.text & "'" - this sort of thing is asking for it to be messed with. (People can inject SQL statements into the free text, hence the name)
____________________
'12 NC700S & '12 CB600F Hornet [Stolen by some dickless twat] Suzuki GT500 shed
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 19:21 - 29 Feb 2016    Post subject: Reply with quote

Don't think I've managed to piss anyone off enough to make it worthwhile.
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

Jayy
Mr. Ponzi



Joined: 08 Jun 2009
Karma :

PostPosted: 19:37 - 29 Feb 2016    Post subject: Reply with quote

https://themeforest.net/search?utf8=%E2%9C%93&term=classified+ads&referrer=search&view=list&sort=sales&date=&price_min=&price_max=&sales=&rating_min=

Problem solved.
 Back to top
View user's profile Send private message You must be logged in to rate posts

ScaredyCat
World Chat Champion



Joined: 19 May 2012
Karma :

PostPosted: 19:43 - 29 Feb 2016    Post subject: Reply with quote

Jayy wrote:
https://themeforest.net/search?utf8=%E2%9C%93&term=classified+ads&referrer=search&view=list&sort=sales&date=&price_min=&price_max=&sales=&rating_min=

Problem solved.


Do this^^^ Wordpress + theme. You'll have it up and running quickly and you wont have to pay someone to look after it. You'll be able to edit and change stuff as you need to and not even worry about the database behind it. Minimal cost.
____________________
Honda CBF125 ➝ NC700X
Honda CBF125 ↳ Speed Triple
 Back to top
View user's profile Send private message You must be logged in to rate posts

Jayy
Mr. Ponzi



Joined: 08 Jun 2009
Karma :

PostPosted: 19:50 - 29 Feb 2016    Post subject: Reply with quote

Wordpress themes on there are so good these days, you have to ask yourself the question... do you want a completely bespoke site? or do you want something pre-made but modified to your needs?

The average small - medium business user just want something that looks great with their colours and branding on there and if it keeps costs down, they like it even more.

Want something completely bespoke with bespoke functionality and features? Pull your wallet out and be prepared to spend big.
 Back to top
View user's profile Send private message You must be logged in to rate posts

winz
World Chat Champion



Joined: 05 Feb 2015
Karma :

PostPosted: 20:01 - 29 Feb 2016    Post subject: Reply with quote

Jayy wrote:
Wordpress themes on there are so good these days, you have to ask yourself the question... do you want a completely bespoke site? or do you want something pre-made but modified to your needs?

The average small - medium business user just want something that looks great with their colours and branding on there and if it keeps costs down, they like it even more.

Want something completely bespoke with bespoke functionality and features? Pull your wallet out and be prepared to spend big.


What Jay said. I'd happily quote you for it. But it will be for a bespoke job.
____________________
Current Bikes: BMW K1200S
Previous: Honda CBR929RR, Honda CBR1100XX, Honda CB600F
 Back to top
View user's profile Send private message You must be logged in to rate posts

Fin
World Chat Champion



Joined: 27 Feb 2016
Karma :

PostPosted: 20:03 - 29 Feb 2016    Post subject: Reply with quote

st3v3 wrote:
Don't think I've managed to piss anyone off enough to make it worthwhile.


SQL injection is easy to do and could take less than a minute, most on here wouldn't do it maliciously but more to prove that your website is shit and for a laugh.
 Back to top
View user's profile Send private message You must be logged in to rate posts

Kickstart
The Oracle



Joined: 04 Feb 2002
Karma :

PostPosted: 20:19 - 29 Feb 2016    Post subject: Reply with quote

st3v3 wrote:

I've google for classifieds websites, many results are wordpress related, is this normal? a simple template I can tweak images of and in time have bits built around sounds ideal.


There are various templated systems around. Can't say I am that interested in them so not sure on what templates are available. Fair chance there is one for Wordpress or Joomla or the like which will do the job.

Or you could chop around a shop web site setup like Prestashop.

st3v3 wrote:
Don't think I've managed to piss anyone off enough to make it worthwhile.


I have done it to things people have written at work (not destructively - it is a bit harder to start dropping tables) just to show them the hole in their code. First thing to try is putting quotes in the input fields and see if you get a system error (or a but more complicated, right click on a check box and use inspect element to edit the value).

Seriously, people will do it for the hell of it. Possibly not for damage, but to get info. For example if your login is Admin, put that in the user name field and put ' or 1 = 1 -- in the password field and you have a chance of logging in as you. Then as admin you might be able to get a list of user ids, and maybe passwords, probably email addresses, etc.

All the best

Katy
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Jayy
Mr. Ponzi



Joined: 08 Jun 2009
Karma :

PostPosted: 20:44 - 29 Feb 2016    Post subject: Reply with quote

I work exclusively with Wordpress these days. I used to use all kinds of things but WP will do pretty much anything you need.

Theme Forest has some impressive themes on there and don't be put off by the fact it's only $40-$60, they build these complex themes with all the premium features you'd expect but sell in volume. I believe one of the best sellers is @ 190,000 units.

In my experience, you won't find a better solution for the price bracket and WP + a premium theme like this, you don't even need to know HTML / CSS these days, the options panels, drag and drop page builders will take care of it all.
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 22:03 - 29 Feb 2016    Post subject: Reply with quote

Ok, so I should be setting up a simples wordpress stylee thing to get going, then have some sponsors pay advertising/placement for a few months then go bespoke?

As long as people can list their own cars/bikes to start with, the platform isn't important. Long term though, it needs to be custom.
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

Jayy
Mr. Ponzi



Joined: 08 Jun 2009
Karma :

PostPosted: 12:47 - 01 Mar 2016    Post subject: Reply with quote

Simple? Wordpress can be as complex as you want it to be.

Start off with one of them top themes, compare the features and make sure it has most of what you want, they usually cover most bases when aiming a theme at the masses for a particular niche.

See how you get on for a few months, you will be pleasantly surprised I think. Your users will highlight any short falls and you can begin deciding what needs to be implemented.

You don't need to have something completely bespoke made unless what you've got can't be customised by a developer to suit your needs.

i.e. If it was 90% of what you need, hire a dev to add the 10% on to the existing WP site.

If it's the complete opposite of what you need, then it's time to go bespoke.

There may also be some really good turnkey solutions out there.
 Back to top
View user's profile Send private message You must be logged in to rate posts

UnknownStuntm...
World Chat Champion



Joined: 13 Sep 2007
Karma :

PostPosted: 13:47 - 01 Mar 2016    Post subject: Reply with quote

Kickstart wrote:

All the best

Katy

Laughing
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 14:15 - 01 Mar 2016    Post subject: Reply with quote

^What are you, 12?

Ontopic, I will see what this wordpress setup is all about, and work from there unless in a month or 2 it doesn't feel right. Thumbs Up
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

UnknownStuntm...
World Chat Champion



Joined: 13 Sep 2007
Karma :

PostPosted: 14:19 - 01 Mar 2016    Post subject: Reply with quote

st3v3 wrote:
^What are you, 12?

It was funny because he was telling you that you might have people pretending to be you if you don't have your spacky website coded properly. Then he signed it as someone else. Clearly, you didn't get that joke. I offer you pity.
 Back to top
View user's profile Send private message You must be logged in to rate posts

ScaredyCat
World Chat Champion



Joined: 19 May 2012
Karma :

PostPosted: 14:26 - 01 Mar 2016    Post subject: Reply with quote

UnknownStuntman wrote:
It was funny because he was telling you that you might have people pretending to be you if you don't have your spacky website coded properly. Then he signed it as someone else. Clearly, you didn't get that joke.


It wasn't a joke, you're just 6 months behind the curve.
____________________
Honda CBF125 ➝ NC700X
Honda CBF125 ↳ Speed Triple
 Back to top
View user's profile Send private message You must be logged in to rate posts

UnknownStuntm...
World Chat Champion



Joined: 13 Sep 2007
Karma :

PostPosted: 14:55 - 01 Mar 2016    Post subject: Reply with quote

I apologise for any confusion. Leaving it there ^^ as it explains what I *thought* the point of the post was.

Good luck with your website.
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 13:23 - 02 Mar 2016    Post subject: Reply with quote

UnknownStuntman wrote:
st3v3 wrote:
^What are you, 12?

It was funny because he was telling you that you might have people pretending to be you if you don't have your spacky website coded properly. Then he signed it as someone else. Clearly, you didn't get that joke. I offer you pity.
Laughing I think you need to get to know someone before making assumptions.

In all fairness I can see why you thought that.

P.S, getting annoyed at me and lashing out doesn't have an impact, one day my 'spacky website' will be something, so you might need the pity later. Karma
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts

Jayy
Mr. Ponzi



Joined: 08 Jun 2009
Karma :

PostPosted: 14:28 - 02 Mar 2016    Post subject: Reply with quote

Well this escalated quickly.
 Back to top
View user's profile Send private message You must be logged in to rate posts

UnknownStuntm...
World Chat Champion



Joined: 13 Sep 2007
Karma :

PostPosted: 16:41 - 02 Mar 2016    Post subject: Reply with quote

Jayy wrote:
Well this escalated quickly.

Not really.

Back on topic. IIRC you can pay Autotrader to reskin and host your content on their site, and it's got a fairly healthy API for meddling with.

Why not that?
 Back to top
View user's profile Send private message You must be logged in to rate posts

st3v3
Super Spammer



Joined: 16 Oct 2006
Karma :

PostPosted: 17:26 - 02 Mar 2016    Post subject: Reply with quote

Because I couldn't list on Auto Trader, it needs to be a standalone classifieds.
____________________
Roger wrote: Women don't get damp for clingy puppies. Get some better happy pills, hit the gym & buy a medallion the size of a dinner plate. Job done
 Back to top
View user's profile Send private message You must be logged in to rate posts
Old Thread Alert!

The last post was made 10 years, 185 days ago. Instead of replying here, would creating a new thread be more useful?
  Display posts from previous:   
This page may contain affiliate links, which means we may earn a small commission if a visitor clicks through and makes a purchase. By clicking on an affiliate link, you accept that third-party cookies will be set.

Post new topic   Reply to topic    Bike Chat Forums Index -> The Geek Zone All times are GMT + 1 Hour
Goto page 1, 2  Next
Page 1 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Read the Terms of Use! - Powered by phpBB © phpBB Group
 

Debug Mode: ON - Server: birks (www) - Page Generation Time: 0.13 Sec - Server Load: 0.42 - MySQL Queries: 13 - Page Size: 132.84 Kb