PHP - One Works Other Dont

Hi, im using colorbox(basically like lightbox) for some links on my site. When a user clicks the link it opens this lightbox. But if they type the link into the address bar manually it takes them to the actual page(which isnt formatted properly). Is there a way to open up the lightbox when they enter the address manually? or a work around?

i am a beginerr in php..
and here is my code..which shows error in the querry line..
erro goes like this

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\restafinal\process_edit_page.php on line 56

and code goes like this..
echo part works well...that query line is the error line..please tell me whats the problem...

Code: [Select]
<?php



//$id=$_GET["id"];
$id= $_GET['id'];
 $menu_name= $_POST['menu_name'];

 $position= $_POST['position'];
 $visible= $_POST['visible'];
 $note= $_POST['note'];
 $content= $_POST['content'];
 
 
 //echo part works well..
echo "menu_name"; echo $menu_name;
 echo "<br/>";
 echo "position"; echo $position;
   echo "<br/>";
 echo "visible";  echo  $visible;
    echo "<br/>";
  echo "note";  echo $note;
   echo "<br/>";
echo "id"; echo $id;

echo $content;



[b]$result = mysql_query(UPDATE page SET note =$note, nevigation = $menu_name WHERE id = $id,$connection)[/b]

// test to see if the update occurred
if (mysql_affected_rows() == 1) {
// Success!



} else {
$message = "The page could not be updated.";
$message .= "<br />" . mysql_error();
}




?>

Hi Guys,

im not sure if this is possible or not... i want to be able to paste information from stored information in one web browser to another browser with a different website...

E.G i have a website where a user inputs information and i want to be able to export that in text format to another website where the page is set to take information.


not sure if this makes sence but any ideas appriciated.

I have the echo statement set up for all files, but what i want to do is put an if statement for example if it contains .pdf or .docx dont echo out an image how would i do this? 

Code: [Select]

<?php $id = explode("/", $_GET['a']); $id = $id[2]; ?>
<?php global $allow_client_uploads; ?>
<div id="content">
<div class="wrapper content">

<h3 class="page-title"><?php echo $project['name']; ?></h3>

<div id="client-controls">
<a href="<?php echo $this->redirect('messages/add/'.$id, true); ?>" class="new-message">Post Message to Admin</a>

<?php if($allow_client_uploads): ?>
<a href="<?php echo $this->redirect('documents/add/'.$id, true); ?>" class="new-file">Upload A Document</a>
<?php endif; ?>

<a href="<?php echo $this->redirect('clients/change_password', true); ?>" class="change-password">Change Password</a>
</div>

<!--<div class="project-progress">Progress
<div class="progressbar">
        <div id="test" class="progressbar-completed"
style="width:<?php // echo $project['progress']; ?>%;">
            <div>&nbsp;</div>
        </div>
        <div><?php // echo $project['progress']; ?>%</div>
    </div>
    </div> -->
   
<ul class="project-phases">

<?php $n=0; global $document_upload_path;?>

<?php foreach($project['phases'] as $phase): ?>

<li class="clearfix">

<div class="large-bullet"><?php echo ++$n; ?> </div>

<h1 class="phase-title"><?php echo $phase ?></h1>

<?php if(@count($documents[$n])>0): ?>

<ol class="documents">

<?php foreach($documents[$n] as $doc): ?>
<li>
<a href="<?php echo $this->redirect('documents/download/'.$doc['path'], true); ?>">
<?php echo $doc['description']; ?> <br />
</a>

<?php //echo $doc['size']."K - "; ?>

<span class="date"><?php // echo date("F j, Y, g:i a", $doc['created']); ?></span>  
<?php // echo (isset($doc['uploaded_by']))? ", by ".$doc['uploaded_by']:""; ?>
                       <a href="/clientele/uploads/<?php echo $doc['path'];?>" class="lightbox"><?php echo '<img src="/clientele/uploads/'.$doc['path'].'" height="300" width="300">'; ?></a>
</li>
<?php endforeach;?>
</ol>

<?php else: ?>

<?php endif; ?>
</li>
<?php endforeach;?>
</ul>

<div class="sidebar">

