Omzy Posted March 9, 2009 Share Posted March 9, 2009 I'm creating a website for my friend's car business using PHP 5.2 with MySQL. I would like to provide him with an easy to use interface where he can log in and add/delete/modify stock. There also needs to be a facility to add multiple images. There is no e-commerce facility required. Now I've looked at two options so far: 1) phpmyadmin - this would be too complex for my friend and does not provide facility to add images 2) Joomla using virtuemart extension - this is more geared towards an e-commerce site and although you can disable the e-commerce functions it's still not ideal for showcasing cars. I also came across a script here: http://real-estate-management-software.org/ - the only problem with this it seems to be written in PHP4 and I could not get to to work on PHP5 at all. Otherwise that would have been a perfect solution - it's nice and simple and although it's designed for properties I could easily modify it for cars. So I'm looking for a free solution to this - anyone have any suggestions? Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted March 9, 2009 Share Posted March 9, 2009 I would look into using WordPress or Drupal. Joomla is a horrible CMS. You have to do like 6 steps to accomplish one task. Your easiest option, IMO, is WordPress... although I am an avid believer in building your own CMS Quote Link to comment Share on other sites More sharing options...
Maq Posted March 9, 2009 Share Posted March 9, 2009 Why not build your own? Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 I could have a go at building it myself, but surely there must be one out there already? Just something simple that can be adopted for different uses. Quote Link to comment Share on other sites More sharing options...
cleary1981 Posted March 9, 2009 Share Posted March 9, 2009 http://www.php-shopping-cart-tutorial.com/ This might be of some use to you. Fully working script available free to download and use Quote Link to comment Share on other sites More sharing options...
Maq Posted March 9, 2009 Share Posted March 9, 2009 http://www.php-shopping-cart-tutorial.com/ This might be of some use to you. Fully working script available free to download and use That link displays a blank page for me. Quote Link to comment Share on other sites More sharing options...
.josh Posted March 9, 2009 Share Posted March 9, 2009 look at the basic database interaction tutorial on this site. The tutorial walks you through a form that lists stuff and lets you add/edit/delete stuff from the list. You can tweak it from there. Quote Link to comment Share on other sites More sharing options...
cleary1981 Posted March 9, 2009 Share Posted March 9, 2009 Don't know what happened their but it looks to up again now Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 I can easily code a form for the basic product management - but the tricky bit would be implementing a good login system and image uploader with auto-thumbnailing... Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted March 9, 2009 Share Posted March 9, 2009 I actually found a good script online for auto thumbnailing... mine worked on the fly though verses creating it upon upload. Try google for scripts like this.. Quote Link to comment Share on other sites More sharing options...
cleary1981 Posted March 9, 2009 Share Posted March 9, 2009 That site is down again. but I think its exactly what you are looking for. Try the online demo of the backend. Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted March 9, 2009 Share Posted March 9, 2009 I can easily code a form for the basic product management - but the tricky bit would be implementing a good login system and image uploader with auto-thumbnailing... If its only your friend updating the website then why use a login system. Just put the admin files in a folder called admin/ and protect using htpasswd - easy. Image uploading and resizing isn't that hard. I use imagemagick but you could use GD functions. There are loads of examples. Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted March 9, 2009 Share Posted March 9, 2009 here is an example for image thumbnails http://phpthumb.sourceforge.net/ Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 cleary1981 - thanks for that suggestion. I had a look at it but again it's more of a shopping cart tool... neil - that's true about the login system. so the main issue is the images i suppose. i would need to create a system that allows me to add/remove images for a car - how would I go about linking the images to it's correspending car? There can be any number of images. Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted March 9, 2009 Share Posted March 9, 2009 Store the filenames in a db table after upload against the id of the car images ===== id carId filename so your cms link could be /car-images.php?carId=123 Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 This would have been PERFECT if I could get it to work on PHP5! http://real-estate-management-software.org/tutorial1/quickstart1.htm I'm devasted! Anybody want to give it a go and see if they can get it working on PHP5? Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 neil - i need thumbnail images to appear on the car details page, then each thumbnail opens up it's full image... Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted March 9, 2009 Share Posted March 9, 2009 neil - i need thumbnail images to appear on the car details page, then each thumbnail opens up it's full image OK when a user clicks on a car you will have the id of the car in the url car.php?carId=123 Get all images from the database from carId 123 and display them on the page. You can use a bit of javascript to do a popup link. You could pass the filename within the link so on the popup page all you need is print "<img src='images/".$_GET['filename']."'>"; Quote Link to comment Share on other sites More sharing options...
Omzy Posted March 9, 2009 Author Share Posted March 9, 2009 I have 3 questions to ask: 1) Let's say I'm in the admin area - and I have an "upload image" button on a car details page. How do I link the image file with it's corresponding car entry in the database? 2) Let's say I have 10 fields in the database to store filenames for 10 images - some cars might not have 10 images so won't it error if it tries to fetch 10 images for each car? 3) Do the filenames for the thumbnail images need to be entered in the database? Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted March 9, 2009 Share Posted March 9, 2009 I explained briefly in previous posts to your questions 1) Let's say I'm in the admin area - and I have an "upload image" button on a car details page. How do I link the image file with it's corresponding car entry in the database? As I said you use the cars primary key ID Lets do a database: cars ===== carId make model name images ===== imageId carId filename Put the carId in a hidden field in the upload form 2) Let's say I have 10 fields in the database to store filenames for 10 images - some cars might not have 10 images so won't it error if it tries to fetch 10 images for each car? You dont have 10 fields in the cars table. You store images in the images table and use the carId as the join. I can store any number of images I want. 3) Do the filenames for the thumbnail images need to be entered in the database? No, when the image is uploaded and resized store the image in a thumbs/ directory with the same filename as the biggest image. 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.