Edak

[SOLVED] AJAX and Joomla

Edak replied to Edak's topic in Javascript Help

Nevermind, I'm scraping AJAX and doing it old school. Thanks anyways!

Hey everyone, I have a page that currently shows entries from the last 30 days by default. I currently have a link at the bottom. "Click here to show results past thirty days." and when clicked it will momentarily show the information I want, but almost instantly it will "reload" the page back to the last 30 days. Now, I've had three people look at it (myself included) and it does this for me, the second person the link does nothing at all and for the last person the link takes them back to the main page. I'm using Google Chrome, second person was using FireFox, not sure on the last. http://jayandtonyservices.com/members/ user: test pass: test The page I'm referring to is "My Unlocks" currently there are two entries, one is set for the last 30 days (to show by default) and the second entry is set at a few months back (So you can see the difference). Only real difference between the two PHP scripts is the MYSQL Query. The PHP/JavaScript <?php define( '_VALID_MOS', 1 ); include_once( 'globals.php' ); require_once( 'configuration.php' ); require_once( 'includes/joomla.php' ); $option="test"; $mainframe = new mosMainFrame( $database, $option, '.' ); $mainframe->initSession(); $my = $mainframe->getUser(); $email = mysql_real_escape_string($my->email); $con = mysql_connect("REMOVED","REMOVED","REMOVED") or die('Could not connect: ' . mysql_error()); mysql_select_db("jayandt_a4804327reselle", $con); //Replace with your MySQL DB Name $sql = "SELECT * FROM unlock_pending WHERE payer_email = '$email' AND TO_DAYS(NOW()) - TO_DAYS(date) <= 30 ORDER BY date DESC"; $result = @mysql_query($sql); ?> <html> <body> <script type="text/javascript"> var xmlhttp function unlockpending() { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Your browser does not support XMLHTTP!"); return; } var url="unlockpending.php"; xmlhttp.onreadystatechange=stateChanged; xmlhttp.open("POST",url,false); xmlhttp.send(null); } function stateChanged() { if (xmlhttp.readyState==4) { document.getElementById("tableness").innerHTML=xmlhttp.responseText; } } function GetXmlHttpObject() { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari return new XMLHttpRequest(); } if (window.ActiveXObject) { // code for IE6, IE5 return new ActiveXObject("Microsoft.XMLHTTP"); } return null; } </script> <table border="0" cellspacing="0" cellpadding="2" id="tableness"> <tr> <th align="left" width="75">Order#</th> <th align="left" width="150">IMEI#</th> <th align="left" width="100">Method</th> <th align="center" width="70">Credits</th> <th align="right" width="100">Unlock Code</th> </tr> <?php while ($row = mysql_fetch_assoc($result)) { if($row['unlockcode'] == "not found") { $color="red"; } elseif ($row['unlockcode'] == "pending") { $color="gray"; } else { $color="green"; } ?> <tr> <td align="left" width="75"><?php echo $row[ 'orderid']; ?></td> <td align="left" width="150"><?php echo $row['imei']; ?></td> <td align="left" width="100"><?php echo $row['method']; ?></td> <td align="center" width="70"><?php echo $row['creditded']; ?></td> <td align="right" width="100">><?php echo $row['unlockcode']; ?></td> </tr> <?php } mysql_free_result($result); mysql_close($con); ?> </tr> </table> <a href="" onclick="unlockpending()">Click here to show results past thirty days</a> </body> </html> The PHP Script <?php define( '_VALID_MOS', 1 ); include_once( 'globals.php' ); require_once( 'configuration.php' ); require_once( 'includes/joomla.php' ); $option="test"; $mainframe = new mosMainFrame( $database, $option, '.' ); $mainframe->initSession(); $my = $mainframe->getUser(); $email = mysql_real_escape_string($my->email); $con = mysql_connect("REMOVED","REMOVED","REMOVED") or die('Could not connect: ' . mysql_error()); mysql_select_db("jayandt_a4804327reselle", $con); //Replace with your MySQL DB Name $sql = "SELECT * FROM unlock_pending WHERE payer_email = '$email' ORDER BY date DESC"; $result = @mysql_query($sql); ?> <html> <body> <table border="0" cellspacing="0" cellpadding="2"> <tr> <th align="left" width="75">Order#</th> <th align="left" width="150">IMEI#</th> <th align="left" width="100">Method</th> <th align="center" width="70">Credits</th> <th align="right" width="100">Unlock Code</th> </tr> <?php while ($row = mysql_fetch_assoc($result)) { if($row['unlockcode'] == "not found") { $color="red"; } elseif ($row['unlockcode'] == "pending") { $color="gray"; } else { $color="green"; } ?> <tr> <td align="left" width="75"><?php echo $row[ 'orderid']; ?></td> <td align="left" width="150"><?php echo $row['imei']; ?></td> <td align="left" width="100"><?php echo $row['method']; ?></td> <td align="center" width="70"><?php echo $row['creditded']; ?></td> <td align="right" width="100">><?php echo $row['unlockcode']; ?></td> </tr> <?php } mysql_free_result($result); mysql_close($con); ?> </tr> </table> </body> </html>

Once every 24 hours in PHP.

Edak posted a topic in PHP Coding Help

Hey I would like to know the best way to allow a user to do something once every 24 hours. My thought was to make a table and store the date in that, but it's a reputation program and what if that user gave rep to 100 people that day, that's 100 tables filled just to hold info so he can't give any of those people rep again. I'd prefer you didn't actually code it out, just pointed me in the right direction. Thanks!

Sign In

Posts

Joined

Last visited

Profile Information

Edak's Achievements

Newbie (1/5)

Reputation

[SOLVED] AJAX and Joomla

[SOLVED] AJAX and Joomla

Once every 24 hours in PHP.

Browse

Activity

Important Information