<?php if(is_array($messages)): ?>
<div class="messagebar">Latest News</div><br />
<?php foreach($messages as $message): ?>

<div class="message clearfix">
           
<p class="body"><?php echo $message['message']; ?></p>
<span class="meta"> <?php // echo $message['posted_by']; ?></span>
</div>

<?php endforeach; ?>

<?php endif; ?>

</div>


<div class="clear"></div>
</div>
</div>

Hi. im baffled on this.

boss wants a traffic feed for the office so im using SimplePie to grab rss feeds and the google maps traffic overlay as a view of the roads. The trouble is when i do it via xampp locally it looks fine, but when i load into onto our local webserver (ubuntu 18.04 with apache) it only shows a small line and cant figure out why? any help is appreciated. The attached images are how my local xampp sees it and the other is via the ubuntu 18.04 with apache, php & mysql installed  My Code is below

	<?php
// Include the SimplePie library
require_once('php/autoloader.php');
 
// Because we're using multiple feeds, let's just set the headers here.
header('Content-type:text/html; charset=utf-8');
 
// These are the feeds we want to use
$feeds = array(
	'http://m.highwaysengland.co.uk/feeds/rss/AllEvents.xml',
	'https://traffic.wales/feeds/incidents-events/rss.xml',
	'https://traffic.wales/feeds/roadworks/rss.xml',
	'https://trafficscotland.org/rss/feeds/currentincidents.aspx',
	'https://trafficscotland.org/rss/feeds/roadworks.aspx'
);
 
// This array will hold the items we'll be grabbing.
$first_items = array();
 
// Let's go through the array, feed by feed, and store the items we want.
foreach ($feeds as $url)
{
    // Use the long syntax
    $feed = new SimplePie();
    $feed->set_feed_url($url);
    $feed->init();
 
	// How many items per feed should we try to grab?
	$items_per_feed = 5;
 
	// As long as we're not trying to grab more items than the feed has, go through them one by one and add them to the array.
	for ($x = 0; $x < $feed->get_item_quantity($items_per_feed); $x++)
	{
		$first_items[] = $feed->get_item($x);
	}
 
    // We're done with this feed, so let's release some memory.
    unset($feed);
}
 
// We need to sort the items by date with a user-defined sorting function.  Since usort() won't accept "SimplePie::sort_items", we need to wrap it in a new function.
function sort_items($a, $b)
{
	return SimplePie::sort_items($a, $b);
}
 
// Now we can sort $first_items with our custom sorting function.
usort($first_items, "sort_items");
 
 
// Begin the (X)HTML page.
?>
<!DOCTYPE html>
<html>
  <head>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no">
    <meta charset="utf-8">
    <title>Traffic Layer</title>
	  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
    		  	<style type="text/css">
	body {
		height: 100%;
		font:12px/1.4em Verdana, sans-serif;
		color:#333;
		background-color:#fff;
	}
 
	a {
		color:#326EA1;
		text-decoration:underline;
		padding:0 1px;
	}
 
	a:hover {
		background-color:#333;
		color:#fff;
		text-decoration:none;
	}
 
	div.header {
		border-bottom:1px solid #999;
	}
 
	div.item {
		padding-left:5px;
		border-bottom:1px solid #999;
	}
	div#site {
		padding:5px 0;
		width:300px;
	}
	      /* Always set the map height explicitly to define the size of the div
       * element that contains the map. */
      #map {
        height: 100%;
      }
      /* Optional: Makes the sample page fill the window. */
      html, body {
        height: 100%;
        margin: 0;
        padding: 0;
		}	
	 footnote, p{
		color:red;
		font:9px/1.4em Verdana, sans-serif;
	    font-weight:bold;
					}
	</style>
  </head>
  <body>

		
  <!-- NEW -->

	  <div class="row">
    <div class="col-md-2">
		  <!-- BOF Simple Pie News Feed Info -->

