PHP - Php $this->_vars['html'] Unknown Missing Value [closed]

i have a script that wrote which updates fields in a mysql database with millions of rows. it just uses a while loop for each row.

now the problem is that i forgot to add something to the script, but i already visited the .php file in my browser.

i closed the browser and when i refresh the database it still seems to be running even though i closed the browser the script was running on....

is this because the script is still cached in the memory or what? how can i stop it?

I made a bug which caused endless loop and endless printing.
When I noticed that, I closed the browsers tab, fixed the bug, open a new tab and re-run.
I was assuming the server would start from the beginning, but instead I noticed that some variables were active and the program continued from where it stopped.
How can I make the program to stop when the client tab is terminated?

Hi Everyone,

I wonder if somebody could help me. I have been at this for hours and am really struggling.

I have a timer which I have set up for a quiz.  The quiz opens in a javascript shadow box.  When the quiz is opened a session variable for the timer is set up to keep track of the time. 

What I need is for this session variable to end when the shadow box is closed. I have a onClose hook to peform actions when the shadow box is closed which is in javascript.

Obviously I cannot end the session variable in the javascript function due to js being client side and php being server side.

Has anyone any suggestions how I can resolve this issue.

I need to end this session variable as if the user exits the quiz and then selects another quiz to do the timer uses the current time session rather than assigning the new time value for that particular quiz.

Thanks in advance. 

Edd

Hello. I want to display all photos from the database. The problem is that it  displays nothing. I added a foreach loop in html but further it not display. I'am beginner, I hope someone help me where I make mistake. I care about separation logic from view.

 

class photo_display
{
    private $database;
    private $userData;


    public function __construct($database)
    {
        $this->database = $database;
    }

    public function display()
    {


        $query = $this->database->connect()->prepare("SELECT photo FROM photo");
        $query->execute();

        if ($query->rowcount()) {
            $row = $query->fetchAll();
        }
        $this->userData = $row;



    }

    public function display_Photos(string $colName)
    {
        return (isset($this->userData[$colName])) ? $this->userData[$colName] : [];

    }
}

<div class='container-fluid bg-dark' id='profil'>
            <div class='row'>
                <div class=" col-12 col-sm-12 col-md-4 col-lg-4 col-xl-4 order-5 order-12 order-6 order-md-4">
                    <div class="row" id="margin">
                        <div class="col-xl-12 d-flex justify-content-center" id="test">
                            <?php foreach ($photo_display->display_Photos('photo') as $value)
                            { ?>
                                <img src ="<?php echo var_dump($value) ?>" />;
                            <?php }
                            ?>

                        </div>
                    </div>
                </div>

 

Hello,
How do I get a user's session destroyed when he closes his browser?

Thanks in advance

Ok this is some noob question here

I have a page that has few separate pieces of php code embeded within html code. Each piece is separated with Code: [Select]
<?php  ... ?> tags, everything works fine.

I need to assign a variable in first (from the top) piece of php code. Then I want to be able to use that variable in all others php pieces across this same page....

I searched and searched and first tried to do it like :

First piece:
Code: [Select]
<?php
function id()
{
$id="blah";
}
?>

Second piece :
Code: [Select]
<?php
id();
...
echo $id;
?>

didn't work, then I tried

First place:
Code: [Select]
<?php
$id="blah";
function id()
{
global $id;
}
?>

Second piece :
Code: [Select]
<?php
echo $id;
?>

After struggling and reading for few days all about global, static, and regular variables i finally decided to ask professionals to help.... please let me know if you need me to make the question description more clear or smn

Hey All,

I have a sessions table that is used to see if a user is online.  It only gets deleted when they click the Logout button.  What I need to do is have it so it gets deleted even if they close the browser.

Should I add a column in the sessions table with a time stamp and check on each page for every user to make sure its great than 30 min?

Is there a better way to do this, without so many queries?

Thanks

This topic has been moved to JavaScript Help.

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

im using 000webhost as a test site and when i run this code it redirects me to there err page but with no error message.
the sql query works fine in phpmyadmin and i added the rest of the code to try the php side.
i "think" the problem is the echo $rows"value's" as im unsure of what the $vars should be


<?php
include("config.php"); 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql = "SELECT make, COUNT(*) AS total, SUM(IF(comments = \'pass\', 1, 0)) AS withComments FROM dsgi_serval GROUP BY make ORDER BY COUNT(*) DESC"; 
$result=mysql_query($sql);
echo "$sql";
echo "$result";

