PHP - Moved: Php Pagination And Post/session Variables Problem

Hi,
 
 Can any  one help me wit the pagination in android mobile App  Pls find the attached file for full code
 
As per the below coe it displays only 40 posts but i have around 500 posts. I can increse
 
function add_query_vars($public_query_vars) {
        $public_query_vars[] = $this->namespace.'_p';
               return $public_query_vars;
    }
 
 
 
$args = array(
                'post_type' => 'post',
                'post_status' => 'publish',
                'category__in' => $categories,
            );
            if ($wp->query_vars[$this->namespace.'_p'] == 1){
                $args['posts_per_page'] = 10;
                $args['offset'] = 0;
            }else{
                $args['posts_per_page'] = 40;
                $args['offset'] = 10;
            }
            
            $posts = get_posts($args);
 
 
I have tried but i am getting only 210 posts.only if i increse the post_per_page more than 70 in mobile android app it shows loding
 
$args = array(
                'post_type' => 'post',
                'post_status' => 'publish',
                'category__in' => $categories
            );
          if ($wp->query_vars[$this->namespace.'_p'] == 1){
                $args['posts_per_page'] = 70;
                $args['offset'] = 0;
            }
            if ($wp->query_vars[$this->namespace.'_p'] == 2){
                $args['posts_per_page'] = 140;
                $args['offset'] = 70;
            }
            if ($wp->query_vars[$this->namespace.'_p'] == 3){
                $args['posts_per_page'] = 210;
                $args['offset'] = 140;
            }

           

            $posts = get_posts($args); Attached Files  wp-app-maker.php   49.23KB   1 downloads

I have a search page that then submits to a php page that queries the database. I've been struggling to figure out how to paginate it, but I think I've narrowed down the problem. I didn't realize $_POST results didn't pass through when people clicked the pagination links at the bottom. I verified this by replacing  the LIKE variable with a specific word and it worked.

I'm trying to learn how to set up sessions, thinking this might solve my problem. Doesn't seem to be working. Can I get some suggestions on how to do this? What's happening now is that it's pulling a random 8 pages that have nothing to do with the original query.

I start my entire page with:
Code: [Select]
<?php

session_start();

$_SESSION['leafshape'] = $_post['select1'];
$_SESSION['leafcolor'] = $_post['select2'];
$_SESSION['leafvein'] = $_post['select3'];
$_SESSION['leafmargin'] = $_post['select4'];

$leafshape = $_SESSION['leafshape']; 
$leafcolor = $_SESSION['leafcolor'];
$leafvein = $_SESSION['leafvein']; 
$leafmargin = $_SESSION['leafmargin']; 

and I'm setting up the queries like this:
Code: [Select]
$query = "SELECT COUNT(*) as num
                    FROM
                        descriptors
                    JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        descriptors.leaf_shape LIKE '{$_SESSION['leafshape']}'
                        AND descriptors.leaf_venation LIKE '{$_SESSION['leafvein']}'
                        AND descriptors.leaf_margin LIKE '{$_SESSION['leafmargin']}'";

I also tried replacing the '{$_SESSION['leafshape']}' in the query with the assigned variable $leafshape

Hey guys,   I'm using the following pagination script from a website I found. I'ts basically a pagination script that takes data from a MySQL database and displays a certain number of sets before placing the next set on a new page.   This script works great if I substitute a static value for the data I want returned but If the request is stored in a $POST variable like from an HTML form the data refuses to paginate. It will render the first set of data but will not paginate the rest and only shows blank pages   I'm thinking it has something to do with the $POST variable not being set or carrying over to each page but I'm not sure.   I truly appreciate the help!

<?php
	/*
		Place code to connect to your DB here.
	*/
	include('config.php');	// include your code to connect to DB.

	$tbl_name="";		//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 = "filename.php"; 	//your file name  (the name of this file)
	$limit = 2; 								//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 column_name 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\">� previous</a>";
		else
			$pagination.= "<span class=\"disabled\">� previous</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\">next �</a>";
		else
			$pagination.= "<span class=\"disabled\">next �</span>";
		$pagination.= "</div>\n";		
	}
?>

	<?php
		while($row = mysql_fetch_array($result))
		{
	
		// Your while loop here
	
		}
	?>

<?=$pagination?>
	

I try to use session to keep post data. It is not working. The program likes this .

html 

<select name="type">
   <option >for</option>
  <option value="PC">Photo copier</option>
      <option value="Fax">Fax</option>
      <option value="Copier">Copier</option>
      <option value="Cheque">Cheque</option>
     <option value="Print">Printer</option>
      <option value="Copier/Fax">Copier/Fax</option>
</select> <br />
PHP CODE

