m3rajk — Thu, 18 Sep 2003 18:03:10 +0000

i didn't know about that.

i need to find a good mysql book. do you have any recommendations?

i wish you could search functions @ mysql.com like @ php.net

that works like a charm to fix the problem.

i noticed theres an issue inserting posts, but also in displaying. since they get inserted i think i'll continue working outthe forums.php display issues, but anything new will be in a new thread.

i switched from

<?php
function mkfrmlst($foruminf, $utds, $gmtos){ 
// make a forum into a table string for display
  $forum=$foruminf['title']; // forum info
  $fid=$foruminf['forum_id']; // forum info
  $threads=$foruminf['threads']; // forum info
  $lauth=$foruminf['last_post_auth']; # who/when of last post
  $lpt=$foruminf['last_post_time']; # who/when of last post
  $lpta=toTimestamp($lpt); # change to user's time format/zone
  $lptd=gmmktime($utds, ($lpta+($gmtos*60*60))); # change to user's time format/zone
  $tblln=\"        <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td><td>
$threads</td><td>$lauth</td><td>$lptd</td></tr>\n\"; # add the row with the forum
  
< br />$lpta=toTimestamp($lpt); <br />$lptd=gmmktime($utds, ($lpta+($gmtos*60*60)));</p>\";
  
  return $tblln;
}
?>

<?php
function mkfrmlst($foruminf, $utds, $gmtos){ 
// make a forum into a table string for display
  $forum=$foruminf['title']; // forum info
  $fid=$foruminf['forum_id']; // forum info
  $threads=$foruminf['threads']; // forum info
  $lauth=$foruminf['last_post_auth']; # who/when of last post
  $lpt=$foruminf['last_post_time']; # who/when of last post
  if($lpt==0){ $lauth='No Posts'; $lpt='No Posts'; }
  else{ $lpt=gmmktime($utds, ($lpt+($gmtos*60*60))); }# change to user's time format/zone
  $tblln=\"        <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td><td>
$threads</td><td>$lauth</td><td>$lpt</td></tr>\n\"; # add the row with the forum
  
< br />$lpta=toTimestamp($lpt); <br />$lptd=gmmktime($utds, ($lpta+($gmtos*60*60)));</p>\";
  
  return $tblln;
}
?>

Mark Hensler — Thu, 18 Sep 2003 01:00:01 +0000

I don't have the time right now to go through all that (real life's been busy lately).

You don't need a toTimestamp() function. MySQL has several Date and Time Functions. Noteably UNIX_TIMESTAMP().

m3rajk — Tue, 16 Sep 2003 22:47:07 +0000

ok. last thing turned out to be this this line:

<?php
$forumlist.=\"     <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum
?>

should be

<?php
$forumlist.=\"     <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td>$lpt</td></tr>\n\"; # add the row with the forum
?>

but....the function that makes the forum listing (i sent that out to a diff function so i change things once as mcgruff suggested) is this:

<?php
function mkfrmlst($foruminf, $utds, $gmtos){ 
// make a forum into a table string for display
  $forum=$foruminf['title']; // forum info
  $fid=$foruminf['forum_id']; // forum info
  $threads=$foruminf['threads']; // forum info
  $lauth=$foruminf['last_post_auth']; # who/when of last post
  $lpt=$foruminf['last_post_time']; # who/when of last post
  $lpta=toTimestamp($lpt); # change to user's time format/zone
  $lptd=gmmktime($utds, ($lpta+($gmtos*60*60))); # change to user's time format/zone
  $tblln=\"        <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td><td>
$threads</td><td>$lauth</td><td>$lptd</td></tr>\n\"; # add the row with the forum
  
  echo \"<p>test:$utds -> $gmtos<br />$lpt=\$foruminf['last_post_time']; 
< br />$lpta=toTimestamp($lpt); <br />$lptd=gmmktime($utds, ($lpta+($gmtos*60*60)));</p>\";
  
  return $tblln;
}
?>

and the timestamp:

<?php
function toTimestamp($dateTime){  # turn a mysql datetime into a unix timestamp
 # find all the
  $year=substr($dateTime,0,4); $month=substr($dateTime,5,2); $day=substr($dateTime,8,2);
 # parts of time
  $hour=substr($dateTime,11,2); $min=substr($dateTime,14,2); $sec=substr($dateTime,17,2);
  $ts=gmmktime($hour,$min,$sec,$month,$day,$year); # get the unix timestamp

  echo \"<p>$year=substr($dateTime,0,4); <br />$month=substr($dateTime,5,2); 
<br />$day=substr($dateTime,8,2); <br />$hour=substr($dateTime,11,2); 
<br />$min=substr($dateTime,14,2); <br />$sec=substr($dateTime,17,2); 
<br />$ts=gmmktime($hour,$min,$sec,$month,$day,$year);</p>\";

  return $ts; # return it
}
?>

the echos are there to debug.

