PHP - Can't Get Pagination To Work Properly

why aint this working??

Code: [Select]
<?php
                                if ($_COOKIE['watch_id']){
                                    $cookie = $_COOKIE['watch_id'];
                                    $cookie_query = mysql_query("SELECT * FROM user WHERE cookie='$cookie'");
                                    if (mysql_num_rows($cookie_query) >= 1){
                                    ?>
                                    <li><a href="/index.php">Home</a></li>
                                    <li><a href="/cpanel.php">C-Panel</a></li>
                                    <li><a href="/logout.php">Logout</a></li>
                                    pass
                                    <?php   
                                    }
                                    if (mysql_num_rows($cookie_query) <= 1){
                                    ?>
                                    <li><a href="register.php">Register</a></li>
                                    <li><a href="#" onclick="OPEN_login();">Login</a></li>
                                    <li><a href="index.php">Home</a></li>
                                   fail1
                                    <?php
                                    }
                                }
                                
                                if(!$_COOKIE['watch_id']){
                                ?>
                                <li><a href="register.php">Register</a></li>
                                <li><a href="#" onclick="OPEN_login();">Login</a></li>
                                <li><a href="/index.php">Home</a></li>
                                fail2
                                <?php
                                }
                                ?>

i have checked in the browser and the cookies match but it always echos fail2 which means that this line is returning false:

Code: [Select]
if ($_COOKIE['watch_id']){

i have tried using isset but that didnt help either!

any help?

Hi guys, I have stuck with this issue for over 3 hours now. My remove all button just wouldn't work.   Can anyone tell me what's the issue? I have 2 pages, one parent and another pop-up page that takes the values (cartSubmit) from parent. And I wrote out the code for both pages but I just cannot get it to work.  I apologize in advanced if my code looks messy or doesn't make any sense.   Please take a look at the code and let me know if you could spot anything wrong with it. Any help is greatly appreciated.   Here is the code related to the remove all button in the parent page:

if(isset($_POST['finalSelected']))
{	echo "<br/>inside";
	if(!empty($_POST['fSelected']))
	{	echo "<br/>if NOT empty";
		$chosen = $_POST['fSelected'];
		foreach ($chosen as $item)
			echo "</br>aID selected: $item </br>";
		//implode function to transform an array to a string
		//chosen(array) to $delimit(String)
		$delimitStr = implode(", ", $chosen);
		//Save the selected String to SESSION
		if(!isset($_SESSION["final"]))
		{	
			$_SESSION["final"] .= "$delimitStr";
		}
		else
		{
			$_SESSION["final"] .= ", $delimitStr";
		}
		//Explode function to transform the SESSION variable back to an array for further trimming.
		$arraySession = explode(', ', $_SESSION["final"]);
		//Array unique to filter out duplicates.
		$uniqueArray = array_unique($arraySession);
		$cartSubmit = implode(", ",$uniqueArray);
		$_SESSION['cartSubmit'] = $cartSubmit;
	}
	else
	{
		echo "<br/>else empty";
		$noSubmit = $_SESSION["final"];
		//Explode function to transform the SESSION variable back to an array for further trimming.
		$arraySession = explode(', ', $_SESSION["final"]);
		//Array unique to filter out duplicates.
		$uniqueArray = array_unique($arraySession);
		$cartSubmit = implode(", ",$uniqueArray);
		$_SESSION['cartSubmit'] = $cartSubmit;
		
	}
}


<form name= "finalForm" method="POST" action="test6-1.php" target = "_self">
<input type="Submit" name="finalSelected"/>
<a href="javascript:popup('test6-3.php?aID=
<?php if(empty($_SESSION['final']) && empty($_SESSION['cartSubmit'])) echo "0";
else if(empty($cartSubmit)) echo "0"; else echo $_SESSION['cartSubmit'];?>')">Cart</a>


<?php if(isset($FinalName)) 
{ foreach($FinalName as $key => $item) 
	{?>
	<tr><td>
	<input type="checkbox" name="fSelected[]" value="<?php echo htmlspecialchars($FinalID[$key])?>" />
	<?php echo "$FinalID[$key] & $item";?>
	</td></tr>
<?php }
}?>
	</form>

And here is the code in the pop-up page.

<script> window.onunload = refreshParent;
function refreshParent() 
{
window.opener.location.reload();
}
</script>
if(isset($_POST['removeAll'])) 
{ $aID = "0"; 
unset($_SESSION['cartSubmit']); 
unset($_SESSION['final']); 
header("Location : test6-3.php?aID=0"); 
}

Edited by Cyjm1120, 18 November 2014 - 12:16 PM.

I cannot get my script to update table: locations_all column city_state to the full state name.. Here's what I've been hacking at for 4.5 hours now! Ready to hit the sack.. Thanks for any input:

$state_list = array('AL' => "Alabama", 'AK' => "Alaska", 'AZ' => "Arizona", 'AR' => "Arkansas", 'CA' => "California", 'CO' => "Colorado", 'CT' => "Connecticut", 'DE' => "Delaware", 'DC' => "District Of Columbia", 'FL' => "Florida", 'GA' => "Georgia", 'HI' => "Hawaii", 'ID' => "Idaho", 'IL' => "Illinois", 'IN' => "Indiana", 'IA' => "Iowa", 'KS' => "Kansas", 'KY' => "Kentucky", 'LA' => "Louisiana", 'ME' => "Maine", 'MD' => "Maryland", 'MA' => "Massachusetts", 'MI' => "Michigan", 'MN' => "Minnesota", 'MS' => "Mississippi", 'MO' => "Missouri", 'MT' => "Montana", 'NE' => "Nebraska", 'NV' => "Nevada", 'NH' => "New Hampshire", 'NJ' => "New Jersey", 'NM' => "New Mexico", 'NY' => "New York", 'NC' => "North Carolina", 'ND' => "North Dakota", 'OH' => "Ohio", 'OK' => "Oklahoma", 'OR' => "Oregon", 'PA' => "Pennsylvania", 'RI' => "Rhode Island", 'SC' => "South Carolina", 'SD' => "South Dakota", 'TN' => "Tennessee", 'TX' => "Texas", 'UT' => "Utah", 'VT' => "Vermont", 'VA' => "Virginia", 'WA' => "Washington", 'WV' => "West Virginia", 'WI' => "Wisconsin", 'WY' => "Wyoming");
      foreach ($state_list as $key => $value) {
          // get all state abbr and name values.
          while ($row = mysqli_fetch_array($result)) {
              $query2 = "UPDATE locations_all SET city_state=$value WHERE city_state=$key";
              $result2 = mysqli_query($cxn, $query2) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query2");
          } //while ($row = mysqli_fetch_array($result))
      } //foreach ($state_list as $key => $value)

I'm able to get the image file name in the database, the image to the right place BUT the problem is the image is totally black and after it's uploaded, a whole bunch of warnings appear.  Here are the warnings:

Warning: getimagesize(image_files/image-16.jpg) [function.getimagesize]: failed to open stream: No such file or directory in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 37

Warning: Division by zero in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 54

Warning: Division by zero in C:\Users\Samantha\Desktop\xampp\htdocs\image-crop-demo.php on line 71

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 78

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 86

Warning: imagecopy() expects parameter 2 to be resource, boolean given in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 102

Here is the form:
<form action="image-crop-demo.php?username=<?php echo $username ?>" method="post" enctype="multipart/form-data">
  Upload an image for processing<br>
  <input type="file" name="Image1"><br>
  <input type="submit" value="Upload">
</form>

And here is the form action file:

 
$username = $_GET['username'];

 define( 'DESIRED_IMAGE_WIDTH', 150 );
  define( 'DESIRED_IMAGE_HEIGHT', 150 );

  $source_path = $_FILES[ 'Image1' ][ 'name' ];  

$sql="UPDATE thumbnail SET Image1='$source_path' WHERE username = '$username'";

 if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

  } 
