Databases
StackOverflow2013
Postsdbo
POreturned ajax query data undefined
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POreturned ajax query data undefined
    primarykey
    data
    text
    <p>Hello I am attempting to create an ajax query but when my results are returned I get <strong>Undefined</strong> as a response. Except for the object called "hello" which returns back as "h" even though it is set to "hello". I have a feeling it has something to do with the way ajax is sending the data but i'm lost as to what may be the issue. Any help would be greatly appreciated.</p> <p><strong>here is the ajax</strong></p> <pre><code>function doSearch() { var emailSearchText = $('#email').val(); var keyCardSearchText = $('#keyCard').val(); var userNameSearchText = $('#userName').val(); var pinSearchText = $('#pin').val(); var passwordSearchText = $('#password').val(); $.ajax({ url: 'process.php', type: 'POST', data: { "hello": "hello", "emailtext": "emailSearchText", "keycardtext": "keyCardSearchText", "usernametext": "userNameSearchText", "pinText": "pinSearchText", "passwordtext": "passwordSearchText" }, dataType: "json", success: function (data) { alert(data.msg); var mydata = data.data_db; alert(mydata[0]); } }); } </code></pre> <p><strong>Then here is the php</strong></p> <pre><code>include_once('connection.php'); if(isset($_POST['hello'])) { $hello = $_POST['hello']; $emailSearchText = mysql_real_escape_string($_POST['emailSearchText']); $keyCardSearchText = mysql_real_escape_string($_POST['keyCardSearchText']); $userNameSearchText = mysql_real_escape_string($_POST['userNameSearchText']); $pinSearchText = mysql_real_escape_string($_POST['pinSearchText']); $passwordSearchText = mysql_real_escape_string($_POST['passwordSearchText']); $query = "SELECT * FROM Students WHERE (`User name`='$userNameSearchText' OR `Email`='$emailSearchText' OR `Key Card`='$keyCardSearchText')AND(`Password`='$passwordSearchText'OR `Pin`='$pinSearchText')"; $students = mysql_query($query); $count = (int) mysql_num_rows($students); $data = array(); while($student = mysql_fetch_assoc($students)) { $data[0] = $student['First Name']; $data[1] = $student['Last Name']; $data[2] = $student['Date of last class']; $data[3] = $student['Time of last class']; $data[4] = $student['Teacher of last class']; $data[5] = $student['Membership Type']; $data[6] = $student['Membership Expiration Date']; $data[7] = $student['Free Vouchers']; $data[8] = $student['Classes Attended']; $data[9] = $student['Classes From Pack Remaining']; $data[10] = $student['5 Class Packs Purchased']; $data[11] = $student['10 Class Packs Purchased']; $data[12] = $student['Basic Memberships Purchased']; $data[13] = $student['Unlimited Memberships Purchased']; $data[14] = $student['Groupon Purchased']; }; echo json_encode(array("data_db"=&gt;$data, "msg" =&gt; "Ajax connected. The students table consist ".$count." rows data", "success" =&gt; true)); }; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSteve Beaty
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COdata should be a string with the json; eval() it in your js. (=> is a wrong idea)
      singulars
      1. POreturned ajax query data undefined
      1. USbwoebi
    2. CO@bwoebi No it shouldn't. With `dataType: "json"` jquery handles that for you.
      singulars
      1. POreturned ajax query data undefined
      1. USJames Montagne
    3. CO@bwoebi, please put that as an answer so I can downvote it.
      singulars
      1. POreturned ajax query data undefined
      1. USDerek S. Henderson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload