[SOLVED] need help with AJAX script

Alith7 · February 23, 2009

I'm trying to modify an Ajax script that was posted elsewhere on the site and I'm getting no where. I'm trying to update the two text fields "quote_to" and "email_to" when the "customer" drop down list is changed.

Any ideas?? I know the script is a bit of a mess. :-\

<?php require_once('Connections/geQuote.php'); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "quote";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "noaccess.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = "quote.php";
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

$editFormAction = "quote.php";
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insertQuote")) {
  $insertSQL = sprintf("INSERT INTO quote (sales_id, cust_id, quote_to, email_to, title, quote, created) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['sales_id'], "int"),
                       GetSQLValueString($_POST['cust_id'], "int"),
                       GetSQLValueString($_POST['quote_to'], "text"),
                       GetSQLValueString($_POST['email_to'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['quote'], "text"),
                       $_POST['created']);

  mysql_select_db($database_geQuote, $geQuote);
  $Result1 = mysql_query($insertSQL, $geQuote) or die(mysql_error());

  $insertGoTo = "quote_listsort.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_geQuote, $geQuote);
$query_listSales = "SELECT salesrep.sales_id, CONCAT(salesrep.first_name,' ', salesrep.last_name) AS salesRep FROM salesrep ORDER BY salesrep.last_name, salesrep.first_name";
$listSales = mysql_query($query_listSales, $geQuote) or die(mysql_error());
$row_listSales = mysql_fetch_assoc($listSales);
$totalRows_listSales = mysql_num_rows($listSales);

mysql_select_db($database_geQuote, $geQuote);
$query_listCustomer = "SELECT customer.cust_id, customer.name FROM customer ORDER BY customer.name";
$listCustomer = mysql_query($query_listCustomer, $geQuote) or die(mysql_error());
$row_listCustomer = mysql_fetch_assoc($listCustomer);
$totalRows_listCustomer = mysql_num_rows($listCustomer);

$selected=mysql_select_db($database_geQuote, $geQuote);
      if( isset($_POST['Submit']) )
      {
         echo "<pre>";
         print_r($_POST);
      }
      if( isset($_GET['ajax']) )
   {
      //In this if statement
      switch($_GET['cust_id'])
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         echo "{$row_custData['dbinfo']}";
      }
      exit; //we're finished so exit..
   }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Graphic Edge Printing</title>

<script language="javascript">
   function ajaxFunction(ID, Param)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
      
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
      
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
              //the line below reset the third list box incase list 1 is changed
              document.getElementById('quote_to').innerHTML = "";
		  
		   //the line below reset the second list box incase list 1 is changed
              document.getElementById('email_to').innerHTML = "";
              
              //THIS SET THE DAT FROM THE PHP TO THE HTML
            document.getElementById(cust_id).innerHTML = xmlHttp.responseText;
           }
      }
       xmlHttp.open("GET", loaderphp+"?ID="+ID+"&ajax="+Param,true);
       xmlHttp.send(null);
   }
</script>

<?php include('style_rules.php'); ?>
</head>

<body>
<div id="wrapper">
  <div id="titlebar"><img src="images/header.jpg" alt="Graphic Edge Printing" /></div>
  <div id="maincontent">
    <div id="nav">
      <?php include('navbar.php'); ?>
    </div>
    <h1>New Quote</h1>
    <form action="<?php echo $editFormAction; ?>" method="POST" name="insertQuote" id="insertQuote" target="_self">
      <p><table width="650">
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Sales Rep: </h2>
        </div></td>
        <td><select name="sales_id" id="sales_id">
          <?php
do {  
?>
          <option value="<?php echo $row_listSales['sales_id']?>"><?php echo $row_listSales['salesRep']?></option>
          <?php
} while ($row_listSales = mysql_fetch_assoc($listSales));
  $rows = mysql_num_rows($listSales);
  if($rows > 0) {
      mysql_data_seek($listSales, 0);
  $row_listSales = mysql_fetch_assoc($listSales);
  }
?>
        </select>
</td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Customer:</h2>
        </div></td>
        <td><select name="cust_id" id="cust_id" onchange="ajaxFunction('quote_to', this.value);">
          <?php
