PHP - Limiting Someone On A Website

Following on from the excellent help in the thread at http://www.phpfreaks.com/forums/php-coding-help/using-a-generated-row-number-in-another-query I have another question regarding the League Standings that are generated there.

I want to have another version that limits the records to the last 5 games for each team. Just using 'LIMIT 5' would return the first five teams and all their records but I want it to retrieve all of the teams and each teams last five records (games). The easy way would be to restrict a the dates but as games get postponed and moved using WHERE with a specific date would not guarantee the same number of games for each team.

There is the possibility that this could be done via the query but I have not come across anything in some quite extensive searching (although, once again, I do not know if I am using the right search terms!) so I assume PHP would, once again be the saviour!

Thanks in advance for any suggestions.
Steve

Hi. Trying to use the "Excerpt or Content Word Limit in WordPress: Redux" code to limit my Amazon product description content but to no avail. Getting the "Fatal error: Call to undefined function content() in index.php on line 36". The following is the code in the index.php file that makes the call: "
<div class="post-content">
   <?php content(30); ?>
<!-- <?php the_post_excerpt($excerpt_length=30); ?> -->
</div><!-- POST CONTENT --> "
The functions.php file is quite large but I attached it so anyone who would like to take a look at it.
Can anyone tell why it's not finding the function 'content'? Thanks!

I have a database of 100 lines which have echoed onto the page so each line within the database is printed. I would like to limit it to ten. However, I have tried a whole range of different loops but none of them seek to work.

Some of them print the database ten times so I have 1000 lines on the page. Can anyone advise the best method of limiting how many lines within a database are printed on the page?

hello all -

I have a social network for the cystic fibrosis community and we've had a spammer the passed couple of days. I have captchas set up and they work well, but in addition to those I want to limit the amount of blogs a user is allowed to post a day.

I have been able to count and echo out the amount a user has made, but for some reason, when I use an if statement to stop the blog from posting it still post's. I have been working on this going on hour 8 now and need some major help

Thanks in advnace. Here is my code

Code: [Select]
if(isset($_POST['subComposeBlog'])) {

$query = "SELECT COUNT(`id`) FROM `cysticBlogs` WHERE `Author` = '".$auth."' && `date` = NOW() && `status` = 'active'";
$request = mysql_query($query,$connection) or die(mysql_error());
$result = mysql_fetch_array($request);

        $valid = true;



if($_POST['Category'] == "null") {
$valid = false;
$error_msgs[] = "Whoops! Please select a category for this blog.";
}

if(empty($_POST['blogTitle'])) {
$valid = false;
$error_msgs[] = "Whoops! Cannot submit a blog without a title,how are you going to attract people's attention to read your masterpiece?";

}

if(empty($_POST['blogBody'])) {
$valid = false;
$error_msgs[] = "Whoops! Cannot submit a blog without a body,that would not be a blog now would it?";

}

if($result['COUNT(`id`)'] > 3) {
$valid = false;
echo "Whoops! You can only write three blogs per day due to spam";
}

         if($valid) {

$query = "INSERT INTO `cysticBlogs` (
`blogTitle`,
`blogBody`,
`date`,
`time`,
`Author`,
`Category`
) VALUES (
'" . mysql_real_escape_string($_POST['blogTitle']) ."',
'" . mysql_real_escape_string($_POST['blogBody']) ."',
'" . date("Y-m-d") ."',
'" . date("G:i:s") ."',   
'" . $auth->id ."',
'" . mysql_real_escape_string($_POST['Category']) ."')";

mysql_query($query, $connection) or die (mysql_error());
header("Location: BlogsSecurity.php");

}
}

I've got a somewhat simple problem I think.. I'm working on a uni practical, and one of the checkpoints is to limit the number of incorrect login attempts to 2. I know I could do this very easily with session variables, however on the practical sheet, it says that we're not allowed to modify any of the partially implemented code.

So I was wondering, what other ways are there to track the number of incorrect logins? If it comes to it, I will just use session variables, as it's pretty much the most sensible way I'd imagine.. but would like to know of any other possible ways..

Cheers
Denno

