Member Avatar for marty63

Hi, said how do I do something like this: I have an index/database with 3 fields NAME, COMPANY NAME, IMAGE NAME (0001.tif 0002.tif and on), it is 500 entries long these images are business cards that I have scanned in .tif format I like to do a web-site with 2 sheets; the left one for my drop down to show the index or search by name that when found click on it and display the image on the right sheet using the plugin alternatif to display tif images on the browser.
Any Ideas how I can accomplish this?. I have done some web sites very plain just playing around, but I have no clue as how to do this. Thanks in advance for your help.

  • 3 Contributors
  • 2 Replies
  • 115 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by linux

Dani AI

Generated

For : the work breaks down into three practical steps — make the TIFF scans web-friendly, keep a small searchable index, and wire a simple viewer. Both and pointed out you need server-side logic; the notes below show a safe, beginner-friendly workflow you can follow step by step (convert files, store filenames/thumbnail paths in a DB, expose a tiny search API, and load images into a two-pane UI).

TIFFs are not reliably viewable in modern browsers. Convert originals to JPEG/PNG and create thumbnails (keep the TIFFs as an archive). ImageMagick is a common tool for batch work:

# create web JPGs from TIFFs
magick mogrify -format jpg -path web-jpgs *.tif

# create 200px thumbnails into thumbs/
magick mogrify -resize 200x -path thumbs web-jpgs/*.jpg

A minimal data model and server endpoint will get you from a list to a viewer. Example table and a tiny PHP search endpoint (returns JSON):

CREATE TABLE cards (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  company VARCHAR(255),
  filename VARCHAR(255),
  thumb VARCHAR(255)
);

<?php
// search.php?q=smith
$q = $_GET['q'] ?? '';
$db = new PDO('mysql:host=localhost;dbname=cards','user','pass');
$stmt = $db->prepare("SELECT id,name,company,thumb,filename FROM cards WHERE name LIKE ? OR company LIKE ? LIMIT 200");
$stmt->execute(["%$q%","%$q%"]);
header('Content-Type: application/json');
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));
?>

Front-end: a left column lists results, a right column has an <img> whose src is set to the chosen filename. Start with a static HTML prototype first; then replace the list with the JSON-driven output above.

Quick tips: use thumbnails for speed, keep originals offline, set correct file permissions and MIME types, limit search results (pagination), and handle multi-page TIFFs by extracting pages with ImageMagick (e.g., magick convert multipage.tif[0] page0.jpg). Test locally with a simple dev stack before deploying. For conversion docs see ImageMagick.

Recommended Answers

All 2 Replies

Member Avatar for Anonymusius

Since you provide very few information is it hard to help. I'd say you should go with PHP. PHP is very easy to learn and integrates nicely with mysql databases. PHP puts HTML and CSS out, all server side. For more info on PHP go to http://www.php.net/.

Good luck and if you have any questions regarding PHP ask in the PHP forum.

Member Avatar for linux

You might want to look into PHP, Perl, Ruby On Rails, Python, ASP, or another language like that. HTML/CSS won't handle this. I could do this with a desktop application, written in C++ or Visual Basic (if you need it done, I could do it, and maybe do it using Ruby On Rails for a website).

But yeah, any powerful web language should do the trick.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.