MySQL database in HTML page

Question

1.00/5 (1 vote)

See more:

Hi....
I want to connect MySQL database in my HTML page. I want to insert and retrieve data using MySQL database which I have created using phpMyadmin in WAMP server. How can it possible using HTML 5. I saw many examples for creating table and insert, delete etc. But first I have to connect the database to my HTML page. Then insert data into the database and retrieve data from it. I also want to connect a remote database in my HTML page. I searched on google and none of them helped me. If you have any idea, please share.

Thank you....

Posted 10-Aug-12 20:01pm

Neha Thanka

Updated 7-Dec-17 19:03pm

Add a Solution

Comments

Mohibur Rashid 11-Aug-12 13:47pm

what was the search string you used?

and besides, you cannt connect mysql with html you need to use php

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kislay Raj · Answer 1 · 2012-08-11T21:48:00

I think you can't connect MySQL database in html page directly but there is some way to hiding the backhand/server side scripting code's and display html pages. now I am talking about php(because of WAMP).
Create a php file first to make connection to mysql
for example connect.php

PHP

<?
$host="localhost"; // Host name.
$db_user="root"; // MySQL username.
$db_password=""; // MySQL password.
$database="test"; // Database name.
$link = mysql_connect($host,$db_user,$db_password);
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
else
{
echo "Mysql Connected Successfully";
}

mysql_close($link);
?>

and Create a Index.html using ajax

HTML

<html>
<head>
<script type="text/javascript">
function checkmyconnect()
{
var xmlhttp;
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","connect.php",true);
xmlhttp.send();
}
</script>
</head>
<body>
<h2>Let Connect to mysql in html file</h2>
<div id="myDiv">No connection</div>
<button type="button"  önclick="checkmyconnect()">Check Mysql connection</button>

</body>
</html>

and test now