Ad:

PHP Discussion Thread
Marked Solved
Views: 749

Jun 26th, 2010

Ajax in my php

Expand Post »

High guyz am tryin to get hint from my database but i am managing to do so,though if i list the array am able. please help if any one has an idea

here is the html code

PHP Syntax (Toggle Plain Text)
<html>
<head>
<script type="text/javascript">
function showHint(str)
{
if (str.length==0)
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
</head
<body>
 
<p><b>Start typing a name in the input field below:</b></p>
<form>
First name: <input type="text" onkeyup="showHint(this.value)" size="20" />
</form>
<p>Suggestions: <span id="txtHint"></span></p>
 
</body>
</html>
<html>
<head>
<script type="text/javascript">
function showHint(str)
{
if (str.length==0)
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
</head
<body>

<p><b>Start typing a name in the input field below:</b></p>
<form>
First name: <input type="text" onkeyup="showHint(this.value)" size="20" />
</form>
<p>Suggestions: <span id="txtHint"></span></p>

</body>
</html>

and the php code looks like this

PHP Syntax (Toggle Plain Text)
<?php
// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";
$a[]="Liza";
$a[]="Elizabeth";
$a[]="Ellen";
$a[]="Wenche";
$a[]="Vicky";
 
//get the q parameter from URL
$q=$_GET["q"];
 
//lookup all hints from array if length of q>0
if (strlen($q) > 0)
  {
  $hint="";
  for($i=0; $i<count($a); $i++)
    {
    if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
      {
      if ($hint=="")
        {
        $hint=$a[$i];
        }
      else
        {
        $hint=$hint." , ".$a[$i];
        }
      }
    }
  }
 
// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="no suggestion";
  }
else
  {
  $response=$hint;
  }
 
//output the response
echo $response;
?>
<?php
// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";
$a[]="Liza";
$a[]="Elizabeth";
$a[]="Ellen";
$a[]="Wenche";
$a[]="Vicky";

//get the q parameter from URL
$q=$_GET["q"];

//lookup all hints from array if length of q>0
if (strlen($q) > 0)
  {
  $hint="";
  for($i=0; $i<count($a); $i++)
    {
    if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
      {
      if ($hint=="")
        {
        $hint=$a[$i];
        }
      else
        {
        $hint=$hint." , ".$a[$i];
        }
      }
    }
  }

// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="no suggestion";
  }
else
  {
  $response=$hint;
  }

//output the response
echo $response;
?>

Similar Threads

How can I pass large amounts of information through AJAX? in PHP
Using AJAX and PHP Resources and Tutorial in JavaScript / DHTML / AJAX

Jothe

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

22 posts
since Jun 2010

Permalink

Jun 26th, 2010

Re: Ajax in my php

hehe your ajax example is from w3schools...

ok first make a database for names, then query them all

then changed this part from an array

PHP Syntax (Toggle Plain Text)
// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";
$a[]="Liza";
$a[]="Elizabeth";
$a[]="Ellen";
$a[]="Wenche";
$a[]="Vicky";
// Fill up array with names
$a[]="Anna";
$a[]="Brittany";
$a[]="Cinderella";
$a[]="Diana";
$a[]="Eva";
$a[]="Fiona";
$a[]="Gunda";
$a[]="Hege";
$a[]="Inga";
$a[]="Johanna";
$a[]="Kitty";
$a[]="Linda";
$a[]="Nina";
$a[]="Ophelia";
$a[]="Petunia";
$a[]="Amanda";
$a[]="Raquel";
$a[]="Cindy";
$a[]="Doris";
$a[]="Eve";
$a[]="Evita";
$a[]="Sunniva";
$a[]="Tove";
$a[]="Unni";
$a[]="Violet";
$a[]="Liza";
$a[]="Elizabeth";
$a[]="Ellen";
$a[]="Wenche";
$a[]="Vicky";

PHP Syntax (Toggle Plain Text)
$sql = mysql_query("SELECT name FROM users"); //sample table users
while($row=mysql_fetch_array($sql)){
$a[] = $row['name'];
}
$sql = mysql_query("SELECT name FROM users"); //sample table users
while($row=mysql_fetch_array($sql)){
$a[] = $row['name'];
}

Last edited by vaultdweller123; Jun 26th, 2010 at 8:10 am.

vaultdweller123

Reputation Points: 32

Solved Threads: 60

Posting Pro in Training

Offline

484 posts
since Sep 2009

Permalink

Jun 26th, 2010

Re: Ajax in my php

First of all please rephrase your question.

Secondly, I recommend to use jQuery instead of reinventing the wheel again in using ajax.

Thirdly, i believe that w3schools ajax code is not correct since it was not working with me under some circumstances. Change the line 27 from

PHP Syntax (Toggle Plain Text)
xmlhttp.send(); to xmlhttp.send(NULL);
xmlhttp.send(); to xmlhttp.send(NULL);

shubhamjain1

Reputation Points: 17

Solved Threads: 14

Junior Poster in Training

Offline

56 posts
since Oct 2009

Permalink

Jun 28th, 2010

Re: Ajax in my php

@vaultdweller123 thanx the code worked...and yes code is from W3schools.
@shubhamjain1 the code for w3schools works alright but you need to understand it, in this case if you changed the last part of the code

PHP Syntax (Toggle Plain Text)

xmlhttp.send();

PHP Syntax (Toggle Plain Text)

xmlhttp.send(arguments);

it will work under all circumstances..thanx anyway

Jothe

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

22 posts
since Jun 2010

Permalink

Jun 28th, 2010

Re: Ajax in my php

@vaultdweller123 tha code worked for a few minutes when i came back it gave me the following error:
mysql_fetch_array() expects parameter 1 to be resource, boolean. the warning is shown at the following line

PHP Syntax (Toggle Plain Text)
while($row=mysql_fetch_array($query, $db) or die(mysql_error))
while($row=mysql_fetch_array($query, $db) or die(mysql_error))

Jothe

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

22 posts
since Jun 2010

Permalink

Jun 28th, 2010

Re: Ajax in my php

just stick to my original code and you'll do fine

PHP Syntax (Toggle Plain Text)
$sql = mysql_query("SELECT name FROM users"); //sample table users
while($row=mysql_fetch_array($sql)){
$a[] = $row['name'];
}
$sql = mysql_query("SELECT name FROM users"); //sample table users
while($row=mysql_fetch_array($sql)){
$a[] = $row['name'];
}

Last edited by vaultdweller123; Jun 28th, 2010 at 10:29 am.

vaultdweller123

Reputation Points: 32

Solved Threads: 60

Posting Pro in Training

Offline

484 posts
since Sep 2009

Permalink

Jun 29th, 2010

Re: Ajax in my php

thanx ur code helped me alot tho it didn't work as surposed so i changed some part of code and it worked..i changed it to

PHP Syntax (Toggle Plain Text)
$query = 'SELECT name FROM ecomm_products ORDER BY product_code';
$result= mysql_query($query, $db) or die(mysql_error($db));
while($row =mysql_fetch_assoc($result)){
    foreach($row as $value){
     $a[] = $row['name'];
    }
}
$query = 'SELECT name FROM ecomm_products ORDER BY product_code';
$result= mysql_query($query, $db) or die(mysql_error($db));
while($row =mysql_fetch_assoc($result)){
    foreach($row as $value){
     $a[] = $row['name'];
    }
}

thanx anyway

Jothe

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

22 posts
since Jun 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Values from for loop into database

Next Thread in PHP Forum Timeline: How to Save Value Multiple Dropdown

DaniWeb Message

Cancel Changes

User Name
Password