<div id="site">
 
	<?php
	foreach($first_items as $item):
		$feed = $item->get_feed();
		?>
 
		<div class="chunk">
			<h6><b><?php echo html_entity_decode($item->get_title(), ENT_QUOTES, 'UTF-8'); ?></a></b></h6>
 
			<?php echo $item->get_content(); ?>
 
			<?php if ($enclosure = $item->get_enclosure()): ?>
				<div>
				<?php echo $enclosure->native_embed(array(

				)); ?>
				</div>
			<?php endif; ?>
 
			<p class="footnote">Source: <?php echo $feed->get_title(); ?></a> | <?php echo $item->get_date('j M Y | g:i a'); ?></p>
		</div>
 
	<?php endforeach; ?>

 
</div>
	  
			<!-- EOF Simple Pie News Feed Info -->	</div>
    <div class="col-md-10">
		  <!-- BOF Map Info -->

	<div id="map"></div>
    <script>
      function initMap() {
        var map = new google.maps.Map(document.getElementById('map'), {
          zoom: 7.4,
          center: {lat: 53.8059821, lng: -1.6057714}
        });

        var trafficLayer = new google.maps.TrafficLayer();
        trafficLayer.setMap(map);
      }
    </script>
    <script async defer
    src="https://maps.googleapis.com/maps/api/js?key=<My Google API Key>&callback=initMap">
    </script>
<!-- EOF Map Info --></div>
</div>

<!--OEF Test -->
</script>
  </body>
</html>

hi,

im getting the error

Quote

Fatal error: Call to undefined function notification() in C:\xampp\htdocs\xampp\index.php on line 21


after including the functions.php file i wrote. It does include it but the data isnt being recognised from it. If i copy/paste the notification() function into index.php it works.

Can someone tell me why so i can fix it?

Hello!

i am new to php. I need help to get all the displayed information in the mail, see below. I dont get the phone information. 

Thanks in adwansed

<?php



// anger en variabel som kan lagra de eventuella felaktigheterna 

$errors = array(); 

// kontrollera om ett Förnamn angivits 

if (!$_POST["namn"]) 

$errors[] = "- NAMN"; 

// kontrollera om ett TELEFONNUMMER angivits 

if (!$_POST["phone"]) 

$errors[] = "- TELEFONNUMMER";

// kontrollera om ett TELEFONNUMMER angivits 

$emailcheck = $_POST["email"]; 

if(!preg_match("/^[a-z0-9\å\ä\ö._-]+@[a-z0-9\å\ä\ö.-]+\.[a-z]{2,6}$/i", $emailcheck)) 

$errors[] = "- din E-POSTADRESS saknas eller är felaktig"; 

// kontrollera om ett Meddelande angivits 

if (!$_POST["message"]) 

$errors[] = "- inget MEDDELANDE har skrivits!"; 

 

if (count($errors)>0){ 

echo "<h1>Felmeddelande:</h1> 

<strong>Följande information måste anges innan du kan skicka formuläret:</strong><br /><br> 

"; 

foreach($errors as $fel) 

echo "$fel <br />"; 

echo "<br />Ange den information som saknas och skicka formuläret igen. Tack! <br />"; 

echo "<a href='javascript:history.go(-1)'>klicka här för att komma tillbaka till formuläret</a>"; 

} 

