PHP - Moved: Update Ebay Ad With Number From Website

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.

I'm trying to get a value which changes but is always contained the same way

this is the text Next: Brigadier  (81654 of 220000)

as you can see below this is the value i need to get I just can't figure out the RegEx for it? help please!

Smaller CODE
Code: [Select]
<div class="rankBar">
                        <p class="grade"><span id="ctl00_mainContent_identityBar_currentGlobalRankLabel" class="current">Colonel Grade 3</span><span id="ctl00_mainContent_identityBar_nextGlobalRankLabel" class="future">Next: Brigadier&nbsp;&nbsp;(81654 of 220000)</span></p>
                        <div class="rankMeter">
                            <div id="ctl00_mainContent_identityBar_rankBarPanel" class="bar" style="width:37%;">
<span></span>
</div>
                        </div>

FULL CODE

Code: [Select]
<div id="ctl00_mainContent_identityBar_idbarPanel">

        <div class="glowBox idRankContainer">
            <div class="corner bottomLeft"></div>
            <div class="lattice"></div>
            <div class="content">
                <a href="/Stats/Reach/default.aspx?player=l RaH l" id="ctl00_mainContent_identityBar_avatar" class="avatar"><img id="ctl00_mainContent_identityBar_emblemImg" src="/Stats/emblem.ashx?s=70&amp;0=0&amp;1=0&amp;2=0&amp;3=0&amp;fi=0&amp;bi=0&amp;fl=0&amp;m=3" style="height:70px;width:70px;border-width:0px;"></a>
                <div class="idRank">
                    <div class="userInfo">
<img id="ctl00_mainContent_identityBar_namePlateImg" class="img_plate" src="/images/reachstats/nameplates/512.png" alt="" style="height:30px;width:60px;border-width:0px;">
                       
                        <a href="/projects/reach/article.aspx?ucc=faq&amp;cid=28756"><img id="ctl00_mainContent_identityBar_currentGlobalRankImage" title="Colonel Grade 3" class="img_rankIcon" src="/images/reachstats/grades/med/A4BF62C6-1E3F-468A-9A73-8237600B2AD3.png" alt="Colonel Grade 3" style="height:40px;width:40px;border-width:0px;"></a> 
                        <h2><a href="/Stats/Reach/default.aspx?player=l RaH l" id="ctl00_mainContent_identityBar_gamerTag">l RaH l</a> - FLIR</h2>
                       
                    </div>
                    <div class="rankBar">
                        <p class="grade"><span id="ctl00_mainContent_identityBar_currentGlobalRankLabel" class="current">Colonel Grade 3</span><span id="ctl00_mainContent_identityBar_nextGlobalRankLabel" class="future">Next: Brigadier&nbsp;&nbsp;(81654 of 220000)</span></p>
                        <div class="rankMeter">
                            <div id="ctl00_mainContent_identityBar_rankBarPanel" class="bar" style="width:37%;">
<span></span>
</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="glowBox shields">
            <div class="corner topRight"></div>
            <div class="lattice"></div>
            <div class="content">
                <ul>
                    <li class="campaign">
                        <p>Campaign</p>
                        <img id="ctl00_mainContent_identityBar_spCampaignImage" title="Completed Legendary Difficulty" alt="Campaign Progress" src="/images/reachstats/campaign_progress/legendary.png" style="height:59px;width:54px;border-width:0px;">
                    </li>
                    <li class="coop">
                        <p>Co-op</p>
                        <img id="ctl00_mainContent_identityBar_coopCampaignImage" title="Completed Normal Difficulty" alt="Coop Campaign Progress" src="/images/reachstats/campaign_progress/normal.png" style="height:59px;width:54px;border-width:0px;">
                    </li>
                    <li class="arena_display">
                        <p>Arena</p>
                        <a id="ctl00_mainContent_identityBar_arenaLink" href="/stats/reach/careerstats/playlists.aspx?player=l RaH l&amp;vc=2"><img id="ctl00_mainContent_identityBar_currentBestArenaDivisionImg" alt="" src="/images/reachstats/arena_div/0.png" style="height:47px;width:48px;border-width:0px;"></a>
                        <div class="glowBox popOut po_arenaSeason2">
                            <div class="corner topRight"></div>
                            <div class="corner bottomLeft"></div>
                            <div class="content">       
                                <h4>Arena Season 6</h4>

