I'm meant to be doing a rush project for a friend using PHP / MySQL. In theory, it should be simple. However, I'm not that good with PHP, I have 'flu and I can't think straight! Basically, what he wants consists of: Customer database Simple shopping cart Packing report I should mention, at no time do his customers have access to this site. All orders are entered by a member of staff. So, first you have to select (or create a customer). Next, you enter the details of their order. This is to be done in a very simple way: Three text boxes are used. The first is used to enter a product description, the second to enter the price and the third to enter quantity. A button is then clicked, which adds the item to the 'cart'. Before the order is submitted, a delivery date is chosen. Also, (and this is the hard part - for me, at least!) some method of selecting whether the order should be repeated (e.g. weekly or fortnightly). The final part is to prepare a daily report that can be printed, so the packers know what to put on the van, and the driver knows where to go. What do you think? Simple? Achievable by tomorrow? :banghead: Any suggestions would be greatly appreciated. If anyone knows of something open source (or otherwise) that would do this, simply, please let me know. (a standard eCommerce solution is too complex, and is split between user and admin, neither of which are wanted). Thanks!
There are some ways to do this. For example, you could run cron weekly/fortnightly on a certain php script. Or, you could have an admin viewable website listing all orders that would fetch all regular orders and the weird weekly/fortnightly ones. I wish I could help you more, but I'm in a middle of a deadline, sorta. But if you have any specific questions, you could PM me or something.
If you can't get any help (I'd like to help but I'm not into PHP yet) maybe the best thing to do is getting a free store PHP app and modding the code to fit your needs. This is way easier than making one from scratch. Also you can get some PHP manuals here (I'm pretty sure I've seen a bunch of tutorials for what you need there): http://www.tutorialized.com
Thanks for the replies, guys. Yeah, I could mod open source code, the only problem is that it is TOO different from what I want. It is really simple (in theory), it's just getting it achieved! It is more just the shopping cart that I need - no logging in, no customer interface. I think I'll take a look into PHP sessions, should give me an idea. Thanks for the ideas, guys - I'll look into them.... but not right now - I've got a splitting headache!
Sounds like a job for Microsoft Access or whatever the database program is (been a few years), not PHP
Well, Access would work... but basically anything you do in Access you should be able to do in PHP with a MySQL database. The whole idea is that it can be accessed online (with a private URL) so that things can be administered remotely - and they don't have to shell out large amounts of money on a copy of Access per PC!
That doesn't sound amazingly trivial, but not bad. Have you looked into giving them phpMyAdmin for starters? It's fairly intuitive.
phpMyAdmin allows administering of a database. You would almost never give a user access to it when you're developing a front end for them to use. Of course, I use it to create and administer the database. I've got a fair way through this, many thanks to drx for all the invaluable help. It's hopefully looking to be finished fairly soon!
Nah, it doesn't solve anything. The users are, not wanting to cause any offense, noobs. They need simple forms, not over-complications of accessing phpMyAdmin. Besides that, my friend owns a small web hosting company. He doesn't want to give users access to his database like that, no matter what level of access they have. And creating the reports in phpMyAdmin certainly isn't easy! My friend's hosting company is all about easy and efficient. That's why I've been called in to do the coding for him
Any news on this ? If you still need help I might be able to give you a hand, I don't have much spare time but it wouldn't hurt to help another board member ;-)
@retro What you can help is an open Source ECommerce Script like Oscommerce or XTCommerce. Its the best way to build an Webshop for beginners, because you have toons of Mods and all open source php! First start is easy and very interesting if you new in PHP/MySQL. Hope i can help you. http://www.oscommerce.com/ I used OsCommerce for long Time. All you discripe can be posible with that Code. You have an huge Admin Part where you can control everthing. Very good Mods, for examble an good SEO Script, Or Shipping and Pay Modules like PayPal ... over 4600 Mods :dance:
