PHP - Post Var Across Multiple Pages?

Hi guys,
 I have a php file that will go to a site and scrape the data I need. However this site is setup to use pagination so when I try to scrape all the players names I have to do separate queries to search each page. Is there a way to find out by using code how many pages there are and query all the pages at same time?

I use  this code
Code: [Select]
<?php //first page

//turn error reporting on
libxml_use_internal_errors(true);

//get data from this page
$dom = new DOMDocument;
$dom->loadHTMLFile('http://www.gametracker.com/server_info/76.73.3.42:1716/top_players/?searchipp=50#search');
$xpath = new DOMXPath($dom);

// Get the total player count
$rows2 = $xpath->query('//div[@class="block774"]/div');

// Get the rows from the search list
$rows = $xpath->query('//table[@class="table_lst table_lst_spn"]/tr');


for ($i=1; $i<$rows->length-1; $i++) {
    $row = $rows->item($i);

    // Get the columns for a row
    $cols = $row->getElementsByTagName('td');

// Get the player rank (1st column)
    echo 'Rank:'.trim($cols->item(0)->textContent).PHP_EOL;

    // Get the player name (2nd column)
    echo 'Name:'.trim($cols->item(1)->textContent).PHP_EOL;

// Get the player score (3rd column, actually 4th but number 3 is hidden)
    echo 'Sco '.trim($cols->item(3)->textContent).PHP_EOL;

echo "<br />";
}
?>





<?php //secondpage

//turn error reporting on
libxml_use_internal_errors(true);

//get data from this page
$dom = new DOMDocument;
$dom->loadHTMLFile('http://www.gametracker.com/server_info/76.73.3.42:1716/top_players/?searchipp=50&searchpge=2#search');
$xpath = new DOMXPath($dom);

// Get the rows from the search list
$rows = $xpath->query('//table[@class="table_lst table_lst_spn"]/tr');


for ($i=1; $i<$rows->length-1; $i++) {
    $row = $rows->item($i);

    // Get the columns for a row
    $cols = $row->getElementsByTagName('td');

// Get the player rank (1st column)
    echo 'Rank:'.trim($cols->item(0)->textContent).PHP_EOL;

    // Get the player name (2nd column)
    echo 'Name:'.trim($cols->item(1)->textContent).PHP_EOL;

// Get the player score (3rd column)
    echo 'Sco '.trim($cols->item(3)->textContent).PHP_EOL;
echo "<br />";
}

?>
I also have to go to that website first to see how many pages there are so I can have enough queries.

I am creating a webpage for my golf league and some of the information(variables) such as Name, Address and email, must be reused across multiple pages for different outputs.  May question is "Can I, or is there a way to reUse variables across multiple pages.   "Do I need to create a session and make everything session variables"?  "Should I link to a database and call the information when needed"? 

Any explanation would be greatly appreciated. 

Hello Everyone was wondering if I could get some help with the following code? I am querying a database for results of listings that are in a database these listings are displayed on the page in a form. I am wanting each listing to be on a different page. Below is my code.
Code: [Select]


$lim=1;
if (!isset($s) || $s < 1 || !is_numeric($s)) {
            $s = 1;
        }


    $start = ($s - 1) * $lim;
     $sql = "select id,bussimg,imagewidth,imageheight,email,usridm,company,businesscategory,address1,address2,state,city,zip,website,email,repname,description,phonenumber,country,status from $approvecheckbusinesses where usridm='$user_id'";
    $result=db_query($sql);
     



        $countpages = $sql;
        $sql = $sql . " order by id asc limit $start, $lim";
       $result=db_query($sql);
        $pages = ceil(mysql_num_rows(mysql_query($countpages)) / $lim);
     
   


$result=db_query($sql);
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$Listid= mysql_result($result, $i, "id");

$usridm= mysql_result($result, $i, "usridm");
$CompanyName= mysql_result($result, $i, "company");
$realname= mysql_result($result, $i, "repname");
$email= mysql_result($result, $i, "email");
$BusinessCategory= mysql_result($result, $i, "businesscategory");
$status= mysql_result($result, $i, "status");
   



echo ("FORM IS TO BE DISPLAYED HERE");

}