$session_start();
$_SESSION[brand]=$_POST[brand];
$_SESSION[sort]=$_POST[sort];
$_SESSION[type]=$_POST[type];


if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 18;


$select="select * from $chun where  brand = '$_SESSION[brand]' or  sort ='$_SESSION[sort]' or type='$_SESSION[type]'  LIMIT $start_from, 18";

$result2=mysql_query($select, $connection) or die (mysql_error());

$sql = "select count(*) from $chun  where   brand = '$_SESSION[brand]' or  sort ='$_SESSION[sort]' or type='$_SESSION[type]' ";
<div class="trunpage"><a href='table2.php?page=<?php echo  "$i" ; ?>&id=<?php echo "$_POST[brand]";?>&cd=<?php echo "$_POST[kind]";?>&td=<?php echo "$_POST[type]";?>'  ><?php echo  "$i" ; ?></a>
      
I get error message.

Notice: Undefined variable: session_start in C:\wamp\www\php1000\table2.php on line 174

Fatal error: Function name must be a string in C:\wamp\www\php1000\table2.php on line 174


Please tell me how to solve this problem . Thank you very much.

As the title says session, post and get are not working. This is what i use to initialize them. For get just switch session with get.

Code: [Select]
foreach ($row as $val)
          { 
            $_SESSION[$rowcount] = $val;
//              echo "<td>$val</td>\n";
                $rowcount=$rowcount+1;
      }
when i was using session i would check to make sure that they were working with a couple of these lines in the same php document.

Code: [Select]
echo "Session row 1 = ".$_SESSION[0]."<br />";
echo "Session row 2 = ".$_SESSION[1]."<br />";
then on the next page where I was trying to receive the variables i was using this just to start off with and make sure i was getting the variables.

Code: [Select]
session_start();
if(!isset($_SESSION[1])){
echo "help1";}else{$var=$_SESSION[1];
}
echo $_SESSION[1];
echo $var;
if i switch to post and get i get the same results. if there is an easier way to pass variables between pages id love to hear them

...anyone know anything about Internet Explorer not printing values from session variables.  It works on Firefox but not on Internet Explorer.  The session variable value works find on the web page but click on Print preview and it dissapears and will not print.

they recently reset my website so my php.ini file has been adjusted. One of my sites is no longer passing a session variable to the next page. I am sure its one of the settings being reset. here is the data from my phpinfo file. Anything that looks off to anyone?

session
Session Support    enabled
Registered save handlers    files user sqlite
Registered serializer handlers    php php_binary wddx

Directive   Local Value   Master Value
session.auto_start   Off   Off
session.bug_compat_42   On   On
session.bug_compat_warn   On   On
session.cache_expire   180   180
session.cache_limiter   nocache   nocache
session.cookie_domain   no value   no value
session.cookie_httponly   Off   Off
session.cookie_lifetime   0   0
session.cookie_path   /   /
session.cookie_secure   Off   Off
session.entropy_file   no value   no value
session.entropy_length   0   0
session.gc_divisor   100   100
session.gc_maxlifetime   1440   1440
session.gc_probability   1   1
session.hash_bits_per_character   4   4
session.hash_function   0   0
session.name   PHPSESSID   PHPSESSID
session.referer_check   no value   no value
session.save_handler   files   files
session.save_path   /home/users/web/b535/ipw.plevtech/public_html/cgi-bin/tmp   /home/users/web/b535/ipw.plevtech/public_html/cgi-bin/tmp
session.serialize_handler   php   php
session.use_cookies   On   On
session.use_only_cookies   Off   Off
session.use_trans_sid   0   0

Hi

Can some steer me in the right direction.  I am having issues subtotaling 2 session variables:

<td>'.$_SESSION['itemqty'][$key].'*'.$_SESSION['itemprice'][$key].'</td>

Can you advise if I am doing this right?

Cheers

Say I have a dropdown menu consisting of user specific options. I need to be able to set a session variable depending on the option chosen & then re-access it on the following page. Can someone give me a crash course on how to utilize session variables?

Hi.  I'm brand new to this forum, so sorry if I do something wrong...

I'm someone who has thought myself to code in php to add dynamic objects to my basic static websites.  I have had no formal education.  This is not my first project however. 

I'm having problems with session variables working fine up to a point when I call a new file and then all my session variables are lost.  I have tried everything, but cannot keep them alive when I get into this or any other new file.

I display a form, get user data submitted, then display a next form and after the user submits this next form all the session variables are lost.

Anyone have any idea what is killing my session variables?

Thanks in advance.

Hello dear friends,

say i've form with 2 variables which i want to post to another file

file 1

