Hello everybody!
I need to get the values of two hidden fields and values that make a query in my database and return this column to a text field in the same form, I have already informed the forum here that can do that with Ajax, researched and made an example But it is not working. I am sending the code below, if someone can help me would be much appreciated
form.php
<!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=utf-8" />
<title>..::Radiologyx>>Agendamento>>Cadastro>>Convênios:
:..</title>
<link href="../css/ris.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function eStatus(Status){
if(Status == 0){
document.getElementById("tf_agendamento_paciente_matricula").style.display ='none';
document.getElementById("tf_agendamento_paciente_num_guia").style.display ='none';
}else{
document.getElementById("tf_agendamento_paciente_matricula").style.display ='block';
document.getElementById("tf_agendamento_paciente_num_guia").style.display ='block';
}
}
function getHTTPObject()
{
if(window.XMLHttpRequest){
return new XMLHttpRequest();
} else if(window.ActiveXObject){
var prefixes = ["MSXML2", "Microsoft", "MSXML", "MSXML3"];
for(var i = 0; i < prefixes.length; i++){
try{
return new ActiveXObject(prefixes[i] + ".XMLHTTP");
} catch (e) {}
}
}
}
var xmlHttp = getHTTPObject();
function seek_value(conv, exa)
{
id('tf_agendamento_paciente_valor_exame').innerHTML = 'Loading...';
xmlHttp.open("GET", "seek_value.php?conv="+conv+"&exa="+exa, true);
xmlHttp.onreadystatechange = function()
{
if (xmlHttp.readyState==4)
{
id('tf_agendamento_paciente_valor_exame').innerHTML = xmlHttp.responseText;
}
}
xmlHttp.send(null);
}
function id(el){
return document.getElementById(el);
}
window.onload = function()
{
id('hf_agendamento_paciente_convenio').onblur = function()
{
var conv = document.getElementById("hf_agendamento_paciente_convenio").value;
id('hf_agendamento_paciente_exame').onblur = function()
{
var exa = document.getElementById("hf_agendamento_paciente_exame").value;
busca_valor(conv,exa);
}
}
}
</script>
</head>
<body>
<div id="edit_area_agenda">
<form id="todoform" name="todoform" method="post" action="banco/agenda_paciente.php" onSubmit="return validaAgenda()">
<table width="776" border="0" cellspacing="4" cellpadding="0">
<tr>
<td width="43"> </td>
<td width="399">Convênio:<input type="hidden" name="hf_agendamento_paciente_convenio" id="hf_agendamento_paciente_convenio"/></td>
<td width="147">Matrícula:</td>
<td width="163">Nro Guia:</td>
</tr>
<tr>
<td> </td>
<td><input name="tf_agendamento_paciente_convenio" type="text" id="tf_agendamento_paciente_convenio" size="60"/><input type="button" name="button2" id="button2" value="..." onclick="abre_conv()"/></td>
<td><input name="tf_agendamento_paciente_matricula" type="text" id="tf_agendamento_paciente_matricula" size="20" /></td>
<td><input name="tf_agendamento_paciente_num_guia" type="text" id="tf_agendamento_paciente_num_guia" size="20" /></td>
</tr>
<tr>
<td> </td>
<td>Exame:<input type="hidden" name="hf_agendamento_paciente_exame" id="hf_agendamento_paciente_exame"/></td>
<td>Valor Exame:</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input name="tf_agendamento_paciente_exame" type="text" id="tf_agendamento_paciente_exame" size="60"/><input type="button" name="button2" id="button2" value="..." onclick="abre_exa()"/></td>
<td><input name="tf_agendamento_paciente_valor_exame" type="text" id="tf_agendamento_paciente_valor_exame" size="20" /></td>
<td> </td>
</tr>
</table>
</form>
</div>
</body>
</html>seek_value.php
<?php
header("Expires: {$gmtdate} GMT");
header("Last-Modified: {$gmtDate} GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Progma: no-cache");
include "banco/conecta.php";
$conv = $_GET['conv'];
$exa = $_GET['exa'];
$query = "select exame_preco_valor from rad_exames_precos where exame_preco_exame='$exa' and exame_preco_convenio='$conv'";
$result = pg_query($conexao,$query);
$row = pg_fetch_object($result);
$valor = $row->exame_preco_valor;
echo $valor;
}
?>Help me please:S
