PHP premade databases anyone know where i can find one that will fit my needs?

[Wessidemike]

Guys I'm new to web development and especially new to databases. I have no programing background but I am computer literate in other aspects. I'm trying to start a small online business dealing with online book sales. I'm looking possibly for a premade php database that will do these things.

1. users need to be able to post books and information to a website.
2 other users need to be able to see the posted books and get in contact with them.
3. I need the database to send emails directly from the website so that the sending party is unaware of the recievers email address. Of coarse untill the reciever reply's. Similar to craigslist but with the email built in.
4. I also need the database to send out emails to users under certain constraints. Sorta like the book expires after x days please respond to have your book reposted or somethign similar to that.

I would like to keep costs down as much as possible. And simplicity is definitely not overated since I'm going to be learning as I go.

Oh and is PHP the way to go in this instance?

[pbmods]

Heya, Wessidemike. Welcome [back] to TSDN!

PHP is definitely a good option for this project. I doubt you are going to find a good premade setup, although there are e-commerce applications out there.

Just don't use osCommerce. I have to work on a client project that uses osCommerce, and it is a pile of @#$%.

My advice would be to write the application yourself, or else get the capital to contract someone to do it for you, if timing is essential.

Pretty much everything except for processing credit card payments is pretty easy to build (if time-consuming), and since merchant banks make a goodly-sized living off of online sales, you can be assured that they will have an easy-to-implement solution when it comes time to getting payment working!

And of course, we are here to help, too :)

If you want to go ahead with building your own app, post back, and we'll help get you started.

[kovik]

As for the emails, craigslist actually creates temporary email addresses for each post. If you are doing it straight through your website though, PHP's mail() function and the much more advanced Swiftmailer will do the job nicely.

[Wessidemike]

What is a good source to get started with learning PHP? I'm trying to get this site up in the next month or so, an easy read would be perfect. Oh i'm on a mac if that makes a difference, but i also have access to a pc laptop.

Thanks,
Mike

[kovik]

Umm.... How long have you been programming in PHP? Even if you have experience in other languages. there's a good amount of PHP that you'll need to know to make an easily maintainable website, and anything e-commerce related should be handled when you're at an experienced point in your career.

Of course, you could always get a pre-made an e-commerce application, but you wouldn't gain much knowledge from it.

[pbmods]

Heya, Mike.

Here's what I would recommend. Give yourself a week to plan it out. Focus on design and functionality. Don't worry about how to make it work; just design a system that your customers would want to use.

After the first week, take a look at what you have. Give yourself an honest estimate of how long you think it will take to build. Then double it. Post your ideas here if you want.

Odds are, you'll probably want to hire a pro to set it up, at least at first.

I think it's an admirable goal to want to learn how to program by putting together an e-commerce app, and if you had two or three months to get it done, I'd say, "Great! Post back if you get stuck!"

But if you need it in a month, I would strongly recommend pulling together the capital to have it built for you.

[Wessidemike]

anyone have an estimate for what it would cost to have this sort of application designed for me??

[kovik]

The fact that you are after anything e-commerce related will raise the price, regardless of who quotes you. I could easily get this finished in less than a month (and from your description, I could probably do it in less than two weeks flat), but I'm not exactly a cheap hire. If I wasn't currently in the middle of a project, I could probably do it for less, but having multiple projects at once requires a bit more... incentive. ;)

There are plenty of novice programmers here at the forums that would do it for much less than I would. Though you wouldn't exactly get the quality or maintainability that you are likely after, you would save money and as you learn the language, you could re-factor the code.

[Wessidemike]

I guess it is e-commerce but there will be no money transactions and there is no user signup. So i'm not TOO concerned about security. Users will only be posting their phone number, email address, and book. That's about it. Oh their last name will be the password to remove their posting from the website. Either that or they will click a link from an email that i send them to remove their post. Is this still fairly involved?

Too keep users email anonomous i wanted to built the email program into the website. That way they don't need to know the email address to email the book seller. They will find out the address if/when the seller reply's.

[pbmods]

Heya, Mike.

Ok. Let's start from the beginning.

1. users need to be able to post books and information to a website.

What kind of format are you looking for? Is this like a posting similarly to the way Craigslist does it? Or is it more like a forum, where other Users can post responses to the original post?

2 other users need to be able to see the posted books and get in contact with them.