do {  
?>
          <option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
          <?php
} while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  $rows = mysql_num_rows($listCustomer);
  if($rows > 0) {
      mysql_data_seek($listCustomer, 0);
  $row_listCustomer = mysql_fetch_assoc($listCustomer);
  }
?>
        </select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td><input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>
      </tr>
  <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>
   <tr>
        <td width="200" height="25"><div align="right">
          <h2>Title:</h2>
        </div></td>
        <td><input name="title" type="text" class="widebox" id="title" maxlength="255" /></td>
      </tr>
      <tr>
        <td width="200" height="25" valign="top"><div align="right">
          <h2>Quote:</h2>
        </div></td>
        <td><textarea name="quote" id="quote" cols="54" rows="25"></textarea></td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right"></div></td>
        <td><input type="submit" name="Submit" value="Submit Quote" /></td>
      </tr>
    </table>
    <input name="created" type="hidden" id="created" value="NOW()" />
    <input type="hidden" name="MM_insert" value="insertQuote">
    </form>
  </div>
  <div id="footer"><?php include('copyright.php'); ?></div>
</div>
</body>
</html>
<?php
mysql_free_result($listSales);

mysql_free_result($listCustomer);
?>

MadTechie · February 24, 2009

After a quick look.. i seams theirs a few things that would cause problems..

1.

case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=",$_GET['ajax']);
         break;

should probably be

case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;

also why are you clearing these

document.getElementById('quote_to').innerHTML = "";

document.getElementById('email_to').innerHTML = "";

as email_to will always be blank!

and this

document.getElementById(cust_id).innerHTML = xmlHttp.responseText;

should be

document.getElementById('cust_id').innerHTML = xmlHttp.responseText;

Alith7 · February 24, 2009

ok, I made those changes, now when I try to select a customer, the whole customer list clears.

sorry to post the whole code, I'm not sure what is causing the problem so I don't know what I can leave out.

Thank you for your help!

<?php require_once('Connections/geQuote.php'); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "quote";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "noaccess.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = "quote.php";
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

$editFormAction = "quote.php";
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insertQuote")) {
  $insertSQL = sprintf("INSERT INTO quote (sales_id, cust_id, quote_to, email_to, title, quote, created) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['sales_id'], "int"),
                       GetSQLValueString($_POST['cust_id'], "int"),
                       GetSQLValueString($_POST['quote_to'], "text"),
                       GetSQLValueString($_POST['email_to'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['quote'], "text"),
                       $_POST['created']);

  mysql_select_db($database_geQuote, $geQuote);
  $Result1 = mysql_query($insertSQL, $geQuote) or die(mysql_error());

  $insertGoTo = "quote_listsort.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_geQuote, $geQuote);
$query_listSales = "SELECT salesrep.sales_id, CONCAT(salesrep.first_name,' ', salesrep.last_name) AS salesRep FROM salesrep ORDER BY salesrep.last_name, salesrep.first_name";
$listSales = mysql_query($query_listSales, $geQuote) or die(mysql_error());
$row_listSales = mysql_fetch_assoc($listSales);
$totalRows_listSales = mysql_num_rows($listSales);

mysql_select_db($database_geQuote, $geQuote);
$query_listCustomer = "SELECT customer.cust_id, customer.name FROM customer ORDER BY customer.name";
$listCustomer = mysql_query($query_listCustomer, $geQuote) or die(mysql_error());
$row_listCustomer = mysql_fetch_assoc($listCustomer);
$totalRows_listCustomer = mysql_num_rows($listCustomer);

$selected=mysql_select_db($database_geQuote, $geQuote);
      if( isset($_POST['Submit']) )
      {
         echo "<pre>";
         print_r($_POST);
      }
      if( isset($_GET['ajax']) )
   {
      //In this if statement
      switch($_GET['cust_id'])
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         echo "{$row_custData['dbinfo']}";
      }
      exit; //we're finished so exit..
   }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Graphic Edge Printing</title>