<div class="twoColumn">
<img id="ctl00_mainContent_identityBar_arenaRepeater_ctl00_arenaImage" src="/images/reachstats/arena_div/0.png" style="height:47px;width:48px;border-width:0px;">
<h5>Doubles Arena</h5>
<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl00_divisionName">Not Qualified Yet</p>

<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl00_lastSeasonControl">Last Season: <img id="ctl00_mainContent_identityBar_arenaRepeater_ctl00_lastSeasonImage" src="/images/reachstats/arena_div/0.png" style="height:23px;width:23px;border-width:0px;"> </p>
</div>
<div class="rule_transparent"></div>
<div class="twoColumn">
<img id="ctl00_mainContent_identityBar_arenaRepeater_ctl02_arenaImage" src="/images/reachstats/arena_div/0.png" style="height:47px;width:48px;border-width:0px;">
<h5>FFA Arena</h5>
<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl02_divisionName">Not Qualified Yet</p>

<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl02_lastSeasonControl">Last Season: <img id="ctl00_mainContent_identityBar_arenaRepeater_ctl02_lastSeasonImage" src="/images/reachstats/arena_div/0.png" style="height:23px;width:23px;border-width:0px;"> </p>
</div>
<div class="rule_transparent"></div>
<div class="twoColumn">
<img id="ctl00_mainContent_identityBar_arenaRepeater_ctl04_arenaImage" src="/images/reachstats/arena_div/0.png" style="height:47px;width:48px;border-width:0px;">
<h5>Team Arena</h5>
<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl04_divisionName">Not Qualified Yet</p>

<p id="ctl00_mainContent_identityBar_arenaRepeater_ctl04_lastSeasonControl">Last Season: <img id="ctl00_mainContent_identityBar_arenaRepeater_ctl04_lastSeasonImage" src="/images/reachstats/arena_div/0.png" style="height:23px;width:23px;border-width:0px;"> </p>
</div>

   
                            </div>
                        </div>     
                    </li>
                </ul>
            </div>
        </div>     
</div>

Okay, I've made a new webpage for phpBB3, and it was working until about lunchtime yesterday. The next time I edited it, the page didn't update. I have tried several times to update it since, but it won't work. Here's my portal.php code:

Code: [Select]
<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

page_header('phpBB3 Portal Public Test!');

$template->set_filenames(array(
    'body' => 'portal_style.html',
));

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));
page_footer();
?>
Here's my portal_style.html:
Code: [Select]
<!-- INCLUDE overall_header.html -->

<script src="/port/scripts/getannounce.php">
</script>

<h2><div align="center">Announcement!</div></h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

<div class="content" align="center">
    <script type="text/javascript" src="announce1.php">
</script>
   </div>

<span class="corners-bottom"><span></span></span></div></div>
 

<h2><div align="center">Announcement!</div></h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

   <div class="content" align="center">
          <script src="/port/scripts/announce1.php">
</script>
   </div>

   <span class="corners-bottom"><span></span></span></div>
</div>

<h2><div align="center">Announcement!</div></h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

<div class="content" align="center">
        <script src="/port/scripts/announce3.php">
</script>
   </div>

<span class="corners-bottom"><span></span></span></div></div>

<h2><div align="center">Announcement!</div></h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

<div class="content" align="center">
        <script src="/port/scripts/announce4.php">
</script>
   </div>

<span class="corners-bottom"><span></span></span></div></div>

<h2><div align="center">Announcement!</div></h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

<div class="content" align="center">
        <script src="/port/scripts/announce5.php">
</script>
   </div>

<span class="corners-bottom"><span></span></span></div></div>

<!-- INCLUDE jumpbox.html -->
<!-- INCLUDE overall_footer.html -->
I will provide the others if you need them. Why would this be happening?

Thanks!

I need like,

http://www.trackcourier.in/

The customer chooses selected courier service and enters tracking id then clicks its redirect to the appropriate courier service website.

eg: If tracking id 12345 the redirect link should be https://www.fedex.com/apps/fedextrack/index.html?tracknumbers=12345&cntry_code=in

How to do for India courier services?

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?