PHP - How To Get The Page Count Of A Tiff And Pdf File

Hello,

I have a layered tiff file. I want to create a GD image from one of its layers. Looking for something like:

imagecreatefromtiff($img, 2);

Any idea of a library that would support this?

is this possible?

Hi guys,

i have an array of data, with customers and their pics.
something like:

Quote

array (customerid=>customerpic,...........);

something like
Quote

123412=>'https://mylink.com/mypic343545.tiff'
433453=>'https://mylink.com/mypic3434345.tiff'


my goal is to:
1. go through the array and download all the pics, with names like customerid.tiff
2. when done renaming, make a zip file ON-THE-FLY
3. download the zip file to my PC.

i know i can use file_put_contents and things like that, but i am not able to really connect the dots, especially the zipping of them all on the fly.....anyone has an idea on this?

Alright guys i have an idea on what am going to do here, although i am unsure that it's the best way to go about it.

I am creating a blog and i need to count how many views an article gets in order to display the top 10 most viewed articles. Here is my plan...

1. Add an additional field to my blog posts table called viewed
2. On the view article page have an update method that adds one to the current number on the the coloum viewed
3. When displaying the 10 most viewed articles query it by the heightest number and limet to 5

Hello-

I have a social network that has a blogs and questions section. There are community pages for each one ( blogs/questions ) On each of those pages. the first ten blogs/questions are displayed. To the right of those are a list of clickable categories that sort the pages according to their category.

I have pagination implemented after each ten. I am doing a mod_rewrite for pretty urls on my dev and have everything working correctly. The problem is, after hitting next the first time 'page=' is blank and just reloads the first (defaulted page) but after a second click it becomes 'page=10' as it should and then the third click 'page=20" as it should.

So basically I am trying to get it to go to 'page=10" after one click, not two. Here is the code for the pagination:

Code: [Select]
<div id="all_page_turn">
                         <ul>

                            <?php if($totalBlogs > 10 && $_GET['page'] >= 10) { ?>
                             <li class="PreviousPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] - 10);} ?>">Previous Page</a>
                             </li>
                             <?php } ?>

                               <?php if($totalBlogs > 10 && $_GET['page'] < ($totalBlogs-10)) { ?>
                             <li class="NextPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] + 10);} ?>">Next Page</a>
                             </li>
                             <?php } ?>



                         </ul>
        </div>

</div>and here is the defaulted category link:

Code: [Select]
<div id="RightBlogs">
        <div id="search_blogs_future" class="round_10px">
        <form name="searchBlogs" action="/blogs" method="get">
            <input type="text" name="BlogSearch" class="text" value="<?php if(empty($_GET['BlogSearch'])) { echo "Search Blogs"; }else{ echo $_GET['BlogSearch'];} ?>" onclick="clearify(this);" />
             <input type="submit" name="subBlogSearch" value="Search" />
         </form>
     </div>
     <div class='<?php if(empty($_GET['cat']) || $_GET['cat'] == "All") { echo "all_blog_cats_Highlighted"; }else{ echo "all_blog_cats_unHighlighted"; } ?> round_10px'>
         <a href='/blogs/?cat=All'>
                 All
                 </a>
          </div>Here is a screen shot of the page, as I'm on my dev so I can't provide a link. you can't see the "next" button, but it's there on the bottom, and then the categories are on the right.

[attachment deleted by admin]

Hi Everyone,

I have an ecommerce store that I have done some coding for, and each category has some coding to create pages to display items in that category.  For some reason, I am getting a couple of "ghost" pages on the end of a couple categories.

For example, look at this page:  http://www.autismcommunitystore.com/view.php?category=4

Pages 5 & 6 are blank - page 4 has the last of the items in the category.  I have a table called prods_to_cats which connects the products and the categories (a many to many relationship).

I'm posting the code here - could someone just let me know if they spot something that looks like trouble?

Thank you in advance for your time!

Code: [Select]
<?
$category=$_REQUEST['category'];
$showcategory=$category;

include 'connect.php';

$thiscategory = mysql_query("SELECT * FROM category WHERE category_id=$showcategory", $dbh);
$thisrow = mysql_fetch_array($thiscategory);
$this_des=$thisrow["category_description"];
$this_text=$thisrow["category_text"];

$titlekey="Products listed in $this_des at Autism Community Store 877-422-5932";


// If current page number, use it
// if not, set one!

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

// Define the number of results per page
$max_results = 40;

// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);

echo  '<div id="product">';
$result = mysql_query("SELECT DISTINCT product.id, product.* FROM prods_to_cats INNER JOIN product ON prods_to_cats.id=product.id WHERE prods_to_cats.category_id=$showcategory ORDER BY product.title ASC LIMIT $from, $max_results", $dbh);
$numresult = mysql_num_rows($result);
if($numresult==0)
{
echo "<p style='padding-left: 50px'>There are no products listed in this category.</p>\n";
}
else
{

$thiscategory = mysql_query("SELECT * FROM category WHERE category_id=$showcategory", $dbh);
$thisrow = mysql_fetch_array($thiscategory);
$this_des=$thisrow["category_description"];
echo "<table width='100%'><tr>";

echo "<div style='position:relative; left:150px;'><font size='2'>Return To: <strong><a href='http://www.autismcommunitystore.com'>Home </a></strong></font></div><br/>";

echo "<div style='position:relative ; width:100%' align='center'>";
echo "<br />";
echo "<img src='http://www.watchesandthings.com/autism/images/suppliesHeader.gif'>";
echo "</div>";
echo "<h2>";
echo "<div style='padding-right:20px ; position:relative ; width;100%; text-align:right;'>";
echo "<div style='position:relative ; width;80%; text-align:center; left:20%;'>";
echo $this_des;
echo "</div>";
echo "</div>";
echo "</h2>";
echo "<div style='position:relative ; padding-left:30px ; padding-right:30px ; '>";
echo "<p>";
echo "$this_text </p>";
echo "</div>";
echo "</tr>";

$count = 1;
$column = 1; //initialize column 1 or 2


//-----------------------code for drop down menu----------------------------------------
include 'browserChecker.php';

/*
echo $browser;
echo "<br/>";
echo $browser_version;
echo "<br/>";
$main_version=$browser_version[0];
echo $main_version;
*/

if ($browser=='IE' && $browser_version<7){
echo '<br />';
//make version 6 compatible select box
if ($category==1 || $category==24){
}else{
?>

<center>
<div id="hiddendiv" style="display:;">
  <form method="get" enctype="multipart/form-data" action="http://www.autismcommunitystore.com/viewsubcategory.php">
  <select id="myselectbox" name="subcategory" >
  <?
$sql="SELECT * FROM subcategory ORDER BY sub_description ASC";
$result=mysql_query($sql, $dbh);

while($myrow=mysql_fetch_array($result))
{
if ($myrow['category_id']==$category){

$myrow['sub_description']

?>
    <option name="subcategory" value="<? echo $myrow['sub_id'] ?>"  ><? echo $myrow['sub_description'] ?> </option>
     <?
}//close if for category check
}//close drop down while loop

?>
</select>
  </center>
  <div id="go_subcat">
  <input type="submit"  value="&nbsp;&nbsp;GO&nbsp;&nbsp;" style="background-color: #E4DFF3; color: #6F5079; border: 2px solid #6F5079">
  </div>
  </form>
</div>
<?
}//end check category

}else{
//make normal select box


if ($category==1 || $category==24){
}else{
?><div style="z-index:2"><br /><form method="get" enctype="multipart/form-data" action="http://www.autismcommunitystore.com/viewsubcategory.php">
  <div align="center" style='z-index:5'>
  <select name="subcategory" size="1" style="background-color: #ffffff; color: #6F5079; border: 2px solid #6F5079">
    <?
$sql="SELECT * FROM subcategory ORDER BY sub_description ASC";
$result=mysql_query($sql, $dbh);

while($myrow=mysql_fetch_array($result))
{
if ($myrow['category_id']==$category){

?>
    <option name="subcategory" value="<? echo $myrow['sub_id'] ?>"  ><? echo $myrow['sub_description'] ?> &nbsp;</option>
     <?
}//close if for category check
}//close drop down while loop

?>
  </select>
  <input type="submit"  value="&nbsp;&nbsp;GO&nbsp;&nbsp;" style="background-color: #E4DFF3; color: #6F5079; border: 2px solid #6F5079">
  </div>
</form>
</div>

<?
}

}//end browser checker if


//-----------------------end code for drop down menu----------------------------------------


//reste variables
$result = mysql_query("SELECT DISTINCT product.id, product.* FROM prods_to_cats INNER JOIN product ON prods_to_cats.id=product.id WHERE prods_to_cats.category_id=$showcategory ORDER BY product.title ASC LIMIT $from, $max_results", $dbh);





echo "<TABLE cellspacing='20'>";
while($myrow = mysql_fetch_array($result))
{

extract($myrow);
$location=$image;
$price=$sale_price;
$item=$myrow["id"];
$stockstatus=$stat;
if($stat=='IN STOCK')
{
$stockstatus="";
}
else
{
$stockstatus="--Item Coming Soon--";
}
if($price>0)
{
$printout="<table border=0 height=70 width=250><tr><td width='100px' align='center' ><a href=http://www.autismcommunitystore.com/item/$item/><img src=http://www.watchesandthings.com/autism/files/thumbnails/$location border=0 alt=$product_id></a></td><td><a href=http://www.autismcommunitystore.com/item/$item/>$title</a><br><span class=prod-dollar>$$price</span><br>$stockstatus</td></tr></table>";
}
else
{
$printout="<table border=0 height=70 width=250><tr><td width='100px' align='center' ><a href=http://www.autismcommunitystore.com/item/$item/><img src=http://www.watchesandthings.com/autism/files/thumbnails/$location border=0 alt=$product_id></a></td><td><a href=http://www.autismcommunitystore.com/item/$item/>$title<br /><span class=prod-dollar>Click for Pricing</span></a><br>$stockstatus</td></tr></table>";
}
if ($column=="1")
{
echo "<tr><td>$printout</td>"; // first column
}
else {
echo "<td>$printout</td></tr>"; // 2nd column
}
// end of columns
$count += 1;
// this is a modulus operator it gets the remainder of the equation
$column = $count % 2;
} // end of while loop
echo "</table>";
;

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM prods_to_cats WHERE category_id=$showcategory"),0);
//$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM product"),0);

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);