Code: [Select]
<script type="text/javascript">
// <![CDATA[
$(document).ready(function(){
$('#loader').hide();
$('#inner').children().click(function(){
var a = $(this).attr("name");
$.post("rating.php?value="+a,{},
function(response){
$('#inner').fadeOut();
$('#inner').html(unescape(response));
$('#inner').fadeIn();
setTimeout("hideMesg();", 2000);
});
});
});
function hideMesg(){
$('.rating_message').fadeOut();
$.post("rating.php?show=1", {},
function(response){
$('#inner').html(unescape(response));
$('#inner').fadeIn('slow');
});
}
// ]]>
</script>
this will post the following ( the value of name )

Code: [Select]
<div class="rating_dis" name="<?php echo $k?>" id="<?=$id?>">&nbsp;</div>
but i want it also to post the value of the (id)

here is the second file which should get the name

Code: [Select]
if($_REQUEST['value']){
$name = $_REQUEST['value'];

$query = "insert into rating (rated, channelid) values ('$name', '$idz')";
mysql_query( $query);
}
so the problem is how to send from file 1 to file 2 both the (name) and (id)
how to double this ?

Code: [Select]
var a = $(this).attr("name");
$.post("rating.php?value="+a,{},
to be also

Code: [Select]
var a = $(this).attr("id");
$.post("rating.php?any="+a,{},
then i can get it from file 2 easily get both.

thank you 

Well i have a session['rmanr'] a have set after a submit containing the date and unique id. I have to be able to do multiple submits on that same form but if they submit multiple times the same rmanr have to be used...   I tried the following:

$date         = date("Y-m-d");
$datestrip    = str_replace("-",  "", $date);
$lastdetid     = $dbh->lastInsertId();
if(!isset($_SESSION['rmamr'])){
            $rmanr                   = $datestrip;
            $rmanr                  .= $lastdetid;
            $_SESSION['rmanr']       = $rmanr;
        } else {
            $rmanr                   = $_SESSION['rmanr'];
        }

    $uprmastmt = $dbh->prepare("UPDATE rma SET r_nr = '$rmanr' WHERE r_id = ?");
    $uprmastmt->bindParam(1, $lastid);
    $uprmastmt->execute();

But i keep getting a new rmanr every time i submit... Could it be that my form submit reset my SESSION?

Hello everyone and thanks in advance for the help. I am working on a permission system for a site I am creating that will be used to restrict access to various areas of the site. I have a table with all the permission that is linked to a group that the user is a member of. I then use a query to get a list of the permission ids the user is part of and put those into the session array. I used a basic login script I found online I planned on modifying to add my own features and to make more secure.

Originally it had just a member id and member name variable in the session array saved in the login script which are both working fine after login. I am using a dynamic variable to set one session variable for each permission with the id being the changing part in the variable name. The problem I found is that the new variables are not being set. When i removed the redirect from my login script so I could check the problem I found that the temp variable, which is also set before it saves to the session array, is blank as well. If I hit refresh on my browser the new variables become set and all is well.

I was talking to nvee in irc chat who said I need to make a function on the page I am redirected to that checks if the variable exists. I looked through the original code of the login script I am using and found that this seems to be how they did it as well so I added an if statement to my index page to check if the variable has a value with and without using if isset. In both cases the new variable is still not getting set. He also gave me some pointers to help make my login checks more secure but the main thing IM concerned with right now is to make my new permission variables accessible to the session. My login script is available in my pastebin.

I am finally making the upgrade from PHP 5.3 to PHP 7.3.  When converting over the code I noticed that session some sessions are not being processed.  My test code for this is below:

 

session_start(); 
include ("../includes/connect.inc");

echo "hiiiiiiii: ".$currentDate;
echo "He  ".$_SESSION['user'];


if (isset($_SESSION['user']))
{
	$user = $_SESSION['user'];
	$currentDate = date("Y/m/d");

}
else
{
	echo "Session not started: ";
}

 

My include is listed below:

$link = mysqli_connect('localhost', 'root', ''); 
if (!$link) { 
    die('Could not connect: ' . mysql_error("Connection error message")); 
} 
mysqli_select_db($link, 'dbname') or die (mysqli_error($link)); 



date_default_timezone_set('America/Chicago');

define ("TZ_CORRECTION", 43200);

$bkcolor = "#FFFFFF";

$currentDate = (Date("Y-m-d"));

I am not getting the message "Session not started or the current date from the include".   

If it matters I am using WAMP as my testing server

Any help is greatly appreciated.

Question about variable variables and using session variables for them. O.K. So if I have:

$foo = 3;
$_SESSION['bar'] = "foo";

$$_SESSION['bar']  should equal the value of $foo, however I can't get it to work. Can someone tell me what I am doing wrong..... is it formatting???

Thanks,
Thomas