<script language="javascript">
   function ajaxFunction(ID, Param)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
      
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
      
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            //THIS SET THE DAT FROM THE PHP TO THE HTML
            document.getElementById('cust_id').innerHTML = xmlHttp.responseText;
           }
      }
       xmlHttp.open("GET", loaderphp+"?ID="+ID+"&ajax="+Param,true);
       xmlHttp.send(null);
   }
</script>

<?php include('style_rules.php'); ?>
</head>

<body>
<div id="wrapper">
  <div id="titlebar"><img src="images/header.jpg" alt="Graphic Edge Printing" /></div>
  <div id="maincontent">
    <div id="nav">
      <?php include('navbar.php'); ?>
    </div>
    <h1>New Quote</h1>
    <form action="<?php echo $editFormAction; ?>" method="POST" name="insertQuote" id="insertQuote" target="_self">
      <p><table width="650">
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Sales Rep: </h2>
        </div></td>
        <td><select name="sales_id" id="sales_id">
          <?php
do {  
?>
          <option value="<?php echo $row_listSales['sales_id']?>"><?php echo $row_listSales['salesRep']?></option>
          <?php
} while ($row_listSales = mysql_fetch_assoc($listSales));
  $rows = mysql_num_rows($listSales);
  if($rows > 0) {
      mysql_data_seek($listSales, 0);
  $row_listSales = mysql_fetch_assoc($listSales);
  }
?>
        </select>
</td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Customer:</h2>
        </div></td>
        <td><select name="cust_id" id="cust_id" onchange="ajaxFunction('quote_to', this.value);">
          <?php
do {  
?>
          <option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
          <?php
} while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  $rows = mysql_num_rows($listCustomer);
  if($rows > 0) {
      mysql_data_seek($listCustomer, 0);
  $row_listCustomer = mysql_fetch_assoc($listCustomer);
  }
?>
        </select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td><input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>
      </tr>
  <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>
   <tr>
        <td width="200" height="25"><div align="right">
          <h2>Title:</h2>
        </div></td>
        <td><input name="title" type="text" class="widebox" id="title" maxlength="255" /></td>
      </tr>
      <tr>
        <td width="200" height="25" valign="top"><div align="right">
          <h2>Quote:</h2>
        </div></td>
        <td><textarea name="quote" id="quote" cols="54" rows="25"></textarea></td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right"></div></td>
        <td><input type="submit" name="Submit" value="Submit Quote" /></td>
      </tr>
    </table>
    <input name="created" type="hidden" id="created" value="NOW()" />
    <input type="hidden" name="MM_insert" value="insertQuote">
    </form>
  </div>
  <div id="footer"><?php include('copyright.php'); ?></div>
</div>
</body>
</html>
<?php
mysql_free_result($listSales);

mysql_free_result($listCustomer);
?>

MadTechie · February 24, 2009

Its kinda hard for me to run the code (not having the DB etc)

but from what i can read i have updated it (see below)

However.. the data your getting from the database.. what do you want to do with it ?

as your pointing it to a textbox.. or did you want a list ?

the code below i have fixed a few parts but also re-labled the text box to quote_to-old and added a div labled quote_to

this sould give you an output but probably not how you want it..

<?php require_once('Connections/geQuote.php'); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "quote";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "noaccess.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = "quote.php";
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

$editFormAction = "quote.php";
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insertQuote")) {
  $insertSQL = sprintf("INSERT INTO quote (sales_id, cust_id, quote_to, email_to, title, quote, created) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['sales_id'], "int"),
                       GetSQLValueString($_POST['cust_id'], "int"),
                       GetSQLValueString($_POST['quote_to'], "text"),
                       GetSQLValueString($_POST['email_to'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['quote'], "text"),
                       $_POST['created']);

  mysql_select_db($database_geQuote, $geQuote);
  $Result1 = mysql_query($insertSQL, $geQuote) or die(mysql_error());

  $insertGoTo = "quote_listsort.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_geQuote, $geQuote);
$query_listSales = "SELECT salesrep.sales_id, CONCAT(salesrep.first_name,' ', salesrep.last_name) AS salesRep FROM salesrep ORDER BY salesrep.last_name, salesrep.first_name";
$listSales = mysql_query($query_listSales, $geQuote) or die(mysql_error());
$row_listSales = mysql_fetch_assoc($listSales);
$totalRows_listSales = mysql_num_rows($listSales);

mysql_select_db($database_geQuote, $geQuote);
$query_listCustomer = "SELECT customer.cust_id, customer.name FROM customer ORDER BY customer.name";
$listCustomer = mysql_query($query_listCustomer, $geQuote) or die(mysql_error());
$row_listCustomer = mysql_fetch_assoc($listCustomer);
$totalRows_listCustomer = mysql_num_rows($listCustomer);

$selected=mysql_select_db($database_geQuote, $geQuote);
if( isset($_POST['Submit']) )
{
	echo "<pre>";
	print_r($_POST);
}
if( isset($_GET['ajax']) )
{
      //In this if statement
      switch($_GET['ID']) 
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         echo "{$row_custData['dbinfo']}";
      }
      exit; //we're finished so exit..
   }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Graphic Edge Printing</title>