else { 

// formuläret är korrekt ifyllt och informationen bearbetas 

$to = "mailo@mail.com"; 

$from = $_POST["email"]; 

$subject = 'Kontakt från webbplatsen!'; 

$namn = $_POST["namn"]; 

$phone = $_POST["phone"]; 

$message = $_POST["message"]; 



######################################################################## 

// HEADERS för innehållstyp och textkodning 

$headers = "Content-Type: text/plain; charset=utf-8 \r\n";  

$headers .= "From:".$namn." <".$from.">"."\r\n";  

$headers .= "MIME-Version: 1.0 \r\n"; 

######################################################################## 





// Mailfunktionen som skickar bekräftelsen

if (mail($to, $subject, $message, $headers))

    echo nl2br("<h2>Tack $namn! 

Ditt meddelande har skickats!</h2> 



//###I WANT ALL THIS IN THE MAIL###

<b>Mottaga </b> $to

<b>Namn:</b> $namn

<b>E-Mail:</b> $from

<b>Telefonnummer:</b> $phone

<b>meddelande:</b> <br/>$message 



"); 

     

else

    echo "Det gick inte att skicka ditt meddelande";

} 

?>

 

why this simple code only works on chrome??

function mostrarOcultar(obj) {
  document.getElementById('seguro').style.visibility = (obj.checked) ? 'hidden' : 'visible';
}

Hello,

im using a contact form which sends me an email with the data name.. comments ..

Now im testing a new better server which use IMAP (old POP3) and my form is not working like it used to be..

Code: [Select]
                $emailTo = " $dbSentEmail"; //Put your own email address here
$emailServer = "noreply@totalsports.com.cy"; //Put your own email address here
$body = "Name: $name \n\nEmail: $email \n\nSubject: $subject \n\nComments:\n $comments";
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/plain; charset=UTF-8' . "\r\n";
$headers .= 'From: Contact Form <'.$emailServer.'>' . "\r\n" . 'Reply-To: ' . $email;

mail($emailTo, $subject, $body, $headers);

Any idea what i have to do to work like before?

ok , i made a friends thing  and its to hard to work with so i need to change it to where it has it own table ... i had it in an array in a table with other things , and now its hard to get it from the array so i want to make it simpler ... so here is my code and what i want to do , i need help and thank you in advance

here is my part 1 of my adding people as friends.
Code: [Select]
<?php
if ($_POST["request"] == "requestFriendship") {

    $mem1 = preg_replace('#[^0-9]#i', '', $_POST['mem1']); 
    $mem2 = preg_replace('#[^0-9]#i', '', $_POST['mem2']); 
//
if (!$mem1 || !$mem2 || !$thisWipit) {
echo  'Error: Missing data';
     exit(); 
}
//
if ($mem1 == $mem2) {
     echo  'Error: You cannot add yourself as a friend';
     exit(); 
} 

$sql_frnd_arry_mem1 = mysql_query("SELECT friend_array FROM myMembers WHERE id='$mem1' LIMIT 1"); 
while($row=mysql_fetch_array($sql_frnd_arry_mem1)) { $frnd_arry_mem1 = $row["friend_array"]; }
$frndArryMem1 = explode(",", $frnd_arry_mem1);
    if (in_array($mem2, $frndArryMem1)) { echo  'This member is already your Friend'; exit(); }

$sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1");
$numRows = mysql_num_rows($sql);
if ($numRows > 0) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> You have a Friend request pending for this member. Please be patient.';
        exit(); 
}
$sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1");
$numRows = mysql_num_rows($sql);
if ($numRows > 0) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> This user has requested you as a Friend already! Check your Requests on your profile.';
        exit(); 
}
$sql = mysql_query("INSERT INTO friends_requests (mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("Friend Request Insertion Error"));
//$sql = mysql_query("INSERT INTO pms (to, from, time, sub, msg) VALUES('$mem2','XXXXX',now(),'New Friend Request','You have a new Friend Request waiting for approval.<br /><br />Navigate to your profile and check your friend requests. <br /><br />Thank you.')") or die (mysql_error("Friend Request PM Insertion Error"));
    //$id = mysql_insert_id();
echo '<img src="images/round_success.png" width="20" height="20" alt="Success" /> Friend request sent successfully. This member must approve the request.';
    exit(); 
}
?>Now i need to change my code to where it inserts all this info and stuff not as an array and , in another table which is called "friends" my table is set up like this
Code: [Select]
-- Table structure for table `friends`

CREATE TABLE IF NOT EXISTS `friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_1` int(11) NOT NULL,
  `mem_2` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


So please if im not clear enough i will post more details

hi every one
i want to make a list from my database and if user click on one item it open a link... its a list of models of products so if click in one link me to the page of its full description, my database has the fields: "modelo" (model), and "paginal" the link page i make this code.. works fine cause display all the catalog but when i click in an item dont do nothing... hes the code.. what im missing??
tnx in advance


    <?PHP
// Connect to MySQL Server
@mysql_connect('localhost','user','password') or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db('zerocctv_almacen') or DIE("Couldn't Select Database");
$sql = "SELECT modelo, paginal,precio,foto FROM modelos";
$result=mysql_query($sql);
$row_array=mysql_fetch_row($result);
$string='<select name=selection><option value=>modelo</option>';