Hi Everyone,   I have a question about pagination. I have this code that I would like to incorporate into my php file.   This is said code that will be incorporated:  

 
try {

    // Find out how many items are in the table
    $totalItems = $databaseHandle->query('
        select
            count(*)
        from
            tableName
    ')->fetchColumn();

    // Set how many items per page to display
    $limit = 10;

    // find how many pages are needed
    $totalPages = ceil($totalItems / $limit);

    // Find out which page we are on
    $currentPage = min($totalPages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
        'options' => array(
            'default'   => 1,
            'min_range' => 1,
        ),
    )));

    // Calculate the offset for the query
    $offset = ($page - 1)  * $limit;

    // Some information to display to the user
    $start = $offset + 1;
    $end = min(($offset + $limit), $total);

    // "back" link
    $prevlink = ($page > 1) ? '<a href="?page=1" title="First page">&laquo;</a> <a href="?page=' . ($currentPage - 1) . '" title="Previous page">&lsaquo;</a>' : '<span class="disabled">&laquo;</span> <span class="disabled">&lsaquo;</span>';

    // "forward" link
    $nextlink = ($page < $pages) ? '<a href="?page=' . ($page + 1) . '" title="Next page">&rsaquo;</a> <a href="?page=' . $totalPages . '" title="Last page">&raquo;</a>' : '<span class="disabled">&rsaquo;</span> <span class="disabled">&raquo;</span>';

    // Display the paging information
    echo '<div id="paging"><p>', $prevlink, ' Page ', $currentPage, ' of ', $totalPages, ' pages, displaying ', $start, '-', $end, ' of ', $totalItems, ' results ', $nextlink, ' </p></div>';

    // Get the results. Paged query
    $stmt = $databaseHandle->prepare('
        select
            *
        from
            tableName
        order by
            name
        limit
            :limit
        offset
            :offset
    ');

    // Bind the query params
    $stmt->bindParam(':limit', $limit, PDO:: PARAM_INT);
    $stmt->bindParam(':offset', $offset, PDO:: PARAM_INT);
    $stmt->execute();

    // Results?
    if ($stmt->rowCount() > 0) {
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $iterator = new IteratorIterator($stmt);

        // Display the results
        foreach ($iterator as $row) {
            echo '<p>', $row['name'], '</p>';
        }

    } else {
        echo '<p>No results could be displayed.</p>';
    }

} catch (Exception $e) {
    echo '<p>', $e->getMessage(), '</p>';
}

  and this is what is in my php file:  

<html>
  <head></head>
  <body>
  <?php if (!isset($_POST['q'])) { ?>


<img src="/wvb-logo-slogen.png" border="0" />
    <h2>Search</h2>
    <form method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
      <input type="text" name="q" size="30" />
    </form>

  <?php } else { ?>

<img src="/wvb-logo-slogen.png" border="0" />
    <h2>Search Results</h2>

  <?php
    try {
      // create object
     // $swish = new Swish('/usr/local/apache/htdocs/swish/index.swish-e');
        $swish = new Swish('/var/www/html/pdf2/index.swish-e');


      // get and run query from command-line
      $queryStr = htmlentities($_POST['q']);
      $result = $swish->query($queryStr);
  ?>

   Found <?php echo $result->hits; ?> match(es) for '<?php echo $queryStr; ?>'.

  <?php
      // iterate over result set
      // print details for each match
      while($r = $result->nextResult()) {
   ?>

  <p>
    <?php echo $r->swishreccount; ?>
      <strong>
      <a href="<?php echo '/pdf2', ltrim($r->swishdocpath, '.') ;  ?>">
         <?php echo $r->swishdocpath; ?>
      </a>
   </strong> (sco  <?php echo $r->swishrank; ?>) <br/>
<?php echo $r->swishdocpath; ?><br />
<?php

$file = '/var/www/html/active_colist.csv';
$fh = fopen($file, 'r');
$companies = array();
$row = fgetcsv($fh, 1024); // ignore header
while ($row = fgetcsv($fh, 1024)) {
    $companies[$row[0]] = array('company' => $row[1], 'country' => $row[3]); //changed line
   }
fclose($fh);


//Split a filename  by .
$filenames = explode(".", $r->swishdocpath);
//get 3 chars from $filenames to $country
$wvb_number = substr($filenames[1],1,12);
$country = substr($filenames[1],1,3);
echo 'Country: '.$companies[$wvb_number]['country']."<br />";
//echo 'Country Name: '.$country."<br />";
//$filenames[2] = explode(".", $r->swishdocpath);
$year = substr($filenames[2],0,4);
echo 'Year: '.$year."<br />";
//$filenames = explode(".", $r->swishdocpath);
//$wvb_number = substr($filenames[1],1,12);
echo 'WVB Number: '.$wvb_number."<br />";
echo 'Company Name: '.$companies[$wvb_number]['company'];
//echo 'Country: '.$companies[$wvb_number]['country'];

?>


  </p>

  <?php
      }
    } catch (Exception $e) {
      die('ERROR: ' . $e->getMessage());
    }
  }
  ?>

  </body>
