PHP - You Viewed Items, Strategy?

I am wondering if there is an easier / better way to keep my development and test databases in synch.   When I develop, I may add tables or fields to existing tables. When I upload from the development server to the test server I can check and make sure that I include all of the programs that I have edited by using the filesystems last modified date. However, I keep track of new and changed tables in MYSQL manually. Is there an easy way, that I am just missing, to see last modified dates for tables within a db? Is there some other strategy I should be using. I hate missing a table and having the test server give errors on code I debugged once on the development server.

I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that

Hello,

I'm working on a very simple strategy based game site (mainly to expand my knowledge).

What I basically want it to do is, you send a solider to an area which takes, say 20 seconds. After 20 seconds, he battles for 30 seconds, and then arrived back home which takes another 20 seconds.

All the user is going to be seeing is a 'status' echo'ed text saying "Arriving in 00:??", "Battle Over in 00:??", and "Home in 00:??".

So its just using a time counter. But what makes it more complicated, is that I want the time progress to be saved (datebase), so say I have to wait 50 seconds, I can sign off, go on another computer, sign in and still see my timer going down according to the time that has just passed.

So, what I've done so far is, have 4 variables:

$realTime - Holds the actual time in seconds.
$waitingTime - Holds how long I need to wait. (this is stored in my DB)
$differenceTime - Difference between real time and my waiting time. (loaded from my DB)
$soliderProgress - Progress of the solider, so: Arriving, Battle ... (stored on DB)


Code: [Select]
$realTime = date("s");

//soliderProgress is 'Starting' by default
if(soliderProgress == "Starting"){
   //solider is moving to area
   $differenceTime = $realTime + $waitingTime;
   $SQL = ("UPDATE users SET differenceTime='$differenceTime' WHERE username='$username'");
   soliderProgress = "Arriving";
   $SQL = ("UPDATE users SET soliderProgress='$soliderProgress' WHERE username='$username'");
}

if(soliderProgress == "Arriving"){
   echo "Arriving to area";
   if($realTime >= $differenceTime){
      //timer is complete
      soliderProgress = "Battle";
      $SQL = ("UPDATE users SET soliderProgress='$soliderProgress' WHERE username='$username'");
   }
}

This kind of works, but sometimes my $differenceTime is higher than 60 which messes it up, and also the timer isn't live ... so I have to keep refreshing the page

I am refactoring entire collective scattered SQL from my legacy codebase, and into separate classes, and looking for some structure to put it into.

Right now I have folders effectively called `DataFromDB` - contains classes that accepts whatever parameters are given, and returns pure data back to the user `DAO` - Data Access Object, which takes that raw data from DB and makes sense out of it and prepares it for consumption by the model/business logic layer objects. That is:

    - src (folder)
      |- DAO (folder)
        | - ProductADAO (classes - take data in, return consumable objects out)
        | - ProductBDAO
        | - ...
        | - ProductZDAO
      |- DataFromDB (folder)
        | - ProductAData (classes - contain methods to query pure result sets from DB)
        | - ProductBData
        | - ...
        | - ProductZData

Whenever I need to make a new SQL or refactor an old one I do this: What is this SQL doing?  Is it operating on `SomeObjectX`?  If yes, find/create class called `ObjectX`, and add a method to it, extracting pure data from DB, put it into `DataFromDB` folder. Write the `DAO` object if needed to transform data into a consumable object. Use the object as is in my code. Does this look like a good strategy?  Is there a better one?   My problem with this one is that before (now) all the SQL is tightly coupled and is included into the multiple business classes.  Using the above strategy will mean I am to be creating many many classes, a lot of classes, most likely one for every few SQL statements.    The pros is that it seems like I will achieve a level of code modularity that I wanted.

hi i am working on a project in which i have to retrieve the articles which are the most visited by the users. i have serched the internet but not find any useful code snippets. can any one guide me how to solve this problem.

So, you know how on forums (including this one) the icon of a topic/forum will be greyed out if your account viewed that topic's latest post, regardless of which computer you viewed it on? How exactly does it store that?

I know that logically it would store it on the Database, but I'm curious as to the actual implementation. It seems to me that storing every single topic you viewed it and when would take up huge numbers of rows, even for a small number of people, like say 100. If you have a forum with 1000's of people, each viewing even 3 topics a day, you're record numbers would be huge, slowing down the database. And calling your last viewed time for each and ever topic? Wouldn't that slow down the code excecution heaps?

If you have any input, I'd love to hear it. It's a question I've been wrestling with in the back of my mind for a few years now

Hello everyone

I wonder if you could help me.

I want to create a function called


<?php
function mythings($what)


Which would allow me to pass an ID number to, such as


<?php
mythings(5419);


