Hi Sofia,
My earlier post was rubbish - you can't look up a select entry in the database in the middle of a form like that. Sorry, my brain can't have been connected that day.
To do this with ChronoForms you'd need to submit after the district is selected then re-show this form (or a new one) with the additional fields.<?php
// initialise the database code
global $database;
if ( !$_POST['escolha'] ) {
// show select list
} else {
$escolha = $_POST['escolha'];
$sql = "
SELECT *
FROM #__chronoforms_2
WHERE distrito = '$escolha';";
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo "<table width='500px'>
<tr><td valign='middle'><h1>Distrito</h1></td>
<td valign='middle'>
<select name='lista' size='1' id='lista'>
<option value='vazio' selected>choose one</option>
<option value='Lisboa'>Lisboa</option>
<option value='Viseu'>Viseu</option>
</select>
<input type='submit' name='submit' value='Test!'> </td></tr>";
foreach ( $rows as $record ) {
echo "<tr>
<td colspan='2'>
<h2>".$record->cf_id." | ".$record->especie." | ".$record->raca."</h2>
</td></tr>
<tr>
<td valign='top'>Em ".$record->data.", ".$record->nomeanimal.", tinha:<br />
Idade: ".$record->idade." anos<br />
Peso: ".$record->peso." kg<br />
Altura: ".$record->altura." cm<br /></td>
<td valign='top'>Reside com: ".$record->user.", ".$record->distrito."<br />
Telefone: ".$record->telefone."<br />
Email: ".$record->email."<br /></td>
</tr>";
}
echo "</table>";
}
?>Bob<br><br>Post edited by: GreyHead, at: 2008/03/21 18:38
Hi Sofia,
Try setting the form redirect to index.php?option=com_chronocontact&chronoformname=bancodesangue_display
Bob
Done. Still only appears the select box after submit. No results.
Kiss,
Sofia
Hi Sofia,
I guess we lose the $_POST array in the redirect. I'll try building a version here in the morning and see if I can get it to work.
Bob
Hi Sofia,
I think this will work (fingers crossed).
In the general tab turn 'Email the results/' to OFF
In the Form code tab put this in Form HTML: <?php
global $database;
echo '<table width='500px'>
<tr><td valign='middle'><h1>Distrito</h1></td>
<td valign='middle'>
<select name='escolha' size='1' id='escolha'>
<option value='vazio' selected>choose one</option>
<option value='Lisboa'>Lisboa</option>
<option value='Viseu'>Viseu</option>
</select>
<input type='submit' name='submit' value='Test!' />
</td></tr>';
if ( $_POST['escolha'] ) {
$sql = '
SELECT *
FROM #__chronoforms_23
WHERE distrito = ''.$_POST['escolha'].'';';
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo '<table width='500px'>';
foreach ( $rows as $record ) {
echo '<tr>
<td colspan='2'>
<h2>'.$record->cf_id.' | '.$record->especie.' | '.$record->raca.'</h2>
</td></tr>';
<tr>
<td valign='top'>Em '.$record->data.', '.$record->nomeanimal.', tinha:<br />
Idade: '.$record->idade.' anos<br />
Peso: '.$record->peso.' kg<br />
Altura: '.$record->altura.' cm<br /></td>
<td valign='top'>Reside com: '.$record->user.', '.$record->distrito.'<br />
Telefone: '.$record->telefone.'<br />
Email: '.$record->email.'<br /></td>
</tr>
}
echo '</table>';
}
?>and in the OnSubmit after email box put this code:
<?php
showform( $_POST );
?>Like this the form shows just the select box if nothing has been selected, otherwise it shows the select box and the results for the district.
Bob<br><br>Post edited by: GreyHead, at: 2008/03/23 23:34
Hello Bob,
I have been seek, so i only saw your message today. Tried and still get the same blank page😟
Email option was already disabled.
I replaced the code with yours and added the after submit code you sent, and still get the same blank page after submit.
Maybe it would be easier for you if i sent you throught pm a login and password so you can access my joomla backoffice, to check it out. Tell me if you want me to do it.
Big kiss,
Sofia
Hi Sofia,
Sorry to hear you've been sick.
Sure, - email me the login details to the address in my sig.
Bob
Hi Bob,
Can´t access greyhead.net fr your contacts because is down for maintenance. Can you send your mail to [email]piodesign@gmail.com[/email] and i'll reply to you with all information you will need?
Thanks,
Sofia
Hi Sofia,
First of all, dont go to the greyhead.net itself, instead, replace ' at ' with @😉
So, I have been looking into your post, I see the best way to do what you need is AJAX, If you can follow me you will be able to do it, here are the steps :
#1- I will assume you have 1 form which is showing the data called : show_data
put this code inside it :
<script type="text/javascript">
function getHTTPObject() {
var xmlhttp;
if(window.XMLHttpRequest){
xmlhttp = new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"«»);
if (!xmlhttp){
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP"«»);
}
}
return xmlhttp;
}
var http = getHTTPObject(); // We create the HTTP Object
</script>
<script type="text/javascript">
function loadfields(){
var lista = document.getElementById("lista"«»).value;
http.open("POST", "index2.php?option=com_chronocontact&chronoformname=show_data_ajax" , true);
http.onreadystatechange = function ()
{ if (http.readyState == 1) {
document.getElementById('sofia_div').innerHTML = 'LOADING';
}
else if (http.readyState == 4) {
if(http.status==200) {
document.getElementById('sofia_div').innerHTML = '';
var results=http.responseText.split("*#*");
var results=results[1].split("#999-#");
if(results[0] == 'yes'){
document.getElementById('sofia_div').innerHTML = results[1];
}
}
}
};
//http.send(null);
http.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"«»);
http.send("escolha=" + escape(lista));
}
</script>
<table><tr><td valign="middle"><h1>Distrito</h1></td>
<td valign="middle">
<select name="lista" size="1" id="lista" onChange="loadfields()">
<option value="vazio" selected>choose one</option>
<option value="Lisboa">Lisboa</option>
<option value="Viseu">Viseu</option></select> <input type="submit" name="submit" value="Test!"> </td></tr></table>
<div id="sofia_div"></div>
#2- create another form called : show_data_ajax and add this code inside it :
<?php
// initialise the database code
global $database;
$escolha = $_POST['escolha'];
$sql = "SELECT * FROM #__chronoforms_2 WHERE distrito = '$escolha';";
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo "*#*"."yes"."#999-#";
echo "<table width=\"500px\">
";
foreach ( $rows as $record ) {
echo "<tr>
<td colspan=\"2\"><h2>".$record->cf_id." | ".$record->especie." | ".$record->raca."</h2></td></tr>
<tr>
<td valign=\"top\">Em ".$record->data.", ".$record->nomeanimal.", tinha:<br />
Idade: ".$record->idade." anos<br />
Peso: ".$record->peso." kg<br />
Altura: ".$record->altura." cm<br /></td>
<td valign=\"top\">Reside com: ".$record->user.", ".$record->distrito."<br />
Telefone: ".$record->telefone."<br />
Email: ".$record->email."<br /></td>
</tr>";
}
echo "</table>";
echo "*#*";
?>
now access the main show_data form and choose any item from the dropdown and voila, it should be working!!!🙂
Let me know how it will go!
Cheers
Max
Post edited by: admin, at: 2008/03/25 15:51
Post edited by: admin, at: 2008/03/25 15:57<br><br>Post edited by: admin, at: 2008/03/25 16:02
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Hello guys,
Sorry for the late response. This past week as been a mess. I have been sick. Only now, i feeling better.
Thanks for your responses.
Max, i did not try out your ajax code, because Bob solve the problem before. He acess my backoffice and discover the problem. I prefer to have the code in php, because, although i'm not an expert i can read it and understand it, so i can apply it in the future without boring you guys again. Ajax is like chinese for me.
Anyway, i'm sure it will help someone outhere.
Again, thanks for you kindness and help.
Kiss,
Sofia
