PHP - Restricting Content Based On Number Of Views

Hi all,

I'm trying to create a PHP script for user's profile to display the amount of times they've been viewed. I'm looking to have this script increase on a unique view, and it should update the variable in the database.

Profiles are accessed by the following link: userprofile.php?userid=X (where X is the ID, e.g. 1, 2, 1001, 345982, etc.).

The database variable I'm looking to update is called ProfileViews.

I began developing the script, which is as follows:

Code: [Select]
$_SESSION['Viewed'] = 0;

if ($_SESSION['Viewed'] == 0) {

$profileViewsQuery = mysql_query("SELECT ProfileViews FROM Users WHERE UserID='????'");

$getProfileViews = mysql_fetch_array($profileViewsQuery);

$profileViews = $getProfileViews['ProfileViews'];

$profileViews = $profileViews + 1;

mysql_query("UPDATE Users SET ProfileViews='$profileViews' WHERE UserID='????'");

$_SESSION['Viewed'] = 1;

}

However, I'm stumped on a couple things. Could you possibly help me out?

1. How can I get the script to recognize the link accessed's ID? E.g. when a user goes to userprofile.php?userid=1001, how can I get the script to identify the ID to update should be 1001? This is where the "????" would be replaced in the code.
2. On page load, the variable is always going to be $_SESSION['Viewed'] = 0, which isn't going to produce unique hits. Do you have any recommendations how I could achieve unique hits using this method?

Thanks very much for reading.

Hi,

I need to write some code for this but unsure where to start.

Basically i have a database of say 10 rows. I need to be able to input a number and some sort of fair algorithm will choose one of the rows.

The number will be from 6 to 10 numbers long, and will need to pick the same result each time based on that number.

Its for a lotto game

This topic has been moved to PHP Regex.

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

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

Hello,

I had 8 select boxes(dropdowns) in a form. Its like a search kind of implementation in the website. I don't know what the user selects, he may choose different select boxes, any number of select boxes.

So, based upon the user selection, I need to generate the data. The data fields to be generated would be almost same.

So, How would I know what the user selection is and how many select boxes has been selected and how could I generate different data based upon selected boxes.

I had to make a small note abt this, that the data generation fields may change for some of the user select combinations, but most of the result fields would be same.

so, can you please help me out, how to do, how to make different combination data generations, because, i had 8 fields, i had to make 8! combinations, that would result in a big code.

im wanting to change the sql in my query based on if a field is empty or not. if the field is empty then i dont want it to post anything, but if its not empty then it can post the content. heres what i have so far but it does post the content even if the field is empty.


(!empty($password)) ? $pass_sql = "u_password = '$password'," : $pass_sql = null;

$link->query("UPDATE ".TBL_PREFIX."users
                SET 
                $pass_sql
u_allow_user_pm = '".$_POST['allow_user_pm']."'
                WHERE u_username = '".$_POST['user_name']."'")
                or die(print_link_error());


how can i stop it from updating if the field is empty?

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';
}
?>

Working on a site with a couple hundred virtually identical landing pages to maximize SEO.

Rather than hard code the pages, I am wondering if there is a way to have one page that handles all the url's and dynamically codes and loads with title, keywords, content & alt tags all specific to the particular url requested.

Seems like the challenge is doing it in a way that does not constitute a redirect.

Is it better to do this in the .htaccess?

Hi Folks,

This is my first post here and I was wondering if anyone could help me out at all please.

I would basically like to change the logo on the home page based on whether a query string from a referring URL has a specific value. It's an affiliate URL for an online store, so essentially I need to get the referrer, check if the query string adnetwork = as and then replace the logo if it does, if not leave it as it is. Does that make sense? Any help would very much appreciated.

I was thinking along the lines of:

<?php

if ($_GET('adnetwork') == 'as') {
changeLogo();
}
else
{
leaveLogo();
}

?>

Am I along the right lines folks?

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

