PHP - Moved: Problem With Css Character Limit Border Thing Idk Help.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342142.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=342991.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319167.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=354388.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=321386.0

Unless buffer overflows or breaking out of code to perform a new command are problems that have been solved....

I am trying to figure out the proper PHP method for setting a boundary on a variable within a script. I have this variable $name which is fed a value from $_POST['name'] from a form field. Now this form field is limited in the HTML to accept only 20 characters, but someone could easily edit the form or outgoing post data. So I want to know how to limit the variable size in the script. In other languages it could be something like this: var name(20). So how do I do that in PHP?

If a LIMIT on rows is set by the dropdown, the Pagination links do not reflect this. For example, if you had 100 rows showing 25 records per page, the pagination should show 4 pages, whereas if there were 10 records per page it should show 10 pages.
At the moment, the pagination shows 4 pages (which is correct for the page default of 25 records) but if someone chooses to show 10 records per page, it still only shows the 4 pages in the pagination links and if you click one it takes you the relevant page, ignoring the user selected LIMIT. If a user selects 5 records per page in the dropdown and then clicks page 2 in the pagination it shows records 26-50 when it should really show records 6-10.

On the flip side, without selecting a number of rows in the dropdown, if you click on page 2 it shows records 26-50 and if you then choose 5 in the dropdown it does show the first 5 from that page (ie 26-30).
So they do sort of work together but I would really like the pagination to alter depending on the number of rows selected.

I hope that has not confused everyone too much but below is the code that I am using, in full as everything is related it seems. I have commented it as best I can to try to clear things up but if it would be better for me to break it down into the relevant bits then just shout!

There are two sets of pagination on there, top and bottom, and the top one is after the
Code: [Select]
// TOP PAGINATIONcomment

and the form for the dropdown is after
Code: [Select]
// LIMIT ROWS DROPDOWN
If anyone can explain how I can get this to work properly, or whether it is even possible, I would be extremely grateful!

Thanks in advance
Steve

  Code: [Select]
<?php require_once('../../Connections/Test.php'); ?>

<?php
// Make a MySQL Connection
mysql_select_db($database_Test, $Test);

// How many rows to show per page
$rowsPerPage = 25;

// Show the first page by default
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}

// Counting the offset to show the right records per page
$offset = ($pageNum - 1) * $rowsPerPage;

// Retrieve all the data from the seasons table
$query = "SELECT *,
DATE_FORMAT(`season_start`,' %D %M %Y') AS startdate,
DATE_FORMAT(`season_end`,'%D %M %Y') AS enddate
FROM seasons ";
$query .= ( isset($_POST['records_per_page']) && intval($_POST['records_per_page']) > 0 ) ? 'LIMIT ' .$offset.',' . (int) $_POST['records_per_page'] : 'LIMIT ' .$offset.',' . $rowsPerPage;

$result = mysql_query( $query ) or die('Query: ' . $query . '<br>Produced error: ' . mysql_error() . '<br>');


//Query for the DECADES INDEX at the top
$links = mysql_query("SELECT DISTINCT SUBSTRING(season_name,1,3) as letter FROM seasons ORDER BY 1") or die(mysql_error());

// PAGINATION
// Find the number of records
$page_query   = "SELECT COUNT(season_name) AS numrows FROM seasons";
$page_result  = mysql_query($page_query) or die('Error, query failed');
$page_row     = mysql_fetch_array($page_result, MYSQL_ASSOC);
$page_numrows = $page_row['numrows'];

// Divide the number of records by records per page to get number of pages
$maxPage = ceil($page_numrows/$rowsPerPage);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Season List</title>
<link href="../../styles/databaseedit.css" rel="stylesheet" type="text/css" />


</head>

<body>

<div class="container">
  <?php include("/homepages/46/d98455693/htdocs/Templates/database/header.html"); ?>
 <?php include("/homepages/46/d98455693/htdocs/Templates/database/left.html"); ?>
  <div class="content">
    <h1>
      SEASON LIST</h1>
    <p>Filter by Decade<br />
      <?php
// DECADES LISTING AT TOP OF PAGE
// Fetch the records of the DECADE $row
while($linkrow = mysql_fetch_array($links))
{
// Show links to DECADE queries and add "0's" to the result
echo '<a href="seasonslistdecades.php?searchstring=';
echo $linkrow['letter']. '">'.$linkrow['letter'].'0\'s</a> ';
}
?>
    </p>
    <hr />
   <?php 
// TOP PAGINATION
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   } 
}

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\"><a href=\"$self?page=$page\"><img src=\"../../images/icons/Prev.png\" height=\"20\"  alt=\"Previous\" title=\"Previous Page\" /></a> ";

   $first = " <a href=\"$self?page=1\"><img src=\"../../images/icons/First.png\" height=\"20\"  alt=\"First\" title=\"First Page\" /></a> ";
} 
else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\"><img src=\"../../images/icons/Next.png\" height=\"20\"  alt=\"Next\" title=\"Next Page\" /></a> ";

   $last = " <a href=\"$self?page=$maxPage\"><img src=\"../../images/icons/Last.png\" height=\"20\"  alt=\"Last\" title=\"Last Page\" /></a> ";
} 
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}

