php mysql 选择字段,当选择选项时使用值填充输入字段 - php mysql

I have a form that i would like to submit details when an option is selected from the database.

The mysql database table [USERS]contains fields like [email],[age],[name].I want to be able to populate the other fields when one field is selected from the menu.

User

-- Select User --

Mark

Paul

Hannah

Age

Email

How do i acheive this using jquery or javascript.

解决方案

Please Try this,

on your HTML page:

write this to your html page,

$(document).ready(function(){

$('#user').on('change',function(){

var user = $(this).val();

$.ajax({

url : "getUser.php",

dataType: 'json',

type: 'POST',

async : false,

data : { user : user},

success : function(data) {

userData = json.parse(data);

$('#age').val(userData.age);

$('#email').val(userData.email);

}

});

});

});

in getUser.php:

getUser.php

$link = mysqli_connect("localhost", "user", "pass","mydb");

$user = $_REQUEST['user'];

$sql = mysqli_query($link, "SELECT age,email FROM userstable WHERE name = '".$user."' ");

$row = mysqli_fetch_array($sql);

json_encode($row);die;