okahontas 0 Newbie Poster

Hi php masters..

i manage to use an ajax combobox to shows bus fares and destination on my site and it works great in xampp..

problem start when i tried to upload the site to my host server (linux)..

the combobox contains 4 .php scripts and 1 .js script
there are 3 tables in the mysql database; origin (asal), destination (tujuan) and price (harga).

i already googling to solve my problem but still no result.. :(

thanks for you help.... :D

so here goes..

ajax.js

var xmlHttp = buatObjekXmlHttp();
   
   function buatObjekXmlHttp()
   {
      var obj = null;
      if (window.ActiveXObject)
         obj = new ActiveXObject("Microsoft.XMLHTTP");   
      else 
         if (window.XMLHttpRequest)
            obj = new XMLHttpRequest();
          
      // Check xmlHttp content
      if (obj == null)
         document.write(
            "Browser tidak mendukung XMLHttpRequest");      
      return obj;    
   }
           
   function ambilData(sumber_data, id_elemen)
   { 
      if (xmlHttp != null)
      {
         var obj = document.getElementById(id_elemen);
         xmlHttp.open("GET", sumber_data, true);

         xmlHttp.onreadystatechange = function ()
         {
            if (xmlHttp.readyState == 4 &&
                xmlHttp.status == 200)
            {
               obj.innerHTML = xmlHttp.responseText;
            }
         }  
         
         xmlHttp.send(null);
      }
   }

infotujuan.php

<html>
<head>
<title>Mencari Data Tujuan</title>

<script type="text/javascript" src="ajax.js">
</script>
<script type="text/javascript">
function tampilkanPilihanNegara()
{
   var elemen_benua = document.getElementById("id_benua");
   var nama_benua = elemen_benua.value;

   if (nama_benua == '--')
   {
      
      var lokasi_negara = 
         document.getElementById("id_lokasi_negara");
      lokasi_negara.innerHTML = "";
      
      var lokasi_ket = 
         document.getElementById("id_lokasi_keterangan");
      lokasi_ket.innerHTML = "";
      
      return;
   }   

   var url = "pilihtujuan.php?benua=" + nama_benua ;
   ambilData(url, "id_lokasi_negara");
}

function tampilkanInfoNegara()
{
   var elemen_id_negara = document.getElementById("id_negara");
   var id_negara = elemen_id_negara.value;
   
   if (id_negara == '--')
   {
      var lokasi_ket = 
         document.getElementById("id_lokasi_keterangan");
      lokasi_ket.innerHTML = "";
      
      return;
   }   
      
   var url = "kettujuan.php?id=" + id_negara;
   ambilData(url, "id_lokasi_keterangan");      
}
</script>
</head>
<body>
<form>
<table>
<tr>
<td>Asal:</td>
<td>
<select name="selectbenua" id="id_benua"
        onchange="tampilkanPilihanNegara();">
<?php
  require_once("koneksi.php");
  
  $sql = "SELECT `lokasiasal`.`asal`\n"
    . "FROM `lokasiasal`\n"
    . "ORDER BY `lokasiasal`.`asal`";
  
  $hasil = mysql_query($sql);
  if ($hasil)
  {
     print("<option value=\"--\" selected=\"selected\">" .
           "-- Pilih Asal --</option>\n");
           
     while ($baris = mysql_fetch_row($hasil))
     {
        $benua = $baris[0];
        print("<option value=\"$benua\">$benua</option>\n");
     }        
     
     
  }   
  mysql_close($id_mysql);    
?>
</select>
</td>
</tr>
<tr>
<td>Tujuan:</td>
<td><span id="id_lokasi_negara"></span></td>
</tr>
<tr>
<td>Keterangan:</td>
<td></td>
</tr>
<tr>
<td><span id="id_lokasi_keterangan"></span></td>
</tr>
</table>       
</form>
<div id="id_info"></div>       
</body>
</html>

kettujuan.php

<?php
  header("Cache-Control: no-cache, must-revalidates");
  header("Expires: Mon, 26 Jul 1997 00:00:00 GMT");
  
  require_once("koneksi.php");
  
  $id_negara = $_GET["id"]; // Get URL Variable
 
  $sql = "SELECT `lokasiasal`.`asal`, `lokasitujuan`.`tujuan`, `tabelharga`.`harga`\n"
    . "FROM `lokasiasal`\n"
    . " LEFT JOIN `daftarharga`.`tabelharga` ON `lokasiasal`.`id_asal` = `tabelharga`.`id_asal` \n"
    . " LEFT JOIN `daftarharga`.`lokasitujuan` ON `tabelharga`.`id_tujuan` = `lokasitujuan`.`id_tujuan` \n"
    . " WHERE tujuan = '$id_negara'";
  
  	$hasil = mysql_query($sql);
  if (!$hasil)
     print("Query tak dapat diproses");  /* <<<< this always came out every time i choose one of the combobox options */               
  else
  {
     $baris = mysql_fetch_row($hasil);
     $data_ada = TRUE;
     if (empty($baris))
     {
        print("Tak ada yang memenuhi!");
        $data_ada = FALSE;
     }   
        
     if ($data_ada)
     {
        // Creating Tables and column headers
        print("<table border='1'>\n");
        print("<tr>\n");
        print("<td>Asal</td>\n");
        print("<td>Tujuan</td>\n");
        print("<td>Harga</td>\n");
        print("</tr>\n");   
     }   
           
     while ($baris)
     {
        $asal		= $baris[0];
        $tujuan		= $baris[1];
        $harga		= $baris[2];

        // show to table
        print("<tr>\n");
        print("<td>$asal</td>\n");
        print("<td>$tujuan</td>\n");
        print("<td>$harga</td>\n");
        print("</tr>\n");   
        // Read next data        
        $baris = mysql_fetch_row($hasil);
     }
     
     if ($data_ada)
        print("</table>\n");     
  }   
?>

pilihtujuan.php

<?php
  header("Cache-Control: no-cache, must-revalidates");
  header("Expires: Mon, 26 Jul 1997 00:00:00 GMT");
  
  require_once("koneksi.php");
  
  $benua = $_GET["benua"]; // Get URL Variable
  
  $sql = "SELECT `lokasiasal`.`asal`, `lokasitujuan`.`tujuan`, `tabelharga`.`harga`\n"
    . "FROM `lokasiasal`\n"
    . " LEFT JOIN `daftarharga`.`tabelharga` ON `lokasiasal`.`id_asal` = `tabelharga`.`id_asal` \n"
    . " LEFT JOIN `daftarharga`.`lokasitujuan` ON `tabelharga`.`id_tujuan` = `lokasitujuan`.`id_tujuan` \n"
    . " WHERE asal = '$benua'";
		        
  $hasil = mysql_query($sql);
  if (!$hasil)
     print("Query tak dapat diproses");                
  else
  {
     $baris = mysql_fetch_row($hasil);
     
     $data_ada = TRUE;
     if (empty($baris))
     {
        print("Tak ada yang memenuhi!");
        $data_ada = FALSE;
     }   
        
     if ($data_ada)
     {
        // Create Options
        print("<select id='id_negara' " .
              "onchange='tampilkanInfoNegara()'>\n");             
        print("<option value=\"--\" selected=\"selected\">" . 
              "-- Pilih Tujuan --</option>");          
     }   
           
     while ($baris)
     {
        $asal 		= $baris[0];
        $tujuan    	= $baris[1];
		$harga		= $baris[3];
        // Show to options
        print("<option value=\"$tujuan\">$tujuan</option>");   

        // Read next data        
        $baris = mysql_fetch_row($hasil);
     }
	if ($data_ada)
        print("</table>\n");  
  }   
?>

and the last one is connection (koneksi.php)

<?php
  define("NAMA_SERVER", "localhost");
  define("PEMAKAI", "*******");
  define("PASSWORD", "******");
  define("DATABASE", "******");
  
  $id_mysql = mysql_connect(NAMA_SERVER, PEMAKAI, PASSWORD);
  if (!$id_mysql)
     die("Koneksi ke server gagal");
     
  $db_daftarharga = mysql_select_db(DATABASE, $id_mysql);
  if (!$db_daftarharga)
     die("Koneksi ke server gagal");  
?>