PHP - Page Not Going Back

This topic has been moved to JavaScript Help.

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

Ok i have a question about a dynamic website..

What i have is a site that takes content from the MySQL database and load it into the index.php file. And i know how to change the content of the page when i move around in the navigation, e.g when i click on the "HOME" tab, the content for the home page is shown and when i click on "ABOUT", the information about my site is shown and so on..

Now for my question!

I want the content too move everyday automaticly. For example, today i type in some content in the MySQL database that i want to be shown on my website for today. But tomorrow i want the content to have been moved to page 2, and the next day page 3 and so on.. So that everyday i can type in new content, and all the old pages get pushed back one page if that makes sense?

Sorry but I have no actuall code for this cause i don't know how to start, but i guess you could use dates and "if else" statements to determine when the pages should be moved and not. Example code would be greatly appriciated!   

And when i say moved between pages, i mean like this:

Today:
www.mywebsite.com/index.php?pageid=1 - example 2
www.mywebsite.com/index.php?pageid=2 - example 1
www.mywebsite.com/index.php?pageid=3 - empty

Tomorrow:
www.mywebsite.com/index.php?pageid=1 - example 3
www.mywebsite.com/index.php?pageid=2 - example 2
www.mywebsite.com/index.php?pageid=3 - example 1

And we're back online... again!  It may have taken 3-4 days, but we're back.

I made a file for updating data.
I do get the id back from the view page, but not the variable.
What do I do wrong? I'm puzzling a few days, but just don't see it.

This my code:
Code: [Select]
<?php
// init
$msg = '';
$errorMsg = '';
$rep_id = array();
$componist = '';
$repertoire = '';
$titel = '';

$formOK= false;


// + + + + + + + +  GET + + + + + + + + 
if(isset($_GET['id']))  {
$rep_id = inputControl($_GET['id']);
}
if(isset($_GET['componist'])) {
$componist = inputControl($_GET['componist']);
}

//print "session: $login_id, $login_recht"; // TEST van de sessie
// + + + + + + + + + + + + + + + + POST + + + + + + + + + +

if (isset($_POST['UpdateRepSubmit'])) {
  if (isset($_POST['componist'])) {
  $componist = inputControl($_POST['componist']);
}
if (isset($_POST['titel'])) {
   $titel = inputControl($_POST['titel']);
}

}
//print'<pre>'; print_r($repertoire); print '</pre>'; //TEST2


// + + + + + + + + + + + + + + + + + + + queries

$select_query= "SELECT *
FROM repertoire_eng
ORDER BY componist ASC
";


print $select_query; // TEST 3



// # # # # # # # # # # # database connectie # # # # # # # # # # 
$dblink = mysqli_connect($host,$user,$pass,$db) or die ('Mysql-connectie heeft gefaald.');

if (!$dblink) {
// + + + + + + fout bij met maken van databaseverbinding
$errorMsg = "Geen verbinding met de MySQL-server";
}
else {
$result = mysqli_query($dblink, $select_query);

if($result) {
$i = 0;
while ($row = mysqli_fetch_array($result)) { // uitlezen resultaat
$repertoire_ids[$i] = $row['id'];
$componisten[$i] = $row['componist'];
$titels[$i] = $row['titel'];
$i++;

}
}
else {
// + + + + + fout bij het uitvoeren van de query
$errorMsg = "De query kon niet worden uitgevoerd.";
}



// # # # # # # # # # # einde database connectie # # # # # # # # #

mysqli_close($dblink);
}
?>

In the html block:
Code: [Select]
<div id="container">
<form action="edit_repertoire.php" method="post" name="edit_repertoire" onsubmit = "return checkForm(this)">
<fieldset>
<legend>Update repertoire in your list:</legend>


<!-- # # # # # # Toevoegen van een hiddenfield om de id op te halen uit de URL # # # # # #  -->

<input type="hidden" name="id" value = "<?php echo $rep_id; ?>" >

