i getting undefined on username $sql should returned data query.
$('#userlist').on('change', function () { var selected = $("select option:selected").text(); console.log(selected); // use ajax run check $.ajax({ url: '/php/connect/userdropdowncheck.php', type: 'json', data: selected, success: formfill, error: function (xhr, status, err) { console.log(xhr, status, err); } }); function formfill(sql) { var username = sql['userlogin']; var email = sql['useremail']; var admin = sql['admin']; var firstname = sql['firstname']; var lastname = sql['lastname']; var title = sql['title']; var company = sql['company']; console.log(username); if (username.length > 0) { console.log('found user'); console.log(username); $('#username').html($username); } else { console.log('failed find user'); } } }); php code:
<?php session_start(); include 'anonconnect.php'; // username , password sent form $myusername= $_post['selected']; $sql = $dbh->prepare("select * users userlogin= :login"); $sql->execute(array(':login' => $myusername)); $user = $sql->fetch(); /*** close database connection ***/ $dbh = null; if($user->rowcount() == 1){ echo 1; echo json_decode($user); else { echo 0; } ?> it pulling text selected drop down fine , passing function on return cannot find it.
your jquery code be:
function formfill(sql) { var username = sql['userlogin']; var email = sql['useremail']; var admin = sql['admin']; var firstname = sql['firstname']; var lastname = sql['lastname']; var title = sql['title']; var company = sql['company']; console.log(username); if (username.length > 0) { console.log('found user'); console.log(username); $('#username').html($username); } else { console.log('failed find user'); } } $('#userlist').on('change', function () { var selected = $("select option:selected").text(); $.ajax({ url: '/php/connect/userdropdowncheck.php', type: 'post', data: {userlogin:selected}, success: function(data){ formfill(data) }, error: function (xhr, status, err) { console.log(xhr, status, err); } }); }); and php code:
<?php session_start(); include 'anonconnect.php'; // username , password sent form $myusername= $_post['userlogin']; $sql = $dbh->prepare("select * users userlogin= :login"); $sql->execute(array(':login' => $myusername)); $user = $sql->fetch(); /*** close database connection ***/ $dbh = null; if($sql->rowcount() == 1){ //echo 1; //if echo cause jquery code not able read response json , serialize in array echo json_encode($user); // php array json object } else { echo 0; } ?> 