Get Data From MySQL Using PHP

Introduction

In this article I explain Get data from MySQL using jQuery with PHP. I am using a simple HTML form and a JavaScript function with a MySQL table for creating this phenomenon. Such that the user enters a name and fetch your table user enter name correct or not.

First of all, create a new database and table in your MySQL and insert some data. Such as:

Then create a HTML form for displaying the data, such as:

<html>

<head>

<title>Untitled Document</title>

function get() {

$('#age').hide();

$.post('data.php', { name: form.name.value },

function (output) {

$('#age').html(output).fadeIn(1000);

});

}

</script>

</head>

</p>

//show your data in div section though 'id'

</form>

</p>

</body>

</html>

In this form I provided a JavaScript function in the head section.

This is a PHP script file. In this file is your database connection.

<?php

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

$name= mysql_real_escape_string($_POST['name']);

$age= mysql_query("select age from vinod.people where name='$name'");

$age_num_rows=mysql_num_rows($age);

if($name==null)

echo "please enter name!";

else

{

if($age_num_rows==0)

echo "name does not exist!";

else

{

$age=mysql_result($age,0);

echo "$name age is $age";

}}

You can use this article just like that. When enter a blank text box then a message like this is shown:

When the user enters the wrong name then a message like this is shown:

When the user enters the correct name then a message like this is shown: