PHP - Making Php Abort A Instruction After X Amount Of Time

Heres what i got...

function printLB1 (){
$result = mysql_query("SELECT * FROM leaderboards ORDER BY CollegeFootballPoints DESC");
while ($row = mysql_fetch_object($result)) {
    $leaderboard[] =  $row->Username;
$leaderboardPoints[] = $row->CollegeFootballPoints;
}
$num = mysql_num_rows($reault);

//I know from here to ...................  needs to be in a var or echo or something.

  <tr>
    <td>1.</td> //This will auto increment too like i++ but i cna do that myself!
    <td>echo $leaderboard;</td>
    <td>echo $leaderboardPoints;</td>
  </tr>

//Here.........................................................

}

I need to pull a table row per user. But i want to somehow do it once in a function and then ill echo the function into a table after the php stuff is done.

Like i want to pull every a table row per user in the function. then display the function below that way i don't have to write a whole extra query and table row per person.

If you understand please help if not please let me know where i can explain more.

Thanks

I have this page that keeps adding slashes (exponentially) to the $sql var that gets passed on through the hidden text area. I cannot figure out why it does this.

Any ideas are appreciated. Thank you.


<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/login.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/mysql.php';

if(!Login::loggedIn()) {
include $_SERVER['DOCUMENT_ROOT'] . '/include/uploads/pages/login.php';
} else {
function displayForm()
{
$sql     = 'SELECT * FROM `content` WHERE `contentCallid` = \'' . $_GET['page'] . '\'';
$con     = $GLOBALS['mysql']->connect();
$query   = mysql_query($sql, $con);
$content = mysql_fetch_array($query);

$content['breadcrumb']     = explode(',', $content['breadcrumb']);
$content['breadcrumbLink'] = explode(',', $content['breadcrumbLink']);
$breadcrumb = '';

for($i = 0; $i < count($content['breadcrumb']); $i++) {
if($i > 0)
$breadcrumb .= ',';
$breadcrumb .= $content['breadcrumbLink'][$i] . '::' . $content['breadcrumb'][$i];
}

if(empty($_POST['sql'])) {
$sql = 'INSERT INTO `contentVersions`
(`contentCallid` ,
`contentTitle` ,
`content` ,
`views` ,
`permissionNeeded` ,
`status` ,
`version` ,
`created` ,
`createdBy` ,
`lastEdit` ,
`lastEditBy` ,
`breadcrumb` ,
`breadcrumbLink` ,
`noBreadcrumb` ) 
VALUES (
\'' . ($content['contentCallid'])    . '\',
\'' . ($content['contentTitle'])     . '\',
\'' . ($content['content'])          . '\',
\'' . ($content['views'])            . '\',
\'' . ($content['permissionNeeded']) . '\',
\'' . ($content['status'])           . '\',
\'' . ($content['version'])          . '\',
\'' . ($content['created'])          . '\',
\'' . ($content['createdBy'])        . '\',
\'' . ($content['lastEdit'])         . '\',
\'' . ($content['lastEditBy'])       . '\',
\'' . ($content['breadcrumb'])       . '\',
\'' . ($content['breadcrumbLink'])   . '\',
\'' . ($content['noBreadcrumb'])     . '\');';
$sql = stripslashes($sql);
} else {
$sql = $_POST['sql'];
}
?>
<form id="loginForm" name="loginForm" method="post" action="index.php?p=editPage&page=<?= $_GET['page']; ?>&ref=editPage">
   <fieldset>
    <legend>Page Settings </legend>
<p>
      <label>Page Title: </label>
      <input name="title" style="width:450px;" id="title" value="<?= $content['contentTitle']; ?>" type="text" />
    </p>
<p>
      <label>Content ID: </label>
      <input name="callid" readonly="readonly" style="width:381px;" id="callid" value="<?= $content['contentCallid']; ?>" type="text" />
  &nbsp;
  <input name="suggestC" type="button" value="Suggest" onclick="suggestCallID('<?= $content['contentCallid']; ?>');" />
    </p>
<p>
      <label>Breadcrumb: </label>
      <input name="breadcrumb" style="width:381px;" id="breadcrumb" value="<?= $breadcrumb; ?>" type="text" />
  &nbsp;
  <input name="suggestBC" type="button" value="Suggest" onclick="suggestBreadcrumb();" /></p>
  </fieldset>
  <textarea name="editPageWYS" id="editPageWYS"><?= $content['content']; ?></textarea>
   <textarea style="visibility:hidden;" name="sql"><?= $sql; ?></textarea>
   <textarea style="visibility:hidden;" name="version"><?= $content['version']; ?></textarea>
   <textarea style="visibility:hidden;" name="contentid"><?= $content['contentid']; ?></textarea>
   <fieldset>
    <legend>Actions</legend>
<p>
  <input name="save" type="submit" value="Save" />
    </p>
  </fieldset>
</form>
<?php
}

if(!empty($_POST['save'])) {
if(empty($_POST['title']) || empty($_POST['callid'])) {
echo '<blockquote class="failure">Save not successful. You need to have both a title and content id. Please type in a title then click the "Suggest" button.</blockquote>';
displayForm();
} else {
$time = time();
$bc   = explode(',', $_POST['breadcrumb']);
$bcText = array();
$bcLink = array();

for($i = 0; $i < count($bc); $i++) {
$bc[$i]     = explode('::', $bc[$i]);
$bcLink[$i] = $bc[$i][0];
$bcText[$i] = $bc[$i][1];
}

$bcLink = implode(',', $bcLink);
$bcText = implode(',', $bcText);

$con   = $GLOBALS['mysql']->connect();
$query = mysql_query($_POST['sql'], $con);

echo $_POST['sql'];
if(!$query) {
echo '<blockquote class="failure">Warning: A MySQL error has occured while adding the backup to the database.<p>' . mysql_error() . '</p></blockquote>';
displayForm();
}

$sql = 'UPDATE  `content` SET
`content` = \'' . $_POST['editPageWYS'] . '\',
`breadcrumb` = \'' . $bcText . '\',
`breadcrumbLink` = \'' . $bcLink . '\',
`contentCallid` = \'' . $_POST['callid'] . '\',
`contentTitle` = \'' . $_POST['title'] . '\',
`version` = \'' . ($_POST['version'] + 1) . '\',
`lastEdit` = \'' . $time . '\',
`lastEditBy` = \'' . $_SESSION['username'] . '\'
WHERE `contentid` = ' . $_POST['contentid'] . ' LIMIT 1 ;';

$query = mysql_query($sql, $con);
if(!$query) {
echo '<blockquote class="failure">MySQL Error<p>' . mysql_error() . '</p></blockquote>';
displayForm();
} else {
echo '<blockquote>Page Successfully Edited<br /><br /><a href="index.php?p=' . $_POST['callid'] . '&ref=newPage">Click Here to View It</a></blockquote>';
}
}
} else {
displayForm();
}
}
?>

Code: [Select]
${$payment['amount']}
using the $ next to it doesn't work

I am using itinside double quotes, any way I can get that dollar sign right next to it? This for people buying stuff off my forum i want the amount to show right by the $ dollar sign

And im working inside double quotes only

Error:
Code: [Select]
No error, Im have trouble Having This Loop Select Only 2 Uploads At a Time.
Code:
Code: [Select]
<?php

//porperties
$result = mysql_query("SELECT * FROM uploaded");
while($r=mysql_fetch_array($result))
{
   $link=$r["link"];
   $name=$r["name"];
   $type=$r["type"];
   $size=$r["size"];
   $date=$r["date"];
   $id=$r["id"];
echo "
The File $name Was Currently Updated<br>
Size: $size<br>
Type: $type<br>
Date Updated: $date<br>
Link: <a href='$link'>Download</a><br><br>
";
}
?> 
Couldn't Think of a Good name For this,Sorry

Hey quick question on my homepage there is a featured content section, which is populated from my DB some of the posts are really long so I would like to limit the amount of text. how can I do this?  also is there a way to make sure if does not cut a word in half?

thanks

Hi, I have a database where I store times with the Now(); function.

What I want is:
When the viewer looks at the post, instead of it saying: Posted: 2010-11-14 19:08:14,
I want it to say posted: x hours ago, Posted: x days ago, etc.

Any help with this would be appreciated!

Okay, I have a healing spell that allows people to regain stats when it's cast. But, how do I limit it so that they can't go over their maxhp?

Here's what I have so far:


$db->execute("UPDATE `users` SET `hp`=?, `mp`=?, `energy`=? WHERE `id`=?", array($player->hp + $healspell, $player->mp - $spell['mp'], $player->energy - $spell['energy'], $player->id));


What do I need to do in this to tell it to limit it to the maxhp but never going over it? $healspell is a random number, so it is quite possible to go over the maxhp at the moment.

Thank you!

Hi All,

Im new to this forum but think its going to be a regular location for me for quite a while.

Im very very new to php and the guy that was doing code for me is not responding to emails, so i thought id have a go myself...lol
at the moment im going through the trial and error phase while learning.

I have edited some of the code he has put on the site to create a new look.
the original page: http://www.ridersguide.co.uk/county_accommodation.php?county=4;
the one im trying:http://www.ridersguide.co.uk/county_accommodation2.php?county=4;

The new bit is to add a preview of the text for the page.

echo $row[ad_text];
the code above brings up all the text but i only want to show the first 4 or 5 lines. Is this possible in php?

Any help appreciated

Neil

I have a field in my database called description. How can I echo out only 500 out of the 2000 max characters?

Like for example:

Code: [Select]
$query = mysql_query("SELECT description FROM `servers` ORDER BY votes DESC LIMIT 5");

If I were to echo out the value of description for the database, how can I only echo out the first 500 characters?

If I knew what to call it I could have searched it.  So I will just explain.

I have a form that is pulling from a database to build the following.
echo <input name='$row[id]' type='text' id='$row[id]' size=2>;

This will build a page that has this
<input name='22' type='text' id='22' size=2>
<input name='54' type='text' id='54' size=2>

This part works great.  The problem is when I try to add it to the database.  How can I insert variables that I don't know the names of?  They will be something like $_POST[22]   $_POST[54] and so on.  I hope someone can understand my jibberish.

I am sure there is a WAY better way to do this.

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

So I wrote this piece of code that for the most part works. The problem is two things. One if I print out say $dir[$i] I get 7 directories back. if I try and store that in an array to later be access by some other function I get up to 24+ C's instead of C:/Path...

Code: [Select]
public function aisis_get_dir_array($dir){

if(!is_array($dir)){
aisis_get_dir($dir);
return;
}

$count = count($dir);
for($i = 0; $i<$count; $i++){
if(!is_dir($dir[$i])){
_e('Specified dir' . $dir[$i] . 'is not a directory.');
}

$this->directory_list = $dir[$i]; //store these

$handler = opendir($dir[$i]);
while($file = readdir($handler)){
if($file != "." && $file != ".."){
$this->files[] = $file;
}
}

}

return $this->files;
}

right under the line: $this->directory_list = $dir[$i]; //store these if You put in echo $dir[$i] you get back directories.
How ever down in this function:

Code: [Select]
public function load_if_extentsion_is_php($dir, $array = false){
$list = array();
$list_dir = array();

if($array == true){
$list = $this->aisis_get_dir_array($dir);
$list_dir = $this->directory_list;
}
else{
$list = $this->aisis_get_dir($dir);
}

$count = count($list);
for($i = 0; $i<$count; $i++){
if($array == true){
$countdir = count($this->directory_list);
for($j = 0; $j<$countdir; $j++){
echo $list_dir[$j];
//echo $list_dir[$j];
//echo $list[$i];
}
}
//if(substr(strrchr($list[$i],'.'),1)=="php"){
//echo $list[$i];
//require_once($dir . $list[$i]);
//}
}

}

echoing out: echo $list_dir[$j]; gets you up to 24+ C's instead of the directories that are stored.

You can view the whole class at  Paste bin - there is an expiry: 12 hours.

Essentially you call load_if_extentsion_is_php($dir, $array = false) pass it an array of directories and set the array part to true.

To Summarize:

If you pass in an array of directories you should get back:

a echoed list of directories
a echoed list of php files belonging in those directories.

Currently you get the later and a series of C's for  the first.

Why?

if i want to display upcoming events and only want to show the top 3?

Hi,

I have a function where I want to sort an an array of this type:

0 = {'fruit' => 'banana', 'color' => 'yellow', 'age' => '1', 'weight' => '2', 'brand' => 'dole', 'store' => shaws'}
1 = {'fruit' => 'apple', 'color' => 'red', 'age' => '3', 'weight' => '5', 'brand' => 'fuji', 'store' => 'foodmaster'}
etc etc.

I then want to array_multisort this array with different parameters. One way is to sort by fruit, then color, then brand. The second way by age, then store.

Code: [Select]
//This is how I sort it for my first way
//Let's call the array $rows
function sort($rows) {
foreach($rows as $key => $value) {
        $fruit[$key] = $value['fruit'];
$color[$key] = $value['color'];
$brand[$key] = $value['brand'];
    }

    array_multisort($fruit, SORT_ASC, $color, SORT_ASC, $brand, SORT_ASC $rows);
}
I want to try to reuse this function by passing in the keys that I want to sort with. Like doing sort($rows, array('fruit', 'color', 'brand')), then sort($rows, array('age', 'store')). Is this possible?

         

Hey Guys,

I'm looking to echo a large amount of complicated text that includes a lot of symbols, such as this:

Code: [Select]
V\"`'8\"`%n\"`)*$6A`!K!`2D\"`-t\"`!8\"`,?$`!1#D`\"i!`&2%` 9!`$S\"`#C)`# \"`\">\"7`)Q$`+Y\"C`!B!`%2\"`(e\"`($-`&M(`&C#F`$Q$`-P(`$P\"`#Q-`\"A\"`$CA`1e1` 5(`2GC0%2`&x!`'\"#`,i$`%D\"77`\"W!`%K!`$A.`/q+`(V\"`!J\"`,/\"`//%6E`$:#`.%)`\"u!`.d&`,K$`&F#`#V%`!z%`#2\"` &\"`&0!`3.&`2V%`)#+`\"t\"`.,\"` E!`(m&`3P(7`%l*`#q\"`-Q!`(#\"`&#1`1)\"` kC`#P+`$I2`-#\"`3<66`0H!`,|&6`#d#`$}.
Can anyone shed some light as to how I would be able to echo the above without having to backlash all the clashing symbols and preferably without having to include an external file?

All your help is greatly appreciated.
Extreme.