So I have a very simple for loop that I am populating a list with levels and exp required to achieve the next level. I have been using a sandbox to test my output and have also created an excel sheet to replicate the data to verify the content. This code was not mine from the beginning and in creating the spreadsheet I discovered the flaw. Below is the code I am trying to fix:

function experience($L, $pres = 0) {
    $a = 0;
    $end = 0;
	for ($x = 1; $x < $L; ++$x) {
        $a += $x * round($x + 5 * pow(4, ($x / 300)));
	}
	if ($x > 199) {
		$a += $x * round($x + 7 * pow(4, ($x / 290)));
	}
	if ($x > 399) {
		$a += $x * round($x + 11 * pow(4, ($x / 280)));
	}
	if ($x > 599) {
		$a += $x * round($x + 19 * pow(4, ($x / 270)));
	}
	if ($x > 799) {
		$a += $x * round($x + 35 * pow(4, ($x / 260)));
	}
	if ($x > 999) {
		$a += $x * round($x + 67 * pow(4, ($x / 250)));
	}
	return round($a / 1.25);
}

Below is the troubleshooting I am attempting to do (Modified and simplified for and while loop):

//for loop
$no = 200;
$a = 0;
for ($x = 1; $x < $no; ++$x) {
    $a += $x + 1;
}
if ($no > 199) {
    $a += $x + 2;
}
echo $a;


//while loop
$no = 200;
$a = 0;
$x = 1;
while (($x - 1) < $no) {
    $a += $x * round($x + 5 * pow(4, ($x / 300)));
    $x++;
    if ($x > 199) {
        $a += $x * round($x + 7 * pow(4, ($x / 290)));
    }
}
echo $a;

Upon request I can also provide snipets of the excel sheet. So the gist of what the issue I am having is this. Between level 199 and 200 the iteration of the loop is running one extra time through the initial formula. As you can tell at level 200, 400, 600, 800 and 1000 I want this formula to change so that it simplifies the amount of exp required to achieve the next level. I can not for the life of me figure out how to restrict the loop while still allowing the values 200 up to run through it for the first 199 iterations.

The output I should get from the primary code for levels 199 through 201 are as follows: 199 =  200 =  201 = 

At level 199 I am good but for whatever reason it runs one additional iteration at the level 1-199 formula and then moves on to the 200 level formula messing up the values.

Any and all help is much appreciated. I am a novice hobbyist at best and have been doing this for many, many years now but sometimes I get stumped. I chalk it up to lack of proper training and time to really be serious with it.

Thanks in advance....NICON

I am using the following to check that the user is logged on before he/she views pages on my site can I adapt what is here so that only some pages can be viewed by admin only?

<?php
include("../php/dbconnect.php"); //connects to the database

//session code
session_start();
 
//Check if user is authenticated
if(!isset($_SESSION['username'])){
    
//User not logged in, redirect to login page
     header( "Location: http://webdev/schools/hhs/psy_bookings/" );
}
else
{

     //User is logged in, contiue (use session vars to diplay username/email)
     //echo "'Welcome, {$_SESSION['username']}. You are still logged in. <br />'";
    // echo "'Your email address is: {$_SESSION['email']}.'";

}//end of session code
?>  

I have a search code for my site and I want to narrow the scope of the search with a drop down that will allow users to pick a state, ( the sql table includes a state field ) or set the script so that i will only search for results for a particular state.
In the sql select I have tried every way of using WHERE venue_state='NY' but it will not work.
I would really rather allow the users to select a state from a dropdown and then enter the search term - city, zip or venue name.
Thank you for looking

Code: [Select]
<?php
include('config.db.php');
$find  = trim($_GET['find']);
$field = $_GET['field'];


