how are you using mySQL?

[get.Mos]

hello, all:

i'm not new to databases, but i am new to database-driven websites. i've not created one before, but i am currently in the process of reading a book on database-driven websites, but i was wondering, for all you mySQL experts out there or those using mySQL, how are you using it? i would really love to hear specifics, such as allowing queries on your site, etc.

additionally, can anyone tell me if the following is possible:

- data entry into the db via a login gui on the website?
- after new record submitted into db, redirect page is a page itemizing that particular entry? (this would be used to give a printable copy of the entry for papertrail purposes)
- after new record is submitted to db, autoemail is sent to email address submitted (email address is a field), confirming that that record entry into db? (there must also be a way to confirm this email is valid -- can the db do this?)
- querying the db, but only querying records that user entered?

thanks in advance for any help offered.

[garyf]

Sounds like you need to look at CodeCharge or CodeCharge Studio

www.codecharge.com

hth
garyf

[devinemke]

i run several sites on powweb but the main database driven one is a literary magazine. We sell subscriptions via the website and use mySQL to maintain our sunscriber and submission data. mySQL is pretty easy to use but it does lack some basic features that othe db's have (most notably subqueries).

All of the tasks you mentioned can be easily accomplished with PHP/mySQL and your book should cover them. I don't which book your reading but I hear good things about the Kevin Yank book (www.sitepoint.com).

[Mechtech]

function valid_email($email)
if (ereg("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$", $email))
{
return true;
}
else
{
return false;
}


that is one way to check and make sure it is a valid email address Mysql cant do this.... as far as i know