</html>
 

  My question is what would be the best way incorporate this into my php file so that I am able to display a limit number link by page so that not all of the results are listed on the same page? If that is even possible.  

$text = "this is a lot of effing text"


what i want to do is limit it to the 10 characters so it gives back

$stext = substr($text, 10); <-- this is how i thought it would work

echo " $stext";

I have a string in the form of "word1-word2-word3-word4-word5-word-6-word7", but I want to shorten it to 5 words only. 

I've got a typical form with an input type="file" for users to upload photos to my site (2mb max to be exact). If you view my code below, you'll notice that I set a variable as the uploaded file's size, and a variable for the max file size I want in bytes. When making sure that the uploaded file's size is LESS than the limit size I set, it should push an error.

However, I've noticed that my variable $uploadSize that is supposed to grab the upload file size is only returning "0" (zero). I've tried var_dump($_FILES) to see what was going on and it shows the array with the proper name of the uploaded file, etc. but the file size returns 0.

So any file size I upload will bypass my test to see if the file size is less than the limit size. I've tested uploading images 2mb or less and the photos have successfully been queried, moved and resized. However, if I try and upload images LARGER than 2mb, the form still queries all the inputted data into the database but the image isn't successfully moved.

I've used this same form and approach on a previous project and I didn't have any trouble. Can I get your guys' eyes on this and see if I'm missing anything small?

Code: [Select]
<?php

if(isset($_POST['submit'])){

// ------------------------------------------------------------- //

// A.   SET VARIABLES
// A1.  set variables for inputted data
$first = filter_var($_POST['first'], FILTER_SANITIZE_STRING);
$last = filter_var($_POST['last'], FILTER_SANITIZE_STRING);
$email = filter_var($_POST['email'], FILTER_SANITIZE_STRING);
$email2 = filter_var($_POST['email2'], FILTER_SANITIZE_STRING);
$name = filter_var($_POST['name'], FILTER_SANITIZE_STRING);
$description = filter_var($_POST['description'], FILTER_SANITIZE_STRING);

// A2.  set variables for uploaded submission
$uploadPath = $_FILES['uploadFile']['tmp_name'];
$uploadSize = $_FILES['uploadFile']['size'];
$uploadLimit = 2097152; /* 2mb max file size */

// A3.  create error array
$errors = array();

// ------------------------------------------------------------- //

// B.   VALIDATE FIELDS  
// B1.  validate required fields
if (empty($first)){
array_push($errors, 'first');
}
if (empty($last)){
array_push($errors, 'last');
}
if (empty($email)){
array_push($errors, 'email');
}
if (empty($email2)){
array_push($errors, 'email2');
}
if (empty($name)){
array_push($errors, 'name');
}

// B2.  validate emails
if ($email != $email2){
array_push($errors, 'emailmismatch');
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)){
array_push($errors, 'invalidemail');
}

// B3.  validate uploaded image file size
if ($uploadSize > $uploadLimit){
array_push($errors, 'filesize');
}


// ------------------------------------------------------------- //

// if no errors, continue query
if (sizeof($errors) == 0){
// continue query
}

}

