PHP - Is There A Way To Limit Items On A Page Using Php, Based On The Page Resolution?

-First I want to say that I love this site and always check google before I submit questions but im lost.

I'm into security and trying to learn a little Apache, Mysql, and PHP to understand the development cycle better. As practice im creating a notecard test review site. Create notecard Decks, add/delete questions etc. shuffle, then test yourself.

I though I was doing good until I got to the page that shows the questions (test.php).


Right now I pass the "deck_id" field in a GET to a "test.php?id=" page that runs a script that pulls out all the questions for that deck from my "questions" table and loops to show each question for that "deck".

My loop  works, (gets array from database and  shows questions one by one), but it writes all the questions to the page at the same time. DUH. I want it to show one question with a "NEXT" button to show next question. This button clears the first question and writes the next one until they are all done. No grading or anything needed.


Is there a way to do this gracefully?

I dont know much javascript but looked up innerHTML and see i can update text that way but the PHP loop I have goes so fast it just end up showing the last question with no way to pause it between questions. Can anyone think of a way to do this? My problem is passing the data from page to page to page (I lose the array data)


If this is impossible my other thoughts a

1) store current list of Q/A's in cookie    (OR)
2) pass Q/A to another page with POSTS   (OR)
3)store Q/A's to temporary sql table and use GETS in loop to show each one by one. "testing.php?question=1"
4) can i set a global variable that can pass the data to separate pages?
5)user iFrame so it looks like one page (dont know how)


Im leaning to number 3 but want to hear your suggestions. (sorry very new)

Hi,   I am looking for a tutorial or code sample I can use to learn MySQLi pagination with an option to select items per page, like the attached screenshort.   Any help is grately appreciated.   Regards.   joseph Attached Files  table-pagination.jpg   32.87KB   0 downloads

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>

Hi all

not been playing with php over the past year and still a noob lol

i did have some code to include files based on the URL link

E.G:
Code: [Select]
http://www.yoursite.com/index.php?page=about
then i had some form of string that would access the URL

so it would have checked if the url was just index.php or had ?page=somepage after it

I can not seem to find any referance on the www or shift the headach i have got trying to remember the code

so thought some of you wondaful people would no what i am on about and point me in the rught direction of a tutorial for the information or have the code tohand so i can referance from it


thanx all

I have two css external style sheets. One for the 800x600 screen resolution and other for 1200x768. How can I detect the screen resolution and apply the according style sheet using PHP. If I use Javascript, It is possible that the Javascript may not be enable on client side.
has some one a better solution?

Hi,

I am trying to limit an user's input based on a text area size which is 180px.

Is this even possible?

There are ways to read how many linebreak's (\n) there are in a text area, but a long sentence will read as one linebreak.

Any Ideaas?

Hoping someone can help.

I have a file, say bounce.php that uses php url ramdomizer, like this:

<?php
$urls = array("link1",
                      "link2");
$url = $urls[array_rand($urls)];
header("Location: http://$url");
?> 

What I want is to only allow that code to execute if the user is coming from another php page on the same sever/folder.  So like this....

So bounce.php will check where the traffic is coming from.....if traffic is coming from page1.php (file on same server) then it will allow URL REDIRECT CODE to execute, if traffic is coming from another source, such as google.com, or from no referel, then person is sent to another site, say msn.com.

What I'm trying to do is get a php file with content to load into my basic page template based on the page id, however it's not loading anything, however there are no errors coming up. I've looked everywhere I could find, and tried everything I could think of. I really could use some help on this. Below is the page template code and the code I'm trying to use to get the content to load up.

page_templ.php
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" >
<link rel="stylesheet" type="text/css" href="templates/content/style.css" >
<!--This is the css used for IE because we need to correct some things for it.-->
<!--[if IE]>
  <style type="text/css">
    @import 'templates/content/styleIE.css';
  </style>
<![endif]-->
</head>
  <body>
    <?php
    //We need to load our language files with our common text varibles
      require("content/langeng.php");
    ?>
   
<div id="header">
      <?
      //Lets show the header. I use html where I can so smartphones load as little advanced code as possible
        require_once("header.php");
      ?>
</div>

<div id="menu">
      <?//Now our menu.
        require_once("menu.php");
      ?>
</div>

<div id="mbody">
      <?//Now the primary site content.
        //Load up our postvars.php file
        require_once("content/postvars.php");
      ?>
</div>
  </body>
</html>

postvars.php
Code: [Select]
<?php
$id  =  $_POST["id"];
if ( $id == "home" ) {
include 'main_c.php';
}
elseif ( $id == "guides" ) {
include  'guides_c.php';
}
elseif ( $id == "trips" ) {
include  'trips_c.php';
}
?>

I'm feeling a little overwhelmed/burned-out/confused...   

I have a page "article_index.php" that contains a summary of each article plus a link to it, e.g.