<p>ID= <?php echo $rep_id; ?></p>
<p> Componist = <?php echo $componisten; ?></p>

<!-- + + + + + + + FORMREGELComponist + + + + + + + -->
<div class="formregel">
<div class="formkolomlinks">Composer name:</div>
<div class="formkolomrechts"><input name="componist" id="componist"  type="text"  maxlength="128"
value="<?php echo $componist; ?>"  /> Name first, then the initials! </div>
   
</div><!-- Einde formregel -->


<!-- ++ + + + + + FORMREGEL Compositie en of rol + + + + + + + -->
<div class="formregel">
<div class="formkolomlinks">Composition and or role</div>
<div class="formkolomrechts"><input name="titel" id="titel" type="text"  maxlength="128"
value="<?php echo $titel; ?>" /></div>
   
</div><!-- Einde formregel -->


 
<!-- +++++++ FORMREGEL +++++++ -->
<div class="formregel">
<div class="formkolomlinks"><input name="updateRepSubmit" type="submit" value="Update repertoire" /></div>

   
</div><!-- Einde formregel -->



</fieldset>
</form>
<div class="clear"></div>
</div><!-- einde container -->
</div><!-- einde tot_wrap -->

edit: added [code][/code] blocks

Hello everyone! I am a new user and I have a simple question. How to download the database and create a backup. 

Hey everyone. So lately I've been searching for someone to do this for me but I figure if I learned it myself it'd be much more helpful to me in the future. I run a gaming clan, and we have a roster. You can view it he  http://www.zealotgam...s.php?pageid=15

Obviously, you can see a few things. The default page lists all our staff. That is very easy, and not really the part I need help with. The help begins with the games list you see at the side. When you click a game, it lists all users who have that Game listed as their Main Game in a profile field, and lists other info, such as their rank, In-Game contact (which is another profile field) and join date/last active. The games are also themselves divided into categories.

Our code is relatively simple. We keep a manual array of info that keeps these together you can see below:
 

 

// Define Games and Lists //
$gameslist = array();
        
//SETUP $gamelist[] = array("Game Name","urlshortcode","Name of In-Game Name or Account", "field# for that profile field");
        
$gameslist[] = array("Battlefield 4 (PS4)", "bf4ps4", "PlayStation ID", "field7");
$gameslist[] = array("Counter Strike: Global Offensive (EU)", "csgoeu", "Steam ID", "field8");
$gameslist[] = array("Counter Strike: Global Offensive (NA)", "csgona", "Steam ID", "field8");
$gameslist[] = array("Elder Scrolls Online (NA)", "esona", "Main Character", "field45");
$gameslist[] = array("League of Legends (EUNE)", "loleune", "Summoner Name", "field12");
$gameslist[] = array("League of Legends (EUW)", "loleuw", "Summoner Name", "field31");
$gameslist[] = array("League of Legends (NA)", "lolna", "Summoner Name", "field32");
$gameslist[] = array("League of Legends (OCE)", "loloce", "Summoner Name", "field47");
$gameslist[] = array("Minecraft", "mc", "Username", "field14");
$gameslist[] = array("Smite (EU)", "smiteeu", "Smite Account", "field22");
$gameslist[] = array("Smite (NA)", "smitena", "Smite Account", "field22");
$gameslist[] = array("Titanfall", "tfall", "Origin ID", "field29");
$gameslist[] = array("WildStar (EU)", "wseu", "Main Character", "field48");
$gameslist[] = array("WildStar (NA)", "wsna", "Main Character", "field48");
$gameslist[] = array("World of Tanks (EU)", "woteu", "WarGaming.NET ID", "field46");
$gameslist[] = array("Other Game", "other", "", "");


// Game Type Categories
$gamecats = array();


// ADD the # of the game in the list above (starting from 0) to the appropriate category array number list.
$gamecats[] = array("Divisions",array(4,5,6));
$gamecats[] = array("Guilds",array());
$gamecats[] = array("Gaming Groups",array());
$gamecats[] = array("Divisions in Development",array(0,1,2,3,7,8,9,10,11,12,13,14));
$gamecats[] = array("Miscellaneous",array(15));

 