echo "<p><center>Pages<br />";

// Build Previous Link
if($page > 1){
    $prev = ($page - 1);
    echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$prev'>&lt;&lt;Previous</a>&nbsp;";
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i&nbsp;";
        } else {
             echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$i'>$i</a>&nbsp;";
        }
}

// Build Next Link
if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$next'>Next>></a>";
}

echo "</center>";

}//end of else>

echo "</table>";
echo "</div>";
?>

Hey everyone,

So here is my problem. I have some code to display the amount of views that page has got. In this case it is the thread in my forums section. I have used the same code to show how many people have views a certain persons profile page and that works fine but when I use it on my forum thread page I get this error.

Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id='20' LIMIT 1' at line 1



Here is the section of code:

Code: [Select]
<?php
$thread_id = preg_replace('#[^0-9]#i', '', $_GET['id']);
$getThreadViews = mysql_query("SELECT view_count FROM forum_posts WHERE id='$thread_id' LIMIT 1") or die (mysql_error());
$row = mysql_fetch_assoc($getThreadViews);
$counter = $row['view_count'];

if($counter == 0){
$counter = 1;
$startCounter = mysql_query("INSERT INTO forum_posts (view_count) VALUES ('$counter') WHERE id='$thread_id' LIMIT 1") or die (mysql_error());
}

$threadViews = $counter+1;
$appendCounter = mysql_query("UPDATE forum_posts SET view_count='$view_count' WHERE id='$thread_id'") or die (mysql_error());

?>

I have checked that there are no spelling errors so just wanted to show it to a fresh pair of eyes because its really starting to annoy me.

Thanks in advance for any help.

I am trying to figure out the best way to record page impressions in my MySQL database. This count will be coming from multiple websites and webpages, so could be millions per day.

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?

This topic has been moved to MySQL Help.

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

Why am I getting this error when there are 3 Fields with 3 values?

Column count doesn't match value count at row 1

Code: [Select]
$sql5="INSERT INTO participants (participant_name, team_no, sport)
VALUES ('".implode("','$_POST[team]'),('",$_POST['participant_name'])."','$_POST[team]','$sport')";

Is there a code library out there that can read the exif data from image files, without the use of the php exif extension?  I have a Windows hosting package and am noticing that several hosts don't (and won't) enable the exif extension for PHP for some reason.  I need Windows for one of my sites which requires MS SQL access, so I can't use a Unix/Linux host because of that. But all of them support PHP on Windows.   Suggestions?

I was wondering how I would go about doing a sorting of a new element being added on the page.  This element would have to be alphabetically sorted into the existing elements onto the page.  For example:  I am making a file manager, so when a user creates a new file, it would be sorted into the already existing files and displayed in the spot that it should.   All necessary details would be provided by PHP, so I would only need help with the JavaScript part.   Honestly, I have no clue how I would get around to doing that.  I was thinking earlier that it would involve looping through each class of file_name and getting the text() value.  Then add all of the values into an array and sorting it somehow.  Then it would be getting the <tr> of which file_name is before it, and then append under it somehow.   I'm not asking for any free code, but I was wondering which (JavaScript/JQuery) functions I would be looking for.  I was also wondering if the idea I had would be beneficial or not, or if there were any other ways.  Here is how the files are displayed as is:

<?php
// There may be undefined variables, this is only part of it

$return = '<table id="manager" class="table table-bordered">
<thead>
 <tr class="table_header">
   <th><input id="select" type="checkbox"></th>
   <th>Name</th>
   <th>Size</th>
   <th>Last Modified</th>
   <th>Type</th>
   <th>Permissions</th>
   <th></th>
 </tr>
