PHP - Creating Brand Web Pages Using Querys

I am trying to display records from a database using pagination.  Currently the first page is showing and data is being displayed correctly.  The links are also available below to move from page to page, however when I click on the next page, nothing happens.  I know I need to add parameters to my query string, but I'm unsure as to what I need to add.  Can someone help?

Here is where I am calling the page:

Code: [Select]
<a href="index.php?menukey=7" accesskey="7" title="">Project 3</a>
Here is my pagination:

Code: [Select]
function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5) {
        $this->conn = $connection;
        $this->sql = $sql;
        $this->rows_per_page = $rows_per_page;
        $this->links_per_page = $links_per_page;
        $this->php_self = htmlspecialchars($_SERVER['PHP_SELF']);
        if(isset($_GET['page'])) {
            $this->page = intval($_GET['page']);
        }
    }
   
    /**
     * Executes the SQL query and initializes internal variables
     *
     * @access public
     * @return resource
     */
    function paginate() {
        if(!$this->conn) {
            if($this->debug) echo "MySQL connection missing<br />";
            return false;
        }
       
        $all_rs = @mysql_query($this->sql);
        if(!$all_rs) {
            if($this->debug) echo "SQL query failed. Check your query.<br />";
            return false;
        }
        $this->total_rows = mysql_num_rows($all_rs);
        @mysql_close($all_rs);
       
        $this->max_pages = ceil($this->total_rows/$this->rows_per_page);
        //Check the page value just in case someone is trying to input an aribitrary value
        if($this->page > $this->max_pages || $this->page <= 0) {
            $this->page = 1;
        }
       
        //Calculate Offset
        $this->offset = $this->rows_per_page * ($this->page-1);
       
        //Fetch the required result set
        $rs = @mysql_query($this->sql." LIMIT {$this->offset}, {$this->rows_per_page}");
        if(!$rs) {
            if($this->debug) echo "Pagination query failed. Check your query.<br />";
            return false;
        }
        return $rs;
    }
   
    /**
     * Display the link to the first page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'First'
     * @return string
     */
    function renderFirst($tag='First') {
        if($this->page == 1) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page=1">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the link to the last page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'Last'
     * @return string
     */
    function renderLast($tag='Last') {
        if($this->page == $this->max_pages) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page='.$this->max_pages.'">'.$tag.'</a>';
        }
    }
   
    /**
     * Display the next link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '>>'
     * @return string
     */
    function renderNext($tag=' &gt;&gt;') {
        if($this->page < $this->max_pages) {
            return '<a href="'.$this->php_self.'?page='.($this->page+1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the previous link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '<<'
     * @return string
     */
    function renderPrev($tag='&lt;&lt;') {
        if($this->page > 1) {
            return '<a href="'.$this->php_self.'?page='.($this->page-1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
   
    /**
     * Display the page links
     *
     * @access public
     * @return string
     */
    function renderNav() {
        for($i=1;$i<=$this->max_pages;$i+=$this->links_per_page) {
            if($this->page >= $i) {
                $start = $i;
            }
        }
       
        if($this->max_pages > $this->links_per_page) {
            $end = $start+$this->links_per_page;
            if($end > $this->max_pages) $end = $this->max_pages+1;
        }
        else {
            $end = $this->max_pages;
        }
           
        $links = '';
       
        for( $i=$start ; $i<$end ; $i++) {
            if($i == $this->page) {
                $links .= " $i ";
            }
            else {
                $links .= ' <a href="'.$this->php_self.'?page='.$i.'">'.$i.'</a> ';
            }
        }
       
        return $links;
    }
   
    /**
     * Display full pagination navigation
     *
     * @access public
     * @return string
     */
    function renderFullNav() {
        return $this->renderFirst().'&nbsp;'.$this->renderPrev().'&nbsp;'.$this->renderNav().'&nbsp;'.$this->renderNext().'&nbsp;'.$this->renderLast();   
    }
   
    /**
     * Set debug mode
     *
     * @access public
     * @param bool $debug Set to TRUE to enable debug messages
     * @return void
     */
    function setDebug($debug) {
        $this->debug = $debug;

can you run a query says every 60 seconds with out refreshing the entire page? at the moment im using <meta http-equiv="refresh" content="60;url=login_success.php">

I have a while loop that is making a table 5 times for me. The issue that i am having is i need to run 5 different mysql query's for the 5 different tables that the loop is making for me. How would i go about doing this?

Here is my code

<?

$i=1;

 while ( $i <= 5 ) {

?>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="414" height="35" colspan="5"><strong>Level <?=$i?></strong></td>
  </tr>
  <tr>
    <td height="25"><div align="center">Join Date</div></td>
    <td><div align="center">Member Name</div></td>
    <td><div align="center">Username</div></td>
    <td><div align="center">Free/Pro</div></td>
    <td><div align="center"></div></td>
  </tr>
  
  <? 
   
  $level_one = mysql_query("select * from users where ref_by = '$username'");
  while ($level_one_do = mysql_fetch_array($level_one)) {
  
  $status = $level_one_do['status'];
  
  if($status == 1) {
  $status_type = "Free";
  } else {
  $status_type = "Pro";
  }
  ?>
  
  <tr>
    <td height="35"><div align="center"></div></td>
    <td height="35"><div align="center"></div></td>
    <td height="35"><div align="center">
      <?=$level_one_do['Username']?>
    </div></td>
    <td height="35"><div align="center"></div></td>
    <td height="35"><div align="center"><img src="images/email_forward-32.png" width="25" height="25"></div></td>
  </tr> <? } ?>
</table>
<? $i++;  } ?>

Hi there im not quite sure where im going wrong here.

I have 2 queries; the first selects all records in a table == Session username. The second selects all records in a table <> Session username

Both work independently but when i try to compare a field in each table (The: PlanetName) it doesnt work. Im trying to make it so that if the same PlanetName is in  the first query and the second in any of the records it will output an ID.

Code: [Select]
<?php $colname_Fleet = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Fleet = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Fleet = sprintf("SELECT FleetName, PlanetName FROM fleet WHERE PlayerName = %s", GetSQLValueString($colname_Fleet, "text"));
$Fleet = mysql_query($query_Fleet, $swb) or die(mysql_error());
$totalRows_Fleet = mysql_num_rows($Fleet);

$colname_FleetE = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_FleetE = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_FleetE = sprintf("SELECT FleetName, PlanetName FROM fleet WHERE PlayerName <> %s", GetSQLValueString($colname_FleetE, "text"));
$FleetE = mysql_query($query_FleetE, $swb) or die(mysql_error());
$totalRows_FleetE = mysql_num_rows($FleetE);



while ($row_FleetE = mysql_fetch_assoc($FleetE) && $row_Fleet = mysql_fetch_assoc($Fleet)){

if($row_Fleet['PlanetName'] == $row_FleetE['PlanetName']){
echo $row_Fleet['FleetName'];
echo' ';
}}
?>
Any help would be appreciated.

Thanks

Hi,

My site http://bittleships.com is a simple online battleships game. Theres a 1088 cell grid where each cell is a mysql database entry containing details wether its been clicked, if theres a boat in the location etc.

the site usually loads all the querys in 0.3 seconds, but when 5 or more people are playing this easily hits 1+ seconds.

The code that displays the grid is this:

Code: [Select]
  echo("<center><span style='background-color:white;color:red;font-size:12'>$griderrormsg</span></center>");
   }
   echo("<table width='20' border='0' cellspacing='0' cellpadding='0'");
   for($i=1; $i<=32; $i=$i+1){
             echo("<tr>");

             for($j=1; $j<=34; $j=$j+1){
             $c++;
                       $cell = $c;
                       $sql="SELECT * FROM grid WHERE `ID` = $cell";
                       $result=mysql_query($sql);
                       $row = mysql_fetch_array( $result );
                       $clicked = $row['clicked'];

                       if ($clicked == "1"){

                          echo("<td title='$j, $i'><img src='b.gif");

                       }elseif ($clicked == "2"){   //if the ship was hit
                          $hitby = $row['user'];
                          echo("<td title='$j, $i - Hit by $hitby.'><img src='h.gif");
                       }elseif ($clicked == "3"){  //if is chest
                          $hitby = $row['user'];
                          echo("<td title='$j, $i - $prevamount btc won by $hitby.'><img src='chest.gif");
                       }else{

                          echo("<td><a href='index.php?c=$c'><img src='g.gif");

                       }
                       echo("' BORDER=0></td></a>");
             }

             echo("</tr>");
   }
   echo("</table>");
}
Is there a better way of running this for it to run quicker?

Hello coders,

I'm using this code to grab random results from a table and it works well but I need it to be a non-repeating event.

Code: [Select]
$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `jobs_board` ");
$offset_row = mysql_fetch_object( $offset_result );
$offset = $offset_row->offset;
I'm using this query followed by the html which is a set of divs with inline echo statements for the various variables I've localised from the table. Then I'm repeating that process a number of times to create a small list (I wanted to use a single while loop but cant figure it out at the moment).  Anways, how can I make it so each query is random but also not repeated? At the moment they are indeed random but sometimes one same entry will appear a number of times consecutively...

Nice one guys, L-plate

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

like if I'm displaying a hundred entries , my website will be super long in length so I wanna break those hundred entries into maybe like 12 per page .  Then click next page or the page number to view the next 12.

Hi, so....i have these 2 pages, but they don't show up in browser....can't find the error so will ask your help guys

index.php
<?php
session_start();
if(!isset($_SESSION["manager"])){
header("Location: admin_login.php");
exit();
}
//Be sure to check that manager SESSION value is in database
$managerID = preg_replace('#[^0-9]#i',",$_SESSION["id"]); // Filter everything but numbers and letters
$manager = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["manager"]); //Filter everything but numbers and letters
$password = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["password"]); //Filter everything but numbers and letters
//Run MySQL query to be sure that this person is an admin and that their password session var equals the database
//Connect to the MySQL Database
include("../storescripts/connect_to_mysql.php");
$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID AND username='$manager' AND password='$password' LIMIT 1"); //search user
$existsCount = mysql_num_rows($sql); //count the row numbers
if ($existsCount == 0){ //evaluate the count
header("Location: ../index.php");
exit();
}
?>
<!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>MyOnlineStore | Admin Area</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>

<body>
<div align="center" id="mainWrapper">
  <?php include_once("../template_header.php");?>
  <p><br  />
    <br />
  </p>
  <p>&nbsp;</p>
  <p><br />
  </p>
  <div id="pageContent">
    <div id="admin" align="left">
      <h3>Hello what you want to do?</h3>
      <p><a href="#">Manage Inventory</a><br />
      <a href="#">Manage afggagdfag</a></p>
</div>
</div>
<?php include_once("../template_footer.php");?>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>


admin_login.php
<?php
session_start();
if(!isset($_SESSION["manager"])){
header("Location: admin_login.php");
exit();
}
//Be sure to check that manager SESSION value is in database
$managerID = preg_replace('#[^0-9]#i',",$_SESSION["id"]); // Filter everything but numbers and letters
$manager = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["manager"]); //Filter everything but numbers and letters
$password = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["password"]); //Filter everything but numbers and letters
//Run MySQL query to be sure that this person is an admin and that their password session var equals the database
//Connect to the MySQL Database
include("../storescripts/connect_to_mysql.php");
$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID AND username='$manager' AND password='$password' LIMIT 1"); //search user
$existsCount = mysql_num_rows($sql); //count the row numbers
if ($existsCount == 0){ //evaluate the count
header("Location: ../index.php");
exit();
}
?>
<!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>MyOnlineStore | Admin Area</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>

<body>
<div align="center" id="mainWrapper">
  <?php include_once("../template_header.php");?>
  <p><br  />
    <br />
  </p>
  <p>&nbsp;</p>
  <p><br />
  </p>
  <div id="pageContent">
    <div id="admin" align="left">
      <h3>Hello what you want to do?</h3>
      <p><a href="#">Manage Inventory</a><br />
      <a href="#">Manage afggagdfag</a></p>
</div>
</div>
<?php include_once("../template_footer.php");?>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

Hello,

I was wondering if someone could help me to "get" the webaddress of a current webpage and then pull off pieces of the page.  All of my pages look like:

http://localhost:8888/algebra_book/Chapters/Quadratic_Functions/introductory_problem.php

BUT, the stuff to the left of Quadratic Functions WILL change in the future.  So all will look like:

*Quadratic_Functions/introductory_problem.php

Then, I'd like to pull off a $chapter variable, which in this case is Quadratic_Functions and a $page_name variable which in this case will be introductory_problem.

Thanks so much.

Hi,
I hope someone can help. I currently have a page that includes the main page after login, however I am looking into changing this so that when a user logs in they get 3/4 linked images that, when clicked dynamically load/include the page based on the select i.e. user selects the image laptop, that has a hyperlink, it loads the laptop page.

If anyone has any ideas or suggestion,i'd appreciate it.

hi guy's i have on one page select from table, and i don't know how to limit showing content from database on 3, and rest to make number under it and when i click on that number next 3 is showen? Something like on forum when you have more topics then you can show, on botom of page are showen numbers (links). Can some explain me how to do this? i put in while loop something like this
Code: [Select]
while ($prom = mysql_fetch_object($res) and $i<3) and now it is limited on showing first 3, my problem is showing next 3, and if there is more how to split it on 3 per page?

Hello everyone, this is my first post. This isn't just a simple post and leave, I'm looking to expand into this community and learn as much as I can. Well on to the problem at hand!

I decided to start with something simple as a login page and now want to expand it to make it fully functional.

Code: (index.html) [Select]
<html>
<head>
 <title>Deadnode.com</title>
 <LINK href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div style=width:150px;height:80px;position:absolute;left:40%;top:35%;
margin-left:-135px;margin-top:-50px;">

<div class="sidebox">
<div class="boxhead"><h2>Login Required</h2></div>
<div class="boxbody">
<form method="post" action="check.php">
<center><table>

<tr><td><font face="verdana,arial" size=-1>User:</td><td><input type="text" name="user"></td></tr>
<tr><td><font face="verdana,arial" size=-1>Pass:</td><td><input type="text" name="pwd"></td></tr>
<tr><td><font face="verdana,arial" size=-1>&nbsp;</td><td><font face="verdana,arial" size=-1><input type="submit" value="Login"></td></tr>
</table></center>
</form>
</div>

</div>
</body>
</html>

Code: (function.php) [Select]
<?php
function check() {
$admin="test";
$pass="test";
if ( $_POST["user"] == $admin & $_POST["pwd"] == $pass) {
  header('Location: output.php'); }
else {
  header('Location: index.html'); }
}
?>

Code: (check.php) [Select]
<?php
require('function.php');
check();
?>

This is just the code in it originally form; completely functional. I tried to use start_session() in my check() function. I know I should be using cookies, but I haven't gotten that far yet. Is it possible to use my check function as a way to block pages? I tried inserting the same code that is in check.php onto a html page, but I've had no luck with it redirecting back to my index.html page.

Hey all,

I've a problem with including of my pages.
When I do choose lotto on index.php , I do get the page and also can choose how many roster I want.
But I can't see my lotto results, because it does refresh to the index.php again.
How can I fix this problem ?

this is the code of index.php:
Code: [Select]
<?php
        echo '<table class="achtergrond" border="1">';
        echo '<tr><td colspan="3">';
        /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="test">';
        echo '<option selected>Kies een formulier</option></center>';
        echo '<option value="1">Lotto</option>';
        echo '<option value="2">Euromillions</option>';
        echo '</select>';
        echo '<button type="submit" name="knop">OK</button>';
        echo '</form>';
        echo '</td></tr>';
            /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
           if(isset($_POST['knop']))
           {
                  echo '<tr><td>';
                  echo $waarde;
                  /* variabel $waarde een waarde insteken via keuzelijst  */
                  switch($_POST['test'])
                  {
                      case 1;
                          include('formulieren/lotto.php');
                      case 2;
                          include('formulieren/euromillions.php');
                  }
                  echo '</td></tr>';
                  echo '</table>';

           }          
        ?>

and this is the code of lotto.php:
Code: [Select]
<?php
    echo '<table class="achtergrond">';
    echo '<tr><td colspan="3">';
    /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="lotto">';
        echo '<option selected>Kies aantal rooster</option></center>';
        echo '<option value="1">2 roosters</option>';
        echo '<option value="2">4 roosters</option>';
        echo '<option value="3">6 roosters</option>';
        echo '<option value="4">8 roosters</option>';
        echo '<option value="5">10 roosters</option>';
        echo '<option value="6">12 roosters</option>';
        echo '</select>';
        echo '<button type="submit" name="knop1">OK</button>';
        echo '</form>';
    echo '</td></tr>';
    /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
   if(isset($_POST['knop1']))
   {
          /* variabel $waarde een waarde insteken via keuzelijst  */
          switch($_POST['lotto'])
          {
                case 0;
                   $waarde2 = 0;
                   break;
                case 1;
                   $waarde2 = 1;
                   break;
                case 2;
                   $waarde2 = 2;
                   break;
                case 3;
                   $waarde2 = 3;
                   break;
                case 4;
                   $waarde2 = 4;
                   break;
                case 5;
                   $waarde2 = 5;
                   break;
                case 6;
                   $waarde2 = 6;
                   break;
          }...