i don't get why i'm getting -1 as a result from the toTimestamp function, but i am, as can be seen in this printout from the echos( i think that is what's causing the timestamp instead of display as a result of the gmmktime call):

Quote: 0000=substr(0000-00-00 00:00:00,0,4);
00=substr(0000-00-00 00:00:00,5,2);
00=substr(0000-00-00 00:00:00,8,2);
00=substr(0000-00-00 00:00:00,11,2);
00=substr(0000-00-00 00:00:00,14,2);
00=substr(0000-00-00 00:00:00,17,2);
-1=gmmktime(00,00,00,00,00,0000);

test:m/d/Y H:i:s -> -5.00
0000-00-00 00:00:00=$foruminf['last_post_time']; < br />-1=toTimestamp(0000-00-00 00:00:00);
1062590357=gmmktime(m/d/Y H:i:s, (-1+(-5.00*60*60)));

when the toTimestamp function worked fine in the tests i used.. so much so that i adjusted the page for someone elseon here to use... as demoed by this that i took from a past backup

<?php
include(\"path/to/includes (yes this is edited)\"); # includes file
# this is a test to get utc/gmt times

$metime=date(\"Y-m-d H:i:s\", time());
$gmttime=gmdate(\"Y-m-d H:i:s\", time());
$gmttimestamp=time();
$year=substr($gmttime,0,4);
$month=substr($gmttime,5,2);
$day=substr($gmttime,8,2);
$hour=substr($gmttime,11,2);
$min=substr($gmttime,14,2);
$sec=substr($gmttime,17,2);
$ts=toTimestamp($gmttime);
$fts=gmdate(\"Y-m-d H:i:s\", (toTimestamp($gmttime)+(-8*60*60)));

/* list of 76 or so different ways to print the date */

echo <<<END
<html>
<head>
<title>simple time test page</title>
</head>
<body>
<p>my time is: $metime
<br />if this works right, this will be 4 or 5 hours ahead since it's
<!--'--> suppossed to be UTC/GMT time: $gmttime
<br />gmt timestamp? $gmttimestamp
</p>
<p>breaking down gmt dateTime
<br /> year: $year
<br /> month: $month
<br /> day: $day
<br /> hour: $hour
<br /> min: $min
<br /> sec: $sec
</p>
<p>toTimeStamp function test (should be the same as above) and switching back to a datetime
<br />$ts
<br />cali's<!--'--> datetime (pst, not pdt): $fts
</p>
<p>choice tests for forums
<br />$choice01
<br />$choice02
<br />$choice03
<br />$choice04
<br />$choice05
<br />$choice06
<br />$choice07
<br />$choice08
<br />$choice09
<br />$choice10
<br />$choice11
<br />$choice12
<br />$choice13
<br />$choice14
<br />$choice15
<br />$choice16
<br />$choice17
<br />$choice18
<br />$choice19
<br />$choice20
<br />$choice21
<br />$choice22
<br />$choice23
<br />$choice24
<br />$choice25
<br />$choice26
<br />$choice27
<br />$choice28
<br />$choice29
<br />$choice30
<br />$choice31
<br />$choice32
<br />$choice33
<br />$choice34
<br />$choice35
<br />$choice36
<br />$choice37
<br />$choice38
<br />$choice39
<br />$choice40
<br />$choice41
<br />$choice42
<br />$choice43
<br />$choice44
<br />$choice45
<br />$choice46
<br />$choice47
<br />$choice48
<br />$choice49
<br />$choice50
<br />$choice51
<br />$choice52
<br />$choice53
<br />$choice54
<br />$choice55
<br />$choice56
<br />$choice57
<br />$choice58
<br />$choice59
<br />$choice60
<br />$choice61
<br />$choice62
<br />$choice63
<br />$choice64
<br />$choice65
<br />$choice66
<br />$choice67
<br />$choice68
<br />$choice69
<br />$choice70
<br />$choice71
<br />$choice72
<br />$choice73
<br />$choice74
<br />$choice75
<br />$choice76
</p>
<p>hey mikusan, here's the php for you (well.. almost, i can't just use the showcode() 
commandhere because i don't wanna show a specific thing since it's irrelevant to the 
dispay other than gathering functions)
END;
echo '<br />&lt;?php<br />
# this is a test to get utc/gmt times<br />
<br />
$metime=date(\"Y-m-d H:i:s\", time());<br />
$gmttime=gmdate(\"Y-m-d H:i:s\", time());<br />
$gmttimestamp=time();<br />
$year=substr($gmttime,0,4);<br />
$month=substr($gmttime,5,2);<br />
$day=substr($gmttime,8,2);<br />
$hour=substr($gmttime,11,2);<br />
$min=substr($gmttime,14,2);<br />
$sec=substr($gmttime,17,2);<br />
$ts=toTimestamp($gmttime);<br />
$fts=gmdate(\"Y-m-d H:i:s\", (toTimestamp($gmttime)+(-8*60*60)));<br />
<br />
echo &lt;&lt;&lt;END<br />
&lt;html&gt;<br />
&lt;head&gt;<br />
&lt;title&gt;simple time test page&lt;/title&gt;<br />
&lt;/head&gt;<br />
&lt;body&gt;<br />
&lt;p&gt;my time is: $metime<br />
&lt;br /&gt;if this works right, this will be 4 or 5 hours ahead since 
it\'s suppossed to be UTC/GMT time: $gmttime<br />
&lt;br /&gt;gmt timestamp? $gmttimestamp<br />
&lt;/p&gt;<br />
&lt;p&gt;breaking down gmt dateTime<br />
&lt;br /&gt; year: $year<br />
&lt;br /&gt; month: $month<br />
&lt;br /&gt; day: $day<br />
&lt;br /&gt; hour: $hour<br />
&lt;br /&gt; min: $min<br />
&lt;br /&gt; sec: $sec<br />
&lt;/p&gt;<br />
&lt;p&gt;toTimeStamp function test (should be the same as above) 
and switching back to a datetime<br />
&lt;br /&gt;$ts<br />
&lt;br /&gt;cali\'s datetime (pst, not pdt): $fts<br />
&lt;/body&gt;<br />
&lt;/html&gt;<br />
END;<br />
?&gt;';
echo '</body>
</html>';
?>

(note: all code modified to prevent horizontal scrollling)

m3rajk — Mon, 15 Sep 2003 22:12:13 +0000

i was asked by a friednwhat toTimestamp does exactly. here's the function:

<?php
function toTimestamp($dateTime){  # turn a mysql datetime into a unix timestamp
  # find all the parts of time
  $year=substr($dateTime,0,4); $month=substr($dateTime,5,2); $day=substr($dateTime,8,2); 
  $hour=substr($dateTime,11,2); $min=substr($dateTime,14,2); $sec=substr($dateTime,17,2);
  $ts=gmmktime($hour,$min,$sec,$month,$day,$year); # get the unix timestamp
  return $ts; # return it
}
?>

m3rajk — Mon, 15 Sep 2003 19:15:18 +0000

the functionthat makes the forum list:

<?php
function getforums($ual, $db, $utds, $gmtos){ 
  # get the forum listing by user access level, db link
  include('/home/joshua/includes/fyd.altincs.php'); # includes file
  $findforums=mysql_query(\"SELECT * FROM forums\", $db); # get forum info

  $forumlist=''; # create an empty list. that will be filled with forums
  
  // while we can retrieve more forums
  while($foruminf=mysql_fetch_array($findforums)){ 
    $fal=$foruminf['access']; # get forum access level

    if($fal==$visitor){ # if everyone can see
      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

    }elseif($fal==$rmember){ # restricted to members

      # if you're signed in (visitor fal will not match any checks)
      if((contains($ual, $regulars))||(contains($ual, $desireds))){ 

      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

      }
    }elseif($fal==$pmember){ # resticted to paying members

      if(contains($ual, $desireds)){ # you're a paying member

      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

      }
    }elseif($fal==$adult){ # restricted to those verified 18+

      if(contains($ual, $adult)){ # you're verified 18+

      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

      }
    }elseif($fal==$admoap){ # restricted to moderators/approvers/(jr) admins
      # you're a mod/app/...
      if((contains($ual, $moderators))||(contains($ual, $approvers))){ 

      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

      }
    }elseif($fal==$admin){ # restricted to (jr) admins
      if(($ual==$wbm)||($ual==$adm)||($ual==$jra)){ # you're on the admin team

      $forum=$foruminf['title']; // title of forum
      $fid=$foruminf['forum_id']; // id number of forum
      $threads=$foruminf['threads']; /// number of threads in forum
      $lauth=$foruminf['last_post_auth']; // who made the last post
      $lpt=$foruminf['last_post_time'];  // when was it made
      # change to the user's time format/zone
      $lpt=gmmktime($utds, (toTimestamp($lpt)+($gmtos*60*60)));

      $forumlist.=\"       <tr><td><a href=\\"forums.php?fid=$fid\\">$forum</a></td>
<td>$threads</td><td>$lauth</td><td></td>$lpt</tr>\n\"; # add the row with the forum

      }
    }
    echo \"<p>test:<table>$forumlist</table></p>\";
  }
  return $forumlist;
}
?>

and the one that displays it:

<?php
function showforums($forumlist){
  include(\"/home/joshua/includes/fyd.altincs.php\"); # includes file for functions

  echo <<<END
      <h2>Welcome to the Find Your Desire Forums!</h2>
      <h3>Gossip, read, post and mingle with other FindYourDesire members.</h3>
      <h3>Maybe you'll Find YOUR Desire!</h3>
      $tsw750
          <tr>
            <th align=\"center\">Forum</th>
            <th align=\"center\">Threads</th>
            <th align=\"center\">Last Post By</th>
            <th align=\"center\">Last Post At</th>
          </tr>
$forumlist
      </table>
END;
}
?>

$tsw750 is a table opening tag that sets the width to 750 pixels (so that it's formatted screen at 800 by 600 that's maximized or at least stretched open most of the way), there's also some other html attributes in there.

Mark Hensler — Mon, 15 Sep 2003 17:15:42 +0000

Can you post the source code from the output?

Looking at the stuff you posted, I don't see how this function could have output that. tags force text to the next line, yet you have text on the same line as "test:". Plus, I can't see where the table columns are or anything.

But by looking at the number itself.... they appear to be timestamps. The first number is a single timestamp, the rest are two timestamps back to back.