Code: [Select]
<a href="<?php echo WEB_ROOT; ?>articles/postage-meters-save-you-money">
When you click on a link, it goes to "article.php" and uses a mod_rewrite to transform the "pretty URL" to regular URL that "article.php" can use to query the correct article from my database.

-----

Here is what I need help with...

When a user is on a given article page, I want to sto

- ReturnToPath
- ArticleID

in the SESSION.

I am drawing a blank on how to get the "ArticleID" when a user is on a give page?!   

Hope you guys follow me?!


Debbie

We are trying to get progress bar to place active class on the current page it one based on variable being set on page called "page", also the page is written into the <body class="page"> tag, once it is loading the page.   It is not working as we need can anyone, help us with script below to set progress bar to do prev and next?????   So variable is:

 
var page = "refundstep1";

  Body Class tage looks like:

<body class="refunStep 1 main-layout">

    Progress bar is:

<div class="tabContent progress-bar hidden-phone">
                
                  <div class="step active">
                    <h2>Step 1: Enter your Pin</h2>
                  </div>
                
                  <div class="step inactive">
                    <h2>Step 2: Tell us your address</h2>
                  </div>
                
                  <div class="step inactive">
                    <h2>Step 3: Confirm Your Details</h2>
                  </div>
                
</div>

    Code to actual set the other list next as class="inactive", list passed or compelted as class="active done", Current page as class="active"

var progressClass = $('.progress-bar div.step');
$(progressClass).addClass(function(index, activeClass) {
    var activeClass = 'done';
var activePage = 'active';
alert(page);
var currentPage = page;
var pageClass = $('body').hasClass(page);
console.log(pageClass);
    if(pageClass === true) {
 progressClass.addClass(activePage);
 progressClass.prevAll().addClass(activeClass);
 //To select all next elements of `.progressClass` element:
     progressClass.nextAll().addClass(nopageClass);
    }
    return nopageClass;
  }); 
 

This is the link to pull the page

http://127.0.0.1/kudos/?viewkudoid=###

This is the kudo-function.php page

function get_kudo_info($viewkudoid){
	global $wpdb;
    $tablename=acikudos_table_name();
    $viewsql = "SELECT * FROM $tablename WHERE kudoid='$viewkudoid'";
	$viewresult = $wpdb->get_results($viewsql);
    #$vewrow = mysql_fetch_assoc($viewresult);

    return $viewresult;
}

This is the kudo-view.php page

function show_kudos($viewkudoid)
{
   global $wpdb;
   
   $viewkudoid = $_GET['viewkudoid'];
   
   $getthekudo = get_kudo_info($viewkudoid);

    if ($viewkudoid == $getthekudo['kudoid']) {
        
		echo 'Congratulations, you have successfully fixed it!';
    } else {
    echo 'Everything is displayed';
}
	} 

 add_shortcode( 'kudosview', 'show_kudos' );

I know the issue is right in front of me but I can not find it.

Hello,

is it possible to define the next page after a form submission based on a value from the form ?

Example:

My form has a dropdown
Value 1: Flight
Value 2: Flight + Hotel

now i'm trying to achieve that if value 1 is chosen after submission it goes to flight.php, if value 2 it should go to flighthotel.php

or am i heading into the completely wrong direction here and over complicating things ?

Thanks in advance !

Below is the screenshots and script for user page level access i have used it for one of my old projects. Code is working as it was intended. But it needs to be improvised.

Users table

pages table , which has all the pages and links

Access level table. which has user id from users table and page id from pages table (for which user has access)

 

Once the user is created, admin gives access to the user on page basis, the permissions.php page looks like this

The modules

 

Menus inside the modules

 

Pages in each menu

 

Here is my code for permission.php