for ($i=0;$i < mysql_num_rows($result);$i++)
{
if ($row_array[0]=="")
{
$row_array=mysql_fetch_row($result);
}
else
{
$string .='<option value="'.$row_array[1].'">'.$row_array[0]."</option>";
$row_array=mysql_fetch_row($result);
}
}
$string .='</SELECT>';
//echo "</label>";
echo $string;
?>

As expected when a die statement is triggered, my script is exited and ALL of the fields that have been filled in on my form are wiped clean. 
This however is proving to be annoying for users making mistakes. 
Is there a way to keep the data in the correctly filled in fields, and to just wipe or highlight the incorrectly filled in fields?

Code: [Select]
<?php 
 function checkPostcode (&$toCheck) 
 { 
 $alpha1 = "[abcdefghijklmnoprstuwyz]";                           
 $alpha2 = "[abcdefghklmnopqrstuvwxy]";                          
 $alpha3 = "[abcdefghjkstuw]";                                   
 $alpha4 = "[abehmnprvwxy]";                                       
 $alpha5 = "[abdefghjlnpqrstuwxyz]";                               
 $pcexp[0] = '^('.$alpha1.'{1}'.$alpha2.'{0,1}[0-9]{1,2})([0-9]{1}'.$alpha5.'{2})$';  
 $pcexp[1] =  '^('.$alpha1.'{1}[0-9]{1}'.$alpha3.'{1})([0-9]{1}'.$alpha5.'{2})$';
 $pcexp[2] =  '^('.$alpha1.'{1}'.$alpha2.'[0-9]{1}'.$alpha4.')([0-9]{1}'.$alpha5.'{2})$';
 $pcexp[3] =  '^(gir)(0aa)$';  
 $pcexp[4] = '^(bfpo)([0-9]{1,4})$';
 $pcexp[5] = '^(bfpo)(c\/o[0-9]{1,3})$'; 
 $Postcode = strtolower($toCheck);
 $Postcode = str_replace (' ', '', $Postcode);
 $valid = false;
 foreach ($pcexp as $regexp) {    
 if (ereg($regexp,$Postcode, $matches)) {      
 $toCheck = strtoupper ($matches[1] . ' ' . $matches [2]);    
 $toCheck = ereg_replace ('C\/O', 'c/o ', $toCheck);
 $valid = true;
 break;     
 }  
 }  
 if ($valid){return true;} else {return false;};
 }
