PHP - Forum Issue: Unable To Access A Previous Topic

Ok I found the culprit and it's easy!

Code: [Select]
function  timeAgo2($timestamp, $granularity=3, $format='d:H:i:s'){
        $difference = $timestamp;
        if($difference < 0) return '0 seconds ago';
        elseif($difference < 864000){
                   $periods = array('week' => 604800,'day' => 86400,'hours' => 3600,'min' => 60,'seconds' => 1);
                $output = '';
                foreach($periods as $key => $value){
                        if($difference >= $value){
                                $time = round($difference / $value);
                                $difference %= $value;
                                $output .= ($output ? ' ' : '').$time.' ';
                                $output .= (($time > 1 && $key == 'day') ? $key.'s' : $key);
                                $granularity--;
                        }
                        if($granularity == 0) break;
                }
                return ($output ? $output : '0 seconds').'';
        }
        else return date($format, $timestamp);
}

Now I will use:

Code: [Select]
timeAgo2(136622,5)
Which works and it will output:
2 days 14 hours 57 min 2 seconds


But, if I add another "1" to it like this:

Code: [Select]
timeAgo2(1136622,5)

It shows:
Code: [Select]
14:03:43:42
Which is not right, it needs to show, 14 Days, 3hours 43minutes and 42 seconds.... Thank you, I finally explained myself better here, hope you understand

ignore

I've already made fully working create topic, etc; what would I need to make to reply to a thread?

I've gotten this so far...
<?php
$result = mysql_query("SELECT id FROM b ORDER BY id DESC");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<a href='reply.php?id=%s'>Reply</a><hr><br /><br />", $row[0]);
}

mysql_free_result($result);
?>
reply.php?id=%s (%s equaling the thread id) when I click it, it does bring me to the appropriate page, but I don't know where to go from there. Any help? 
any other info you might need just ask

This topic has been moved to PHPFreaks.com Questions, Comments, & Suggestions.

http://www.phpfreaks.com/forums/index.php?topic=332508.0

?

Is there an option somewhere in this cesspool infested IPB settings panel?
Edited by Monkuar, 23 January 2015 - 10:17 PM.

This topic has been moved to PHPFreaks.com Questions, Comments, & Suggestions.

http://www.phpfreaks.com/forums/index.php?topic=343248.0

Hi guys

Just wanted to knw whats the php logic needed to create this function which shows current users viewing a topic

I knw we can have a database table which stores the topic ID as well as user id and that way we can record who is viewing a topic but what happens when they leave?

some users can just close there browser in which case I would never know when they left?


thank you guys

hmm im having some trouble tackling this problem

i have a database table with topicname then 3 columns with 3 pdfs in each one
all the files are stored in a directory called topicfiles in the server
so like 3 topicnames with 3 files in each one

with this page i want to make
i want to display each topic name with the files under it calling it from the server
like

Code: [Select]
topic 1
    file1.pdf
    file2.pdf
    file3.pdf

topic 2
    file4.pdf
    file5.pdf
    file6.pdf

topic 3
    file71.pdf
    file8.pdf
    file9.pdf


i tried using dhandler to access all files in the folder and only managed to display all of the files in rows using foreach loop
was thinkin of using mysql query to access the topic name and then each file for that topic but not sure hmmm

Hi there

I have a MySQL database table that has multiple records which look like (1, Which of these are your favorite color(s)?, Red||Blue||Orange||Green, question-type1 )

I have written some PHP code in extracting that data into a HTML form. (The above data looks like a question with multiple options (radio buttons/checkboxes) below it).

Below is what I'm trying to achieve:
 When the action is Submit: store the question number, user responses of the options , time stamp and user name into a new database table.

I came to know that passing arrays will do the job, but I got stuck in the middle.

Please see the attached documents that has the code.

TIA




[attachment deleted by admin]

I'm trying to create a function where you specify the $points it will then do some mathematical stuff with the $points (explain later) an return an array containing the $rank and $level.

The mathematical stuff:

It starts at 99 and when it reaches +199 it changes the key of the array.

I'm not sure how to describe this theirfore i'll just provide examples:

Example 1:

If $points <= 99

It will return an array containing $ranks[0] and $levels[0], would be the following:

return array('Peon', 0);

Example 2:

If $points >= 100 && $points <= 299

It will return an array containing $ranks[1] and $levels[1], would be the following:

return array('Grunt', 1);

Example 3:

If $points >= 300 && $points <= 499

It will return an array containing $ranks[2] and $levels[2], would be the following:

return array('Berserker', 2);

etc.. until it reaches the 7th key of the $ranks/$levels array

Heres my code:

<?php

function rank($points){
//their are 0-7 levels
$levels = range(0, 7);

//7 ranks
$ranks = array('Peon', 'Grunt', 'Berserker', 'Tauren', 'Spirit Walker', 'Wind Rider');

for(...) {
return array($rank, $level);
}
}
?>

Hi all,
I have a fairly simple problem, but i cannot get to it. I have a page, that displays one (1) record at the time, and I want to have forward and back buttons (links) at the top and bottom of the page. Can anyone help me with that???
Here is a part of my code.

Code: [Select]
<form method="get">
<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<tr><td align="center">
  Select first letter or kind of the story:
  <input type="hidden" name="link" value="stories.php">
<input type="hidden" name="Pripadnost" value="3">
<select name="letter" onchange="this.form.submit()">
<?PHP
$letter =  trim($_REQUEST["letter"]);
?>

<option value="Sve" <?PHP echo $letter == "All" ? " selected " : "" ; ?>>All</option>
<?PHP
include_once ("/includes/databaseMySQL.php");
mysql_set_charset('utf8');

$SQL = "Select distinct ucase(left(title,1)) as sl FROM tblStoryes order by sl";

$rs_data = mysql_query($SQL) or die(mysql_error());
while ($row_data = mysql_fetch_assoc($rs_data)) {
      ?>
      <option value="<?PHP echo $row_data["sl"]; ?>"<?PHP echo $letter == $row_data["sl"] ? " selected " : "" ;
  echo ">".$row_data["sl"] ;?></option>
      <?PHP
 // ******************  Listed all the first letters of the titles into a drop box. *********************** //
} ?>
</select> &nbsp; &nbsp; &nbsp;
Bosnian <input type="checkbox" name="Bosnian " <?PHP echo isset($_REQUEST["Bosnian "]) ? "checked=checked" : "" ;?> onclick="this.form.submit()" />  &nbsp;
Turkish <input type="checkbox" name="Turkish "  <?PHP echo isset($_REQUEST["Turkish "]) ? "checked=checked" :  "" ;?> onclick="this.form.submit()" />  &nbsp;
Arabian <input type="checkbox" name="Arabian "  <?PHP echo isset($_REQUEST["Arabian "]) ? "checked=checked" : ""  ;?> onclick="this.form.submit()" />

</td></tr>
</table>

<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<?PHP
$id = -1;
$rs_data = mysql_query("Select max(id) as maxid from  tblStories WHERE aktivno = True") or die(mysql_error());
$row_data = mysql_fetch_assoc($rs_data);
$maxid = (int) $row_data["maxid"];

 // ******************  Found the largest ID from the table. *********************** //

$SQL = "SELECT * FROM tblStories WHERE aktivno = True ";


if ( strlen($letter) < 3 && strlen($letter) > 0 ) {
$SQL = $SQL . " and ucase(left(`title`, 1)) = '" . $Letter . "'";
}

$lang = 0;
$lang = $lang + isset($_REQUEST["Bosnian"]) * 4;
$lang = $lang + isset($_REQUEST["Turkish"]  ) * 2;
$lang = $lang + isset($_REQUEST["Arabian"] );
switch ($lang) {
    case 6: // bos i tur
        $SQL = $SQL . " and ( Bosanski = 1 or Turski = 1 ) ";
        break;
    case 5: // bos i ar
        $SQL = $SQL . " and ( Bosanski = 1 or Arapski = 1) ";
        break;
case 4: // bos
        $SQL = $SQL . " and Bosanski = 1 ";
        break;
    case 3: // tur i ar
        $SQL = $SQL . " and ( Turski = 1 or Arapski =1) ";
        break;
    case 2: // tur
        $SQL = $SQL . " and Turski = 1 ";
        break;
    case 1: // ar
        $SQL = $SQL . " and Arapski =1 ";
        break;
}


if (trim($_REQUEST["DBid"]) <> ""  or  $_REQUEST["DBid"] > 0)
$SQL = $SQL . " and  id > " . trim($_REQUEST["DBid"]) ;
$SQL = $SQL . " LIMIT 1"; //order by naslov

$rs_data = mysql_query($SQL) or die(mysql_error());
echo "<!--" . $SQL . " : Jezik je:" . $lang . "-->";
while ($row_data = mysql_fetch_assoc($rs_data)) {
$id = (int) $row_data["ID"];
?>
  <tr>
<td align="center" colspan=3>
       <h3><?PHP echo $row_data["Title"];?> </h3>
    </td>
    </tr>   
    <tr>
      <td width=20%>&nbsp;
      </td>
      <td align="justify" width=60%>
        <?PHP  echo $row_data["tekst"]; // tekst = text, but not keyword ?>
      </td>
      <td width=20%>&nbsp;
      </td>
    </tr>
<?PHP
}
?>
</table>
<p>

<?PHP
// ****************************** HEEEEELLLLPPPPPP ******************************* //
?>

<table border="0" width="90%" cellpadding="1" align="center">
  <tr>
    <td align="center"><a href="?DBid=1<?PHP
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
} ?>"> &lt;&lt;</a></td>
    <td align="center"><a href="?DBid=<?PHP
echo $_REQUEST["id"];
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>" >&lt;</a></td>
<?PHP if (  $maxid <=  $id ) { ?>
    <td align="center">&gt;</td>
    <td align="center">&gt;&gt;</td>
<?PHP }
  else
  {?>
    <td align="center"><a href="?DBid=<?PHP
echo $id ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;</a></td>
    <?PHP if ( ($id + 9) <  $maxid ) { ?>
    <td align="center"><a href="?DBid=<?PHP
echo $id+10 ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;&gt;</a></td>
    <?PHP
    }
    else
      {?>
        <td align="center">&gt;&gt;</td>
<?PHP }?>   
<?PHP }?>
  </tr>
</table>
</form>

I have rows being generated in a foreach loop.  I need to find the time in the row before it (or maybe after it if my logic is screwed up) to see if the times are equal.  If they are equal, I need to see if the next row after that is equal. If it is not equal then stop.

mysql
user id     time        action
1               5            bought
1               5            purchased
1               5            sold
1               4            created

Code: [Select]
foreach($newsfeed as $k => $news)
{
if ($news['time'] == $news['time'] of $k--)
{
echo " you bought purchased and created";
}
        else
        {
                echo $news['action'];
         }
}

How can I get the next four and previous four rows?

Here is what I have and it isn't working at at all.
$q1 = Mysql::query("SELECT id, file, dir FROM photos WHERE id > $id AND album = '$al' ORDER BY id ASC LIMIT 4");
$q2 = Mysql::query("SELECT id, file, dir FROM photos WHERE id < $id AND album = '$al' ORDER BY id DESC LIMIT 4");

I want to list the previous (minus) 10 records.
classic asp example:  <% do while not rs.eof and i< 7 %>
how to do with php pdo?

My code is this:
<?php
$sqlq=$connectx->prepare("SELECT * FROM lovetree ");
$sqlq->execute();
while($rs = $sqlq->fetch()) {

echo $rs['tree'];

}
?>

Thanks...