</thead>
<tbody>';
 
$path = $_SERVER['DOCUMENT_ROOT'];
 
// Scan the directory and remove the paths from the result
$files = array_diff(scandir($path), array(".", ".."));
 
// Get the number of files in the directory
$num_files = count($files);
 
// If there are no files in the directory, return the empty directory variable we defined earlier
if($num_files == 0)
    return $empty_dir;
 
$directory_array = array();
$file_array = array();
foreach($files as $file) {
 
    // Set the path correctly
    $file_path = $path."/".$file;
 
    // If the item is a directory
    if(is_dir($file_path))
        $directory_array[] = $file;
    // The item is a file
    else
        $file_array[] = $file;
 
}
 
// Sort each of the arrays alphabetically
sort($directory_array);
sort($file_array);
 
// Merge the directories and files into one array - directories shown first
$files = array_merge($directory_array, $file_array);
 
// Loop through the items
foreach($files as $file) {
 
    $file_name = $file;
    // Set the path correctly
    $file = $path."/".$file;
 
    // Get the information for the file
    if(is_dir($file))
        $file_size = "--";
    else
        $file_size = @filesize($file);
 
    if($file_size === false) {
 
        $checkbox = '<input id="files_check" type="checkbox" name="files[]" value="'.htmlentities($file_name).'">';
        $file_name = htmlentities($file_name). " - <b>Fatal Error Reading</b>";
        $file_size = "--";
        $last_modified = "--";
        $type = "--";
        $permissions = "--";
        $actions = "--";
 
    } else {
 
        $finfo = finfo_open(FILEINFO_MIME_TYPE);
 
        $checkbox = '<input id="files_check" type="checkbox" name="files[]" value="'.htmlentities($file_name).'">';
 
        if(is_dir($file)) {
 
            $file_name = '<i class="icon-folder-open"></i> <a href="manager.php?path='.htmlentities($file_name).'/">'.htmlentities($file_name).'</a>';
 
        } else {
 
            $file_name = '<i class="icon-file"></i> <a href="manager/view_contents.php?file=/'.htmlentities($file_name).'&token='.htmlentities($_SESSION['secure_token']).'">'.htmlentities($file_name).'</a>';
 
        }
 
        $file_size = htmlentities(get_appropriate_size($file_size));
        $last_modified = htmlentities(get_appropriate_date(filemtime($file)));
        $type = htmlentities(finfo_file($finfo, $file));
        $permissions = htmlentities(substr(sprintf('%o', fileperms($file)), -4));
        $actions = '<i class="actions"></i>';
 
    }
 
 
    $return .= "<tr>
<td>{$checkbox}</td>
<td class='file_name'>{$file_name}</td>
<td>{$file_size}</td>
<td>{$last_modified}</td>
<td>{$type}</td>
<td class='permissions'>{$permissions}</td>
<td class='action'>{$actions}</td>
 </tr>";
 
 
}
 
$return .= '</tbody>
</table>';
 
return $return;
?>

Anyone can help me?

<?php
$tbl_name="menu";
$kategorije = mysql_query("SELECT * FROM $tbl_name WHERE Left(menu_name, 1) BETWEEN 'A' AND 'M' ORDER BY menu_name ASC");
if (!$kategorije) {
die("Database query failed: " . mysql_error());
}

while ($row=mysql_fetch_array( $kategorije )) {
echo "<div id=lista-header><h4>{$row["menu_name"]}</h4></div>";
$id_sub=$row['id_menu'];
$podkategorije = mysql_query("SELECT * FROM submenu WHERE id_menu=$id_sub ORDER BY sub_name ASC", $connection);
if (!$podkategorije) {
die("Database query failed: " . mysql_error());
}
echo "<ul class=\"pod\">";
while ($pod=mysql_fetch_array( $podkategorije )) {
echo "<li><a href=index.php?=podkate?".$pod["id_sub"]." class=black>{$pod["sub_name"]}</a><hr size=1 align=left width=100px color=#cccccc></li>";
}
echo "</ul>";
}


?>

In this way, I get list with categories and hes subcategories. How to count how many subcategories have each categories, and count how many articles have each categories?

Example (I wanna get this kind of look):

Categories name (3)
subcategoriesname (2)
subcategoriesname (4)
subcategoriesname (7)

Categories name (5)
subcategoriesname (1)
subcategoriesname (14)
subcategoriesname (9)
subcategoriesname (2)
subcategoriesname (


Categories name (2)
subcategoriesname (28)
subcategoriesname (17)

Where the numbers represent how many categories and sub-items have articles