if ($pages > 1) {
            echo("<p align=left style='font-size: 85% color=white'>");
            for ($i = 1; $i <= $pages; $i++) {
                echo("[");
                if ($i == $s) {echo("<b>");}
                else {echo("<a id=home_offerLink href='index.html?EditMemberListing&user_id=$user_id&s=$i'>");}
                echo("Page $i");
                if ($i == $s) {echo("</b>");}
                else {echo("</a>");}
                echo("]  ");
            }
            echo("</p>")


Page Numbers here using the above code.. The problem I seem to be running into is that it only displats the first record. The page numbers show up page 1 page 3
page 2 and three are blank there is no mysql error or anything for some reason I only get that first result out of three

I have an ordering process that consists of 3 pages:

1) Page1: Enter name/address
2) Page2: Based on address, determine availability of products, and let user choose which products, how many, etc.
3) Page3: Enter credit card info to send to the processor

What is the best way to store information fro page 1 to page 2, then from page 2 to page 3? I thought about just using hidden fields. Is this OK? Is there another preferred way?

Thanks!

Hey Im always trying to remove code and cut corners to reduce work in the long run, soIim wondering how I could link my menu bar from say a template to ALL my php pages for my site so I don't have to write/change links on every page when I need to.

Thanks

I'm am somewhat new to PHP and am trying to set up a website for my cousin's wedding. Her idea is to have the guests sign in with a user/pass that she provides, and once they sign in, they will be taken to a page that has their name on it (i.e. "Mr. and Mrs. So and So, you are invited...). I have come to the conclusion that I will need to make an image for each guest's name (she wants to use a font for their names that nobody will have on their computer) so what I need to know is:

How do I link each user name to their own personalized webpage, where the image of their name on the next page will change based on what username is entered? I have been told to use Sessions (which I don't yet have in this code), but I'm clueless as to how to make that work for multiple users. Where do I put the coding, what does the coding look like, etc.

Thanks in advance for any help!

The php code I have right now is this (i'm sorry it's so long, I just don't want to leave anything out that might be important):

Code: [Select]
$LOGIN_INFORMATION = array(
  'steve' => 'password',
  'rick' => 'password',
  'tom'=> 'password'
);

// request login? true - show login and password boxes, false - password box only
define('USE_USERNAME', true);

// User will be redirected to this page after logout
define('LOGOUT_URL', 'http://www.example.com/');

// time out after NN minutes of inactivity. Set to 0 to not timeout
define('TIMEOUT_MINUTES', 0);

// This parameter is only useful when TIMEOUT_MINUTES is not zero
// true - timeout time from last activity, false - timeout time from login
define('TIMEOUT_CHECK_ACTIVITY', true);

##################################################################
#  SETTINGS END
##################################################################


///////////////////////////////////////////////////////
// do not change code below
///////////////////////////////////////////////////////

// show usage example
if(isset($_GET['help'])) {
  die('Include following code into every page you would like to protect, at the very beginning (first line):<br>&lt;?php include("' . str_replace('\\','\\\\',__FILE__) . '"); ?&gt;');
}

// timeout in seconds
$timeout = (TIMEOUT_MINUTES == 0 ? 0 : time() + TIMEOUT_MINUTES * 60);

// logout?
if(isset($_GET['logout'])) {
  setcookie("verify", '', $timeout, '/'); // clear password;
  header('Location: ' . LOGOUT_URL);
  exit();
}

if(!function_exists('showLoginPasswordProtect')) {

// show login form
function showLoginPasswordProtect($error_msg) {
?>
<html>
<head>
  <title>Please enter password to access this page</title>
  <META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">
  <META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
body,td,th {
font-family: Verdana, Geneva, sans-serif;
font-size: 10px;
color: #666;
}
body {
background-color: #FFFFFB;
}
</style>
</head>
<body>
<div align="center">
  <style>
    input { border: 1px solid black; }
  </style>
  <div style="width:600px; margin-left:auto; margin-right:auto; text-align:center">
  <form method="post">
    <h4>Please sign in using the information provided on the invitation</h4>
    <font color="red"><?php echo $error_msg; ?></font><br />
<?php if (USE_USERNAME) echo 'Login:<br /><input type="input" name="access_login" /><br />Password:<br />'; ?>
    <input type="password" name="access_password" /><p></p><input type="submit" name="Submit" value="Submit" />
  </form>
  <br />
  <a style="font-size:9px; color: #B0B0B0; font-family: Verdana, Arial;" href="http://www.zubrag.com/scripts/password-protect.php" title="Download Password Protector">Powered by Password Protect</a>
  </div>
</body>
</html>

<?php
  // stop at this point
  die();
}
}

// user provided password
if (isset($_POST['access_password'])) {

  $login = isset($_POST['access_login']) ? $_POST['access_login'] : '';
  $pass = $_POST['access_password'];
  if (!USE_USERNAME && !in_array($pass, $LOGIN_INFORMATION)
  || (USE_USERNAME && ( !array_key_exists($login, $LOGIN_INFORMATION) || $LOGIN_INFORMATION[$login] != $pass ) ) 
  ) {
    showLoginPasswordProtect("Incorrect password.");
  }
  else {
    // set cookie if password was validated
    setcookie("verify", md5($login.'%'.$pass), $timeout, '/');
    
    // Some programs (like Form1 Bilder) check $_POST array to see if parameters passed
    // So need to clear password protector variables
    unset($_POST['access_login']);
    unset($_POST['access_password']);
    unset($_POST['Submit']);
  }

}

else {

  // check if password cookie is set
  if (!isset($_COOKIE['verify'])) {
    showLoginPasswordProtect("");
  }

  // check if cookie is good
  $found = false;
  foreach($LOGIN_INFORMATION as $key=>$val) {
    $lp = (USE_USERNAME ? $key : '') .'%'.$val;
    if ($_COOKIE['verify'] == md5($lp)) {
      $found = true;
      // prolong timeout
      if (TIMEOUT_CHECK_ACTIVITY) {
        setcookie("verify", md5($lp), $timeout, '/');
      }
      break;
    }
  }
  if (!$found) {
    showLoginPasswordProtect("");
  }

}

?>

Hello everyone,

Very new to coding - enjoying it but struggling! I think I'm trying to do something pretty common but I seem to have come up against a complete wall now and after hours/days searching the internet and reading books I'm completely stuck! I'm  trying to write some code to search a MySQL database of products, then display the results. For some search results there will be lots of products so I want to display 10 products on the first page then allow visitors to go to the next page to see another 10, and so on - a type of pagination, as they should then be able to click back to see the last page etc.
I've got to the point of being able to display the first 10 search results, but I can't figure out at all how to create some kind of page scrolling/pagination system.
Please, does anybody have any ideas??
I've attached my code, I hope this is the correct way of doing things here.
Many thanks for your time!

The PHP search code...
Code: [Select]

<?php
//opens connection to mysql server
$dbc = mysql_connect('localhost');
if (!$dbc) {
die('Not connected :' . mysql_error());
}
echo "Connected to mysql database<br />";
//select database
$db_selected = mysql_select_db("NAME_OF_DATABASE", $dbc);
if (!$db_selected)
{
die ("Cannot connect :" . mysql_error());
}
echo "Connected to database<br /><hr />";
echo "Here are your results";

$term = $_POST['term'];
$category = $_POST['category'];
$brand = $_POST['brand_name'];
 
  
$sql = mysql_query("SELECT * FROM products where product_name like '%$term%' AND category_name like '%$category%' AND brand_name like '%$brand%' LIMIT 0, 10");
 
{ 
while ($row = mysql_fetch_array($sql)){
echo "<table border='1' width='100%'> ";
echo "<tr>"; 
echo "<td style='vertical-align:top' width='25%'>" . '<img src="', $row['image_url'], '" alt="', $row['product_name'], '"  width="100" height="100" />' . "</td>";
echo "<td style='vertical-align:top' width='50%'>" . $row['product_name'];
echo "<br />";
echo  "<span style='font-size: 10px'>" . $row['description'] . "</span>" . "</td>"; 
echo "<td style='vertical-align:top' width='25%'>" . $row['price'];
echo "<br />";
echo "<br />";
echo "<hr />";
echo "$row['merchant_name'] </td>";
echo "</tr>";
    }
echo "</table>"; 
}
?>

Hi,

I have some code which scrapes data from a page. However there are around 1200 product pages on the site I need to scrape, when I attempt to loop through all the pages I get a server timeout. I can only get to around 40 without timeout. Has anyone else had this problem?

Hi all,

I've done a LOT of googling on this and found things that match what I need but nothing actual achieves what I need.

I've used one php file before for doing multiple jobs (ie registration?step=2 / 3 etc), but I've boo-booed somewhere and it only works up until step 2, step 3 doesn't work.  Here's what I have currently, it also leads me on to the next question.

Code: [Select]
<?php if(isset($_GET['step']) == 2) { ?>
   Please select the problem you are encountering.
   <a href="registration.php?step=3&console=<?php $_GET['console'] ?>&issue=1rrod"><img src="store/image/data/1rrod.gif" width="92" height="92" /></a>
   <?php } if (isset($_GET['step']) == 3) { ?>
   END
   <?php } else {?>
   Please select which type of Xbox 360 you have<br />
    <a href="registration.php?step=2&console=xbox"><img src="images/xbox360.gif"></a>
    <a href="registration.php?step=2&console=xboxslim"><img src="images/xbox360e.gif"></a>   
    <?php } ?>
So, first step (which is bottom), lets you select which type of console it is - only two possible choices.  That then passes that data to step 2, which is what issue the console is having. 

Now I've tried this with $_POST, as I would prefer to work that way.  I've experimented with $_SESSION to try and pass everything I need, using code found elsewhere.  But I just can't get it to pass from page to page and finally be able to use it to email in the final step.

Final issue - I want to use images instead of buttons to be able to pass the variables.  I've found that using hidden type input does work but I think this issue is related to the above one.

Thanks!

Jason

I'm sorting out a simple PHP email form, and I would like, when the email arrives in my inbox, for it to display both the email of the sender AND their name as specified in the form on my website.

So far I have
$from    = $_POST['from'];
with the 'from' being the client's email address. I would also like their name ('name') to show up next to their email in the header.

I have tried such things like

$from    = $_POST['from' . 'name'];
//or
$from    = $_POST['from']; $_POST['name'];

and a few more, but I'm terrible at PHP coding in general. I have searched, but I really am at a loss as to what to search for.

Can someone please give me an idea as to what I should do? 

Thanks,
Sacha.

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

Hi guys, I am trying to create a script that gets a multiple select form selections and assign them to variables with php via the POST method.

This is my code:

Code: [Select]
<select name="search_commodity[]" multiple="multiple" size="3" style="position:absolute; top:80px; left:414px; " >
<option value="all">All</option>
<option value="none">None</option>
<option value="some">Some</option>
</select>


Then after the form gets submited then it should go to this php page and the first value of the chosen options has to be assigned to the variable called commo. The problem is that is is not assigning anything.
Code: [Select]

<?php $commo = $_POST['search_commodity[0]']; ?>


Can someone help please? I can't figure it out.

hi i was working on a code where i need to use multiple categories for a post, i get help before to add post in multi categories, now i need help on what would be my query to do update for a multiple categories post,
 to insert a new post with multiple categories  i used this

$values = array();
foreach($_POST['categories'] as $catID)
{
    $values[] = "($postID, $catID)";
}
$sql = "INSERT INTO `relation` (`postid`, `catid`)
              VALUES " . implode(', ', $values);
$query = $db->query($sql);

so if a post had 3 categories it will add in relation table, now i wants to update that post and modify the categories, all other part is done only problem is to update this relational category table which have two columns only associated with post.  i tried like this but did not work

$sql = "UPDATE relation SET  `catid`
             = " . implode(', ', $values) . " WHERE  postid ='$id' ";

please any help

Afternoon All,

I can't seem to work this problem out;

I have a form that is generated from a sql list and have two inputs as follows;
Code: [Select]
<input type="text" name="suppliernumber[]" id="suppliernumber[]" />
<input name="snomed[]" type="checkbox" id="snomed[]" value="<?php echo $row['VPPID']; ?>" />

Both are fed to my processing files as arrays, i then run the following foreach which uses the VPPID from the post to search in a database using a where clause.

The problem comes when i also need to obtain the data from the suppliernumber $_POST if any has been supplied.

My php code;

Code: [Select]
foreach ($_POST['snomed'] as $value) {

$getRecord_sql = "SELECT vmps.NM AS NM,  vmpps.QTYVAL AS QTYVAL,  bnf_lookup_subcatagory.BNF_SUBCAT AS BNF_SUBCAT,  bnf_lookup_catagory.BNF_CAT AS BNF_CAT FROM bnf_lookup_catagory INNER JOIN bnf_vmp ON  bnf_lookup_catagory.BNF_CAT =  bnf_vmp.BNF_CAT INNER JOIN bnf_lookup_subcatagory ON  bnf_vmp.BNF_SUBCAT =  bnf_lookup_subcatagory.BNF_SUBCAT RIGHT OUTER JOIN vmps INNER JOIN vmpps ON  vmps.VPID =  vmpps.VPID ON  bnf_vmp.VPID =  vmpps.VPID WHERE VMPPS.VPPID = '$value'";
$getRecord = mssql_query($getRecord_sql);
$row = mssql_fetch_array($getRecord);

$nm = $row['NM'];
$qtyval = $row['QTYVAL'];
$BNF_SUBCAT = $row['BNF_SUBCAT'];
$BNF_CAT = $row['BNF_CAT'];
$SUPPLIER = $_POST['suppliernumber'];

array_push($data_array, array($value, $nm, $BNF_CAT, $BNF_SUBCAT, '', $SUPPLIER, '', '1', '', '', '', '', '', '', '', '1', '', '', $qtyval));

}

I can't work out how to add the suppliernumber, i know i need another foreach but can't work out how to do it.

Hope someone can help.

Sam