PHP - About Page Load

I have a page that processes a variable passed in the url to go get information out of a text file in JSON format.  For some reason though, passing one variable loads a page, passing a certain variable (who's data in the file is virtually identical to the first)  will cause the browser to just load the page indefinitely.  Maybe even more strange is that on my local machine, the variable that won't load is switched, and the other loads fine.  How can I debug what's happening when the page never loads so that I never get an error?

Hi!

I am looking for a script that counts how many queries is executed on page load?
I hadn't realised one of my scripts was doing hundreds of queries simultaneously
and never would of thought this would be the cause of high load.

As I'm developing stuff in PHP, I want to ensure minimum queries are executed
especially because I am doing this in a procedural manner and not OOP.

Thanks in advance.

hello,

i want to get into a particular page if the user stays more than lets say 20 minutes to automatically load another php page.

More specific i have a page which is a test. The user answears to some multiple choice questions. i want him to have only a particular time to anwear. Lets say after 20 min i want to load the results page.

Any ideas?

I'm trying to block access to a particular page if the visitor is not from a specific country (using Maxmind Geoip Country database), but not quite sure how to code this properly:

I tried this and many variations of this inside the head tags, bud doesn't work. Any suggestions on the best way to go about this?

Code: [Select]
<?php

require_once("geoip.inc");
$gi = geoip_open("/home/username/GeoIP.dat",GEOIP_STANDARD);
$country_code = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);

if($country_code !== 'US')
header("HTTP/1.0 404 Not Found"); 
exit; 

?>

Is there some way of a php include which is visible on every page (footer), itself having two php includes, but only one of which would be visible, then on the user refreshing the page or on visiting another page on the site, that include would be replaced with another php include?  Preferably done without any js.

Any help appreciated.

Chris

Hi,

I have a div which reloads every 10 seconds but I want it so that if it equals something then redirect the whole page when at the moment it just loads the whole page in in the div but need the div as it stores all my variables, anyone know of anything else I can use?

Thanks

can someone please help me with this
I'm trying to make it so that when the page loads
just the condition below will happend unless the if statment happends.

so I need two if statments that work off of one condition? so i was thinking of using OR
but i would need a if statement that says the page is being loaded

what this code does it displays someones profile when search is hit
but i want it to display the persons own profile soon as the page is loaded first






Code: [Select]
<?php
if(isset($_POST['search'])) {

// searches goaulds then displays them
$search3 = "SELECT goauld,id FROM users WHERE goauld='".mysql_real_escape_string($_POST['goaulds'])."'"; 
$search2 = mysql_query($search3) or die(mysql_error());
WHILE($search1 = mysql_fetch_array($search2)){ 

$grab_goauld = $search1['goauld'];

echo '<table width="300" height="5" border="1" align="center">';
  echo '<th><center>Goauld Statistics</center></th>';
  
   echo "<tr><td height='340'>$grab_goauld</td></tr>";
   
    }
}
  echo '</table>';
  
?>

Hi,   I am trying to make a page where the footer is loaded according to the screen size, so if someone is accessing the website via a tablet will be a footer, if it is from the computer, there will be another footer.   my problem is that although it is recognizing the windows width, it is not changing the footer accordingly.   this is my code:

$width = "<script>document.write(window.innerWidth);</script>";
if ($width < 900)
{
include("footer_mobile.php");
}
else
{
include("footer.php");
}

for some reason it is always loading the else footer even though the windows with changes. I added echo"$width" ; and the result of the variable was fine.     does anyone know what the problem is cause it is driving me crazy?

I am creating a stream page that updates automatically without the page reloading by reloading a div on the page using a timer. However, I only want it to run the update and fade in/fade out when there is a new status in the table. I tried doing it through PHP getting the number of rows in the table on the page itself and then checking the number of rows on an action page, however, the number of rows didnt update when the div was reloaded. I then tried doing it using jquery/javscript but had the same problem.

How can I acheive this?   Thanks in advance