This gets tedious to keep track of manually, and my admins with no programming experience can barely understand what is happening.

The listing of users is very easy, and I do not need any help with that. What I would like to add is a manager in the admin panel where you could save the information listed above to a table such as PREFIX.games. I imagine having several drop down boxes. A mockup is below:
 

 
I'd then Like a list of games that includes these rows in the table with a [ ] Remove checkbox.

I do not know how to add this to the admin panel and would love guidance on how to begin doing this. The sorting would go by Game Status (the second array in my php code) then Alphabetical. This would go a long way in helping my staff edit this list themselves. Any help would be appreciated.

Skype: j.c.will my be better to work personally with me.

$i = 0;
while($i < 10) {

   if ($i == 7) {
     //Do Function
   } else {
     $i++
    Go back to beginning of loop
  }

  //More if statements here.
}

Hi everyone reading this,

I have used PHP before as a hobby programmer but recently my boss asked me to make a webpage to accept worker's hours and store them in a database. So I realize that in the last few years object oriented style has been added into PHP. I have learnt OOP (C++) about a decade ago and understand the fundamentals of it.

If I am writing this website code, am I going to be better off spending the time to get familiar with the new OOP stuff in PHP and use that or would it be better to just use an old sequential style of programming? I know this may seem like apples and oranges and that it varies based on opinion, but maybe there can be reasons for me to use OOP over sequential.

For instance, if I write this code to be flexible enough that I can do a basic "worker times" table first, then I might be able to add additional functionality later, like worker details and qualifications, all of which could be brought up with the click of a button. Will it generally be easier to add onto code using OOP?