else {

  //
  // Add file validation code here
  //

  list( $source_width, $source_height, $source_type ) = getimagesize( $source_path );

  switch ( $source_type )
  {
    case IMAGETYPE_GIF:
      $source_gdim = imagecreatefromgif( $source_path );
      break;

    case IMAGETYPE_JPEG:
      $source_gdim = imagecreatefromjpeg( $source_path );
      break;

    case IMAGETYPE_PNG:
      $source_gdim = imagecreatefrompng( $source_path );
      break;
  }

  $source_aspect_ratio = $source_width / $source_height;
  $desired_aspect_ratio = DESIRED_IMAGE_WIDTH / DESIRED_IMAGE_HEIGHT;

  if ( $source_aspect_ratio > $desired_aspect_ratio )
  {
    //
    // Triggered when source image is wider
    //
    $temp_height = DESIRED_IMAGE_HEIGHT;
    $temp_width = ( int ) ( DESIRED_IMAGE_HEIGHT * $source_aspect_ratio );
  }
  else
  {
    //
    // Triggered otherwise (i.e. source image is similar or taller)
    //
    $temp_width = DESIRED_IMAGE_WIDTH;
    $temp_height = ( int ) ( DESIRED_IMAGE_WIDTH / $source_aspect_ratio );
  }

  //
  // Resize the image into a temporary GD image
  //

  $temp_gdim = imagecreatetruecolor( $temp_width, $temp_height );
  imagecopyresampled(
    $temp_gdim,
    $source_gdim,
    0, 0,
    0, 0,
    $temp_width, $temp_height,
    $source_width, $source_height
  );

  //
  // Copy cropped region from temporary image into the desired GD image
  //

  $x0 = ( $temp_width - DESIRED_IMAGE_WIDTH ) / 2;
  $y0 = ( $temp_height - DESIRED_IMAGE_HEIGHT ) / 2;

  $desired_gdim = imagecreatetruecolor( DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT );
  imagecopy(
    $desired_gdim,
    $temp_gdim,
    0, 0,
    $x0, $y0,
    DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT
  );

  //
  // Render the image
  // Alternatively, you can save the image in file-system or database

$remote_file = "image_files/".$_FILES["Image1"]["name"];
imagejpeg($desired_gdim,$remote_file);

}//

I am currently creating a multi-user login system, and I have created the database in MySQL, but the problem is that my PHP script is not working as expected. I would like it so that if the user enters in a correct username + password combination, then they are redirected to a webpage called "congrats.php" for example. However, with my current PHP code, if I include a redirection instruction based on the correct input, then when I run the script, then the user is instantly taken to the congrats.php page without filling in any login details. I'm quite sure that the database has been connected to, as due to the layout of my script at the moment, the text that reads "You did it!" appears 4 times, the same number of rows in my MySQL database. My PHP coding for this is:

Code: [Select]
<html><head><title>Multi-User Log In Form</title></head>
<body>
<?php
$self = $_SERVER['PHP_SELF'];
$username = $_POST['username'];
$password = $_POST['password'];
?>
<form action = "<?php echo $self; ?>" method = "post">
Username <input type = "text" name = "username" size = "8">
Password <input type = "password" name = "password" size = "8">
<input type = "submit" value="Submit">
</form>
<?php
$conn = @mysql_connect("localhost", "root", "") or die ("Err: Conn");
$rs = @mysql_select_db("test3", $conn) or die ("Err: Db");
$sql = "select * from users";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($rs)) {

$name = $row["uname"];
$pass = $row["pword"];
if ($username = $name && $password = $pass)
{
//CODE FOR REDIRECTION SHOULD GO HERE
//header("location:congrats.php");
echo "You did it!";
}
else
{
echo "Invalid username and password combination";
}
}
?></body>
</html>

Any help in trying to get it so that my PHP script will redirect only if a correct username + password combination is entered would be greatly appreciated