?>

<table><tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>
<tr>
<td align="center"><strong>make</strong></td>
<td align="center"><strong>Total</strong></td>
<td align="center"><strong>Validated</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><?php echo $rows['make']; ?></td>
<td><?php echo $rows['total']; ?></td>
<td><?php echo $rows['withcomments']; ?></td>
</tr>


<?php
}
?>
</table>
<?php
mysql_close();
?>

Hello! I have a strange error on my PHP script and i dont how to fix it. If someone can help me, please help me then! Here is my error: Code: [Select]
logout(); } else { $iq = mysql_query("SELECT * FROM users WHERE username='{$signin_username}' AND password='{$signin_password}' AND suspended='0' LIMIT 1;"); $ir = mysql_fetch_array($iq); $_SESSION['me'] = $ir; } } } } else { die("The configuration did not recieve appropriate variables to accept your request."); } if ($set['next_clearup'] < time ()) { $next_clearup = time () + 60 * 60 * 24; mysql_query ('' . 'UPDATE settings SET set_value=\'' . $next_clearup . '\' WHERE set_name=\'next_clearup\' LIMIT 1;'); mysql_query ('UPDATE users SET ads_clicked=\'\' WHERE ads_clicked!=\'\''); } } ?>
Warning: include(THDIRindex.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\Upload\index.php on line 16

Warning: include() [function.include]: Failed opening 'THDIRindex.php' for inclusion (include_path='.;\xampp\php\PEAR') in C:\xampp\htdocs\Upload\index.php on line 16
And here is the PHP file the error is in:
Code: [Select]
<?php

session_start();
include_once('lib/lib.php');
include_once('lib/configuration.php');

$ddir = THDIR.$do->get_file_url();
include($ddir);

if(file_exists(HEADER)) { include_once(HEADER); }
if($contents) { print $contents; }
if(file_exists(FOOTER)) { include_once(FOOTER); }
?>
Help ASAP if you can!

Hey,

I've got a query in which a variable is interpreted as a column and I don't why this is caused.


$upgrade_time_sql = "SELECT * FROM todo_upgrades WHERE profile_id = ".$profile_id." AND level = ".$profile_data['level2_'.$show.'']." AND type = ".$show."";
$upgrade_time_res = mysql_query($upgrade_time_sql) or die (mysql_error());


$show is filled with the content "storage"

The mysql_error is

"Unknown column 'storage' in 'where clause'"

Thanks for helping.

I Am getting along with php better than I was previously. But this 68 year old brain still refuses to learn very fast!

Here is the error I'm receiving when I'm trying to open the db:

Parse error: syntax error, unexpected T_VARIABLE in /home/taft65/public_html/memProtest.php on line 197


<?php
                            error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);
                            $host = "localhost";
                            $dbname="database;"
       Failing ------>$username = "user";
                            $password="drDedf#hj";


I understand you do not need to declare varibles in PHP, Correct? I checked the db to ensure that I'm calling the correct value. NuSpherePhpEd to validate the code. I also check it with DSV PHP Editor. Both come up with the same error. I'm also using MyPhpAdmin to create the database and tables.

I know also to place this calling info in another folder and include it by calling it with a php include statement. I just have it within the code to quickly test it.

Thank you for any assistance.
Bob...

Hey im kind of new to PHP me and my mate was working on a script and we can not seem to get this working:
Its connected through mysql.
And it shows

Quote

Notice: Undefined index: username in C:\xampp\htdocs\stick_arena.php on line 21

Notice: Undefined index: userpass in C:\xampp\htdocs\stick_arena.php on line 22

Notice: Undefined index: action in C:\xampp\htdocs\stick_arena.php on line 23

Notice: Undefined index: usercol in C:\xampp\htdocs\stick_arena.php on line 24

Notice: Undefined index: stats in C:\xampp\htdocs\stick_arena.php on line 25



Here are the lines
Quote

// declare variables
$username = sanitize($_POST['username']);
$password = sanitize(md5($_POST['userpass']));
$action = sanitize($_POST['action']);
$usercol = sanitize($_POST['usercol']);
$stats = sanitize($_POST['stats']);



Here is the full script for that page:
Click here
please help as soon as possible.

Hey


I have a script that builds an array but for some reason there is a loose integer in the variable which is confusing me and i think its the cause of my syntax errors in javascript. But i got no idea where it is coming from =/