// print the navigation link
echo $first . $prev . $nav . $next . $last;?>

// LIMIT ROWS DROPDOWN
   <div class="drop_right" ><form action="" method="post" name="records_per_page" target="_self">
     Number of Records per page
     <select name="records_per_page" id="records_per_page">
       <option value="5">5</option>
       <option value="10">10</option>
       <option value="15">15</option>
       <option value="20">20</option>
       <option value="25">25</option>
       <option value="30">30</option>
       <option value="40">40</option>
       <option value="50">50</option>
   </select> <input type="submit" name="SUB" id="SUB" value="Submit" />
   </form></div>
<p>
      <?php
// SEASONS LISTING
// Show the Table Headers
  echo '
  <table  align="center" cellspacing="0" cellpadding="0">
  <tr>
  <th>ID</th>
  <th>Name</th>
  <th>From</th>
  <th>To</th>
  <th>Edit</th>
  </tr>
  ';
 
// Show the Season Data
  while($row = mysql_fetch_array($result))
{
echo '
<tr>
    <td>'.$row['season_id'] .'</td>
<td>'.$row['season_name'] .'</td>
    <td>'.$row['startdate'] .'</td>
    <td>'.$row['enddate'] .'</td>  
<td><img src="../../images/icons/Search.png" height="20"  alt="View" /> 
<img src="../../images/icons/Edit.png" height="20"  alt="Edit" />
  <img src="../../images/icons/Close.png" height="20"  alt="Delete" /></td>
   </tr>
' ;
}
echo '</table> ';


// BOTTOM PAGINATION
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   } 
}

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\"><a href=\"$self?page=$page\"><img src=\"../../images/icons/Prev.png\" height=\"20\"  alt=\"Previous\" title=\"Previous Page\" /></a> ";

   $first = " <a href=\"$self?page=1\"><img src=\"../../images/icons/First.png\" height=\"20\"  alt=\"First\" title=\"First Page\" /></a> ";
} 
else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\"><img src=\"../../images/icons/Next.png\" height=\"20\"  alt=\"Next\" title=\"Next Page\" /></a> ";

   $last = " <a href=\"$self?page=$maxPage\"><img src=\"../../images/icons/Last.png\" height=\"20\"  alt=\"Last\" title=\"Last Page\" /></a> ";
} 
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}

// print the navigation link
echo $first . $prev . $nav . $next . $last;
?>
      <br />
    <p>&nbsp;</p>

    <!-- end .content --></div>
  <div class="footer">
    <p>This .footer contains the declaration position:relative; to give Internet Explorer 6 hasLayout for the .footer and cause it to clear correctly. If you're not required to support IE6, you may remove it.</p>
    <!-- end .footer --></div>
<!-- end .container --></div>
</body>
</html>

Hi people!
I have a form with a select list where options are populated from a table in my db..
the string format is like this -> car - branch (ex. toyota - japan so on..)
when viewing the options it displays correctly with the "-" but when i tried submitting the form which will be inserted into the db
the "- branch" gets cut off..
i think i need to encode it but i don't know how to do it..

thanks for any reply! 

I have got a set of data for a country for each week of the year, but want to display the data a quarter at a time, using a form which posts a value into LIMIT, which was OK for the 1st quarter, but for subsequent quarters I needed to use LIMIT in the form LIMIT start, rows. I found by experiment that this had to be the last statement in the query. when I added the start I got an error: Parse error: syntax error, unexpected ',' in /homepages/43/d344817611/htdocs/Admin/Visitdata.php on line 10 Here is the SQL part of my code:

$Visit_data="SELECT WeekNo.WNo, WeekNo.WCom, Countries.Country, ctryvisits.CVisits FROM ctryvisits 
LEFT JOIN Countries
ON ctryvisits.country=Countries.CID
LEFT JOIN WeekNo
      ON ctryvisits.WNo=WeekNo.WNo
      WHERE Countries.Country = '".$_POST["Country"]."'
ORDER BY ctryvisits.WNo LIMIT '".$_POST["QUARTER"]."'" - 13, '".$_POST["QUARTER"]."'";

Is this the best way of doing what I require or is there an easier way of achieving what I want?

I submit text to my MySQL database using a form on my site. When I look at the text in my database, sometimes, there are strange characters. The strange characters are caused by quotation marks, em dashes, apostrophes and foreign letters of the alphabet. I think that this only happens when the source of the text is a Windows program. I understand that this is a character encoding issue, but I don't fully understand the subject. I've spent the last few hours researching it, but it's only confused me.   My site uses UTF-8 encoding:

<meta http-equiv="content-type" content="text/xml; charset=utf-8" />

The collation of my database is utf8_general_ci.   My form looks like this:

<form action="" method="post">
</form>