What I want to do with that function is store the ID numbers of the past 6 items I have viewed, but I want to store each item as a SESSION once it has been passed.

So essentially I would end up with the following 6 SESSIONS


<?php
$_SESSION['item1'];
$_SESSION['item2'];
$_SESSION['item3'];
$_SESSION['item4'];
$_SESSION['item5'];
$_SESSION['item6'];


So the "item1" SESSION would be the latest item ID passed through the function

But then if I then passed a new ID through the function, that new ID passed would then become

$_SESSION['item1'];

and the current SESSION

$_SESSION['item1'];

would become

$_SESSION['item2'];

and

$_SESSION['item2'];

would become

$_SESSION['item3'];

and so on.

This means I can do a list such as

<?php
print "Item 1".$_SESSION['item1']."<br>";
print "Item 2".$_SESSION['item2']."<br>";
print "Item 3".$_SESSION['item3']."<br>";
print "Item 4".$_SESSION['item4']."<br>";
print "Item 5".$_SESSION['item5']."<br>";
print "Item 6".$_SESSION['item6']."<br>";
?>

Does that make much sense? Can anyone help.

Thanks very much all

John

Hello all,

Wondering if you can help me, I am wondering if it is possible to get PHP to show the last websites you viewed, just giving the names of the websites in a list. If so? is there any pointers someone can give me as to how to learn to achieve something like this..I'd really appreciate the help!

Hello people i have a system that takes people to generated pages from the database, the user has a field to input a video and others watching videos will get redirecting to tht video in time, what i want to know is how can i tell if a user viewed the page so to stop them getting redirected to it again by my random video query?

The link always is video.php?id=blabla

the id changes every refresh, so i can call that id to check if there on the page but how can i tell if they have been on it before.

This topic has been moved to PHP Applications.

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

hey all,
i have an issue, i have a directory site called hackingtoolz.tk and if you go to it, you will see a list of folders as it is just a directory the problem is how to i stop the banner from apearing in the directory.
i have tried changing the chmod to 4000 and that just made the jpeg stay their and the banner screw up
if you go to the site you will understand what i mean better
hope you can help
cheers nick

This script ...

<?php

    echo "Your IP Address: <br/>";
    print_r($_SERVER['REMOTE_ADDR']);

?>

... prints:

::1

I am looking to have the IP address from which the site is viewed printed on screen. What is the issue, here, with the script I have?   I have been trying this on localhost and I am using XAMPP.

<?php query_posts('meta_key=post_views_count&posts_per_page=3&orderby=meta_value_num& order=DESC'); if (have_posts()) : while (have_posts()) : the_post(); ?> <ul class="rpul"> <li> <div class="class="post-thumb wp-post-image" style=' '> <?php if ( has_post_thumbnail() ) : ?> <?php the_post_thumbnail('thumbnail') ?> <?php endif ?> </div><div class='cat-post-text'> <h1> <a href="<?php the_permalink(); ?>"><?php the_title(); ?>

 

so the user is reading a story, to finish reading he has to click a link that redirects them to the signup page.
Code: [Select]
<?php
session_start();
$beginurl = $_SERVER['HTTP_REFERER'];
$_SESSION['beginurl'] = $beginurl;
echo $_SESSION['beginurl'];
?>
<html>
 <head>
  </head>
 <body>
<script type="text/javascript"><!--
location.replace("http://www.mysite.com/members/");
//--></script>
  </body>
</html>
When they get to the second page, they have to click a link that opens up a modal. this is the code that runs when they hit the register button

Code: [Select]
session_start();
$beginurl = $_SESSION['beginurl'];

$beginurl= (isset($_SESSION['beginurl'])) ? $_SESSION['beginurl'] : 'Error';

if( $_SESSION['status'] ='authorized')   
$_SESSION['$makemodal'] = 0;

//sends the user to the page upon successful password credential
if(!isset($_SESSION['SESS_USERID'])||(trim($_SESSION['SESS_USERID']=='admin')))
   {
        echo '<script language="javascript">';
         
echo "top.location.href = $beginurl";
        echo '</script>';
        exit();
    }

Am I passing this variable correctly?

and I'm not sure if the top.location.href towards the bottom is correct either, right now after I hit the register button I'm redirected to a blank page where the url is,

"http://www.mysite.com/function Error() { [native code]}"

Hello, I was wondering how to create the 'This post is being viewed by user1, user2, user3 and ... guests' on a certain location of the forum/website.

I was thinking about having all these usernames / guests stored in the mysql database, however this caused an issue for me, since I got no idea if you can/are allowed to place an array in a table.

I am hoping someone out here knows what is the easiest/most efficient way of doing this.

Thanks in advance.