|
PHP - How To Check Php Page Loading Takes Time ?
Hello Coders,
Iam in a confused situation. I made a php script & in that script i want to check how much time (in seconds) the page is taking to fetch the content from the server. If the time is greater than to i defined time then i want to show a error message to the users. Anybody can give me ideas ..................... ?? Similar TutorialsIs there a way to run a check on the server to see how long it takes for the page to get built, then print it to the screen?
I tried searching for it online for a few minutes, but it wasn't able to be found. All I'm finding on there is how to optimize the pages, but I want a simple time check performed on the page loading
So I am trying to check if the current time is one hour before a variable time: Code: [Select] $date_game=$dt->format('Y n j'.$pieces[2]); echo $date_game; echo date('Y n j H'); if (date('Y n j H') < $date_game) { echo "The time is before the stored time"; } This displays 2012 1 21 17:30 2012 1 21 16 i.e $pieces[2] = 17:30. and $dt formatted Y n j = 2012 1 21. The current Y n j H is 2012 1 21 16. I want to know if it is more than one hour until the date/time stored in $date_game. At the moment it just tells me that it is before that time. Can I do something like Code: [Select] $data_game - 1->format('H'); or something? Thanks guys Could i use curl to check api response time and if so how? I want the script to check if something already has been submitted into the database before the submission, I tried it to do it with num_rows, but I'm encountering a problem. Here's the script: $con_submit = $_POST['submit']; $user_id = $_SESSION['user_id']; if ($con_submit && isset($user_id)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // POST variables $knuffix_name = strip_tags(trim($_POST['knuffix_name'])); $knuffix_contribution = $_POST['knuffix_contribution']; $knuffix_category = strip_tags(trim($_POST['sort_category'])); $query = sprintf("SELECT * FROM con WHERE contribution = '%s'", mysqli_real_escape_string($dbc, $knuffix_contribution)); $query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc)); $num_rows = mysqli_num_rows ($query_run) or die (mysqli_error ($dbc)); // $assoc = mysqli_fetch_assoc ($query_run) or die (mysqli_error ($dbc)); echo "num rows" . $num_rows; // and then as an example: if ($num_rows == 0) { // run INSERT INTO script } } When there are entries in the database then num_rows will return me the amount of entries in the echo, BUT if there are ZERO entries, then nothing will happen, and that is because of the query. Since the query looks as follows: Code: [Select] SELECT * FROM con WHERE contribution = '$variable_post_submission' Which means if there's no entry in the database at all, then the query has nothing to select, which again makes the rest of the script NOT work. Which means that num_rows does not return any value, the echo will not even get printed out. But I on the other hand would like num_rows to return zero and have the script continue by INSERTING the submitted data into the database. Any ideas how I could accomplish this? I seem to have a problem with a PHP page I made. When executed on the server, it loads with a filesize 0 and for some browsers, says it does not exist. I believe that the cause is because it is not parsing due to a syntax error. I've busted my @$$ over this code, trying to find the issue, but cannot find it. Here is the whole page's code on pastie: http://pastie.org/1064160 I have a PHP Page. It is doing a lot of site crawling, throughout a lot of loops. Basically it's getting a massive array together and it's huge. However, it's so big that PHP times out beyond belief. I mean there is no error or nothing. Google throws a major error about page not found, IE shows an internet connection error. It really times out big time. Even though it's not really "A LOT". Any advice on what to do in that situation. I can't show the site/code because of NDA, but was curious if someone had ever done that much work on a PHP page before to have it do that? I have a script which registers people to a database, however it doing something very strange. Whenever I place it into even a single CSS div it adds the registration to the dabase but stops loading the next page (index.php) I find this totally bizarre as I haven't seen anything like this behave before. With CSS affecting how PHP works. Especially when the CSS is not inside the <php> of <form> tags. Code: [Select] <?php include("connect.php"); if($_POST['submit']) { $username = mysql_real_escape_string(trim($_POST['username'])); $password = trim($_POST['password']); $password2 = trim($_POST['password2']); $email = mysql_real_escape_string(trim($_POST['email'])); $error = false; if(!isset($username) || empty($username)) { $error = "You need to enter a username."; } $query = mysql_query("SELECT id FROM users WHERE username = '".$username."' LIMIT 1"); if(mysql_num_rows($query) > 0 && !$error) { $error = "Sorry, that username is already taken!"; } if((!isset($password) || empty($password)) && !$error) { $error = "You need to enter a password."; } if((!isset($password2) || empty($password2)) && !$error) { $error = "You need to enter your password twice."; } if($password != $password2 && !$error) { $error = "The passwords you entered did not match."; } if((!isset($email) || empty($email)) && !$error) { $error = "You need to enter an email."; } if(preg_match("/[a-zA-Z0-9-.+]+@[a-zA-Z0-9-]+.[a-zA-Z]+/", $email) == 0 && !$error) { $error = "The email you entered is not valid."; } $query = mysql_query("SELECT id FROM users WHERE email = '".$email."' LIMIT 1"); if(mysql_num_rows($query) > 0 && !$error) { $error = "Sorry, that email is already in use!"; } if(!$error) { $query = mysql_query("INSERT INTO users (username, password, email) VALUES ('".$username."', '".mysql_real_escape_string(md5($password))."', '".$email."')"); if($query) { $message = "Hello ".$_POST['username'].",\r\n\r\nThanks for registering! We hope you enjoy your stay.\r\n\r\nThanks,\r\nJohn Doe"; $headers = "From: ".$website['name']." <".$website['email'].">\r\n"; mail($_POST['email'], "Welcome", $message, $headers); setcookie("user", mysql_insert_id(), $time); setcookie("pass", mysql_real_escape_string(md5($password)), $time); header("Location: index.php"); } else { $error = "There was a problem with the registration. Please try again."; } } } ?><html> <head> <title>Register</title> </head> <body> <form action="" method="post"> <?php if($error) echo "<span style=\"color:#ff0000;\">".$error."</span><br /><br />"; ?> <label for="username">Username: </label> <input type="text" name="username" value="<?php if($_POST['username']) echo $_POST['username']; ?>" /><br /> <label for="password">Password: </label> <input type="password" name="password" value="<?php if($_POST['password']) echo $_POST['password']; ?>" /><br /> <label for="password2">Retype Password: </label> <input type="password" name="password2" value="<?php if($_POST['password2']) echo $_POST['password2']; ?>" /><br /> <label for="email">Email: </label> <input type="text" name="email" value="<?php if($_POST['email']) echo $_POST['email']; ?>" /><br /><br /> <input type="submit" name="submit" value="Register" /> </form> </body> I have some issue with the website just created specifically http://ecolandscaping.co/index.php?m=3 and hosted on the 000webhosting.com. It loads the page slowly. Things what i have consideredto trie to improve better performance: * optimized CSS files * optimized MySQL queries with specifying the rows wanted (SELECT ID, IMAGE.....) * avoid to select an image saved as blob if not necessary etc. * made different image retrieving php files P.S. the website is small of size approx 700KB for loading. Problem is that not all the images (saved in MYSQL BLOB) are loaded successfully. Could anyone have a look and advice what else could cause the performance issue. P.S.S. I do take in account that this isthe free hosting and may cause some problems I have a very weird problem on my PHP5.3/Apache/MySQL based system on WinXp Pro. I have written php script which basically scans every directory in my local hard disc, checks which files are images, sets a counter of the number of images found per folder and saves this count in a MySQL table. To put you in the picture, we are talking about 1000 folders with about 8-10pics each on average 9000 files. On the previous PHP 5.1 / IIS system, (same PC) this used to work moderately well (took a nice 6 mins) and I had to include the command set_time_limit of about 3seconds in the looping to avoid execution timeout failures. (also worked by setting a high value of 10mins before the loopping) ANyway, now I run the exact same script on the new Php5.3 and have the problem that the code starts operating quite fast and gradually it slows and slows until eventually it is dead slow and have to quit internet explorer. For exampe, the first 3000 files are scanned in just 60seconds, then the next 1000 in the next 4 mins, and eventually drops to about 100files or less files per minute. I also noticed that the CPU consumption of iexplorer.exe is 90-99%, and the window of Internet explorer is very slugish with a temp '(not responding)' messages on the top window bar. WHat can I do and test? Is it the code itself, the PHP5.3 or something in php.ini or apache conf. file? Buffers? memory? WHat? gonna crazy! basically, the code scans a dir (location of dir taken from Mysql) puts file contents in an array, analyse the array for .jpg/.gif (and other parameters specific to pics, counts the valid pic files in a variable, puts this in a MySql databse, loops for next folder. The code is a kind of tool to have a count of my pics in my folders and never used remote server/online but only local. Thanks for your time my server is using sendmail, but it takes about 60 seconds to send. And by send, i don't mean to recieve the message. I just have a simple mail call, and when i hit that page it takes about 60 sec to return a result to me. I look for a while on what might be causing, but i can't seem to find anything that i can test out. Anyone ever have this know whats going on? Hi, I'm new. I have been searching for this, but couldn't find my answer ... I've got a form on page A, with its 'action' attribute set to page B.php. Page B does nothing but process the form data & put it in a database. At the bottom of B.php there's a header redirect to page C. My problem is that page B shows up briefly in the browser, looking all blank and weird. Is there a sensible way around this? I just want it to do its stuff in the background. I realise I should be Ajaxing it all but, apart from the fact that I struggle with Ajax operations longer than a couple of lines, it's important that the site should work without javascript. I HOPE this is a really easy one! Thanks What I'm trying to do is get a php file with content to load into my basic page template based on the page id, however it's not loading anything, however there are no errors coming up. I've looked everywhere I could find, and tried everything I could think of. I really could use some help on this. Below is the page template code and the code I'm trying to use to get the content to load up. page_templ.php Code: [Select] <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" > <link rel="stylesheet" type="text/css" href="templates/content/style.css" > <!--This is the css used for IE because we need to correct some things for it.--> <!--[if IE]> <style type="text/css"> @import 'templates/content/styleIE.css'; </style> <![endif]--> </head> <body> <?php //We need to load our language files with our common text varibles require("content/langeng.php"); ?> <div id="header"> <? //Lets show the header. I use html where I can so smartphones load as little advanced code as possible require_once("header.php"); ?> </div> <div id="menu"> <?//Now our menu. require_once("menu.php"); ?> </div> <div id="mbody"> <?//Now the primary site content. //Load up our postvars.php file require_once("content/postvars.php"); ?> </div> </body> </html> postvars.php Code: [Select] <?php $id = $_POST["id"]; if ( $id == "home" ) { include 'main_c.php'; } elseif ( $id == "guides" ) { include 'guides_c.php'; } elseif ( $id == "trips" ) { include 'trips_c.php'; } ?> This should be an easy one but I'm looking for a bit of help. I'm using a php framework and using includes to bring different pieces of a website togethor onto the page. The top of the page uses a flash banner, then there are some simple text sections below. The banner is in it's own php file as well. Wondering if it's possible to have the banner NOT replay after each page load? I'm not sure if this is something I need to setup in the flash file, or if there is a way to do it in the php files? Basically, the banner is the same for all of the pages, and I want it (once loaded) to stay on the page while the details on the bottom change, WITHOUT going through the entire animation again. Make sense? here's the page as it stands now so you can get a better idea what I'm trying to do. http://www.getmoreimpact.com/index.php again not sure if this needs to be done in the flash side, or the php? Any ideas are better than what I've got! Thanks in advance Hi Guys, Quick question. I'm trying to get my head around how I would check that a user has reached a certain page from another page. So for example, the workflow through my site is something like the following: user registers a verification email is sent user clicks the link within the verification email to complete the sign up process user logs in and ONLY on a successful login will the following happen: checks are made to see if account has been verified if user has been verified, go to main menu if user has not been activated his account then he goes to a page that says account has not been activated The bit i'm struggling to get my head around is this... the user should only reach the page 'account has not been activated' page from the login page. If that page was called confirm-account.php. What can i do to stop a random person typing something along the lines of www.mywebsite.com/confirm-account.php and getting straight onto that page? or even upon the registration process if the user is taken to a page that says an email has been sent, how would i stop a random person just typing the url straight to that page and bypassing the pages I would expect them to have gone through before reaching that?? Cheers How <?xml-stylesheet href="/player.xsl" type="text/xsl"?> <config> <auto_start>false</auto_start> <player_skin>/test.swf</player_skin> <main_title>Test</main_title> <playlist_title>PLAYLIST</playlist_title> <time_text>TOTAL TIME</time_text> <pan_labels>L,R</pan_labels> <scroller_speed>1</scroller_speed> <scroller_marquee_content>#TRACK_NAME#</scroller_marquee_content> <repeat_is_enabled>false</repeat_is_enabled> <shuffle_is_enabled>false</shuffle_is_enabled> <default_volume>75</default_volume> <default_pan>0</default_pan> <play_list> <item>test.mp3;Test Soundtrack</item> </play_list> </config>Hi, The above code is from an XML file and I added the <?xml line of code to the XML file, but doing so causes the whole page to no longer display the track information (just blank). Is there there a way I could modify that text to try and call it another way? Thanks Edited by hexcode, 16 July 2014 - 02:52 PM. Apologies if the title is quite vague, I suppose I am looking for some general advice on why some pages I write in PHP, which contain MySQL queries, might be running a bit slow. The following page takes up to 3 seconds to display:
<?php
session_start();
include('admin/user.php');
$connection = mysql_connect("$host","$user","$password")
or die(mysql_error());
mysql_select_db("$txt_db_name",$connection)
or die(mysql_error());
$id = $_REQUEST['id'];
// MATCH INFO
$get_details = mysql_query("
SELECT
MatchDateTime AS date,
DATE_FORMAT(MatchDateTime, '%Y-%m-%d') AS formatdate
FROM
tplss_matches
WHERE
MatchID = '$id'
LIMIT 1",$connection) or die(mysql_error());
$factsdata = mysql_fetch_array($get_details);
mysql_free_result($get_details);
$matchdate = $factsdata['date'];
$matchdate2 = $factsdata['formatdate'];
// -----------SHOW FACTS ABOUT THE STARTING LINEUP---------
echo"
<h5>Appearances & Goals To Date</h5>
<table width=100%>";
$get_starters = mysql_query("
SELECT P.PlayerID AS playerid, CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerNationID AS nation, P.PlayerPositionID as pos
FROM tplss_players P, tplss_appearances A
WHERE A.AppearancePlayerID = P.PlayerID AND A.AppearanceMatchID = '$id'
ORDER BY P.PlayerPositionID ASC
",$connection) or die(mysql_error());
$get_subbies = mysql_query("
SELECT P.PlayerID AS playerid, CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerNationID AS nation, P.PlayerPositionID as pos
FROM tplss_players P, tplss_substitutions S
WHERE S.SubstitutionPlayerIDIn = P.PlayerID AND S.SubstitutionMatchID = '$id'
ORDER BY P.PlayerPositionID ASC
",$connection) or die(mysql_error());
while($combstarters = mysql_fetch_array($get_starters))
{
echo"<tr>";
echo"<td><a href=\"player.php?id=$combstarters[playerid]\">$combstarters[name]</a>";
if($combstarters['pos'] == 1)
{ echo" (GK)"; }
echo"</td>";
$combpid = $combstarters['playerid'];
echo"
<td align=\"left\" style=\"vertical-align: middle;\">
<img src=\"images/flag_$combstarters[nation].jpg\" border=1>
</td>
";
$get_comb_apps = mysql_query("SELECT
COUNT(A.AppearancePlayerID) AS apps
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = '$combpid' AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
",$connection) or die(mysql_error());
$get_comb_ins = mysql_query("SELECT
COUNT(S.SubstitutionPlayerIDIn) AS ins
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = '$combpid' AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
",$connection) or die(mysql_error());
while($combdata = mysql_fetch_array($get_comb_apps))
{
while($idata = mysql_fetch_array($get_comb_ins))
{
$totalapps = $combdata['apps'] + $idata['ins'];
if($totalapps == 1)
{ echo"<td>$totalapps app (debut)</td>"; }
else
{ echo"<td>$totalapps apps</td>"; }
}
mysql_free_result($get_comb_ins);
}
mysql_free_result($get_comb_apps);
$get_goals_all = mysql_query("
SELECT COUNT(G.GoalPlayerID) AS total_goals
FROM tplss_goals G, tplss_matches M WHERE G.GoalPlayerID = '$combpid' AND G.GoalMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate' AND G.GoalOwn != 1
GROUP BY G.GoalPlayerID
",$connection) or die(mysql_error());
if(mysql_num_rows($get_goals_all) == 0)
{ echo"<td> - </td>"; }
while($combgoals = mysql_fetch_array($get_goals_all))
{
if($combgoals['total_goals'] == 1)
{ echo"<td>$combgoals[total_goals] goal</td>"; }
else
{ echo"<td>$combgoals[total_goals] goals</td>"; }
}
mysql_free_result($get_goals_all);
echo"</tr>";
}
while($combsubbies = mysql_fetch_array($get_subbies))
{
echo"<tr>";
echo"<td><a href=\"player.php?id=$combsubbies[playerid]\">$combsubbies[name]</a> (sub)";
if($combsubbies['pos'] == 1)
{ echo" (GK)"; }
echo"</td>";
$combpid = $combsubbies['playerid'];
echo"
<td align=\"left\" style=\"vertical-align: middle;\">
<img src=\"images/flag_$combsubbies[nation].jpg\" border=1>
</td>
";
$get_comb_apps = mysql_query("SELECT
COUNT(A.AppearancePlayerID) AS apps
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = '$combpid' AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
",$connection) or die(mysql_error());
$get_comb_ins = mysql_query("SELECT
COUNT(S.SubstitutionPlayerIDIn) AS ins
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = '$combpid' AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
",$connection) or die(mysql_error());
while($combdata = mysql_fetch_array($get_comb_apps))
{
while($idata = mysql_fetch_array($get_comb_ins))
{
$totalapps = $combdata['apps'] + $idata['ins'];
if($totalapps == 1)
{ echo"<td>$totalapps app (debut)</td>"; }
else
{ echo"<td>$totalapps apps</td>"; }
}
mysql_free_result($get_comb_ins);
}
mysql_free_result($get_comb_apps);
$get_goals_all = mysql_query("
SELECT COUNT(G.GoalPlayerID) AS total_goals
FROM tplss_goals G, tplss_matches M WHERE G.GoalPlayerID = '$combpid' AND G.GoalMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate' AND G.GoalOwn != 1
GROUP BY G.GoalPlayerID
",$connection) or die(mysql_error());
if(mysql_num_rows($get_goals_all) == 0)
{ echo"<td> - </td>"; }
while($combgoals = mysql_fetch_array($get_goals_all))
{
if($combgoals['total_goals'] == 1)
{ echo"<td>$combgoals[total_goals] goal</td>"; }
else
{ echo"<td>$combgoals[total_goals] goals</td>"; }
}
mysql_free_result($get_goals_all);
echo"</tr>";
}
echo"</table>";
// -----------SHOW FACTS ABOUT THE STARTING LINEUP---------
echo"<br>
<h5>Starting Lineup</h5>
<table width=100%>";
// GET YOUNGEST PLAYER IN STARTING LINEUP
$get_youngest_player = mysql_query("
SELECT
P.PlayerDOB AS dob,
DATE_FORMAT(P.PlayerDOB, '%d/%m/%Y') AS birth,
CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name,
P.PlayerID AS id
FROM
tplss_players P, tplss_appearances A, tplss_matches M
WHERE
P.PlayerID = A.AppearancePlayerID AND
A.AppearanceMatchID = M.MatchID AND
M.MatchDateTime = '$matchdate'
ORDER BY
dob DESC
LIMIT 0,1
",$connection) or die(mysql_error());
while($youngest = mysql_fetch_array($get_youngest_player))
{
echo"<tr>";
$dob = $youngest['dob'];
echo"<td width=30%>Youngest Player:</td><td width=70%><a href=\"player.php?id=$youngest[id]\">$youngest[name]</a> (";
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = ($now - $your_date) / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"$years years $remainder days)</td>
</tr>
";
}
mysql_free_result($get_youngest_player);
// GET OLDEST PLAYER IN STARTING LINEUP
$get_oldest_player = mysql_query("
SELECT
P.PlayerDOB AS dob,
DATE_FORMAT(P.PlayerDOB, '%d/%m/%Y') AS birth,
CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name,
P.PlayerID AS id
FROM
tplss_players P, tplss_appearances A, tplss_matches M
WHERE
P.PlayerID = A.AppearancePlayerID AND
A.AppearanceMatchID = M.MatchID AND
M.MatchDateTime = '$matchdate'
ORDER BY
dob ASC
LIMIT 0,1
",$connection) or die(mysql_error());
while($oldest = mysql_fetch_array($get_oldest_player))
{
echo"<tr>";
$dob = $oldest['dob'];
echo"<td width=30%>Oldest Player:</td><td width=70%><a href=\"player.php?id=$oldest[id]\">$oldest[name]</a> (";
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = ($now - $your_date) / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"$years years $remainder days)</td>";
echo"</tr>";
}
mysql_free_result($get_oldest_player);
// GET AVERAGE DOB OF STARTING XI
$get_average_dob = mysql_query("
SELECT
FROM_DAYS(AVG(TO_DAYS(P.PlayerDOB))) AS dob
FROM
tplss_players P, tplss_appearances A, tplss_matches M
WHERE
P.PlayerID = A.AppearancePlayerID AND
A.AppearanceMatchID = M.MatchID AND
M.MatchDateTime = '$matchdate'
",$connection) or die(mysql_error());
while($average = mysql_fetch_array($get_average_dob))
{
echo"<tr>";
$dob = $average['dob'];
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = $datediff_days / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"<td width=30%>Average Player Age:</td><td width=70%>$years years $remainder days</td>";
echo"</tr>";
}
mysql_free_result($get_average_dob);
$get_players = mysql_query("
SELECT
COUNT(P.PlayerID) AS players
FROM
tplss_players P, tplss_appearances A, tplss_matches M
WHERE
P.PlayerID = A.AppearancePlayerID AND
A.AppearanceMatchID = M.MatchID AND
M.MatchDateTime = '$matchdate'
GROUP BY M.MatchID
",$connection) or die(mysql_error());
$get_scots = mysql_query("
SELECT
COUNT(P.PlayerID) AS scots
FROM
tplss_players P, tplss_appearances A, tplss_matches M
WHERE
P.PlayerID = A.AppearancePlayerID AND
A.AppearanceMatchID = M.MatchID AND
M.MatchDateTime = '$matchdate' AND
P.PlayerNationID = 1
GROUP BY M.MatchID
",$connection) or die(mysql_error());
while($players = mysql_fetch_array($get_players))
{
echo"<tr>";
while($scots = mysql_fetch_array($get_scots))
{
$average = ($scots['scots'] / $players['players']) * 100;
$average = number_format((float)$average, 2, '.', '');
echo"<td width=30%>Domestic Players:</td><td width=70%>$scots[scots] ($average % of starting eleven)</td>";
}
echo"</tr>";
}
mysql_free_result($get_players);
echo"</table>";
?>
<?
// -----------SHOW FACTS ABOUT THE MATCHDAY SQUAD--------------
echo"<br>
<h5>Matchday Squad</h5>
<table width=100%>
";
// GET YOUNGEST PLAYER IN SQUAD
$get_youngest_player_all = mysql_query("
SELECT
P.PlayerDOB AS dob,
CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name,
P.PlayerID AS id
FROM
tplss_players P
INNER JOIN
(
SELECT AppearancePlayerID as PlayerID
, AppearanceMatchID as MatchID
FROM tplss_appearances
UNION
SELECT SubstitutePlayerID as PlayerID
, SubstituteMatchID as MatchID
FROM tplss_substitutes
)
as total USING (PlayerID)
INNER JOIN tplss_matches M USING (MatchID)
WHERE
M.MatchDateTime = '$matchdate'
ORDER BY
dob DESC
LIMIT 0,1
",$connection) or die(mysql_error());
while($youngest_all = mysql_fetch_array($get_youngest_player_all))
{
echo"<tr>";
$dob = $youngest_all['dob'];
echo"<td width=30%>Youngest Player:</td><td width=70%><a href=\"player.php?id=$youngest_all[id]\">$youngest_all[name]</a> (";
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = ($now - $your_date) / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"$years years $remainder days)</td>";
echo"</tr>";
}
// GET OLDEST PLAYER IN SQUAD
$get_oldest_player_all = mysql_query("
SELECT
P.PlayerDOB AS dob,
CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name,
P.PlayerID AS id
FROM
tplss_players P
INNER JOIN
(
SELECT AppearancePlayerID as PlayerID
, AppearanceMatchID as MatchID
FROM tplss_appearances
UNION
SELECT SubstitutePlayerID as PlayerID
, SubstituteMatchID as MatchID
FROM tplss_substitutes
)
as total USING (PlayerID)
INNER JOIN tplss_matches M USING (MatchID)
WHERE
M.MatchDateTime = '$matchdate'
ORDER BY
dob ASC
LIMIT 0,1
",$connection) or die(mysql_error());
while($oldest_all = mysql_fetch_array($get_oldest_player_all))
{
echo"<tr>";
$dob = $oldest_all['dob'];
echo"<td width=30%>Oldest Player:</td><td width=70%><a href=\"player.php?id=$oldest_all[id]\">$oldest_all[name]</a> (";
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = ($now - $your_date) / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"$years years $remainder days)</td>";
echo"</tr>";
}
// GET AVERAGE DOB OF WHOLE SQUAD
$get_average_dob_all = mysql_query("
SELECT
FROM_DAYS(AVG(TO_DAYS(P.PlayerDOB))) AS dob
FROM
tplss_players P
INNER JOIN
(
SELECT AppearancePlayerID as PlayerID
, AppearanceMatchID as MatchID
FROM tplss_appearances
UNION
SELECT SubstitutePlayerID as PlayerID
, SubstituteMatchID as MatchID
FROM tplss_substitutes
)
as total USING (PlayerID)
INNER JOIN tplss_matches M USING (MatchID)
WHERE
M.MatchDateTime = '$matchdate'
",$connection) or die(mysql_error());
while($average_all = mysql_fetch_array($get_average_dob_all))
{
echo"<tr>";
$dob = $average_all['dob'];
$now = strtotime("$matchdate");
$your_date = strtotime("$dob");
$datediff_days = $now - $your_date;
$datediff_years = ($now - $your_date) / 365;
$days = floor($datediff_days/(60*60*24));
$years = floor($datediff_years/(60*60*24));
$remainder = floor($datediff_days/(60*60*24)) - (floor($datediff_years/(60*60*24)) * 365);
echo"<td width=30%>Average Player Age:</td><td width=70%>$years years $remainder days</td>";
echo"</tr>";
}
$get_players_all = mysql_query("
SELECT
COUNT(P.PlayerID) AS allplayers
FROM
tplss_players P
INNER JOIN
(
SELECT AppearancePlayerID as PlayerID
, AppearanceMatchID as MatchID
FROM tplss_appearances
UNION
SELECT SubstitutePlayerID as PlayerID
, SubstituteMatchID as MatchID
FROM tplss_substitutes
)
as total USING (PlayerID)
INNER JOIN tplss_matches M USING (MatchID)
WHERE
M.MatchDateTime = '$matchdate'
GROUP BY M.MatchID
",$connection) or die(mysql_error());
$get_scots_all = mysql_query("
SELECT
COUNT(P.PlayerID) AS scots
FROM
tplss_players P
INNER JOIN
(
SELECT AppearancePlayerID as PlayerID
, AppearanceMatchID as MatchID
FROM tplss_appearances
UNION
SELECT SubstitutePlayerID as PlayerID
, SubstituteMatchID as MatchID
FROM tplss_substitutes
)
as total USING (PlayerID)
INNER JOIN tplss_matches M USING (MatchID)
WHERE
M.MatchDateTime = '$matchdate' AND
P.PlayerNationID = 1
GROUP BY M.MatchID
",$connection) or die(mysql_error());
while($players_all = mysql_fetch_array($get_players_all))
{
while($scots_all = mysql_fetch_array($get_scots_all))
{
echo"<tr>";
$average = ($scots_all['scots'] / $players_all['allplayers']) * 100;
$average = number_format((float)$average, 2, '.', '');
echo"<td width=30%>Domestic Players:</td><td width=70%>$scots_all[scots] ($average % of matchday squad)</td>";
echo"</tr>";
}
}
echo"</table>";
?>
<?
//--------------CHECK FOR ANY DEBUTS----------------
// GET STARTING XI FOR DEBUTS
$get_debuts = mysql_query("
SELECT CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerID AS id, DATE_FORMAT(P.PlayerSigned, '%M %D, %Y') AS signed
FROM tplss_players P, tplss_appearances A
WHERE A.AppearanceMatchID = '$id' AND P.PlayerID = A.AppearancePlayerID
ORDER BY name",$connection);
// GET SUBS FOR DEBUTS
$get_sub_debuts = mysql_query("
SELECT CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerID AS id, DATE_FORMAT(P.PlayerSigned, '%M %D, %Y') AS signed
FROM tplss_players P, tplss_substitutions S
WHERE S.SubstitutionMatchID = '$id' AND P.PlayerID = S.SubstitutionPlayerIDIn
ORDER BY name",$connection);
echo"<br><h5>First Team Debuts</h5>
<table width=100%>";
// SHOW ANY DEBUTS FOR PLAYERS IN STARTING XI
while($appdata = mysql_fetch_array($get_debuts))
{
$appplayerid = $appdata['id'];
$get_starts = mysql_query("
SELECT COUNT(A.AppearancePlayerID) AS total
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = $appplayerid AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY A.AppearancePlayerID
",$connection) or die(mysql_error());
$starts = mysql_fetch_array($get_starts);
$get_subst = mysql_query("
SELECT COUNT(S.SubstitutionPlayerIDIn) AS total
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = $appplayerid AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY S.SubstitutionPlayerIDIn
",$connection) or die(mysql_error());
$subst = mysql_fetch_array($get_subst);
$total_apps = $starts['total'] + $subst['total'];
$head_url = "images/heads/" . $appplayerid . ".jpg";
if($total_apps == 1)
{ echo"<tr>
<td width=20%>
<img src=\"";
if(file_exists($head_url))
{ echo"images/heads/$appplayerid.jpg"; }
else
{ echo"images/heads/none.jpg"; }
echo"\" width=\"50\" style=\"border:0px solid; border-radius:25px;\">
</td>
<td width=40%><a href=\"player.php?id=$appplayerid\">$appdata[name]</a></td><td width=40%>(Signed $appdata[signed])</td>"; }
else
{ echo""; }
}
mysql_free_result($get_debuts);
// SHOW ANY DEBUTS FOR PLAYERS COMING OFF BENCH
while($appdatas = mysql_fetch_array($get_sub_debuts))
{
$appplayerid = $appdatas['id'];
$get_starts = mysql_query("
SELECT COUNT(A.AppearancePlayerID) AS total
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = $appplayerid AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY A.AppearancePlayerID
",$connection) or die(mysql_error());
$starts = mysql_fetch_array($get_starts);
$get_subst = mysql_query("
SELECT COUNT(S.SubstitutionPlayerIDIn) AS total
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = $appplayerid AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY S.SubstitutionPlayerIDIn
",$connection) or die(mysql_error());
$subst = mysql_fetch_array($get_subst);
$total_apps = $starts['total'] + $subst['total'];
$head_url = "images/heads/" . $appplayerid . ".jpg";
if($total_apps == 1)
{ echo"<tr>
<td width=20%>
<img src=\"";
if(file_exists($head_url))
{ echo"images/heads/$appplayerid.jpg"; }
else
{ echo"images/heads/none.jpg"; }
echo"\" width=\"50\" style=\"border:0px solid; border-radius:25px;\">
</td>
<td width=40%><a href=\"player.php?id=$appplayerid\">$appdatas[name]</a></td><td width=40%>(Signed $appdatas[signed])</td>"; }
else
{ echo""; }
}
mysql_free_result($get_sub_debuts);
echo"</table>";
?>
<?php
// --------------------CHECK FOR ANY MILESTONES----------------
// GET STARTING XI FOR MILESTONES
$get_milestones = mysql_query("
SELECT CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerID AS id
FROM tplss_players P, tplss_appearances A
WHERE A.AppearanceMatchID = '$id' AND P.PlayerID = A.AppearancePlayerID
ORDER BY name",$connection);
// GET SUBS FOR MILESTONES
$get_sub_milestones = mysql_query("
SELECT CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerID AS id
FROM tplss_players P, tplss_substitutions S
WHERE S.SubstitutionMatchID = '$id' AND P.PlayerID = S.SubstitutionPlayerIDIn
ORDER BY name",$connection);
// GET SCORERS FOR GOAL CHECKS
$get_goals = mysql_query("
SELECT CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, P.PlayerID AS id
FROM tplss_players P, tplss_goals G
WHERE G.GoalMatchID = '$id' AND P.PlayerID = G.GoalPlayerID AND G.GoalOwn != 1
ORDER BY name",$connection);
echo"<Br><h5>Milestones</h5>
<table width=100%>";
// SHOW MILESTONES FOR STARTING XI
while($appdatam = mysql_fetch_array($get_milestones))
{
$appplayerid = $appdatam['id'];
$get_starts = mysql_query("
SELECT COUNT(A.AppearancePlayerID) AS total
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = $appplayerid AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY A.AppearancePlayerID
",$connection) or die(mysql_error());
$starts = mysql_fetch_array($get_starts);
$get_subst = mysql_query("
SELECT COUNT(S.SubstitutionPlayerIDIn) AS total
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = $appplayerid AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY S.SubstitutionPlayerIDIn
",$connection) or die(mysql_error());
$subst = mysql_fetch_array($get_subst);
$total_apps = $starts['total'] + $subst['total'];
echo"";
if($total_apps == '50')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> played his 50th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '100')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> played his 100th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '200')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> made his 200th competitive appearance for the Club.</td></tr>"; }
elseif($total_apps == '250')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> played his 250th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '300')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> made his 300th competitive appearance for the Club.</td></tr>"; }
elseif($total_apps == '400')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> played his 400th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '500')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatam[name]</a> made his 500th competitive appearance for the Club.</td></tr>"; }
else
{ echo""; }
echo"";
}
mysql_free_result($get_milestones);
// SHOW MILESTONES FOR SUBS
while($appdatams = mysql_fetch_array($get_sub_milestones))
{
$appplayerid = $appdatams['id'];
$get_starts = mysql_query("
SELECT COUNT(A.AppearancePlayerID) AS total
FROM tplss_appearances A, tplss_matches M
WHERE A.AppearancePlayerID = $appplayerid AND A.AppearanceMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY A.AppearancePlayerID
",$connection) or die(mysql_error());
$starts = mysql_fetch_array($get_starts);
$get_subst = mysql_query("
SELECT COUNT(S.SubstitutionPlayerIDIn) AS total
FROM tplss_substitutions S, tplss_matches M
WHERE S.SubstitutionPlayerIDIn = $appplayerid AND S.SubstitutionMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY S.SubstitutionPlayerIDIn
",$connection) or die(mysql_error());
$subst = mysql_fetch_array($get_subst);
$total_apps = $starts['total'] + $subst['total'];
if($total_apps == '50')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> played his 50th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '100')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> played his 100th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '200')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> made his 200th competitive appearance for the Club.</td></tr>"; }
elseif($total_apps == '250')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> played his 250th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '300')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> made his 300th competitive appearance for the Club.</td></tr>"; }
elseif($total_apps == '400')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> played his 400th major competitive game for the Club.</td></tr>"; }
elseif($total_apps == '500')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$appdatams[name]</a> made his 500th competitive appearance for the Club.</td></tr>"; }
else
{ echo""; }
}
mysql_free_result($get_sub_milestones);
// SHOW MILESTONES FOR STARTING XI
while($goaldata = mysql_fetch_array($get_goals))
{
$appplayerid = $goaldata['id'];
$get_goal_totals = mysql_query("
SELECT COUNT(G.GoalPlayerID) AS total
FROM tplss_goals G, tplss_matches M
WHERE G.GoalPlayerID = $appplayerid AND G.GoalMatchID = M.MatchID AND M.MatchDateTime <= '$matchdate'
GROUP BY G.GoalPlayerID
",$connection) or die(mysql_error());
$goals = mysql_fetch_array($get_goal_totals);
$total_goals = $goals['total'];
if($total_goals == '1')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> scored his first goal for the Club.</td></tr>"; }
elseif($total_goals == '10')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> reached 10 goals for the Club.</td></tr>"; }
elseif($total_goals == '25')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> scored for the 25th time for the Club.</td></tr>"; }
elseif($total_goals == '30')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> reached 30 goals for the Club.</td></tr>"; }
elseif($total_goals == '50')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> scored his 50th goal for the Club.</td></tr>"; }
elseif($total_goals == '75')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> reached 75 goals for the Club.</td></tr>"; }
elseif($total_goals == '100')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> scored his 100th goal for the Club.</td></tr>"; }
elseif($total_goals == '200')
{ echo"<tr><td width=100%><a href=\"player.php?id=$appplayerid\">$goaldata[name]</a> scored his 200th goal for the Club.</td></tr>"; }
else
{ echo""; }
}
echo"</table>";
mysql_free_result($get_goals);
?>
<hr>
Any suggestions or general advice would be greatly appreciated.
So long story short im trying to read a text file line by line and do a cpl db tests agains that one line my file size is about 1300 lines long so I cut it down to 600 and the page is stil stuck loading, can anyone tell me why, my code is below.: (it was working fine I must have just changed something without knowing it) Code: [Select] <?php include ("include/session.php"); $file_handle = fopen ( "To Do.txt", "rb" ); while ( ! feof ( $file_handle ) ) { $line_of_text = fgets ( $file_handle ); $parts = explode ( '=', $line_of_text ); //get the course infomation //Examples: //$Course_info[0] = GEOL //$Course_info[1] = 1002 //$title = Introduction To Geology $Course_info = explode ( ' ', $parts [0] ); $length = strlen ( $Course_info [0] ) + strlen ( $Course_info [1] ) + 2; $title = substr ( $parts [0], $length ); //check to see if this course is already in the database $sql = "SELECT * FROM courses WHERE course = '$Course_info[0]' AND code = '$Course_info[1]'"; $res = mysql_query ( $sql ) or die ( mysql_error () ); if (mysql_num_rows ( $res ) == 0) { //course doesnt exist //lets get the program ID for this course $id_sql = "SELECT id FROM catagories WHERE code = '$course_info[0]'"; $res = mysql_query($id_sql) or die (mysql_error()); $row = mysql_fetch_array ( $res ); echo $row ['code']; } else { //course is already in the database } exit (); }
$start = 0; I have a script to write out the number of hits each of my websites got each day of the week since I don't trust Google Analytics spying on my websites. The problem is that I have to query each day individually and count how many instances there are with that domain. Since I setup my database give me the time, location, demographics, etc. on each line I'm not sure how to optimize this further. Help would be greatly appreciated. Code: [Select] echo '<table><tr><td>Domain</td>'; foreach($timearray as $t){ echo '<td>'.$t.'</td>'; } echo '</tr>'; $i = 0; foreach($urlarray as $u){ $today = date("Y-m-d"); $yesterday = date("Y-m-d", mktime(0,0,0,date("m") , date("d")-1, date("Y"))); $lastmonth = date("Y-m-d", mktime(0,0,0,date("m")-1 , date("d")-1, date("Y"))); $twoweeks = date("Y-m-d", mktime(0,0,0,date("m") , date("d")-15, date("Y"))); $result3 = mysql_query("SELECT refer,Count(*) as count FROM `approved` WHERE time>'$lastmonth 23:59:59' AND time<'$today' AND refer LIKE '%$u%'"); $row3 = mysql_fetch_array($result3); $result4 = mysql_query("SELECT refer,Count(*) as count FROM `approved` WHERE time>'$twoweeks 23:59:59' AND time<'$today' AND refer LIKE '%$u%'"); $row4 = mysql_fetch_array($result4); if($row3['count']==0){echo "<tr style='background:red'>";}elseif($row4['count']>0){echo "<tr style='background:green'>";}elseif($i % 2){echo "<tr style='background:#CCC'>";}else{echo "<tr style='background:#FFF'>";} echo '<td>'.$u.' '.$row3['count'].' '.$row4['count'].'</td>'; foreach($timearray as $t){ $result = ''; $result = mysql_query("SELECT COUNT(*) AS count FROM `approved` WHERE time LIKE '$t%' AND refer LIKE '%$u%'"); while($row = mysql_fetch_array($result)){ echo '<td>'.$row['count'].'</td>'; } } echo '</tr>'; $i++; } echo '</tr></table>'; I've been trying to figure out how chat apps work all afternoon to do dynamic data in HTML loading. Can someone please tell me where I'm going wrong for the code flow in this script:
<script>
function submitchat{
if (form1.uname.value=='' || form1.msg.value==''){
alert("fill out whole form");
return;
}
var uname=form1.uname.value;
var msg=form1.msg.value;
var xmlhttp= new XMLHttpRequest();
xmlhttp.onreadystatechange = function(){
if (xmlhttp.readyState==4 && xmlhttp.status=200){
document.getElementById('chatlogs').innerHTML=xmlhttp.responseText;
alert("message sent");
}
xmlhttp.open('GET', '?page=3.2&uname='+uname+'&msg='+msg, true);
xmlhttp.send();
}
</script>
<form name="form1">
enter your chat name<input type="text" name="uname">
message: <textarea name="msg"></textarea>
<br>
<div id="chatlogs">Loading Chat Logs...</div>
<a href="#" onclick="">send</a>
</form>
<?php
$uname = $_REQUEST['uname'];
$msg = $_REQUEST['msg'];
if ($msg!='' && $uname!=''){
$chat="
INSERT INTO chat (
`uname` ,
`msg`
)
VALUES (
'$uname',
'$msg'
)";
$result = mysql_query($chat, $con) or die (sql_death($chat));
}
|
|||||||