Here is the function i use:

Code: [Select]
<?php
function img($id) {
      $img = array();
      $img['tiles'] = $this->db->getAll("SELECT DISTINCT t.id, CONCAT('data/tiles/',filename) AS f FROM `map_tiles` AS mt
               INNER JOIN `tiles` AS t ON (mt.tile=t.id)
                WHERE mt.map_id={$this->db->qstr($id)}");

      echo print_r($img); 
      die;            
      //exit(json_encode($img)); // turned off for testing
?>


The echo returns this:
Code: [Select]

Array
(
    [tiles] => Array
        (
            [0] => Array
                (
                    [id] => 10
                    [f] => data/tiles/floor.png
                )


        )

)
1  <----- why does this appear? And could this cause a syntax error if sent back for JS processing?


As you can see there is 1 showing at the end but i don't see why =/ Any ideas if thats suppose to happen ?

So I've been working on this site for a few days now, and it's coming along slow but well.  I'm trying to learn as much as possible about the coding I'm doing because it's a bit outside my skill range, so I'm taking my time.

I'm using a switch statement to dictate navigation, and netsted switches inside as well.  Everything was going great until I started continuing to add code to each case of the switch, then all of a sudden 2 of the cases show up blank, but nothing else is affected.  I spend an hr last night and this morning, looking and redoing, to get the same result.  Can someone take a look at this and advise please?

<?php

switch ($_GET['page']) {
     case 'news':
           switch ($_GET['id']) {
              case $_GET['id']:
                    $id = $_GET['id'];
                  $link = mysql_connect ($host, $user, $pass);
                    mysql_select_db ($db, $link);
                    $query = "SELECT * from news WHERE id = '$id'";
                      $result = mysql_db_query ($db, $query, $link);
                      while ($row = mysql_fetch_array($result)){
                    echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
                    <tr>
                      <td colspan=\"2\" class=\"Main-Header\"><a href=\"index.php?page=news&id=".$row['id'] . "\">".$row['title'] . "</a></td>
                    </tr>
                    <tr>
                         <td colspan=\"2\" class=\"Main-PostInfo\">Posted By: $row[author] on $row[date]</td>
                    </tr>
                    <tr>
                      <td colspan=\"2\" class=\"Side-Content\">$row[content]</td>
                    </tr>
                  </table><br />
                  "); }
                  break;
             default:
                  $link = mysql_connect ($host, $user, $pass);
                    mysql_select_db ($db, $link);
                    $query = "SELECT * from news'";
                      $result = mysql_db_query ($db, $query, $link);
                      while ($row = mysql_fetch_array($result)){
                    echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
                    <tr>
                      <td colspan=\"2\" class=\"Main-Header\"><a href=\"index.php?page=news&id=".$row['id'] . "\">".$row['title'] . "</a></td>
                    </tr>
                    <tr>
                         <td colspan=\"2\" class=\"Main-PostInfo\">Posted By: $row[author] on $row[date]</td>
                    </tr>
                    <tr>
                      <td colspan=\"2\" class=\"Side-Content\">$row[content]</td>
                    </tr>
                  </table><br />
                  "); }
                  break;
           }
           break;
     case 'about';
          $link = mysql_connect ($host, $user, $pass);
          mysql_select_db ($db, $link);
          $query = "SELECT * from aboutvow";
            $result = mysql_db_query ($db, $query, $link);
            while ($row = mysql_fetch_array($result)){
          echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
              <tr>
              <td class=\"Main-Header\">$row[title]</td>
                </tr>
                  <tr>
                      <td class=\"Side-Content\">$row[content]</td>
                    </tr>
                  </table><br />
                  "); }
                 break;
     case 'roster':
           switch ($_GET['id']) {
              case $_GET['id']:
                    $id = $_GET['id'];
                  $link = mysql_connect ($host, $user, $pass);
                    mysql_select_db ($db, $link);
                    $query = "SELECT * from roster WHERE id = '$id'";
                      $result = mysql_db_query ($db, $query, $link);
                      while ($row = mysql_fetch_array($result)){
                    echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td width=\"30\" colspan=\"2\" class=\"Main-Header\">-VoW- $row[gamename]</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-PostInfo\">SECTION 1: PERSONAL INFORMATION</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Name</td>
    <td class=\"Side-Content-Right\">$row[firstname] $row[lastname]</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Location</td>
    <td class=\"Side-Content-Right\">$row[location]</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Age</td>
    <td class=\"Side-Content-Right\">");
    date_default_timezone_set('America/New_York');

    function calculateAge($dob){
   
    return floor((time() - strtotime($dob))/31556926);
   
    }
    $age = calculateAge("$row[dob]");
    echo ("$age</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Connection</td>
    <td class=\"Side-Content-Right\">$row[connection]</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-PostInfo\">SECTION 2: CONTACT INFORMATION</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Email</td>
    <td class=\"Side-Content-Right\">$row[email]</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Steam</td>
    <td class=\"Side-Content-Right\">$row[steamfriends] ($row[steamemail])</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Xfire</td>
    <td class=\"Side-Content-Right\">$row[xfire]</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-PostInfo\">SECTION 3: DAY OF DEFEAT INFORMATION</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">DoD Experience</td>
    <td class=\"Side-Content-Right\">");
    date_default_timezone_set('America/New_York');

    function calculateExp($exp){
   
    return floor((time() - strtotime($exp))/31556926 + 8);
   
    }
    $exp = calculateExp("$row[dodexp]");
    echo ("$exp Years</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">Class</td>
    <td class=\"Side-Content-Right\">$row[class]</td>
  </tr>
  <tr>
    <td class=\"Side-Content-Left\">SteamID</td>
    <td class=\"Side-Content-Right\">$row[steamid]</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-PostInfo\">SECTION 4: MATCH INFORMATION</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-Content\">-VoW- $row[gamename] has no match history</td>
  </tr>
</table><br />
                  "); }
                 break;
              default:
                      $link = mysql_connect ($host, $user, $pass);
                        mysql_select_db ($db, $link);
                        $query = "SELECT * from roster";
                          $result = mysql_db_query ($db, $query, $link);
                          while ($row = mysql_fetch_array($result)){
                     echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td colspan=\"5\" class=\"Main-Header\">Roster</td>
  </tr>
  <tr>
    <td width=\"101\" class=\"Main-Roster-Left\">Name</td>
    <td width=\"124\" class=\"Main-Roster\">Status</td>
    <td width=\"241\" class=\"Main-Roster\">SteamID</td>
    <td width=\"175\" class=\"Main-Roster\">Class</td>
    <td width=\"452\" class=\"Main-Roster\">Recruitment Date</td>
  </tr>
  <tr>
    <td class=\"Main-Roster-Content-Left\"><a href=\"index.php?page=roster&id=".$row['id'] . "\">".$row['gamename'] . "</a></td>
    <td class=\"Main-Content-Roster\">$row[status]</td>
    <td class=\"Main-Content-Roster\">$row[steamid]</td>
    <td class=\"Main-Content-Roster\">$row[class]</td>
    <td class=\"Main-Content-Roster\">$row[admin_recdate]</td>
  </tr>
</table>"); }
                  break;
           }
           break;
     case 'servers':
           switch ($_GET['id']) {
              case 1:
                  echo "ID is 1";
                  break;
              case 2:
                  echo 'ID is 2';
                  break;
              default:
                  echo 'No ID - display main servers';
                  break;
           }
           break;
     case 'forum';
          echo ("FORUM HERE"); 
          break;
     default:
           $link = mysql_connect ($host, $user, $pass);
          mysql_select_db ($db, $link);
          $query = "SELECT * from news ORDER BY date DESC LIMIT 5";
            $result = mysql_db_query ($db, $query, $link);
            while ($row = mysql_fetch_array($result)){
          echo ("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td colspan=\"2\" class=\"Main-Header\"><a href=\"index.php?page=news&id=".$row['id'] . "\">".$row['title'] . "</a></td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Main-PostInfo\">Posted By: $row[author] on $row[date]</td>
  </tr>
  <tr>
    <td colspan=\"2\" class=\"Side-Content\">$row[content]</td>
  </tr>
</table><br />
"); }
     break;
     case 'recruitment':
           switch ($_GET['action']) {
              case 'apply':
                  echo "APPLICATION HERE";
                  break;
              case 'submit':
                  echo 'SUBMIT APPLICATION';
                  break;
              case 'status':
                  echo 'APPLICATION STATUS';
                  break;
              default:
                  echo 'No ACTION - display main recruitment';
                  break;
           }
           break;
}

?>

The problem I am having is getting the default news case and default roster case to print.  Everything else shows up properly.  Sorry for the messy code, I"m working on it!