if($find && $field) { // we have search form submitted
   // check for values to prevent sql injection
   $valid_fields = array("venue_zip", "venue_city" , "show_name");
   if(!in_array($field, $valid_fields)) die("Error: Invalid field!");
   
   $rpp = 10; // results per page
   $adjacents = 4;
   
   $page = intval($_GET["page"]);
   if(!$page) $page = 1;
   
   $reload = $_SERVER['PHP_SELF'] . "?find=" . urlencode($find) . "&amp;field=" . urlencode($field);
   
   echo "<h4>Search Results for $find</h4>\n";
   
   
   $find = addslashes($find);
     $result = mysql_query("SELECT *, DATE_FORMAT(`start_date`, '%b %e, %Y') AS s_date FROM craft_shows WHERE $field LIKE '%$find%'");
   if(mysql_num_rows($result) == 0) {
      echo "<p>0 matches found.</p>";
   } else {
      echo "<table class='table7' cellpadding='2'>";
      echo "<tr><td>&nbsp;</td><td><strong>Date</strong></td><td><strong>Show Name</strong></td><td><strong>City</strong></td><td><strong>Attendance</strong></td></tr>";
      echo "<tr><td colspan='5'><hr class=\"hr2\"></td></tr>";
      
      // count total number of appropriate listings:
       $tcount = mysql_num_rows($result);
      
      // count number of pages:
      $tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number
      
      $count = 0;
      $i = ($page-1)*$rpp;
      while(($count<$rpp) && ($i<$tcount)) {
         mysql_data_seek($result,$i);
         $row = mysql_fetch_array($result);
         $id = $row['id'];
         echo "<tr><td>";
         echo "<a href=\"/show_submits/show_detail.php?id=$id\">Details</a>";
         echo "</td><td>";
         echo $row['s_date'];
         echo "</td><td>";
         echo $row['show_name'];
         echo "</td><td>";
         echo $row['venue_city'];
         echo "</td><td>";
         echo $row['venue_state'];
         echo "</td></tr>";
echo "<tr><td colspan='5'><hr class=\"hr3\"></td></tr>";
         $i++;
         $count++;
      }

      echo "</table><br>";
      
function paginate_one($reload, $page, $tpages) {
   
   $firstlabel = "First";
   $prevlabel  = "Prev";
   $nextlabel  = "Next";
   $lastlabel  = "Last";
   
   $out = "<div class=\"pagin\">\n";
   
   // first
   if($page>1) {
      $out.= "<a href=\"" . $reload . "\">" . $firstlabel . "</a>\n";
   }
   else {
      $out.= "<span>" . $firstlabel . "</span>\n";
   }
   
   // previous
   if($page==1) {
      $out.= "<span>" . $prevlabel . "</span>\n";
   }
   elseif($page==2) {
      $out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
   }
   else {
      $out.= "<a href=\"" . $reload . "&amp;page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
   }
   
   // current
   $out.= "<span class=\"current\">Page " . $page . " of " . $tpages . "</span>\n";
   
   // next
   if($page<$tpages) {
      $out.= "<a href=\"" . $reload . "&amp;page=" .($page+1) . "\">" . $nextlabel . "</a>\n";
   }
   else {
      $out.= "<span>" . $nextlabel . "</span>\n";
   }
   
   // last
   if($page<$tpages) {
      $out.= "<a href=\"" . $reload . "&amp;page=" . $tpages . "\">" . $lastlabel . "</a>\n";
   }
   else {
      $out.= "<span>" . $lastlabel . "</span>\n";
   }
   
   $out.= "</div>";
   
   return $out;
}
   echo paginate_one($reload, $page, $tpages, $adjacents);
   }
}
?>

just wandering if this can be done and if so do you know were i can read about this or have any suggestion?

i have a database with all are clients data that we store in it. I can now let them log into a php search screen that they can pull data from and see what we have stored. I would like to restrict what info they can pull by the user name they log in with, so they are not pulling other client info when they do the search.  the user database and company database are two different ones.

they search by box number and i would like to restrict what it pulls up by company name depending on if the user logged in has rites to that company info.

so if jane doe logged in and she was a member of soso company when she did a box search she would only see what was from soso company instead of how it is now it pulls from soso, DD, and all the company's.


Thanks in advance