HI,
according to my knowledge session_destroy() function would destroy all session variables and mysql_close() would close connection with the database.
   i make a simply logoff.php file and close myssql connection and destroy session. but i still get values from the database and session variables. and doesnt work properly

here is the code
Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
  echo "<html>";
echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
      echo "<thead>";
           echo"<tr>";
                   echo "<th>";
                   echo ID;
                   echo"</th>";
                   echo" <th>";echo Username; echo"</th>";
                    echo"<th>";echo Password; echo"</th>";
                    echo"<th>";echo Last_logged_date; echo "</th>";
                   echo "<th>";echo Last_logged_time;  echo "</th>";
               echo" </tr>";
           echo" </thead>";
           echo" <tbody>";
while($row= mysql_fetch_array($result,MYSQL_BOTH)){
             echo "<tr>";
              echo "<td>";
              echo $row[0];
               echo "</td>";
                   echo "<td>";
              echo $row[1];
              echo "</td>";
                  echo "<td>";
              echo $row[2];
               echo "</td>";
                   echo "<td>";
                echo $row[3];
              echo "</td>";
                  echo "<td>";
              echo $row[4];
               echo "</td>";
            echo "</tr>";
     }
         echo" </tbody>";
         echo "</table>";
         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values".$_SESSION['admin'];
?>

This one requires lots of up front information:

I have a page, for this example that I will call page.php. It takes get parameters, and for this example I'll call the parameter "step". So I have a URL like this: page.php?step=1 This page has a form with an action of page.php?step=1. The code on the page validates the posting information. If the information is bad, it returns the user to page.php?step=1; if it is good, it takes the user to page.php?step=2 via header( "location:page.php?step=2" ). So redirection is done by relative path, not full URLs.
This all works as expected.

Now what I've done is set .htaccess to be HTTPS for this page, via this code:

# Turn SSL on for payments
RewriteCond %{HTTPS} off
RewriteCond %{SCRIPT_FILENAME} \/page\.php [NC]
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]

This works (initially). However, once you try to post the form, it just redirects back to the step=1 version of the page. I really don't know how or why that would be.

I'm not sure how else I can explain this or what other information you may have. But it's frustrating to not get a page working in HTTPS that works in HTTP. Very odd. Any suggestions? (I don't even really know the best location to figure out when/why it's redirecting back to the original page.)

Hi..,
I use below method to export data to excel.

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=abc.xls');

if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

any idea how to solve this?

require_once 'includes/upload.class.php';
$upload = new uploads();
$details = $upload->getFileInformation($id);

<?php echo $details['upload_desc']; ?>

then here the class.

require_once 'db.class.php';



class uploads extends database

{

   private $uploadData;