hi! i dont know if the query below from mysql is slowing down the page or i have not written it properly:
It is very slow, even when you limit the results to 100 . Thanks in advance..
Code: [Select]
SELECT  `tbl_business`.`appformno`, " _
            & "`tbl_business`.`pobox`, `tbl_business`.`plotno`, `tbl_business`.`postalcode`, " _
            & "`tbl_business`.`zonecode`, `tbl_business`.`ne`, `tbl_activities`.`act_code`, " _
            & "`tbl_activity_codes`.`approved_fee`, `tbl_payment_status`.`status`, " _
            & "`tbl_business`.`company`, `tbl_activity_codes`.`description` " _
            & "FROM (`citycouncil`.`tbl_activity_codes` `tbl_activity_codes` " _
            & "LEFT JOIN (`citycouncil`.`tbl_business` `tbl_business` " _
            & "LEFT JOIN `citycouncil`.`tbl_activities` `tbl_activities` " _
            & "ON `tbl_business`.`appformno`=`tbl_activities`.`appformno`) " _
            & "ON `tbl_activity_codes`.`act_code`=`tbl_activities`.`act_code`) " _
            & "LEFT JOIN `citycouncil`.`tbl_payment_status` `tbl_payment_status` " _
            & "ON `tbl_activities`.`id`=`tbl_payment_status`.`activity_id` " _
            & "WHERE tbl_business.appformno LIKE '%" & strFormNo & "%' " _
            & "AND tbl_business.bid LIKE '%" & strBizIdNo & "%'" _
            & " AND `tbl_business`.`contperson` LIKE '%" & strContPerson & "%' " _
            & "AND `tbl_business`.`zonecode` LIKE '%" & strZoneCode & "%' " _
            & " AND `tbl_activities`.`act_code` LIKE '%" & strBizActCode & "%' " _
            & "AND `tbl_business`.`roadstreet` LIKE '%" & strStreet & "%' " _
            & " AND `tbl_business`.`company` LIKE '%" & strBizName & "%' " _
            & "AND `tbl_business`.`building` LIKE '%" & strBuilding & "%' " _
            & "ORDER BY `tbl_business`.`appformno`

So I have a page that has profile images basically, but these images cache and when someone clicks on anything, like rotate image, since my script rotates the image and saves it correctly, I can hit Ctrl+F5 and the image then shows up correct, but the page loading itself after running my script using a get method and then using the header coming back to the same page the image looks like it wasn't reloaded. Noones gonna hit Ctrl+F5, so how do I get this to cache the image completely when the page reloads? I've tried
<meta http-equiv="pragma" content="no-cache" />

But this doesn't work, well nothing seems to work really.

Hello All,   I have been going crazy trying to figure this out, I hope someone can help me out   I have header and footer.php files that on all my pages I get them to load with include,   but for some strange reason, this certain page it will not load I did some research and apparently theres problems with div and php, does anyone know how to make this work?   Thank you in advance, Elaine Attached Files  test.txt   4.81KB   7 downloads

Hi guys,

Should be a simple 1.

If i have the following at the top of the page:


$page_views = $row['page_views'] + 1;
mysql_query("UPDATE table SET page_views='$page_views'");


and then the following at the bottom of the page:


echo $row['page_views'];


Should I see the page views as 1 the first time the page is visited, 2 the second time the page is visited, and so on......?
At the moment im seeing 0 on the first page visit, 1 on the second page visit, 2 on the third.....

I had this problem before on another page i was working, and i simply solved it by displaying the mysql query above the echo similar to the code above. However now it does not seem to be working.

Am i missing something really simple? lol

Thanks

Hi Guys and Gals,

I run a simple fansite for some of my fellow MTG Tactics players at www.onlinegamekey.com

I recently made a Booster Page value page he http://www.onlinegamekey.com/booster-packs.php

And it seems the page loads really slow, but I kind of understand that since its doing a lot of math and dealing with a lot of data.

I am wondering if there is a way to possibly optimize the page and querys in such a way that it doesn't take so long to load.

I'm basically using 4 queries to get the value of each pack and 1 function to average the query data. And I add them up as I go.