So you want to set up a community where people can contact one another if... they are reading the same books? If they have similar views on a particular book / subject?

I guess what I'm asking is, "Under what circumstances might a User on your site want to contact another User?"

3. I need the database to send emails directly from the website so that the sending party is unaware of the recievers email address. Of coarse untill the reciever reply's. Similar to craigslist but with the email built in.

The implementation of this can be easy or hard, depending on how you do it. We'll deal with this when we get to it. For now, just assume that it will work eventually.

4. I also need the database to send out emails to users under certain constraints. Sorta like the book expires after x days please respond to have your book reposted or somethign similar to that.

Another "we'll double-cross that bridge when we get to it".

Help me out; I'm trying to understand what the site does so I can recommend how to get started.

[kovik]

So i'm not TOO concerned about security. Users will only be posting their phone number, email address, and book. That's about it. Oh their last name will be the password to remove their posting from the website. Either that or they will click a link from an email that i send them to remove their post.

*Gasp* Talk about utter lack of privacy and user protection... I sincerely hope you rethink that in it's entirety.

What do you mean by they'd ONLY be posting their personally identifiable information?? What kind of an attitude is that? The user is key, my friend. You MUST protect them. It is your job (and can technically get you sued).

[Wessidemike]

*Gasp* Talk about utter lack of privacy and user protection... I sincerely hope you rethink that in it's entirety.

What do you mean by they'd ONLY be posting their personally identifiable information?? What kind of an attitude is that? The user is key, my friend. You MUST protect them. It is your job (and can technically get you sued).

Ok let me respond to this one first. There is no user signup I don't need/want the users information. The website is, without giving my idea away an online classifieds ad exclusively for books. The information i will request of my users is their first and last name, phone number, email address, book title. The last name will not be posted on the website it will be used solely by the poster to remove his post. (either this or a link will be sent in an email to remove the post.) So the user can pick whether they want to be contacted by phone or by email or by both. You can get more information about a person by looking in the yellow pages. That is why I'm not TOO concerned about security. The users are not suplying important information. I do want the email addresses of the posters to be hidden. That's why i want the email program to be built into the website, unless someone can think of an easier more cost effective way. For example if I post a book and you want to buy my book you email me. You don't know what my email address is until i respond back to you. Because the email address will be masked by the built in email program.

[Wessidemike]

Heya, Mike.

What kind of format are you looking for? Is this like a posting similarly to the way Craigslist does it? Or is it more like a forum, where other Users can post responses to the original post?

Yes its an online classified like craigslist. I would like the information to be displayed in a form similar to the Itunes look. Where you have user, book, price presented similar to how the songs are presented , artist, song, album etc. I also want them to be able to click the (i guess it's called a reorder button) where it changes order from a-z to be z-a or low price to high price and vice versa at the users discretion.

So you want to set up a community where people can contact one another if... they are reading the same books? If they have similar views on a particular book / subject?

I guess what I'm asking is, "Under what circumstances might a User on your site want to contact another User?"

user A posts a book to the website to sell. user B searches the website for the book he needs. He sees that user A has posted the book that he needs/wants. user B then emails or calls user A to arrange a pickup. There is no money transaction over the website users arrange that themselves. And i do not charge them to use the website it's 100% free.

thanks for all your help so far, I really appreciate it.

[kovik]

Ok let me respond to this one first. There is no user signup I don't need/want the users information. The website is, without giving my idea away an online classifieds ad exclusively for books. The information i will request of my users is their first and last name, phone number, email address, book title. The last name will not be posted on the website it will be used solely by the poster to remove his post. (either this or a link will be sent in an email to remove the post.) So the user can pick whether they want to be contacted by phone or by email or by both. You can get more information about a person by looking in the yellow pages. That is why I'm not TOO concerned about security. The users are not suplying important information. I do want the email addresses of the posters to be hidden. That's why i want the email program to be built into the website, unless someone can think of an easier more cost effective way. For example if I post a book and you want to buy my book you email me. You don't know what my email address is until i respond back to you. Because the email address will be masked by the built in email program.

Okay then, that's understandable. I still don't understand why you would use their last name as a password rather than allowing them to create their own password. This would also save you the security risk of saving their "password" in plain-text.

[Wessidemike]

I found this link while searching for premade stuff... I know what i want the website to do, i just don't konw what i need to get it to do it.

http://www.fileflash.com/download/25478/

Does this sound like something i could use to write the code for me?