DaniWeb Forum Index > Web Development > PHP

csv file, ajax, php

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 35

Reputation: cali_dotcom is an unknown quantity at this point

Solved Threads: 0

cali_dotcom cali_dotcom is offline

Offline

Light Poster

csv file, ajax, php

Jul 21st, 2009

i'm parsing a csv file with ajax and php, although i think i did everything right, nothing happens when i click on the link.

here is the code:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
here is the html:
<div id="brandContainer">
<ul id="brandNav">
<li class="categorypage" id="face"><a href="javascript:showCD('a','brandPage')">A</a></li>
</ul>
<div id="brandPage"></div>
</div>
 
here is the ajax/javascript:
 
var xmlhttp
function showCD(str, div)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  }
var url="getbrands.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged(div);
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
 
function stateChanged(div)
{
if (xmlhttp.readyState==4)
{
document.getElementById(div).innerHTML=xmlhttp.responseText;
}
}
 
function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}
 
 
 
and here is the php(getbrands.php):
 
<?php
 
$q=$_GET["q"];
 
$handle = fopen("http://www.totalbeauty.com/resource/lists", "r");
while (($data = fgetcsv($handle, ";;")) !== FALSE) {
	$brands= $data[0];
    }
$brand = explode(",", $brands);
for ($i=0; $i<=count($brand); $i++){
 
	$a=strtolower($brand[$i]);
	$display = "<ul>";
	if ($q = $a[0]){
		$display .= "<li>'".$a."'</li>";
	}
	$display .="</ul>";
	echo $display;
}
 
 
?>
here is the html:
<div id="brandContainer">
<ul id="brandNav">
<li class="categorypage" id="face"><a href="javascript<b></b>:showCD('a','brandPage')">A</a></li>
</ul>
<div id="brandPage"></div>
</div>

here is the ajax/javascript<b></b>:

var xmlhttp

function showCD(str, div)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  }
var url="getbrands.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged(div);
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}

function stateChanged(div)
{
if (xmlhttp.readyState==4)
{
document.getElementById(div).innerHTML=xmlhttp.responseText;
}
}

function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}



and here is the php(getbrands.php):

<?php

$q=$_GET["q"];

$handle = fopen("http://www.totalbeauty.com/resource/lists", "r");
while (($data = fgetcsv($handle, ";;")) !== FALSE) {
	$brands= $data[0];
    }
$brand = explode(",", $brands);
for ($i=0; $i<=count($brand); $i++){
	
	$a=strtolower($brand[$i]);
	$display = "<ul>";
	if ($q = $a[0]){
		$display .= "<li>'".$a."'</li>";
	}
	$display .="</ul>";
	echo $display;
}


?>

can anyone please tell me what is wrong with this code?
thanks...

•

Join Date: Aug 2004

Posts: 47

Reputation: Banderson is an unknown quantity at this point

Solved Threads: 4

Banderson

Offline

Light Poster

Re: csv file, ajax, php

Jul 22nd, 2009

If you get an error make sure it is not an access denied. An access denied is pretty common if your on a windows server. Because your requesting xmlhttp.open("GET",url,true); and windows is funny about those things.

Try this:

here is the ajax/javascript

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
var xmlhttp;
function showCD(str, div)
{
 
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  }
var url="getbrands.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
 
function stateChanged(div)
{
if (xmlhttp.readyState==4)
{
document.getElementById(div).innerHTML=xmlhttp.responseText;
}
}
 
function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}
var xmlhttp;
function showCD(str, div)
{

xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  }
var url="getbrands.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}

function stateChanged(div)
{
if (xmlhttp.readyState==4)
{
document.getElementById(div).innerHTML=xmlhttp.responseText;
}
}

function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}

here is the html

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<div id="brandContainer">
<ul id="brandNav">
<li class="categorypage" id="face"><a href="javascript:showCD
 
('a','brandPage')">A</a></li>
</ul>
<div id="brandPage"></div>
</div>
<div id="brandContainer">
<ul id="brandNav">
<li class="categorypage" id="face"><a href="javascript<b></b>:showCD

('a','brandPage')">A</a></li>
</ul>
<div id="brandPage"></div>
</div>

and here is the php(getbrands.php)

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
$q=$_GET["q"];
 
$handle = fopen("http://www.totalbeauty.com/resource/lists", "r");
while (($data = fgetcsv($handle, ";;")) !== FALSE) {
	$brands= $data[0];
    }
$brand = explode(",", $brands);
for ($i=0; $i<=count($brand); $i++){
 
	$a=strtolower($brand[$i]);
	$display = "<ul>";
	if ($q = $a[0]){
		$display .= "<li>'".$a."'</li>";
	}
	$display .="</ul>";
	echo $display;
}
 
 
?>
<?php

$q=$_GET["q"];

$handle = fopen("http://www.totalbeauty.com/resource/lists", "r");
while (($data = fgetcsv($handle, ";;")) !== FALSE) {
	$brands= $data[0];
    }
$brand = explode(",", $brands);
for ($i=0; $i<=count($brand); $i++){
	
	$a=strtolower($brand[$i]);
	$display = "<ul>";
	if ($q = $a[0]){
		$display .= "<li>'".$a."'</li>";
	}
	$display .="</ul>";
	echo $display;
}


?>