I am doing a simple webpage with pure html codes and I want it to connect with database(MySQL)... I have no any idea if it is possible to connect a database with html code only...

so..my question is:
Can i work with database with just html codes? if so..how can I connect a database?
or if not.. what should I do so that I can work with database? what are the codes?

somebody...thanks...

You might be able to connect to SQLite using JavaScript, but other than that, you'll need to use a server language like PHP or ASP to connect to a database like MySQL, PostgreSQL, etc. You won't be able to do it with just HTML.

JavaScript should be able to do it, at least against SQL Server. But you have to configure the database in a way that most hosts won't allow, due to risk. Plus, we're not talking about Microsoft products.

To get into (ie connect to) a database, you need to supply credentials. Those tend to come in one of two forms. Either you've got a user name and pass phrase combination, or you're logged into a network (typically Windows NT) and by virtue of your AD account, you're granted (or denied!) access to the database. With HTML, we have a problem.

The markup can run on any computer or cell phone in the world. So right there, single sign on is out. And because I can look at a web page, and email it to someone else, you can't put a password into it!

That leaves ASP.NET, PHP, or some other server side development framework. What these do is run your custom logic (ie querying a database) and then build an HTML web page from what it learns.

And that, in turn, brings up another issue. A database doesn't answer your queries in HTML format. The server code takes the answer, and converts it into something your browser knows how to display.

http://us3.php.net/mysql_connect

Your going to need more than that but php.net will get you started in the right direction.

imo this is a bad idea. You would need to use javascript and more precisly ajax to make the server calls. This would still leave you needing something server side to answer the ajax calls. In MS SQL you can set the server up to deliver XML over http which would work fine but I am not aware of MySql having this ability. I would also tend to keep the database server bound and behind a layer of abstraction (ie some code). Better to bite the bullet and learn a language (i recommend php or ruby for beginer). When starting out a little code can go a long way. You are really just following the pattern:

1. Get data from database.
2. Do some processing/formatting.
3. Render data to screen.

very quick to learn these basics.

If you really cannot do this I would take the route of prebuilding the html files from the database. I assume you know how to query a database, so (horrible as it may be), you could write queries to generate the html content on a nightly basis and then upload these.

I would imagine that there would also be significant security issues if you're connecting through JavaScript as it's viewable from the browser. The only way I would recommend it is if you're building a desktop app using Adobe AIR.