Developing (v7+)

External form and Ajax

Permalink March 21, 2014 at 1:48 PM

hey there,
the following code is working outside concrete, but when i load it to a external form it doenst...
any 1 can help me on this one?

<?php
define('HOSTNAME','localhost');
define('DB_USERNAME','root');  // Change  username, password and database name as you deefined
define('DB_PASSWORD','');
define('DATABASE','Concrete');
$link = mysql_connect(constant('HOSTNAME'), constant('DB_USERNAME'), constant('DB_PASSWORD')) or die("Database connection error, please check!");
mysql_select_db(constant('DATABASE'), $link) or die("Connection to the defined database not possible, please check!");
?>
<!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" />
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){

Viewing 15 lines of 108 lines. View entire code block.

 
<?php
define('HOSTNAME','localhost');
define('DB_USERNAME','root');  // Change  username, password and database name as you deefined
define('DB_PASSWORD','');
define('DATABASE','Concrete');
$link = mysql_connect(constant('HOSTNAME'), constant('DB_USERNAME'), constant('DB_PASSWORD')) or die("Database connection error, please check!");
mysql_select_db(constant('DATABASE'), $link) or die("Connection to the defined database not possible, please check!");
?>
 
 
<!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" />
<script type="text/javascript" src="jquery.min.js"></script>
 
 
<script type="text/javascript">
 
$(document).ready(function(){
 
$('#Ano').bind('change', function (e) { 
        if( $('#Ano').val() == '') {
          $("#Div1").css({ display: "none" });
         $("#Div2").css({ display: "none" });
 
        }
 
      else if( $('#DisciplinaL').val() !== '') {
         $("#Div1").css({ display: "inline-block"});
        $("#Div2").css({ display: "none" });
 
        }
      }).trigger('change');
 
$('#Curso').bind('change', function (e) { 
        if( $('#Curso').val() == '') {
 
         $("#Div2").css({ display: "none" });
 
        }
 
      else if( $('#Curso').val() !== '') {
         $("#Div2").css({ display: "inline-block"});
 
 
        }
      }).trigger('change');   
 
 
 
});
 $("#Curso").change(function()
  {
 
   var Curso = $(this).val();
   if(Curso != '')  
    {
     $.ajax
 
     ({
        type: "POST",
       //url: "",
       data: "Curso="+ Curso,
       success: function(option)
       {
         $("#Disciplina").html(option);
       }
     });
    }
    else
    {
      $("#Disciplina").html("<option value=''>Selecione a Disciplina</option>");
    }
   return false;
 
});
</script>   
 
 
</head>
 
<body>
 
 
 
<?php
 
$query = "select * from ConAno";
$res   = mysql_query($query);
 
$query2 = "select * from ConCursos";
$res2   = mysql_query($query2);
?>
 
<select id="Ano" name="Ano" style="" >
  <?php
  echo "<option value=''>Selecione o Ano</option>";
  while($row = mysql_fetch_array($res))
  {
    echo "<option value='".$row['Cod_ano']."'>".ucfirst($row['Nome_ano'])."</option>";
  }
  ?>
</select>
 
 
 
<div id="Div1" style="display:none;">
<select id="Curso" name="Curso" style="" >
  <?php
  echo "<option value=''>Selecione o Curso</option>";
  while($row = mysql_fetch_array($res2))
  {
    echo "<option value='".$row['Cod_curso']."'>".ucfirst($row['Nome_curso'])."</option>";
  }
  ?>
</select>
 
 
 
 
</div>
 
 
<?php
if(isset($_POST['Curso']) && $_POST['Curso'] != '') 
{
  $Curso = $_POST['Curso'];
  $Curso = mysql_real_escape_string($Curso);
  $query = "SELECT ConDisciplinas.Cod_disciplinas, ConDisciplinas.Nome_disciplinas, ConCursos.Cod_curso FROM ConDisciplinas INNER JOIN (ConCursos INNER JOIN ConCursoDisciplina ON ConCursos.Cod_curso = ConCursoDisciplina.Curso) ON ConDisciplinas.Cod_disciplinas = ConCursoDisciplina.Disciplina GROUP BY ConDisciplinas.Cod_disciplinas, ConDisciplinas.Nome_disciplinas, ConCursos.Cod_curso HAVING (((ConCursos.Cod_curso)= '".$Curso."'))";
  $res = mysql_query($query);
  if(mysql_num_rows($res))
  {
    while($row = mysql_fetch_array($res))
   {
     echo "<option value='".$row['Cod_disciplinas']."'>".ucfirst($row['Nome_disciplinas'])."</option>";
   }
  }
 
}
?>
<div id="Div2" style="display:none;">
 
 
<select  id="Disciplina" name="Disciplina">
  <option value="">Selecione a Disciplina</option>
</select>
</div>
</body>
</html>

aryeh replied on Mar 21, 2014 at 3:02 pm Permalink Reply

since you are running it within the concrete files you do not need to connect to the database. Its already connected. Just make sure the table is in the same database.

ranonymus replied on Mar 21, 2014 at 3:19 pm Permalink Reply

thanks for the quick answer, but how i said outside concrete server is works fine.

aryeh replied on Mar 21, 2014 at 3:26 pm Permalink Reply

where are you trying it that it works fine? Plane php file?
can you explain in more detail what your trying to do?

ranonymus replied on Mar 21, 2014 at 3:32 pm Permalink Reply

when i test it in plane php the form works great. i have 3 chained selects and i use ajax to populate the last one as you can see.
the ajax function works well in plane php wich means the select its populated. however when open in concrete5 the function doenst run... so the third select inst populated....

aryeh replied on Mar 21, 2014 at 3:34 pm Permalink Reply

If you remove the connection to the databaee on the c5 it should work.

aryeh replied on Mar 21, 2014 at 3:34 pm Permalink Reply

Also are you getting some kind of error?

ranonymus replied on Mar 22, 2014 at 7:46 am Permalink Reply

no error, the third select just stays blank...
and removing the connection dindt work
Also now i can see its something about the ajax. its not loading data to the select...

ranonymus replied on Mar 24, 2014 at 3:36 pm Permalink Reply

no1 can help?
im now able to load external js and css. however the function is not working right. something about the .ajax

Forums

Developing (v7+)

External form and Ajax

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?