0

My page contains a date picker. so when i select a date, a table with list of images uploaded on that date wil be displayed.so for that i used ajax. so here is my problem wen i select a date, table appears and in that table a dropdown of users is present. so wen i select some user and click submit button, the table that is present is disappearing due to page refreshing and i am not getting any value. so can anyone help me please...
Thank u.

<?php
    @session_start();
    echo "<strong style='color:navy'><h2>Welcome $_SESSION[username].</h2></strong>";
?>
<html>
<script type="text/javascript">
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("POST","useajax.php?q="+str,true);
xmlhttp.send();
}
</script>
<head>
<link rel="stylesheet" type="text/css" href="css/table.css"/>
<meta charset="UTF-8" />
    <link rel="stylesheet" href="css/base.css" type="text/css" media="all" />
    <link type="text/css" href="css/jquery.ui.all.css" rel="stylesheet" />
    <script type="text/javascript" src="jquery-1.4.2.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.core.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.widget.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.datepicker.js"></script>
    <link type="text/css" href="css/demos.css" rel="stylesheet" />
    <script type="text/javascript">
    $(function() {
        $("#datepicker").datepicker();
    });
    </script>
</head>
<body>
<form>
<table align="right"> 
    <tr> <td></td>
        <td></td><td><a href="logout.php"><h2>Logout</h2></a></td></table>
<div class="demo" align="center">

<h2>Choose Uploaded date <input name="dates" type="text" id="datepicker" onchange="showUser(this.value)"></h2>
</div>
<br>
<?php

?>
<div align="center" id="txtHint"><h1>Images information will be listed here.</h1></div> 
</form>
</body>
</html>

---useajax.php----

<html>

<body>
<link rel="stylesheet" type="text/css" href="css/table.css"/>
<form action="useajax.php" method="post">
<table align="center" id="customers" style="width: 90%">
<tr>
  <th>S.no</th>
  <th>Imageid</th>
  <th>Name</th>
  <th>Size</th>
  <th>Type</th>
  <th>Assigned to</th>
  </tr>
  <?php
    include 'connection.php';
    $q=$_GET["q"];
    //$query1= mysql_query("select name from users where role in (2,3)");
   // mysql_error();
    //$result=mysql_query($query1);
    //$options=""; 
    //while ($row=mysql_fetch_array($result)) 
   // {
     //   $assignedto=$row["name"];
      //  $options.="<option value='".$assignedto."'>".($assignedto == $_POST['assignedto'].'selected="selected"'.'') . $assignedto .'</option>'; 
    //}
    $query= mysql_query("SELECT id,imageid,name,size,type from images where uploadeddate='".$q."'");
    mysql_error();
    $num=mysql_num_rows($query);
    if($num==0)
    {
        echo "<strong style='color:red'><center><h2> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NO image uploaded on this date</h2></center></strong> ";
    }
    else
    {
$i=0;
while ($i < $num){
$f1=mysql_result($query,$i,"id");
$f2=mysql_result($query,$i,"imageid");
$f3=mysql_result($query,$i,"name");
$f4=mysql_result($query,$i,"size");
$f5=mysql_result($query,$i,"type");
if($i%2==0)
{
?>
<tr class="">
    <td><?php echo $f1;?></td>
    <td><?php echo $f2; ?></td>
    <td><?php echo $f3; ?></td>
    <td><?php echo $f4; ?></td>
    <td><?php echo $f5; ?></td>
    <td>
        <select name="assignedto">
            <option><b>SELECT</b></option>
            <option>sss</option>
            <option>john</option>
            <option>jack</option>
            <option>rick</option>
        </select>
    </td>
</tr> 
<?php
}
else
{
?>
<tr class="alt">
    <td><?php echo $f1;?></td>
    <td><?php echo $f2; ?></td>
    <td><?php echo $f3; ?></td>
    <td><?php echo $f4; ?></td>
    <td><?php echo $f5; ?></td>
    <td>
        <select>
            <option><b>SELECT</b></option>
            <option>sss</option>
            <option>john</option>
            <option>jack</option>
            <option>rick</option>
        </select>
    </td>
</tr> 
<?php
}
    $i++;
}
?>
<br></table>
<table align="center">
<input type="submit" name="btn" value="submit">   
</table>
<?php
}
if(isset($_POST['btn']))
{
    echo "bingoooo"; 
    
}
?>
</form>
</body>
</html>

here wen i click submit button it goes to line 94. i am not getting this echo also..

Edited by niths: n/a

4
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by diafol
0

check to see if another ajax call is being used with the javascript variable of

xmlhttp

if thats in another ajax call, or used anywhere else you need to rename it in each section. like xmlhttp1, xmlhttp2 etc i dont mean every single one has to be different, but each section that uses it

0

which browser u r using.. this mostly happen in internet explorer.. try this code in firefox.

0

I can't see why you're getting your hands dirty with XMLHttp if you're using jQuery.

You're failing because you're sending data via POST to the php script, but the php script is expecting GET data. Change the php script to $_POST variables.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.