How to start out adding entries to a db from the web.

[iniquity101]

Hello
I have created a database and i want to make it so people can use the form on it that adds the entries to the db. To do this does the db have to be on my wehost?
and what would be the best language to do this with?
Thanks
:confused:

[Jona]

You can do this with any language, but what kind of database is it? If it's MSSQL, use ASP; if it's MySQL or just SQL, I'd use PHP or CGI.

[J]ona

[iniquity101]

Its MySQL
I have signed up for webmatrix hosting, that supports Asp.net, can this be used?

[Sux0rZh@jc0rz]

im trying to figure out how to use the DB at webmatrixhosting too.. hehe

[Khalid Ali]

I a hoping ASP does support other database connection using odbc.However a natural client for MySQL will be PHP.

To enter new records/delete/update existing records you need to know some SQL

Below are three main types of SQL you must know to perform these basic steps.

SELECT
INSERT
UPDATE
DELETE

a google search will bring tonnes of resources.

once you have learned how some of these statments work,you can ask specific questions about PHP /MySQL connectivity and how to run SQL statements from PHP

[PeOfEo]

I know asp.net can use a mysql data base, It is not done often but I have seen it done, and I am willing to bet that asp classic does it in a very similar manner. Yea but with mysql I guess one naturally would use php, they sort of go hand in hand.

[Jona]

Originally posted by PeOfEo
I know asp.net can use a mysql data base, It is not done often but I have seen it done, and I am willing to bet that asp classic does it in a very similar manner. Yea but with mysql I guess one naturally would use php, they sort of go hand in hand.

I do believe that using ASP.Net with MySQL can bring up legal issues. I could be wrong, since you can't believe everything you read...
Also, PHP and MySQL go hand-in-hand so well together, that when you look at MySQL queries in PHP, you almost don't realize that it's a MySQL query. (Trust me, I should know... I'm writing a forum in PHP/MySQL, and it's almost half way done.)

[J]ona

[PeOfEo]

I dont know how using asp.net with mysql would bring up legal issues, but I know there are most definatly ways to do it.

[Sux0rZh@jc0rz]

Originally posted by PeOfEo
I dont know how using asp.net with mysql would bring up legal issues, but I know there are most definatly ways to do it.

Yeah, how would that be a problem? you pay for both, you use both.

[Jona]

Originally posted by Sux0rZh@jc0rz
Yeah, how would that be a problem? you pay for both, you use both.

Like I said:

Originally posted by Jona (that's me!)
...[Y]ou can't believe everything you read...

[J]ona

[iniquity101]

does anyone know any sites that may do tutorials ore tips fro learning a bit of php?
and any free hosting siesd that let u test you script out?
Thanks
:D

[Jona]

Originally posted by iniquity101
does anyone know any sites that may do tutorials ore tips fro learning a bit of php?
and any free hosting siesd that let u test you script out?
Thanks
:D

Um... Tutorials? I usually don't take tutorials, but there are the following sites (my recommendation is the documentation, but that doesn't apply to everyone):

http://phpfreaks.com/
http://php.net/ (I recommend this site, as it is the official documentation.)
http://devshed.com/Server_Side/PHP/
http://hotwired.lycos.com/webmonkey/programming/php/
http://phpbuilder.com/
http://zend.com/ (I also recommend this site.)
http://phpcomplete.com/

Those are a few of them, and I'm sure there are more. Try searching Google.com (http://http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=php+tutorials).

As for hosting, there are a few sites, but no free host will work very well at all--I stronlgy suggest purchasing a host. But of course, I'm sure you'll make the decision to purchase a host once you get agrivated enough by the free hosts. :D

http://t35.com/
http://compactvision.com/

[J]ona

[Ribeyed]

Khalid Ali
I a hoping ASP does support other database connection using odbc.


from what drivers i have for ODBC:

Access
dbase
Visual Fox Pro
Trieber
Oricale
SQL Server

and i would persume that every database you install would have its own ODBC driver.