?>
Code: [Select]
<form method="post" enctype="multipart/form-data" id="submit-form">
    <label for="first">First Name:</label>
    <input name="first" type="text" value="<?php echo $first; ?>"<?php if(in_array('first', $errors)){ echo ' class="error"'; } ?>>
   
    <label for="last">Last Name:</label>
    <input name="last" type="text" value="<?php echo $last; ?>"<?php if(in_array('last', $errors)){ echo ' class="error"'; } ?>>
   
   
    <label for="email">Email Address:</label>
    <input name="email" type="text" value="<?php echo $email; ?>"<?php if(in_array('email', $errors)){ echo ' class="error"'; } else if (in_array('emailmismatch', $errors)){ echo ' class="error"'; } ?>>
   
    <label for="email2">Confirm Email Address:</label>
    <input name="email2" type="text" value="<?php echo $email2; ?>"<?php if(in_array('email2', $errors)){ echo ' class="error"'; } else if (in_array('emailmismatch', $errors)){ echo ' class="error"'; } ?>>
   
    <br><br><br><br>
   
    <label for="name">Your Photo Name:</label>
    <input name="name" type="text" value="<?php echo $name; ?>"<?php if(in_array('name', $errors)){ echo ' class="error"'; } ?>>
   
    <label for="description">Describe The Photo: <span class="optional">(optional)</span> <div class="right"><span class="optional">300 characters max</span></div></label>
    <textarea name="description" onKeyDown="limitInput(this.form.description,this.form.countdown,300);"