This is my function to find average values
Code: [Select]
///AVERAGE FUNCTION
function calculate_average($arr) {
    $count = count($arr); //total numbers in array
    foreach ($arr as $value) {
        $total = $total + $value; // total value of array numbers
    }
    $average = ($total/$count); // get average value
    return $average;
}
These are the queries to get the Average Values
Code: [Select]
<?php
///SETTING THE DAY
$today = date("Y/m/d");
///ALTERING DAY QUERY TIME (20 Days of Data)
$minusday = mktime(0,0,0,date("m"),date("d")-20,date("Y"));
///SETTING THE DAY FOR THE QUERIES
$queryday = date("Y/m/d",$minusday);

///DATA SET FOR BOOSTER PACK 1
//GET THE MYTHIC AVERAGE VALUE
$sqlMythic=mysql_query("SELECT AVG( ab.Price_Per ) AS Aaverage
FROM auctions AS ab
INNER JOIN cardlist AS c ON c.card_name = ab.Card_Name
WHERE ab.Day >= '$queryday'
AND c.rarity = 'Mythic Rare'
AND c.set = '1'
GROUP BY c.card_name, ab.Card_Name") or die;
while ($row=mysql_fetch_array($sqlMythic)) {
$MythicValues[]=$row['Aaverage'];
}
///MYTHIC VALUE IS 10% OF AVERAGE VALUE
$Mythic = calculate_average($MythicValues) * .1;

//GET THE RARE AVERAGE VALUE
$sqlRare=mysql_query("SELECT AVG( ab.Price_Per ) AS Aaverage
FROM auctions AS ab
INNER JOIN cardlist AS c ON c.card_name = ab.Card_Name
WHERE ab.Day >= '$queryday'
AND c.rarity = 'Rare'
AND c.set='1'
GROUP BY c.card_name, ab.Card_Name") or die;
while ($row=mysql_fetch_array($sqlRare)) {
$RareValues[]=$row['Aaverage'];
}
///RARE VALUE IS 90% OF AVERAGE RARE VALUE
$Rare = calculate_average($RareValues) *.9;
///TOTAL CONTRIBUTION TO PACK 100% IS 10% MYTHIC + 90% RARE
$raremythic= $Mythic + $Rare;

///GET THE UNCOMMON AVERAGE VALUE
$sqlUncommon=mysql_query("SELECT AVG( ab.Price_Per ) AS Aaverage
FROM auctions AS ab
INNER JOIN cardlist AS c ON c.card_name = ab.Card_Name
WHERE ab.Day >= '$queryday'
AND c.rarity = 'Uncommon'
AND c.set='1'
GROUP BY c.card_name, ab.Card_Name") or die;
while ($row=mysql_fetch_array($sqlUncommon)) {
$ucValues[]=$row['Aaverage'];
}
///UNCOMMON VALUE IS VALUE * 3
$Uncommon = calculate_average($ucValues);
$urm= ($Uncommon * 3) + $raremythic;

///GET THE COMMON VALUE
$sqlCommon=mysql_query("SELECT AVG( ab.Price_Per ) AS Aaverage
FROM auctions AS ab
INNER JOIN cardlist AS c ON c.card_name = ab.Card_Name
WHERE ab.Day >= '$queryday'
AND c.rarity = 'Common'
AND c.set='1'
GROUP BY c.card_name, ab.Card_Name") or die;
while ($row=mysql_fetch_array($sqlCommon)) {
$cValues[]=$row['Aaverage'];
}
///COMMON VALUE IS VALUE * 10
$common = calculate_average($cValues);
//TOTAL SET 1 VALUE IS ALL VALUES ADDED UP
$curm= ($common * 10) + $urm;
?>
But I'm not real sure where the strain is coming from. The page seems to load really slow, and I'm not sure if I should just try and write all these queries as a separate function then have it write the data to a separate table, or if there is another way to optimize this code.

I'm still have a lot to learn so I would appreciate any thoughts or ideas you folks can offer me.

Many thanks

hiii all, i want to show the database field (alise name) as the url after index.php when page or site loads first time. how i can achieve it? please help.... thanks in advance