As you can see, an accept-charset="utf-8" attribute has not been specified.     Questions   1) I am guessing that my problem is that the Windows characters are being misinterpreted by my UTF-8 setup. Is that correct?   2) If so, is there a way that I can safely convert the Windows characters to UTF-8 during the submission process?   3) Should I also specify an accept-charset="utf-8" attribute on the form?   4) When I paste the Windows text directly into my database without using the form, the characters save without turning into the strange characters. But they don't render properly on my site. Can't browsers identify Windows characters?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=354033.0

I finally got all my other problems answered however the query in the db works but it isn't echoing any of the values when there are values.

<div id="roster" class="content">
<h1 class="pageheading">Singles Biographies</h1>
<span class="minilinks"><a href="/roster/tag-team-roster">Tag Teams</a> | <a href="/roster/stable-roster">Stables</a> | <a href="/roster/manager-roster">Managers</a> | <a href="/roster/referee-roster">Referees</a> | <a href="/roster/staff-roster">Staff</a></span>

<?php      
$query = "SELECT 
    characters.shortName, 
    characters.characterName,
    singles.height,
    singles.weight,
    singles.hometown
FROM 
    characters
    LEFT JOIN singles as singles 
        ON characters.ID = singles.characterID 
WHERE 
    characters.styleID = '1' AND characters.statusID = 1
ORDER BY 
    characters.sortOrder";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  $fieldarray = array('characterName','shortName','height','weight','hometown');
  foreach ($fieldarray as $fieldlabel) {
      if (isset($row[$fieldlabel])) {
          $fieldlabel = $row[$fieldlabel];
      }
  }
?>
<div id="wrestler">
<div id="headshot">

<?php 
        if (file_exists('/images/headshots/' . $shortName . '.png')) {
            print '<img src="images/headshots/' . $shortName . '.png">';
        } else {
            print '<img src="images/headshots/default.png">';
        }
        ?>

</div>
<div id="wrestler-info">
<div id="wrestler-info"><p><span class="rostername"><a class="biolinks" href="/bio?username=<?php echo $shortName ?>"><?php echo $characterName ?></a></span><br />
          Height: <?php echo $singlesheight ?><br />
          Weight: <?php echo $singlesweight ?><br />
          Hometown: <?php echo $singleshometown ?><br /></p>
          </div>

</div>


</div>
<div class="clear"></div>
<?php 
}
?>
</div>

Wonder if any of you had this before.

I'm pulling data from db for given day, and display them in a table. After, as extra feature, I'm running a quick query checking how many record are in the db for given day and dispaying result.

The count works correctly - it shows the actual number of records in db, but the first part of the code - the listing of record - always skips the first record.

So the count returns i.e. 7 record, but on the listing shows only 6.
 
Here's the listing part of the code. Also you might notice a bit "messy" use of odbc_fetch_row and odbc_fetch_array, but that had to do with controlling situation when there was no records in db - I'll clean it up later

Any ideas or solutions welcomed


echo "<table border=0 class=\"report-font-table\"><tr bgcolor=#CCCCCC><td><b>MODEL</b></td><td><b>SERIAL NUMBER</b></td><td><b>INSPECTOR</b></td><td><b>COMMENTS/FAILS</b></td></tr>";
$MySQL1 = 'select Model, Serial_no, Inspector, Comment from CM_Audit where Date=#'.$new_date.'#';
$MyCon=odbc_connect('SQA_Typewriter','','') ;         // use the SQA_Typewriter ODBC
$result=odbc_exec($MyCon,$MySQL1);

$check1=odbc_fetch_array($result);

if (!empty($check1)) {
   while (odbc_fetch_row($result)) {
    echo "<tr>
                <td>".odbc_result($result,"Model")."</td>
                <td >".odbc_result($result,"Serial_no")."</td>
                    <td >".odbc_result($result,"Inspector")."</td>
                        <td >".odbc_result($result,"Comment")."</td>
            </tr>";
  }
  echo "</table>";

      odbc_close($MyCon);
} else {
    echo "</table><p style=font-weight:bold;color:006699>No audits have been carried out on this day.</p>";
}

I am running a search query from MYSQL and it works, but now I want to get a little custom.

I am selecting one field, out of many called paid1 which in database is either Yes or No. I want to do this: if paid1 is NO display Pay Now and everything else display Yes. I want this to be under new heading of paid1b. So the code should look something like this:

$paid1b= if(['paid1'}==No){echo "Pay Now";} else {echo "YES";}

But I am missing something somewhere. What is it?
Thanks

if ($TypeOfPage == 'englandtrinityhouse' || 'welshtrinityhouse' || 'channelislandstrinityhouse'){

  

$Op = '<input type="text" name="Operator" value="Trinity House" class="Operator">';

}

else {

if ($TypeOfPage == 'northernlighthouseboard'){

$Op = '<input type="text" name="Operator" value="Northern Lighthouse Board" class="Operator">';

}

else {

$Op = '<input type="text" name="Operator" class="Operator">';

}

}

This code always echos the first option when echo'd. Ive checked the var is different each time, eg 'northernlighthouseboard' or 'private'.

Anyone care to explain?!
danny