PHP - How To Make: Go To Page 1,2,3....8,9,10

Apologies for this because it's probably very simple, but I've never worked with JavaScript or PHP or anything before.   So the website I am producing is to sell tickets for something. To purchase these tickets the user is required to click on the seats they want and it will pop up in a box on the left hand side confirming their seat selection and how much the ticket is.   The website has to feature a "Reset Database" button which totally resets everything. No tickets are selected anymore, the user is logged out etc. I have this working fine.   It also has to feature a "Cancel" button, which simply removes the seats the user has selected, but still keeps them logged in. How do I code this?   This is what the "Cancel" button looks like on the Index page:     <div id="theButtons">
     <input type="button" value="Cancel Choices" title="Cancel Choices" onclick="cancel()" />
  </div>   And this is my code on the JavaScript page:    function cancel(){
var s = document.getElementsByTagName('space');
   window.location="index.php";
  }   How do I get this working?
Edited by DavidD95, 08 November 2014 - 10:36 AM.

Hi,

Sorry if this is in the wrong place. I really just need a search term to use for what i'm trying to do.

I would like my buttons to appear pressed on each page. For example if you are on the home page the home button will appear pressed. If you are on the screenshots page the screenshots button will appear pressed. Pretty much i want my nav bar to display what page is being viewed.

I'm using SMF forums and i've created an extension of my forum that i'm using on the root of my site. As far as i can tell i have the correct code added to the forum that should highlight the home button while on the home page. The part i'm missing is the code to add onto the home page.

This is the code I have on the button.