I have a profile page where the user answers a list of about 20 questions.  These questions are then put into a mysql table with username, questionid, and answer.  I can store the answers to the table, but I cannot figure out how to get them back to view and edit.
My form is built from basic HTML.  I know how to pull answers from a db table with only 1 row of results, where each field is a different question, but this one is different, as it will pull 20 rows, and each row is for a different question.
Here is how I populate the questions and then fill in the answers.
Code: [Select]
// If this user has never set their profile, insert empty questions into the database
  $query1 = "SELECT * FROM u_profile WHERE username = '" . $_SESSION['username'] . "'";
  $data = mysqli_query($dbc, $query1);
  if (mysqli_num_rows($data) == 0) {
    // First grab the list of questionids
    $query2 = "SELECT questionid FROM questions ORDER BY q_order";
    $data = mysqli_query($dbc, $query2);
    $questionids = array();
    while ($row = mysqli_fetch_array($data)) {
      array_push($questionids, $row['questionid']);
    }

    // Insert empty question rows into the u_profile table, one per question
    foreach ($questionids as $questionid) {
      $query3 = "INSERT INTO u_profile (username, questionid) VALUES ('" . $_SESSION['username']. "', '$questionid')";
      mysqli_query($dbc, $query3);
    }
  }

  // If the questionnaire form has been submitted, write the responses to the database
  if (isset($_POST['submit'])) {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $answer_id => $answer) {
      $query4 = "UPDATE u_profile SET answer = '$answer' WHERE username = '" . $_SESSION['username'] . "' AND questionid = '$answer_id'";
      $uprofile_set = "CALL uprofile_set('" . $_SESSION['username'] . "')";
      mysqli_query($dbc, $query4) or die( "Connection Error1" . mysqli_error($dbc) ) ;
      mysqli_query($dbc, $uprofile_set) or die( "Connection Error2" . mysqli_error($dbc) ) ;
    }
      $races = "SELECT * FROM u_raceschedule WHERE username = '" . $_SESSION['username'] . "'";
      $data = mysqli_query($dbc, $races);
      if (mysqli_num_rows($data) > 0) {
      set_time_limit(30);
       $buildplan = "CALL tplan('" . $_SESSION['username'] . "')";
       mysqli_query($dbc,$buildplan) or die("Connection Error2" . mysqli_error($dbc) ) ;

Would LOVE any help.  I am really new to this whole coding thing.

nothing is echoed
for the second foreach???
foreach($pictures as $picture)
-im breaking cause it's a large file


Code: [Select]
$doc = new DOMDocument();
$doc->load('accommodation.xml');

$i = 0;

$accommodations = $doc->getElementsByTagName('accommodation');
foreach($accommodations as $accommodation) {
if(++$i > 2) break;
$supplierID = $accommodation->getElementsByTagName('code')->item(0)->nodeValue;
 $pictures = $accommodation->getElementsByTagName('pictures')->item(0)->nodeValue;
 $pictures=array();
foreach($pictures as $picture) {
echo $url = $picture->getElementsByTagName('url')->item(0)->nodeValue;

}



}//end


//XMl schema
<?xml version="1.0" encoding="utf-8"?>
<accommodations>
<accommodation>
<code>1</code>
<pictures>
<picture>
<url>http://example.com/images.k.jpg</url>
</picture>
</pictures>

I have tried to create a back button, but I have not reached the correct solution.
I log into first page (index.php) and then you will get two new buttons that brings me to two different pages. Then I want to come back to the login page, the session is gone and I have to log in again. I want to remain logged in  when I get to the index page and be able to see the two buttons. I tried different things such as:

Code: [Select]
<input type="button" value="Return to previous page" onClick="javascript:history.go(-1)" /> Code: [Select]
<?php $referer = $_SERVER['HTTP_REFERER'];
   if (!$referer == '') {
      echo '<p><a href="' . $referer . '" title="Return to the previous page">&laquo; Go back</a></p>';
   } else {
      echo '<p><a href="javascript:history.go(-1)" title="Return to the previous page">&laquo; Go back</a></p>';
   }
?>
But that's not what I'm thinking about. How can I solve this?


index.php

<?php
session_start();

if(isset($_POST['LoutBtn']))
{
session_destroy();

}

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


//convert a string to all lower case letters.
//if user gives username with big letters still can login.
$user = strtolower($_POST['username']);
$pass = $_POST['password'];

if($user == 'admin' && $pass == '123')
{

$_SESSION['LogedIn'] = true;
{

print('Welcome admin');

?>

<table width="50"  align="right"  cellpadding="2" cellspacing="2">

<form method="POST" action="panel.php">
<tr>

<td><input type="submit" value="add post" name="PnlBtn" /></td>
</tr>
</form>

<form method="POST" action="stat.php">
<tr>

<td><input type="submit" name="showstat" value="visitorlog" /></td>
</tr>
</form>

</table>



<?php


}
}
elseif (empty($user) || empty($pass))
         
      
      {
  print('<font color="#FF0000">Please fill in username and password!<br/></font>');
    
      
      }
  
elseif ($_POST['username'] != 'admin'){
      
     
      print('<font color="#FF0000">wrong username<br/></font>');
    
      
      }
      
      elseif ($_POST['password'] != '123'){
      
   
      print('<font color="#FF0000">wrong password<br/></font>');

//elseif {

// print('<font color="#FF0000">The User Name And/Or Password is incorrect!
//  Please try again...<br/></font>');

//print('<a href="index.php">Back</a>');
}

  
  }

?>


<?PHP
/* define the blog content file name */
$filename = "myBlogContent.txt";
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<form method="post" action="index.php" >

<table width="300" border="1" align="right" cellpadding="2" cellspacing="2">
<tr>
<td width="150">UserName:</td>
<td> <input type="text" name="username" size="20" />
</td>
</tr>
<tr>
<td width="150">Password</td>
<td><input type="password" name="password" size="20" /></td>
</tr>
<tr>
<td><input type="submit" value="Login" name="LoginBtn" />
</td>
</tr>
<tr>
<td><input type="submit" value="Logout" name="LoutBtn" /></td>
</tr>
</table>
</form>