<script language="javascript">
   function ajaxFunction(ID, Param)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
     
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
     
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            //THIS SET THE DAT FROM THE PHP TO THE HTML
            document.getElementById(ID).innerHTML = xmlHttp.responseText;
           }
      }
       xmlHttp.open("GET", loaderphp+"?ID="+ID+"&ajax="+Param,true);
       xmlHttp.send(null);
   }
</script>

<?php include('style_rules.php'); ?>
</head>

<body>
<div id="wrapper">
  <div id="titlebar"><img src="images/header.jpg" alt="Graphic Edge Printing" /></div>
  <div id="maincontent">
    <div id="nav">
      <?php include('navbar.php'); ?>
    </div>
    <h1>New Quote</h1>
    <form action="<?php echo $editFormAction; ?>" method="POST" name="insertQuote" id="insertQuote" target="_self">
      <p><table width="650">
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Sales Rep: </h2>
        </div></td>
        <td><select name="sales_id" id="sales_id">
          <?php
do {  
?>
          <option value="<?php echo $row_listSales['sales_id']?>"><?php echo $row_listSales['salesRep']?></option>
          <?php
} while ($row_listSales = mysql_fetch_assoc($listSales));
  $rows = mysql_num_rows($listSales);
  if($rows > 0) {
      mysql_data_seek($listSales, 0);
     $row_listSales = mysql_fetch_assoc($listSales);
  }
?>
        </select>
</td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Customer:</h2>
        </div></td>
        <td><select name="cust_id" id="cust_id" onchange="ajaxFunction('quote_to', this.value);">
          <?php
do {  
?>
          <option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
          <?php
} while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  $rows = mysql_num_rows($listCustomer);
  if($rows > 0) {
      mysql_data_seek($listCustomer, 0);
     $row_listCustomer = mysql_fetch_assoc($listCustomer);
  }
?>
        </select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td>
        <div id="quote_to"></div>
        <input name="quote_to-old" type="text" class="widebox" id="quote_to-old" maxlength="50" /></td>
      </tr>
     <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right">
          <h2>Title:</h2>
        </div></td>
        <td><input name="title" type="text" class="widebox" id="title" maxlength="255" /></td>
      </tr>
      <tr>
        <td width="200" height="25" valign="top"><div align="right">
          <h2>Quote:</h2>
        </div></td>
        <td><textarea name="quote" id="quote" cols="54" rows="25"></textarea></td>
      </tr>
      <tr>
        <td width="200" height="25"><div align="right"></div></td>
        <td><input type="submit" name="Submit" value="Submit Quote" /></td>
      </tr>
    </table>
    <input name="created" type="hidden" id="created" value="NOW()" />
    <input type="hidden" name="MM_insert" value="insertQuote">
    </form>
  </div>
  <div id="footer"><?php include('copyright.php'); ?></div>
</div>
</body>
</html>
<?php
mysql_free_result($listSales);

mysql_free_result($listCustomer);
?>

Alith7 · February 24, 2009

The data is simply a contact name (John Doe) and the email (JDoe@hotmail.com) associated with the customer account that was selected. I have lazy salesmen.

the DB structure is as follows:

CREATE TABLE IF NOT EXISTS `customer` (

`cust_id` int(10) unsigned NOT NULL auto_increment,

`sales_id` int(10) unsigned default NULL,

`name` varchar(40) NOT NULL default '',

`street` varchar(50) default NULL,

`city` varchar(50) default NULL,

`state` char(2) default NULL,

`zip` int(5) default '0',

`phone` varchar(12) default NULL,

`fax` varchar(12) default NULL,

`contact` varchar(40) default NULL,

`cust_email` varchar(50) default NULL,

PRIMARY KEY (`cust_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=395 ;

The coding pulls all the customer ID's and names from the table to fill the dropdown, what I want to do is have it pull the contact info and email to populate the appropriate text fields when the salesman picks a customer. Does that make sense?

Alith7 · February 24, 2009

&(*%#Q&$

this is annoying me. I'm having a heck of time getting this code to crack for me!! so VERY frustrating!

Ok, I see what mean by not working the way I want.

What about by using the AJAX to update a variable that's being plugged into the text field value?

so instead of this:

$selected=mysql_select_db($database_geQuote, $geQuote);
   if( isset($_POST['Submit']) )
   {
      echo "<pre>";
      print_r($_POST);
   }
   if( isset($_GET['ajax']) )
   {
      //In this if statement
      switch($_GET['ID']) 
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         echo "{$row_custData['dbinfo']}";
      }
      exit; //we're finished so exit..
   }

maybe like this??

//call out variables as empty strings
$updateContact = "";
$updatedEmail = "";
//then run script
$selected=mysql_select_db($database_geQuote, $geQuote);
   if( isset($_POST['Submit']) )
   {
      echo "<pre>";
      print_r($_POST);
   }
   if( isset($_GET['ajax']) )
   {
      //In this if statement
      switch($_GET['ID']) 
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         $updateEmail = $row_custData['email'];
         $updateContact = $row_custData['contact'];
      }
      exit; //we're finished so exit..
   }

only it's not working!

MadTechie · February 24, 2009

&(*%#Q&$

this is annoying me. I'm having a heck of time getting this code to crack for me!! so VERY frustrating!

maybe like this??
//call out variables as empty strings
//snip..
only it's not working!

Nope it doesn't work like that!

Okay .. Just to confirm..

Lazy Salesman selects Customer Name from a drop down (value = Customers ID)

form this point you want to populate the remaining fields..

quote_to = contact

email_to = email

If so... (backup first.. i havn't tested any of this)

first change

   if( isset($_GET['ajax']) )
   {
      //In this if statement
      switch($_GET['ID']) 
      {
         case "quote_to":
            $query_custData = sprintf("SELECT contact AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
         case "email_to":
            $query_custData = sprintf("SELECT email AS dbinfo FROM customer WHERE cust_id=%d",$_GET['ajax']);
         break;
      }
      
      $result_custData = mysql_query($query_custData);
      echo "";
      while ($row_custData = mysql_fetch_assoc($result_custData))
      {
         echo "{$row_custData['dbinfo']}";
      }
      exit; //we're finished so exit..
   }

to

if( isset($_GET['ajax']) )
{
$query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['ajax']);
$result_custData = mysql_query($query_custData);
$row_custData = mysql_fetch_assoc($result_custData);
echo $row_custData['contact'].":::".$row_custData['email'];
exit; //we're finished so exit..
}

remove this line

<div id="quote_to"></div>

change

<input name="quote_to-old" type="text" class="widebox" id="quote_to-old" maxlength="50" /></td>

back to

<input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>

and now change

      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            //THIS SET THE DAT FROM THE PHP TO THE HTML
            document.getElementById(ID).innerHTML = xmlHttp.responseText;
           }
      }

To

xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
			var re = /^(.*?)::.*?)$/i;
			var match = re.exec(xmlHttp.responseText);
			if (match != null) {
				document.getElementById('quote_to').innerHTML = match[1];
				document.getElementById('email_to').innerHTML = match[2];
			}            
           }
      }

Alith7 · February 24, 2009

ok, changed that. It's not failing, but it's not updating....

does something in this line need to change for the new function?

<select name="cust_id" id="cust_id" onchange="ajaxFunction('quote_to', this.value);">

MadTechie · February 24, 2009

oops

               document.getElementById('quote_to').innerHTML = match[1];
               document.getElementById('email_to').innerHTML = match[2];

should be

               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];

ajaxFunction function doesn't need the first parameter anymore..

Alith7 · February 24, 2009

ok...still not working.

we have this part of the script:

$selected=mysql_select_db($database_geQuote, $geQuote);
   if( isset($_GET['ajax']) )
{
   $query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['ajax']);
   $result_custData = mysql_query($query_custData);
   $row_custData = mysql_fetch_assoc($result_custData);
   echo $row_custData['contact'].":::".$row_custData['email'];
   exit; //we're finished so exit..
}

The Function:

<script language="javascript">
   function ajaxFunction(ID, Param)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
     
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
     
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            var re = /^(.*?)::.*?)$/i;
            var match = re.exec(xmlHttp.responseText);
            if (match != null) {
               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];
            }           
           }
      }

       xmlHttp.open("GET", loaderphp+"?ID="+ID+"&ajax="+Param,true);
       xmlHttp.send(null);
   }
</script>

and the form data:

<select name="cust_id" id="cust_id" onchange="ajaxFunction('quote_to', this.value);">
          <?php
do {  
?>
          <option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
          <?php
} while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  $rows = mysql_num_rows($listCustomer);
  if($rows > 0) {
      mysql_data_seek($listCustomer, 0);
     $row_listCustomer = mysql_fetch_assoc($listCustomer);
  }
?>
        </select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td>
	<input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>      </tr>
     <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>

must be missing something that needs to be updated or isn't calling for the right data...but what?

MadTechie · February 24, 2009

Okay i have re-created it (kinda)

as i don't have the database i have create a dumb version,,

i hope it makes sense, (if you run this by itself to test first)

<?php
#$selected=mysql_select_db($database_geQuote, $geQuote);
if( isset($_GET['cust_id']) )
{
   $query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
   
   #$result_custData = mysql_query($query_custData);
   #$row_custData = mysql_fetch_assoc($result_custData);
   //Uncomment above and comment below
   
   //Fake Database
   $DATA = array( 
   		1=> array("contact" =>"My Contact1", "email"=> "My Email1"),
   		2=> array("contact" =>"My Contact2", "email"=> "My Email2")
   );
   $row_custData = $DATA[$_GET['cust_id']];
   
   echo $row_custData['contact'].":::".$row_custData['email'];
   exit; //we're finished so exit..
}

?>
<script language="javascript">
   function ajaxFunction(cust_id)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
     
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
     
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            var re = /^(.*?)::.*?)$/i;
            var match = re.exec(xmlHttp.responseText);
            if (match != null) {
               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];
            }           
           }
      }

       xmlHttp.open("GET", loaderphp+"?cust_id="+cust_id,true);
       xmlHttp.send(null);
   }
</script>


<select name="cust_id" id="cust_id" onchange="ajaxFunction(this.value);">
<!--Fake Values Start-->
<option value="1">one</option>
<option value="2">two</option>
<!--Fake Values End-->

<?php
/* 
do {  
?>



<option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
<?php
/*
} while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  $rows = mysql_num_rows($listCustomer);
  if($rows > 0)
  {
      mysql_data_seek($listCustomer, 0);
     $row_listCustomer = mysql_fetch_assoc($listCustomer);
  }
*/
?>

        </select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td>
      <input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>      </tr>
     <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>

MadTechie · February 24, 2009

okay i finished cooking so i'm off to eat..

I hope your doing well but for some debugging

if you try test.php?cust_id=1

you should get a page thats says

My Contact1:::My Email1

if you try the same (with a valid id and the database is used) check to see if you get anything else that may help you find the bug

Back in a while

Regards Richard

Alith7 · February 24, 2009

testing the test script works, but when I try to pull the info from my db I get nothing. I've picked apart the script as best as I can and I'm thinking there's something wrong with the query.

Alith7 · February 24, 2009

thanks for the help, enjoy your dinner!

I'm going to take another crack at it and see what I get debugging the query otherwise I think I'll put it aside and try again tomorrow with a clear head.

MadTechie · February 24, 2009

Heres another attempt.. i'll let you debug some and see what you get

<?php
$selected=mysql_select_db($database_geQuote, $geQuote);
if( isset($_GET['cust_id']) )
{
   $query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
   $result_custData = mysql_query($query_custData);
   $row_custData = mysql_fetch_assoc($result_custData);
   echo $row_custData['contact'].":::".$row_custData['email'];
   exit; //we're finished so exit..
}

?>
<script language="javascript">
   function ajaxFunction(cust_id)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
     
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
     
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            var re = /^(.*?)::.*?)$/i;
            var match = re.exec(xmlHttp.responseText);
            if (match != null) {
               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];
            }           
           }
      }

       xmlHttp.open("GET", loaderphp+"?cust_id="+cust_id,true);
       xmlHttp.send(null);
   }
</script>


<select name="cust_id" id="cust_id" onchange="ajaxFunction(this.value);">
<?php
$listCustomer = mysql_query("SELECT cust_id, name FROM customer");
while ($row_listCustomer = mysql_fetch_assoc($listCustomer))
{
echo "<option value=\"{$row_listCustomer['cust_id']}\">{$row_listCustomer['name']}</option>\n";
}
?>
</select>
</td>
      </tr>
       <tr>
        <td width="200" height="25"><div align="right">
          <h2>Quoted to:</h2>
        </div></td>
        <td>
      <input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" /></td>      </tr>
     <tr>
        <td width="200" height="25"><div align="right">
          <h2>Email to:</h2>
        </div></td>
        <td><input name="email_to" type="text" class="widebox" id="email_to" /></td>
      </tr>

Alith7 · February 24, 2009

I think I've narrowed down the problem to this section:

$query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
   $result_custData = mysql_query($query_custData);
   $row_custData = mysql_fetch_assoc($result_custData);

somehow I think the cust_id isn't getting passed into the query, or something else is wrong with the query.

Your test script worked fine. when I replaced with the database variables, nothing happens. I tried replacing the dynamically populated drop down with hard coded numbers, 1, 10, 15, 20, 25. I confirmed that they all were cust_id #'s in the database, and that didn't work either.

my mind is drawing a blank on what code to add to test the query results.

Alith7 · February 24, 2009

btw, thank you for all your help and patience with my horrid coding skills!

Alith7 · February 24, 2009

ok....so this works:

$DATA = array( 
         1=> array("contact" =>"My Contact1", "email"=> "My Email1"),
         2=> array("contact" =>"My Contact2", "email"=> "My Email2")
   );
   $row_custData = $DATA[$_GET['cust_id']];

this does not:

$query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
$result_custData = mysql_query($query_custData);
$row_custData = mysql_fetch_assoc($result_custData);

The questions is...why? it's rhetorical, I'm thinking out loud...erm, so to speak. unless you have an answer?

Alith7 · February 24, 2009

I've tried dropping the sprintf from the query and running like so:

$query_custData = "SELECT contact, email FROM customer WHERE cust_id=".$_GET['cust_id'];

That didn't work either.

MadTechie · February 24, 2009

find this line

xmlHttp.open("GET", loaderphp+"?cust_id="+cust_id,true);

and add

alert(loaderphp+"?cust_id="+cust_id);
xmlHttp.open("GET", loaderphp+"?cust_id="+cust_id,true);

now you should get an alert

ie

test.php?cust_id=2

try trying typing that in the browser see what you get back

Alith7 · February 24, 2009

got the following error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/14/1/66/102/1066102/user/1100571/htdocs/ge/custtest.php on line 16

:::

Alith7 · February 24, 2009

Lines 14-17

$query_custData = "SELECT contact, email FROM customer WHERE cust_id=".$_GET['cust_id'];
$result_custData = mysql_query($query_custData);
$row_custData = mysql_fetch_assoc($result_custData);
echo $row_custData['contact'].":::".$row_custData['email'];

Alith7 · February 24, 2009

changed to this:

if( isset($_GET['cust_id']) )
{
   $query_custData = sprintf("SELECT contact, email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
   $result_custData = mysql_query($query_custData, $geQuote) or die(mysql_error());
   $row_custData = mysql_fetch_assoc($result_custData);
   echo $row_custData['contact'].":::".$row_custData['email'];
   exit; //we're finished so exit..
}

got this error

Unknown column 'email' in 'field list'

Alith7 · February 24, 2009

rawr!

ok, so I found the flippin error

the field in the table was cust_email not email.

fixed that, passing this code in the address

custtest.php?cust_id=105

returned the correct data

Julie:::JGomels@custwww.com

but now I need the text fields to update. here is what I have for test code atm:

<?php require_once('Connections/geQuote.php'); ?>

<?php

mysql_select_db($database_geQuote, $geQuote);
$query_listCustomer = "SELECT customer.cust_id, customer.name FROM customer ORDER BY customer.name";
$listCustomer = mysql_query($query_listCustomer, $geQuote) or die(mysql_error());
$row_listCustomer = mysql_fetch_assoc($listCustomer);
$totalRows_listCustomer = mysql_num_rows($listCustomer);

$selected=mysql_select_db($database_geQuote, $geQuote);
if( isset($_GET['cust_id']) )
{
   $query_custData = sprintf("SELECT contact, cust_email FROM customer WHERE cust_id=%d LIMIT 0,1",$_GET['cust_id']);
   $result_custData = mysql_query($query_custData, $geQuote) or die(mysql_error());
   $row_custData = mysql_fetch_assoc($result_custData);
   echo $row_custData['contact'].":::".$row_custData['cust_email'];
   exit; //we're finished so exit..
}

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Untitled Document</title>

<script language="javascript">
   function ajaxFunction(cust_id)
   {
      //link to the PHP file your getting the data from
      //var loaderphp = "quote.php";
      //i have link to this file
      var loaderphp = "<?php echo $_SERVER['PHP_SELF'] ?>";
     
      //we don't need to change anymore of this script
      var xmlHttp;
      try
       {
         // Firefox, Opera 8.0+, Safari
         xmlHttp=new XMLHttpRequest();
       }catch(e){
         // Internet Explorer
         try
         {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
         }catch(e){
            try
            {
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }catch(e){
               alert("Your browser does not support AJAX!");
               return false;
            }
         }
      }
     
      xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
            var re = /^(.*?)::.*?)$/i;
            var match = re.exec(xmlHttp.responseText);
            if (match != null) {
               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];
            }           
           }
      }

   alert(loaderphp+"?cust_id="+cust_id);
   xmlHttp.open("GET", loaderphp+"?cust_id="+cust_id,true);
       xmlHttp.send(null);
   }
</script>

</head>

<body>



<select name="cust_id" id="cust_id" onchange="ajaxFunction(this.value);">

   
<?php do { ?>
   <option value="<?php echo $row_listCustomer['cust_id']?>"><?php echo $row_listCustomer['name']?></option>
   <?php } while ($row_listCustomer = mysql_fetch_assoc($listCustomer));
  			$rows = mysql_num_rows($listCustomer);
  			if($rows > 0) {
     		 	mysql_data_seek($listCustomer, 0);
     			$row_listCustomer = mysql_fetch_assoc($listCustomer);
	 			}
?>

        </select>
          <h2>Quoted to:</h2>
      <input name="quote_to" type="text" class="widebox" id="quote_to" maxlength="50" />
          <h2>Email to:</h2>
  <input name="email_to" type="text" class="widebox" id="email_to" />

</body>
</html>

MadTechie · February 25, 2009

Humm.. can't see a problem..

add the following 3 alerts

xmlHttp.onreadystatechange=function()
      {
         if(xmlHttp.readyState==4)
           {
alert(xmlHttp.responseText);
            var re = /^(.*?)::.*?)$/i;
            var match = re.exec(xmlHttp.responseText);
            if (match != null) {
alert(match[1]+"---"+match[2]);
               document.getElementById('quote_to').value= match[1];
               document.getElementById('email_to').value= match[2];
            }
alert("done");
           }
      }

you should get

"Julie:::JGomels@custwww.com" = getting a reply

"Julie---JGomels@custwww.com" = Matched data

"Done" -- no error on matching (doesn't mean it matched)

Sign In

[SOLVED] need help with AJAX script

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information