$buttons = array(
         'overview' => array(
            'title' => $txt['overview'],
'href' => 'http://www.wararmada.com',
            'show' => true,
            'sub_buttons' => array(
               'alliance' => array(
                  'title' => $txt['alliance'],
                  'href' => $scripturl . '?action=overview;area=alliance',
                  'show' => true,
               ),



This is the code i have in the language file.

$txt['overview'] = 'overview';


I'm not sure what this is called. I don't know anything about php but so far i've been able to get by just using google but I don't really know how to search for this.

Thanks for all the help!

Hi, I have a blog page I am working on and I am trying to make some enhancements that I need some help with. In MySQL I have a table with id, title and post. In my page display I want to enable the user to click on the title and display a post on it's own so the URL would look like www.mysite.com/blog/?id=1 or something like that. Here is the PHP function to display the post from MySQL. all on one page.


function GetBlogPosts($inId=null, $inTagId =null)
{
if (!empty($inId))
{
$query = mysql_query("SELECT * FROM blog_posts WHERE id = " . $inId . " ORDER BY id DESC LIMIT 2"); 
}
else if (!empty($inTagId))
{
$query = mysql_query("SELECT blog_posts.* FROM blog_post_tags LEFT JOIN (blog_posts) ON (blog_post_tags.postID = blog_posts.id) WHERE blog_post_tags.tagID =" . $tagID . " ORDER BY blog_posts.id DESC");
}
else
{
$query = mysql_query("SELECT * FROM blog_posts ORDER BY id DESC");
}

$postArray = array();
while ($row = mysql_fetch_assoc($query))
{
$myPost = new BlogPost($row["id"], $row['title'], $row['post'], $row['postfull'], $row["author_id"], $row['date_posted']);
array_push($postArray, $myPost);
}
return $postArray;
}

Hello folks, well what I mean by temporary variables are variables like error messages or success messages that appear after a form has been submitted.  I want to be able to kill these variables when the page is refreshed and return the page to its defualt state.  For example, I'm making this simple page which is basically a form that ask users for some information, then upon submit, stores the  in a database and prints a success message.  If the form is filled out incorrectly or some form fields are left blank, then error messages are printed. What I really want is for these messages to disappear when the page is refreshed.  My current model uses a second page to handle the form, and then upon succes or upon encountering an error, redirects to the form page, passing the error or success variables via the url to the form page where they are printed out.  What can I do differently to achieve what I want (ie kill variables upon page refresh)? Below are the form page, and the page that handles the form respectively.

Code: [Select]

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


<div id="contact_form">


<div align="left" class="green18">Contact Us</div> <br/> <br/>


<label>Your Name:</label> <input class="texta" name ="name" size="20"      maxlength="49"/> <br/> <br/>

<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[0];?>

</div>

<label>Your Company Name:</label> <input class="texta" name ="company" size="30" maxlength="66"/> <br/> <br/>


<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[1];?>

</div>

<label>Subject(Optional):</label> <input class="texta" name ="subject" size="20" maxlength="49"/>  <br/> <br/>


<label>Email:</label> <input class="texta" name ="email" size="20" maxlength="49"/>  <br/> <br/>


<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[2];?>

</div>


<label>Message:</label> <textarea style="float:left" class="" name ="message" cols="40" rows="3"> </textarea> <br/> <br/>

<div class ="error" style="position:relative;bottom:-19px;left:-260px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[3];?>

</div>


<button class="button" type ="submit" name ="submit">Submit</button> <br/>

<div id ="sent" >

<?php //Retrieve the user id from send_email.php page

$sent=$_GET['sent'];

$send_msg = urldecode($sent);  echo $send_msg;  ?>

</div> <!--closes sent-->


</div>


</form>
 




Code: [Select]


<?php


//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);




if (isset($_POST['submit'])) {
 
    $errors = array();


// Connect to the database.

        require('config/config.php');


//Check for errors.


//Check to make sure they entered their name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['name'])) {

        $a = TRUE;

    } else {

        $a = FALSE;

        $errors[0] = '*Please enter a valid name.';


   }



//Check to make sure they entered their company name.

if (!empty ( $_POST['company'])) {

        $b = TRUE;

    } else {

        $b = FALSE;

        $errors[1] = '*Please enter company name.';


   }



//Check to make sure email is valid.

if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $_POST['email'])) { 
 

         $c = TRUE; 


}else { 

         $c = FALSE;

      $errors[2] = '*Please enter a valid email address.'; 

      } 




//Check to make sure they entered their message.

if (!empty ( $_POST['message'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

        $errors[3] = '*Please enter your message.';


   }




 

//If no errors

if (empty($errors)) {

//Create variables for all the post values.

 $name = $_POST['name'];

 $company = $_POST['company'];

 $email = $_POST['email'];

 $message = $_POST['message'];

 $ip = $_SERVER[REMOTE_ADDR];

 $date = (date("Y/m/d:G:i:s"));

 $timestamp = ( mktime(date(H), date(i), date(s), date(m) , date(d) , date(Y)));


//Formulate the insert query.

        $query = "INSERT INTO emails ( email_id, name, company, email, message, ip, date,timestamp) VALUES ( 0, '$name','$company','email', '$message', '$ip' , '$date', '$timestamp' )";
       
        $result = mysql_query($query) or die("Data could not be inserted into table because: " .mysql_error());



if (mysql_affected_rows() == 1) {

    
         // Display success message


          $sent_msg =     "Your email has been sent.  We will get back to you shortly.";

$sent = urlencode($sent_msg);  


         // Display contact page

header("Location: contact_page.php?sent=$sent");  exit();

}else{die("There was a problem: " . mysql_error());}
            


//Display error messages.


} else {// if errors array is not empty

//Confer the errors array into a string

$errors_string = implode(",", $errors);

//Encode the imploded string.

$error_message = urlencode($errors_string);


         // Display page

header("Location: contact_page.php?errors_string=$errors_string");  exit();


        
    }//End of if there are errors.


}//End of if submit.




?>



Also, another problem I just noticed is that, the errors[3] variable isn't getting passed back to the form page.  I don't know if it's because the url can only pass so much info to a second page. The page in question can be located he

http://creativewizz.com/contact_page.php

This topic has been moved to Third Party PHP Scripts.

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

This is the code I have now however when you click next to view more results it says please enter a search..., (there is more code above this however I thought that the problem would be within the code provided.)

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
 
?>

This topic has been moved to JavaScript Help.

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

This topic has been moved to JavaScript Help.

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

Hello everybody,   I am honestly quite a newb when it comes to mod_rewrite.   We run a small social media page with different areas and I would like to change the URLs to something more clean and professional.   User profiles look like this:

http://www.sky-mp3.com/index.php?action=cm&siteid=59&wahl=artists&tat=details&keyid=477

siteid 59 is the artists list and the keyid at the end is the ID of the artist but should be like:

http://www.sky-mp3.com/mischura 

or in worse case like:

http://www.sky-mp3.com/user/mischura 

CMS pages look like this:

http://www.sky-mp3.com/index.php?siteid=106

but should be like:

http://www.sky-mp3.com/charts

(page name instead of siteid)   What I know so far: - I have to add something to the .htaccess file - I need to change something in the code (but I don`t know where)   Im good he?   What would be the first step on the path to clean URLs for me? I found alot of infos here and there but found nothing yet for this specific case.   Kind regards from and thx in advance from Cologne            

Okay so my news script is set to view only 10 pieces of news. But I want it so that it starts a new page once I have more than 10 pieces of news.

Code: [Select]
<?php
require("functions.php");
include("dbconnect.php");

session_start();

head1();
body1();
new_temp();
sotw();
navbar();
     
$start = 0;
$display = 10;
$query = "SELECT * FROM news ORDER BY id DESC LIMIT $start, $display";
$result = mysql_query( $query );

if ($result) {
    while( $row = @mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
        news_box( $row['news'], $row['title'], $row['user'], $row['date'], $row['id'] );
    }
    mysql_free_result($result);
} else {
    news_box( 'Could not retrieve news entries!', 'Error', 'Error', 'Error');
}
                   
footer();

mysql_close($link);
?>
I tried a few things but they failed....miserably.

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

$looponce = 1;
foreach ($this->info as $k => $v) {
if ( (($k == 'subject') && ($v['required'])) && (!$this->settings['customSubject'])) {
for ($i = 0; $i <= 0; $i++) {
$output[] = $this->display_errors('error_system_subject');
}
}
if ( (($k == 'name') && (!$v['required'])) || ((!array_key_exists("name", $this->info)) && ($looponce == 1)) ) {
$output[] = $this->display_errors('error_system_name');
$looponce++;
}
}

That is my loop that i check things in. What i'm more interested in is the name if statement.

If currently checks for a name key in an array(below) and makes sure that it is set to required. If it's not set to required, print out a system error and die()'s.

I'm looking for ways to remove the need for program errors and just change them to what is needed to run.

What i know how to do is, get into the inner array, what i don't know is how to edit the data and put it back exactly as it was given to me. The inner array data can be put back in any order, but the outer array must be in exact order as it was given.


above code $this->info = $formdata;

$formdata = array(
'name' => array('name'=>"Full Name", 'required'=>false, 'type'=>'text'), # This needs to be required=>true, but i can't trust the user, which is why i have the error.
'telephone' => array('name'=>"Telephone", 'required'=>false, 'type'=>'phone'),
);


Any help is greatly appreciated, also am i doing the foreach loop in the code above in an efficient manner or is there another way?

Hi there, As the question says i tried several things but i can't work it out and my knowledge about php isn't that well.

Some code from my pages ,   Page1 ( Redirecting page )

<html>
<title>login_redirect.</title>
body>

<form name="redirect" action="http://mysite/page2.php" method="post">
<input type="hidden" name="mac" value="$(mac)">
</form>

<script language="JavaScript">
<!--
document.redirect.submit();
//-->
</script>
</body>
</html>

Page 2 ( select product )

<?php


session_start();

ini_set('display_errors',1);
error_reporting(E_ALL); 

include '../lib/config.php';
include '../lib/opendb.php';

// get user mac adres from redirect post page1
$_SESSION['macid'] = $_POST['mac'];
// set $macid for other use ( maybe not needed, am learning )
$macid = $_SESSION['macid'];

// echo $macid does show mac adress, so variable is not empty here


if (!empty($_POST["submit"]))

{
$product_choice = $_POST['accounttype'];
$query= "SELECT AccountIndex, AccountCost, AccountName FROM AccountTypes WHERE AccountIndex='$product_choice'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error()); 
while($row = mysql_fetch_array($result))
{
$_SESSION['AccountIndex'] = $row['AccountIndex'];
$_SESSION['AccountCost'] = $row['AccountCost'];
$_SESSION['AccountName'] = $row['AccountName'];
}


header('Location: page3.php');

}

// did leave out the other/html/form stuff here

Page 3 ( show Session variables )

<?php


ini_set('display_errors',1);
error_reporting(E_ALL); 

session_start();

print_r($_SESSION);

?>

Now, on page 3 i do see the right session varables, only the "macid" is empty.   why ?    

This topic has been moved to HTML Help.

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