onKeyUp="limitInput(this.form.description,this.form.countdown,300);"><?php echo stripslashes($description); ?></textarea>
   
    <label for="upload">Photo Image: <span class="optional">(.JPG's only, max 2mb file size)</span></label>
    <input type="hidden" name="MAX_FILE_SIZE" value="2097152">
    <input id="uploadFile" name="uploadFile" type="file"<?php if(in_array('badimage', $errors)){ echo ' class="error"'; } ?> />
   
    <input type="submit" name="submitFeature" class="submit" value="Submit Your Feature">
</form>

Hi,

I'm having a bit of trouble with returning data from the database. It brings back the images etc... correctly, but I need to be able to limit it to two images per, line and then to carriage return. Or using CSS to position them with the correct padding etc... I'm very tired and can't seem to figure it out, which is starting to frustrate me.

To see what I mean, go to www.bikescarsandvans.co.uk/test.php and select the drop down menu.

And see coding for particular section.

Any help will be much appericated, I know a good sleep would probaly help but don't have time for that right now 

Code: [Select]
 
  print "
</td>
<td colspan='2'>
<div id='CollapsiblePanel" . $car_row["id"] . "' class='CollapsiblePanel'>
  <div class='CollapsiblePanelTab' tabindex='0'><img class='drop' src='images/drop_down.jpg' alt='Go' /></div>
  <div class='CollapsiblePanelContent'>
  <p>
<div class='title_tabs'>Standard Specification</div>
<table class='standard_spec'>
<tr>
<th>
Engine Size:
</th>
<td>
".$car_row["engine"]."
</td>
</tr>
<tr>
<th>
BHP:
</th>
<td>
".$car_row["bhp"]."
</td>
</tr>
<tr>
<th>
Fuel Type:
</th>
<td>
".$car_row["fuel_type"]."
</td>
</tr>
<tr>
<th>
Number of Doors:
</th>
<td>
".$car_row["no_doors"]."
</td>
</tr>
<tr>
<th>
Wheels:
</th>
<td>
".$car_row["wheels"]."
</td>
</tr>
</table>     
</p>
";

//QUERY FOR TITLE START
$query_title = "SELECT * FROM extras JOIN car_to_extra ON (car_to_extra.extras_id = extras.id) WHERE car_to_extra.car_id = '{$car_row['id']}' ORDER BY extras.price ASC";
$title_results = mysql_query($query_title) or die ("Error in query: $query_title. ".mysql_error());
$current_heading = '';
while ($title_row = @ mysql_fetch_array($title_results ))
{
if ($current_heading != $title_row["title"])
{
    // The heading has changed from before, so print the new heading here.
    $current_heading = $title_row["title"];
    print "


<p>
<div class='title_tabs'>" . $title_row["title"] . "</div>
  ";
  }

?>
                                           
                                            <a class='data' href='#' onmouseout='hideTooltip()' onmouseover='showTooltip(event,"<?php print "" . $title_row["info"] . "<br/>(&pound;" . $title_row["price"] . ")"; ?>");return false'>
                                      <?php
print "
<img class='extra_img' src=\"". $title_row["img"] ."\" alt='" . $title_row["img_alt"] . "' /></a>
</p>";  


}
//QUERY FOR TITLE END

 
print "  
  </div>
</div>
<script type='text/javascript'>
<!--
var CollapsiblePanel" . $car_row["id"] . " = new Spry.Widget.CollapsiblePanel('CollapsiblePanel" . $car_row["id"] . "', {contentIsOpen:false});
//-->
</script>
</td>
</tr>
";

I recently wrote a web app made with flash that communicates with php scripts on my web server(apache2). Like most others, I believe my web app is the end all be all and could potentially attract millions of users

Ok, long story short, in the long haul, there will be people using robots to communicate with my php scripts to do tasks that are in the game in order to cheat. I'd like to limit these users from hammering the server with robotic requests. I no for a fact that no human will make requests to my game more than once per two seconds or so.  So is it best for me to somehow do this type of code with php? or maybe at the apache level somehow? My flash application can detect http error status codes for each request so if any solution would cause a non standard 200, that is fine, i should be able to detect the code, and wait a couple seconds on the flash client, then do a retry hopefully

I'm lost on this one and would appreciate some help

I have a search form that has a drop down
Code: [Select]
<select name="radius" id="radius">
      <option value="5">5 mi.</option>
      <option value="10">10 mi.</option>
      <option value="15">15 mi.</option>
      <option value="20">20 mi.</option>
      <option value="50">50 mi.</option>
      <option value="100">100 mi.</option>
    </select>

I'm trying to limit the results in a foreach loop within what was selected.

Meaning, if someone selects 10, results within 10 miles will show
The foreach is
Code: [Select]
foreach ($stores as $k=>$v) {
            $output = "<h3 style='margin:0;padding:0'><b>".$storeinfo[$k]['MktName']."</b><br>(approx ".$v." miles)</h3>";
            $output .= "<p style='margin:0 0 10px 0;padding:0'>".$storeinfo[$k]['LocAddSt']."<br>";
            $output .= $storeinfo[$k]['LocAddCity'].", ".$storeinfo[$k]['LocAddState']." ".$storeinfo[$k]['zipcode']."</p>";
            print_r($output);           
        }

$v being the distance. So I need to show only the results of $v that are less than $r.

How would I go about doing this?

Right now, $v displays numbers like 5.04, 173.9 and so forth.

Can anybody help me out?

Thanks in advance.

I would like to know the best practice to achieve the following:

I have a list of dates related to live events for performing artists.  When someone views the web page that contains a section to display the dates, I would only want to show the dates from today into the future and not show any dates from the past.

What is the best way to accomplish this?

Thanks in advance...

I'm trying to make a League of Legends (a video game) community website, both as a personal project and for practice.
Now the game has a lot of champions, each of whom have 5 unique abilities. Now, I thought about manually inputting all the details about each champion into a MySQL database, but that would long and tedious, and I don't really have the time for it now. Also, the game patches very oftern (like, once every 2 weeks) which changes many of the stats, etc. of the champion, and it is not possible for me to keep manually updating these every time there is a patch.

Fortunately, there is a League of Legends Wiki which has all the data I need in their specific champion pages, which they keep updated per patch. So I was wondering if there was any way to get the data from the divs in the wiki, and have it display on my site. What I want to do in my website is that whenever someone types a champion's name (in a post or whatever), I want it to display a hover-over dialog with some of the champions details. And a lot of other features such as that.

In plain English I need a way to :
> Tell PHP to go to the wiki's source code on a specific page
> Find a specific div container
> Get X data from there
> Pass X data into a function to display the hover-over

I think this way, I would not have to maintain a database as I can leech off the wiki's data.
I have not coded anything like this before, so I would like a few pointers as to how to achieve this. Any help will be appreciated!