FirstSearch Blue

View Comments (14)

• Hi, great shortcut. I have one question, how can I check login status of drupal user in my custom php file.

• Great information! I’ve been looking for something like this for a while now. Thanks!

• This does not work for me.I have been working on how to implement a search of this sort for over a 1 1/2 months using every possible way. But everything I have tried will not work.
  Please help!

  • This example is good (with some correction:-))

    function ajaxFunction(){
    var ajaxRequest; // The variable that makes Ajax possible!
    try{
    // Opera 8.0+, Firefox, Safari
    ajaxRequest = new XMLHttpRequest();
    } catch (e){
    // Internet Explorer Browsers
    try{
    ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
    } catch (e) {
    try{
    ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
    } catch (e){

    // Something went wrong
    alert("Your browser broke!");

    return false;
    }
    }
    }

    // Create a function that will receive data sent from the server
    ajaxRequest.onreadystatechange = function(){
    if(ajaxRequest.readyState == 4){

    var ajaxDisplay = document.getElementById('ajaxDiv');
    ajaxDisplay.innerHTML = ajaxRequest.responseText;
    }
    }

    var lastphp = document.getElementById('lastphp').value;
    var queryString = "?lastphp=" + lastphp;

    ajaxRequest.open("GET", "/sites/all/modules/modulename/check.php" + queryString, true);

    ajaxRequest.send(null);

    }

    Last Name:

    ///-----------------------------------------------------------------------------//

    check.php script

    <?php

    //Connect to MySQL Server

    //connect to your database ** EDIT REQUIRED HERE **

    mysql_connect("localhost","username","password") or die('Cannot connect to the database because: ' . mysql_error());

    //specify database ** EDIT REQUIRED HERE **

    mysql_select_db("database") or die("Unable to select database"); //select which database we’re using

    // Retrieve data from Query String
    $last = $_GET['lastphp'];
    // Escape User Input to help prevent SQL Injection
    $last = mysql_real_escape_string($last);
    //Build and run a SQL Query on our MySQL tutorial
    $query = "SELECT * from table where lastname LIKE '%" . $last . "%'"; //just grab every row from our table

    $results = mysql_query($query)or die(mysql_error());
    //print what the user entered (eventually I’m sure you’ll want to use this data in your query)

    echo "You Entered: " . $last . "";

    //print the results

    echo "Database Results: ";

    while($row = mysql_fetch_array($results)){

    echo $row['lastname'].""; //NOTE: Here we are printing all the data from the ‘lastname’ column of our database, either change this name, or make sure you have a //lastname column with some data in it

    }

    ?>

    • check.php script
      ---------------------------------------------
      <?php

      //Connect to MySQL Server
      //connect to your database ** EDIT REQUIRED HERE **

      mysql_connect("localhost","username","password") or die('Cannot connect to the database because: ' . mysql_error());

      //specify database ** EDIT REQUIRED HERE **

      mysql_select_db("database") or die("Unable to select database"); //select which database we’re using

      // Retrieve data from Query String

      $last = $_GET['lastphp'];

      // Escape User Input to help prevent SQL Injection

      $last = mysql_real_escape_string($last);

      //Build and run a SQL Query on our MySQL tutorial

      $query = "SELECT * from table where lastname LIKE '%" . $last . "%'"; //just grab every row from our table

      $results = mysql_query($query)or die(mysql_error());

      //print what the user entered (eventually I’m sure you’ll want to use this data in your query)

      echo "You Entered: " . $last . "";

      //print the results

      echo "Database Results: ";

      while($row = mysql_fetch_array($results)){

      echo $row['lastname'].""; //NOTE: Here we are printing all the data from the ‘lastname’ column of our database, either change this name, or make sure you have a //lastname column with some data in it

      }

      ?>

• It works well for us, as per my programmer. Thanks for sharing this excellent small tutorial with us.

• I found that if copy the example it doesn't work.... I don't know why... maybe it's a format problem (I have deactivated CK editor(rich editor text) but the problem persisted)... when I wrote the example, all was OK.

• Does this work with a the webform module in Drupal?

• Hello
  This is reza. I think you can make query with multiple query parameter using Ajax using the same concept........

• Can anyone send a link as to what this should look like in action, on a live page?

• For some reason, my button does not show. What was created instead is a box with the word 'Search' and I can type in that box. What did I do wrong?

• Search button is not enabled on this, can anyone see this problem ?

  • I fixed the button, but I can't seem to get any results. Is this post being monitored anymore? I would love to see this work. 

    To fix the button, I replaced the line that makes the button and put in this line:  and as you see it is a little different.

    Let me know if you are able to make the query work.