<!-- CONTENT DIV -->
<div style="position:absolute; left: 100px; top: 100px; width: 400px;">

<?PHP

/* check to see if the file exists */
if (!file_exists($filename)) {

echo "The Blog Is Empty";

}else{

/* get the file lines into an array */

$BlogArray = file($filename);

/* count the number of blog entries */

$count = count($BlogArray);
$i=0;

while($i<$count) {

$new_array = explode("|", $BlogArray[$i]);

echo "Posted by: " . $new_array[1] . "<br>";

echo "Posted on: " .  date("m/d/y", time($new_array[0])) . "<br>";

echo "Title: " . $new_array[2] . "<br>";


echo $new_array[3] . "<hr>";


$i ++;

}
}
?>
</div>
</body>
</html>



panel.php


<?php
session_start();
if   ($_SESSION['LogedIn'] == false)
{
$redirect = "Location: " . $_REQUEST['LoginBtn'] . "index.php";
echo header($redirect);

}

elseif ($_SESSION['LogedIn'] == true)
{
echo "welcome";
}




  //if(isset($_POST['LoutBtn'])){
//{
// session_destroy();
// header ('Location: index.php');

//if   ($_SESSION['LogedIn'] == true)
   //{

// print('<h1>Welcome admin</h1>');

 // }

//else
//{
// session_destroy();
// header ('Location: index.php');
//}




?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>



<form  action="content.php" method="post">
<table>


<tr><td>Blog entry posted by (Your name): </td><td><input type="text" name="who" size="20" maxlength="20" value=""></td></tr>

<tr><td>Title of this blog entry: </td><td><input type="text" name="title" size="40" maxlength="80" value=""></td></tr>


<tr><td>Content: </td><td><textarea name="content" rows="5" cols="40"></textarea></td></tr>


<tr><td clospan="2"><input type="submit" value="Submit"></td></tr>

<tr><td clospan="2"><input type="submit" name="showstat" value="visitorlog" /></td></tr>

<tr><td clospan="2"><input type="submit" value="Back" name="back" /></td></tr>

</table>







</form>


</body>
</html>

Perhaps a simple task...  I did ASP coding before, now I'm into PHP. So I'm a newbie in PHP.

2 arrays : $array1 = array("1","2","3","4");  and    $array2 = array("1","2");

In array2 you'll find the numbers that need to be excluded from array1.   So I should have als result  3 and 4.

I tried since 2 days now and can only check and exclude  1 number from array2  butnot dynamical !

Code: [Select]
$ii = 1;
foreach( $arrayLordervalue as $value )
{
  if( $value  == 1 )continue;
 

//komma's tussen de cijfers plaatsen
if($ii == 1){ $values[$ii] = $value;}
else { $values[$ii] = ",". $value;  }
$value2= $value2.$values[$ii];
$ii++;   
}

echo  $value2;     

Gives me 2,3,4. 

I'm completely stuck !

I tried foreach, for ($n...),while... bah what's left ? 

I have found a point in my site where the user may wish to go back a page. Using the back button in the browser works perfectly fine. However, for aesthetical reasons and for "obvious function" reasons i need to create a button on the page which goes back a step in the browsers history.

I know I can do this with Javascript, but I would rather get it done with php first.

Therefore is it possible to create a back button in PHP. The back button in question will go back one step in the browsers history to the same .php it is currently on but in a previous state.

I found this from google, http://www.webmasterworld.com/forum88/870.htm, but then found there was some js in the answers.
I cannot find any other posts similar to this in php freaks

Hi guys,

     I am starting out on mvc, I been reading up on it for a bit now.. and I was just wondering if anyone can take a quick look at it and
give me some insight on it? maybe some suggestions etc.. I will be using this for a some what medium site when I know that it is good enough to be published. Note that its not done.. in reality I just need to make sure I am heading in the right direction.