I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all tickets in grids. the problem is that the number of records are around 30 to 40 but there is a lag around more then 10 seconds while populating the grid. I think its the way I've written. So I need suggestion to improve or correct my problems if any. Please help..here is the code
MyTickets.php
Code: <?php
session_start();
if (!isset($_SESSION['uid']))
{
header('location: login.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>CRPL Support - My Tickets</title>
<link rel="stylesheet" href="css/eticket.css" media="screen">
</head>
<!--<link rel="stylesheet" type="text/css" media="all" href="css/niceforms-default.css" /> -->
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<!--<script type="text/javascript" src="js/supportvalidations.js"></script> -->
<script type="text/javascript" src="js/testajax.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CRPL Support System</title>
</head>
<body>
<div class="container">
<h1><img src="images/logosupport.gif" alt="crplTicket" width="222" height="59" border="0"></h1>
<div class="nav">
<ul>
<li>
</li>
<li id="home"><a href="newticket.php"><img src="images/home.gif" border="0" alt="Main" />New Ticket </a></li>
<li id="mytickets"><a href="mytickets.php"><img src="images/my_tickets.gif" border="0" alt="Main" /> My Tickets</a></li>
</ul>
</div>
<div class="content">
<center> </center>
<div style="margin: 10px 0 60px 0;">
<table width="100%" border="0" cellspacing=0 cellpadding=0 align="center">
<tr>
<td nowrap >
<a href="javascript:filterOpen()"><img src="images/view_open_btn.gif" alt="View Open" border=0></a>
<a href="javascript:filterClosed()"><img src="images/view_closed_btn.gif" alt="View Closed" border=0></a> <a href="javascript:nofilter()"><img src="images/refresh_btn.gif" alt="Refresh" border=0></a>
</td>
</tr>
</table>
<div id="grid_data">
</div>
<div style="clear:both"></div>
</div>
<div class="pre-footer"><br />
<br />
<br />
Support Ticket S</div>
<div class="footer"><table border="0" width="100%">
<tr>
<td><a href="http://www.cr-pl.com" target="_blank">Powered by CRPL</a>
<form id="form1" name="form1" method="post" action="">
<input type="hidden" name="vtype" id="vtype" value="G"/>
<?php session_start();
$mycus_idx = $_SESSION["uid"];
?>
<input type="hidden" name="mycusid" id="mycusid" value=<?php echo $mycus_idx ?> >
</form></td>
<td align="right"> </td></tr>
</table></div>
</div>
</div>
<br/>
<script>
//call after page loaded
window.onload=defaultgrid;
</script>
</body>
</html>
As you can see at the bottom I've used a javascript which triggers at the end of the page..
defaultgrid javascript
-----------------------------
Code: function defaultgrid()
{
var dataString = "mycusid="+document.getElementById('mycusid').value+"&dtype="+document.getElementById('vtype').value+"&sid="+Math.random();
$.ajax({
type: "GET", //GET Method used instead of POST
url: "buildgrid.php", //php file that processes the data
data: dataString, //Pass the data
cache: false, //Do not cache the page
success: function(returnString)
{
document.getElementById('grid_data').innerHTML = returnString;
}
});
}
Finally the code which actually populates the grid...
---------------------
buildgrid.php
---------------------
Code: <?php
require_once('hostinfo.php');
// Connect to server and select databse.
$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die("Error : Cannot connect to the database..");
mysql_select_db($dbname) or die("Error : Cannot select Database...");
//Display type
$vtype = $_GET['dtype'];
$pcusid = $_GET['mycusid'];
if($vtype == 'G')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' order by ticketdate desc";
}
if($vtype == 'O')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' AND status='O' order by ticketdate desc";
}
if($vtype == 'C')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' AND status='C' order by ticketdate desc";
}
if($vtype == 'D')
{
//Default query
$squery = "SELECT ticketno, c_id, city, department, subject, priority, status, ticketdate, messagebody from ticketmaster where c_id = '$pcusid' and department='S' order by ticketdate desc";
}
//Execute Statement using mySQL database
$result = mysql_query($squery, $connection) or die(mysql_error());
$ticketRS = mysql_fetch_assoc($result);
if($ticketRS["ticketno"] == "")
{
echo "<br/><br/> No ticket found ...";
return;
}
echo "<table width='100%' border='0' cellspacing=0 cellpadding=2>";
echo "<tr>";
echo "<td>";
echo "<table border='0' cellspacing=0 cellpadding=2 class='tgrid' align='center'>";
echo "<tr>";
echo "<th width='105' height='20' nowrap>";
// echo "<a href='view.php?sort=ID&order=ASC&' title='Sort By Ticket ID ASC'>Ticket #</a></th>";
echo "Ticket #</th>";
echo "<th width='100'>";
// echo "<a href='view.php?sort=date&order=ASC&' title='Sort By Date ASC'>Creation Date</a></th>";
echo "Creation Date</th>";
echo "<th width='60' align='center'>Status</th>";
echo "<th width='240'>Subject</th>";
echo "<th width='150' align='center'>";
// echo "<a href='view.php?sort=dept&order=ASC&' title='Sort By Category ASC'>Department</a></th>";
echo "Department</th>";
echo "<th width='150'>Priority</th>";
echo "<th width='150'>City</th>";
do
{
$theticket = "'" .$ticketRS["ticketno"] . "'";
echo "<tr class='row1' id='496115'>";
echo "<td align='center' title='" .$ticketRS["ticketno"]. "' nowrap>";
// echo "<a class='Icon webTicket' href=javascript:viewticket(" .$ticketRS["ticketno"]. ",'Grid')>" .$ticketRS["ticketno"]."</a></td>";
echo "<a class='Icon webTicket' href=javascript:viewticket(" .$theticket. ",'Grid')>" .$ticketRS["ticketno"]."</a></td>";
// echo "<a class='Icon webTicket' href='javascript:zahid()'>" .$ticketRS["ticketno"]."</a></td>";
echo "<td nowrap> " .$ticketRS["ticketdate"]. "</td>";
echo "<td> " ;
if($ticketRS["status"] == "O")
{
echo "Open" ;
} else
echo "Close";
echo " </td>";
echo "<td> " .$ticketRS["subject"] . " </td>";
echo "<td align='center'> ";
if($ticketRS["department"] == 'H')
{
echo "Hardware" ;
}else
echo "Software"; echo " </td>";
echo "<td align='center'>";
if($ticketRS["priority"] == 'H') echo "High" ; if($ticketRS["priority"] == 'N') echo "Normal" ;
if($ticketRS["priority"] == 'L') echo "Low" ; echo "</td>";
echo "<td align='center'>" .$ticketRS["city"] . "</td>";
echo "</tr>";
} while ($ticketRS = mysql_fetch_assoc($result));
echo "</table> </td> </tr> <tr> <td> </table>";
?>
how to validate date using javascript
I need to validate date in textbox using javascript..The date is must be not greater than TODAY date and not less than before 3 months ..If either of these conditions is fails will show the prompt
Click counter to ignore traffic from search bots
I have a click counter on my site that...well, counts the number of clicks a link gets on the frontpage. It's a good system, but it's got a few flaws, an example being that it counts
Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/In a nutshell it says XHTML is a big no-no for non-geeks when it comes to dynamic pages i.e. PHP.Do I sidestep XHTML
single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be stored into a single field on the mysql table in the back end. e.gthe user may select red + blue +
Checking BOM Authorization Group
Hai Friends,
image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnail and put it into one directory and save the original file into another, but it seems that when
Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...Code: $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME'
timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing the page.I found this code (i didn't write it) which works to load images but does not switch them
PHP MySQL and DATE
Hi everyoneI have a databse and in one of the columns I have date values such as 2009-March-27. If i have a php interface and want to use a query to select all the rows that is in say october. how
asking for direction
I have 2 tables in my data, which are "post" and "event"I won't make a summary page for showing the condition of these two tables.so what I am thinking is SELECT the fields inside