<div id="demo2-html">                    
<ul id="demo2" class="mnav">
	<li><a href="#">Sales</a>
    <ul>
    <li><a href="#">Lead</a>
    <ul>
			<table class="table table-bordered table-striped table-hover">
				
                <?php 
				
				$s1 = mysqli_query($con, "SELECT pages.page_id as pid, pages.code, pages.page, 
									pages.href, access_level.aid, access_level.page_id as pgid, 
									access_level.user_id 
								FROM pages
								LEFT JOIN access_level ON (pages.page_id=access_level.page_id 
									AND access_level.user_id=".$user." 
									) WHERE pages.code='led'") or die(mysqli_error($con));
									
				while($s2 = mysqli_fetch_array($s1)) {  ?>
				<tr><li><td><?php echo $s2['page']; ?>  </td><td><input type="checkbox" name="sn[]" value="<?php echo $s2['pid']; ?>" <?php if($s2['pgid'] === $s2['pid']) echo 'checked="checked"';?> />
                <input type="hidden" value="<?php echo $s2['pid']; ?>" name="page_id[<?php echo $s2['pgid']; ?>]">
                </td></li></tr>
                <?php } ?>
                </table>
				</ul>
			</li>
            
            <li><a href="#">Customer</a>
    <ul>
			
			<table class="table table-bordered table-striped table-hover">
				
                <?php 
				
				$s1 = mysqli_query($con, "SELECT pages.page_id as pid, pages.code, pages.page, 
									pages.href, access_level.aid, access_level.page_id as pgid, 
									access_level.user_id 
								FROM pages
								LEFT JOIN access_level ON (pages.page_id=access_level.page_id 
									AND access_level.user_id=".$user." 
									) WHERE pages.code='cst'") or die(mysqli_error($con));
									
				while($s2 = mysqli_fetch_array($s1)) {  ?>
				<tr><li><td><?php echo $s2['page']; ?>  </td><td><input type="checkbox" name="sn[]" value="<?php echo $s2['pid']; ?>" <?php if($s2['pgid'] === $s2['pid']) echo 'checked="checked"';?> />
                <input type="hidden" value="<?php echo $s2['pid']; ?>" name="page_id[<?php echo $s2['pgid']; ?>]">
                </td></li></tr>
                <?php } ?>
                </table>
				</ul>
			</li>
      //code goes for all the other modules
      
      </ul>
            </li>
            
    
    
</ul>
</div>


<input type="hidden" name="user" value="<?php echo $user; ?>" />
<div class="row" align="center">
<input type="submit" name="submit" class="btn btn-success" value="Save" />
  </form> 



// form Submission

if(isset($_POST['submit']))
{
	$user = $_POST['user'];
	
 $sql = "DELETE FROM access_level WHERE user_id = ".$user."";
 $query = mysqli_query($con, $sql) or die (mysqli_error($con));

foreach($_POST['sn'] as $sn)
{
 $sql = "insert into access_level (page_id, user_id) values (".$sn.", ".$user.")";
 $query = mysqli_query($con, $sql) or die (mysqli_error($con));
}


if($query)
{
header("location:users.php?access=1");	
}

	
}
  

So against each user i am storing all the page ids here. When i edit any of the users, it deletes all the records and again insers new records. Which i feel is not a proper way to do.
And also, if i have 10 users and 100 pages, suppose all the users are having access to all the pages, records in user_access table will be 1000. 

And in codewise also, i am redirecting the user to no_access.php (as below) page if the user do not have access.

<?php
ob_start();
include("connect.php");
include("admin_auth.php"); 
$q1 =  basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']);
$q2 = $_SERVER['REQUEST_URI'];
$var1 = "/".$q1;

$qa_path=explode('/', $q2);

$right_path = $qa_path[2].$var1;

$parsedUrl = parse_url($q2);


$curdir = dirname($_SERVER['REQUEST_URI'])."/";



$m4 = "select p.page_id, p.code, p.page, p.href, al.aid, al.page_id, al.user_id FROM pages p INNER JOIN access_level al ON p.page_id=al.page_id WHERE al.user_id=".$_SESSION['user_id']."";

$m5 = mysqli_query($con, $m4)  or die (mysqli_error($con));


while($nk1 = mysqli_fetch_array($m5)) {
	
	$href1[] = ($nk1['href']); }
	
	
	if(in_array($right_path, $href1)) {

echo "<script type='text/javascript'> document.location = ".BASE_URL."/".$right_path."</script>"; 
}
else
{

echo "<script type='text/javascript'> document.location = '../no_access.php' </script>";
exit();
}	

?>

I need help in improve and better/effective (structural) way to do this both in database and php script. 

We have the page that the users enter the information, which shows as this in an html file:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Scholarship Form</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link href="style.css" type="text/css" rel="stylesheet"  />
</head>

<?php

?>

<body>

<h1 style = "text-align:center">Scholarship Form</h1>

<form name = "scholarship" action = "process_Scholarship.php" method = "post">
<p>First Name: <input type="text" name="fName" /></p>
<p>Last Name: <input type="text" name="lName" /></p>
<p><input type="reset" value="Clear Form" />&nbsp; &nbsp;<input type="submit" name="Submit" value="Send Form" />
</form>

</body>
</html>

and then the attached file, process_Scholarship.php is the file giving me trouble. We're supposed to be using advanced escaping techniques from our book, and that's when things got tricky. I know it's something silly but I just cant figure it out! Any help asap would be awesome!!!!

Good day and Merry Christmas to all,

I just spent a good time of my christmas eve trying to figure out this problem. I hope one of you santas would be so kind as to help me with it.

First off I have two tables; employee and employee_works both connected via employee_id key.

Basically I have a parent window we'll call parent.php.
inside the parent page is a search button that once clicked will open a child window we'll call child.php

inside the child page is a list, lets say employees with name, employee_id, etc.

My main concern is this:
How do I populate parent.php based off the employee selection I made in the child window.

Example:
-Access parent.php
-Click on search
-Click on [ID: 004] [NAME: JOHN SMITH] [PHONE: 1233456] [DATE HIRED: JULY 16, 1992] <---format of a row in child.php
-child.php automatically closes and parent.php now shows all data from employee_works with the employee_id = 004

Is this even possible? I know this is vary vague and would be willing to explain more if needed. My website is built mostly on javascript and php.