if(isset($_POST['submit']))
{
$drop = mysql_real_escape_string($_POST['drop_1']);
$tier_two = mysql_real_escape_string($_POST['Subtype']);
$Name = mysql_real_escape_string($_POST["Name"]);
$Phone = mysql_real_escape_string($_POST["Phone"]);
$Email = mysql_real_escape_string($_POST["Email"]);
$Postcode = mysql_real_escape_string($_POST["Postcode"]);
$Website = mysql_real_escape_string($_POST["Website"]);
if($Name == '')
{
die ("<div class=\"form\">You did not complete the name field, please try again</div>");
}
elseif  ($Phone == '' or (preg_match("/^([1]-)?[0-9]{3}-[0-9]{3}-[0-9]{4}$/i", $Phone)))
{
die("<div class=\"form\"> You completed the telephone field incorrectly, please try again</div>");
}
elseif  ($Email == '' or (!filter_var($Email, FILTER_VALIDATE_EMAIL)))
{
die("<div class=\"form\"> You completed the Email field incorrectly, please try again</div>");
}    
elseif  ($Postcode == '' or (!checkPostcode($Postcode)))
{
die("<div class=\"form\"> You did not complete the Postcode field correctly, please try again</div>");
}   
elseif  ($Website == '' or (!preg_match("~^[a-z0-9.-]+\.(com|org|net|edu|co.uk)~i", $Website)))
{   
die("<div class=\"form\">You completed the website field incorrectly, please try again</div>");
}
else
{
echo("<div id=\"formtwo\">Thankyou for submiting your details, you will be added to our directory shortly</div>");
}
$query = ("INSERT INTO business (`id`, `Name`,  `Type`, `Subtype`, `Phone`, `Email`, `Postcode`, `WebAddress`, `Confirmed`)
  VALUES ('NULL', '$Name', '$drop', '$tier_two' , '$Phone', '$Email', '$Postcode', '$Website', 'Yes')");
mysql_query($query) or die ( "<br>Query: $query<br>Error: " .mysql_error());
}
?>

hi everyone

i am currently making my website with an uploadform. The upload function is working, but now i am trying to make the site remember the last 5 uploads. The filenames should appear in an array:
$aotf[0]
$aotf[1]
$aotf[2]
$aotf[3]
$aotf[4]
and since all files that can be/are uploaded are images, i want them to be drawed next to each other, each 128x128. THAT is working, but the fetch for images doesn't. When an image is uploaded, i execute this code:
    $readhandle=fopen("uploaddb.log","r");
    $aotf=fread($handle,filesize("uploaddb.log"));
    fclose($readhandle);
    $writehandle=fopen("uploaddb.log","w");
    fwrite($writehandle,"$aotf\r\n" . "uploadform/gebruikers/" . $naam);
    fclose($writehandle);
then,there is some html code, and then there is this code:

$aotf=explode("/n",$aotf);
for($i = count($aotf) - 5; $i <= count($aotf); $i++) {
echo ' <img src="'. $aotf[$i] . '" width="128" height="128"> ';
}

when i open the page, all img src's are empty. The writing works, and the folder of the image is 7777 chmod and the images draw on the screen, but not as the last uploaded. Does anyone know how to make this work? maybe even without a fwrite?


Thank you,

masterens

EDIT: i cannot use mysql

I am building a commenting system, it's sort of like facebooks comments. I have it right now so it loads the first last 3 comments in the database, and then there's a button to view all comments. I have it working fine, except when you add another comment to it, and then click the view all comments,


This is the script that loads onload showing the last 3 comments


$limit  = 3;

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$id' ORDER BY id DESC LIMIT $limit");



This is the php script that runs when you click view more




//($start_id would be 3 in this case)

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$comment_id' ORDER BY id DESC LIMIT $start_id, 1000");

so to try to show you what's happening:

OnLoad--------------------------------|---When you add more comments, (let's just say u add 1 comment before u click view comments)----
comment 9   --------------------------|   comment 10
comment 8   --------------------------|   comment 9
comment 7   --------------------------|   comment 8
------------------------------------------|   comment 7
----to be loaded onclick-------------|------What's loaded onclick---
comment 6   --------------------------|   comment 7
comment 5   --------------------------|   comment 6
comment 4   --------------------------|   comment 5
comment 3   --------------------------|   comment 4
comment 2   --------------------------|   comment 3
comment 1   --------------------------|   comment 2
------------------------------------------|   comment 1


(see how "comment 7" is being shown twice in a row)

Hi,

my page is currently up at brewhas.org/transactions.php.  When I retrieve a set of results > the defined # per page (such as entering 'WI' for last name), I see the first page correctly, and see the links to next pages, but when I go to the next page there are no results displayed.  Same for p.3, etc.

So I've looked around enough to know that I need to pass a variable to the subsequent pages, either via a session variable or the URL.  I have 2 fields input on the form, as well as a limit and offset.  My questions are 1) do I need to pass all 4 and if so then should I use a session variable so the URL does not get too long, and 2) can anyone provide any help with setting session variables and including them to be passed?

I'm a newbie and have grabbed some code where I can but this is where i'm stuck.  thanks in advance.
Code: [Select]
         <?php
               include 'config.php';
               include 'opendb.php';
               $rows_per_page = 20;

                  //Get the values from the text boxes         
                  $fnamesearch = $_POST["fnamesearch"];
                  $lnamesearch = $_POST["lnamesearch"];

                  //These trim and convert the name fields to upper case.
                  $fnamesearch=strtoupper($fnamesearch);
                  $lnamesearch=strtoupper($lnamesearch);
                  $fnamesearch=trim($fnamesearch);
                  $lnamesearch=trim($lnamesearch);
            
                  // Count how many rows are coming back for the query
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT COUNT(*) FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%'))";
                     }

                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the get count query
                  $query_data = mysql_fetch_row($result);
                  $numrows = $query_data[0];
                  echo "count: ".$numrows;   
                  $lastpage = ceil($numrows/$rows_per_page);      //determines how many pages based on rows divided by rows per page
                  echo "pages: ".$lastpage;

                  // Get required page number.  If not present, default to 1.
                  if (isset($_GET['pageno']) && is_numeric($_GET['pageno'])) 
                     {$pageno = $_GET['pageno'];
                     } 
                  else 
                     {$pageno = 1;
                     } 
                  
                  //Checks that the value of $pageno is an integer between 1 and $lastpage.
                  $pageno = (int)$pageno;
                  if ($pageno > $lastpage) 
                     {$pageno = $lastpage;
                     } 
                  if ($pageno < 1) 
                     {$pageno = 1;
                     }                  
               
                  //constructs OFFSET for the sql SELECT statement
                  $offset = ($pageno - 1) * $rows_per_page;
                  
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT * FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%')) LIMIT $offset, $rows_per_page";
                     }
      
                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the query
                  //Count the number of results 
                  $numrows=mysql_num_rows($result);
                  
                  echo "<p class='style7'>Your search: &quot;".$fnamesearch." ".$lnamesearch."&quot; returned <b>".$numrows."</b> results.</p>";
                  
                  if ($numrows == 0)  //if no matches, don't display the table 
                        exit;
                  else            //build the table and insert rows 
                     {
                              echo "<table border=1 cellspacing=0 cellpadding=1 width='77%' align=left bordercolor=#666666>";
                              echo "<tr bgcolor=#cccc99 class='style5'><th width='10%' class='style5'>Date</th>";
                              echo "<th width='10%' class='style5'>Action</th>";
                              echo "<th width='12%' class='style5'>From</th>";
                              echo "<th width='12%' class='style5'>To</th>";
                              echo "<th width='5%' class='style5'>Pos</th>";
                              echo "<th width='18%' class='style5'>Name</th>";      
                              echo "<th width='5%' class='style5'>Round</th></tr>";                     
      
                           while ($row = mysql_fetch_array($result))
                           {
                              echo "<tr><td width='10%' class='style6'>".$row['TRANS_DT']."</td>";
                              echo "<td width='10%' class='style6'>".$row['TRANS_ACTION']."</td>";
                              echo "<td width='12%' class='style6'>".$row['FROM_OWNER']."</td>";
                              echo "<td  width='12%' class='style6'>".$row['TO_OWNER']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['POSITION']."</td>";
                              echo "<td  width='18%' class='style6'>".$row['PLAYER_FNAME']." ".$row['PLAYER_LNAME']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['DRAFT_RND']."</td></tr>";
                           }
               
                           /******  build the pagination links ******/   
                           // if not on page 1, don't show back links
                           if ($pageno > 1) {
                              // show << link to go back to page 1
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'><<</a> ";
                              // get previous page num
                              $prevpage = $pageno - 1;
                              // show < link to go back to 1 page
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'><</a> ";
                           }
                           // range of num links to show
                           $range = 3;

                           // loop to show links to range of pages around current page
                           for ($x = ($pageno - $range); $x < (($pageno + $range)  + 1); $x++) {
                              // if it's a valid page number...
                              if (($x > 0) && ($x <= $lastpage)) {
                                // if we're on current page...
                                if ($x == $pageno) {
                                  // 'highlight' it but don't make a link
                                  echo " [<b>$x</b>] ";
                                // if not current page...
                                } else {
                                  // make it a link
                                  echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$x'>$x</a> ";
                                } // end else
                              } // end if 
                           }
                           // if not on last page, show forward and last page links        
                        if ($pageno != $lastpage) {
                           // get next page
                           $nextpage = $pageno + 1;
                           // echo forward link for next page 
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>></a> ";
                           // echo forward link for lastpage
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>>></a> ";
                        } // end if
                        /******  end build pagination links ******/               
                        echo "</table>";
                     }      
                  mysql_free_result($result);    //release the result set from the table
                  mysql_close($conn);          //close the connection to the db
               ?>

MOD EDIT: [code] . . . [/code] tags added.