   function uploadFile() {

   public function getFileInformation($id)

   {

      $this->uploadData = $this->readData("uploadfiles", "upload_id", $id);

      return $this->uploadData;

   }


But it wont work!
      

Sorry to bug yalls with yet another problem, but I tried applying pagination to the page I use to display the news on my website, which is stored within mysql, and I'm having major issues. Here's the code below for both the pagination and getting the news out of the database to display. Not sure what's going on here. I tested the script and it does everything fine except it doesn't display the information stored within the database.

Go here to see for yourself:
http://www.djsmiley.net/index.php

Code: [Select]
<?php
/*
Place code to connect to your DB here.
*/
include('cms/news/dbconnect.php'); // include your code to connect to DB.

$tbl_name="mynews"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;

/* 
   First get total number of rows in data table. 
   If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

/* Setup vars for query. */
$targetpage = "index.php";  //your file name  (the name of this file)
$limit = 1;  //how many items to show per page
$page = $_GET['page'];
if($page) 
$start = ($page - 1) * $limit;  //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0

/* Get data. */
$sql = "SELECT 10 FROM $tbl_name LIMIT $start, $limit";
$result = mysql_query($sql);

/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1

/* 
Now we apply our rules and draw the pagination object. 
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1) 
$pagination.= "<a href=\"$targetpage?page=$prev\"><img class=\"fltlft2\" src=\"http://www.djsmiley.net/images/Icons/Arrows/Previous.png\" height=\"25\" width=\"25\"></a>";
else
$pagination.= "<span class=\"disabled\"><img class=\"fltlft2\" src=\"http://www.djsmiley.net/images/Icons/Arrows/Previous.png\" height=\"25\" width=\"25\"></a></span>";

//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
}

//next button
if ($page < $counter - 1) 
$pagination.= "<a href=\"$targetpage?page=$next\"><img src=\"http://www.djsmiley.net/images/Icons/Arrows/Next.png\" height=\"25\" width=\"25\"></a>";
else
$pagination.= "<span class=\"disabled\"><img src=\"http://www.djsmiley.net/images/Icons/Arrows/Next.png\" height=\"25\" width=\"25\"></span>";
$pagination.= "</div>\n";
}
?>

<?php
while($row = mysql_fetch_array($result))
{
echo("<p class=NewsContainer><span class=NewsID>$type</span> <font size=5>$title</font><br><br>
<em>posted by <strong>$user</strong> | added on $time</em><br><br> 
$message<br><br>
<label class=fltlft2><img src=../images/Icons/Arrows/Right.png width=20 height=20/></label><a href=$url>Read more - $url</a>
<div class=newsLikeShareRate>
  <table width=100% border=0>
<tr>
  <td width=3% height=21><script src=http://connect.facebook.net/en_US/all.js#xfbml=1></script>
  <fb:like href='$url' show_faces=true width=450 font=arial></fb:like>
                              </td>
<td width=65%><a name=fb_share id=fb_share4 type=icon_link 
   share_url=$url>Share</a>
  <script src=http://static.ak.fbcdn.net/connect.php/js/FB.Share 
type=text/javascript></script></td>
  <td width=32%>Rate this article:
   </td>
</tr>
  </table>
</div></p><br><br>");// Your while loop here

}
?>

<?=$pagination?>

I am trying to code a php, mysql and jquery pagination much like the way twitter's pagination works.

Page 1 i have

Code: [Select]
<div id="load_more">
<?php
$query = mysql_query("SELECT * FROM comments ORDER BY id DESC LIMIT 5");
        while($row = mysql_fetch_assoc($query)){
        $id = $row['id'];
        // show comments code
        }
?>
</div>
<script type="text/javascript">
$(function()
{
$('.showmore').live("click",function()
{
var ID = $(this).attr("id");
if(ID)
{
$("#more"+ID).html('<img src="ajax-loader.gif" />');
$.ajax({
type: "POST",
url: "comments_more.php",
data: "lastmsg="+ ID,
cache: false,
success: function(html){
$("#load_more").append(html);
$("#more"+ID).remove(); // removing old more button
}
});
}
else
{
$(".morebox").html('No more comments.');// no results
}
return false;
});
});
</script>
<div id="more<?php echo $id; ?>" class="morebox">
<a href="javascript:;" style="text-decoration: none; font-size: 12px; color: #ffffff; font-weight: bold; " class="showmore" id="<?php echo $id; ?>">Load More Comments</a>
</div>

So i am only showing 5 rows untill the link is clicked and then i want it to load more comments from comments_more.php which is  the same page as above just it checks for the lastmsg id and alters the query to WHERE id < '$lastmsg'. Everything works ok for clicking the link and showing more results but it only works once. even if there is more than 10 rows it will show as "no more comments" after 10. Any help will be appreciated thanks.

My php/mysql book doesn't cover pagination so I've been searching the web for a simple pagination script that I can learn from.

I got the following one working at http://www.phpsimplicity.com/tips.php?id=1 but it's just showing the next and prev links... no results on the pages and you can click on the next link forever when there's only 11 records in the table I queried.

How can I display results on each page and have the info append to the next page? This is the second example I've tried and none seem to explain this part?