PHP - If On Index.php Or / Show One Page If Not Show Another?

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

I am displaying rows from a database onto a page using:

while($row=mysql_fetch_array($query)){

echo $row['name'];

}

I need to figure out how to limit the rows shown to the page to 100. And if there are 100 rows on the page, a link will be displayed at the bottom, that says "Next 100". Then this will display the next 100 rows.
Can you give an example how to do this please?

Thanks

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 ,

I know my code sucks but i'm learning fast!! I'm trying to show a form if the qty value in a database == 10 or a different form if the value ==20.  I tried but failed.  Any help really appreciated.

Code: [Select]

<?php require_once('Connections/book.php'); ?>
<?php
$colname_cardpayment = "-1";
if (isset($_GET['orderid'])) {
  $colname_cardpayment = (get_magic_quotes_gpc()) ? $_GET['orderid'] : addslashes($_GET['orderid']);
}
mysql_select_db($database_book, $book);
$query_cardpayment = sprintf("SELECT * FROM cards WHERE orderid = '%s' ORDER BY qty ASC", $colname_cardpayment);
$cardpayment = mysql_query($query_cardpayment, $book) or die(mysql_error());
$row_cardpayment = mysql_fetch_assoc($cardpayment);
$totalRows_cardpayment = mysql_num_rows($cardpayment);

 // Database connect
$con = mysql_connect("mysql1.myhost.ie","admin_book","root123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book_test", $con);


//Parse Values from Coupon.php Form
$orderid = mysql_real_escape_string(trim($_POST['orderid']));
$name  = mysql_real_escape_string(trim($_POST['name']));
$surname  = mysql_real_escape_string(trim($_POST['surname']));
$add1 = mysql_real_escape_string(trim($_POST['add1']));
$add2 = mysql_real_escape_string(trim($_POST['add2']));
$town = mysql_real_escape_string(trim($_POST['town']));
$county = mysql_real_escape_string(trim($_POST['county']));
$postcode = mysql_real_escape_string(trim($_POST['postcode']));
$phone = mysql_real_escape_string(trim($_POST['phone']));
$email = mysql_real_escape_string(trim($_POST['email']));
$letterstyle = mysql_real_escape_string(trim($_POST['letterstyle']));


$sql="INSERT INTO custdetails (orderid, name, surname, add1, add2, town, county, postcode, phone, email, letterstyle)
VALUES
('$orderid','$name','$surname','$add1','$add2','$town','$county','$postcode','phone','$email','$letterstyle')";

if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Digital Scribe Books</title>
<link href="style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>


</head>

<body onload="MM_preloadImages('images/buttons/home_over.png','images/buttons/books_over.png','images/buttons/cards_over.png','images/buttons/letters_over.png')">


<div id="snow">
<div id="wrapper">


<div id="header">

<div id="logo"><img src="images/digital_scripe.png" width="218" height="91" /></div>


<div id="menu"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Home','','images/buttons/home_over.png',1)"><img src="images/buttons/home_act.png" name="Home" width="131" height="132" border="0" id="Home" /></a><a href="books.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Books','','images/buttons/books_over.png',1)"><img src="images/buttons/books_act.png" name="Books" width="131" height="132" border="0" id="Books" /></a><a href="cards.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Cards','','images/buttons/cards_over.png',1)"><img src="images/buttons/cards_act.png" name="Cards" width="131" height="132" border="0" id="Cards" /></a><a href="letters.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Letters','','images/buttons/letters_over.png',1)"><img src="images/buttons/letters_act.png" name="Letters" width="131" height="132" border="0" id="Letters" /></a></div>
 </div>
 
 
 
 
<div id="content">



<?php 
echo 'Order ID is :  '. $orderid . '.<br />';

if ($row2['qty'] == 10)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="10 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="12.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";

if ($row2['qty'] == 20)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="20 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="21.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";


?>

</div>


<div id="footer" class="clear"><div id="sign"><div id="sign_text">Personalised<br />
Books</div>
</div></div>

</div></div>






</body>
</html>
<?php
mysql_free_result($cardpayment);
?>

Hi All,

I want to be able to show selected pages of my website as PDF using a 'PDF' button much like this site does:

http://www.westmeon.org.uk/index.php?option=com_content&task=blogsection&id=8&Itemid=35

I presume that I will need to install some sort of software on my server (which runs the latest PHP, MySQL etc.) but after hours of searching online I cannot find a simple way of doing this.

Does anyone have any suggestions or pointers for how I can do this?

FYI my website is written in PHP drawing data from a MySQL database.

Regards,
Neil