PHP - Php Keywords

I currently have three tables

Domains
Keywords
Words

In words I would have

Sport
Football
Rugby

And allocate them to the domain in keywords, but say I wanted Rugby League, would I have an entry in words as Rugby League or two seperate entries rugby and league? And how would i combine them in the keywords table?

Keywords_id
Keywords_domain
Keywords_word

Thanks

Hello,

I'm working on a file upload/download setup.  I want the MySQL table to be arranged like so:

id----int(11)----primary key
Filename----varchar(30)
Keyword1----varchar(30)
Keyword2----varchar(30)
Description----text
DateAdded----timestampCURRENT_TIMESTAMP
Type----varchar(30)
Size----int(11)   
Content----mediumblob

My question is;
Is there a way to make the users select their keywords from a predetermined list (i.e. a dropdown menu) rather than letting them just punch in whatever keywords they want?

Hi, im new to the forum and also to php, ive had a look through the tutorials and various threads but cant seem to find what im after.

im created a simply image gallery that auto creates my thumbnails and allows for editing the image with gdlibrary etc all very good here.

I recently decided to start work on the image keyword tagging so i could carry out searches etc on my very large image collection. i created the usual 3 table setup as im going to have a many to many relationship, so i have my "images" table,  "keywords" table and a "img_key" table to link them together. As i understand it this would seem like the best setup for what i want to achieve, if not would someone be able to advise what i should be doing to get better results.

Ok so the main problem i have now is that i want to show a series of check boxes underneath each image that gets selected so i can start tagging the uploaded images, to do this i used "select * from keywords" which gave me all keywords available - which is what i want......

However, i now want to somehow add to this so that once the page loads it knows which keywords have already been selected and ticks the relevant boxes automatically, as I have an sql update statement linked to the tickboxes/submit button i want to ensure i dont forget to re-tick any boxes

So in a nutshell i need help with displaying all keywords each as a tickbox and if they have already been linked in my 'img_key' link table then they will tick the related tick box automatically , depending on what i need to change im guessing i may need to revise my updating of mysql ?

ive been struggling with this silly problem now for a few weeks so im desperate for some assistance 

Ok, so first, I'm a little more experienced than a newb, but far from an expert.  And I'm fairly certain when yall help me through this I'm going to bang my head on the desk and chastize myself for not thinking of it.  So here we go.

I'm attempting to use some examples I found on php.net for the iptc embed & iptcparse functions.  What I've done is taken a class file that was posted (just a collection of the snippets), corrected it for the most part to function how it should.  It will read the IPTC data from a jpg just fine.  It'll even write to the IPTC fields.  The problem comes with the IPTC_KEYWORDS field.  That field needs to be an array and I can't get it to write properly.  Right now the only thing it's writing is the word "array".

Also, I'm a bit confused as to what one of the functions is trying to do and I think it's the function that's causing the mess.  Below are the classfile and then the test file making the call.
Code: [Select]
<?

/*
Examples taken from php.net
*/

    DEFINE('IPTC_OBJECT_NAME', '005');
    DEFINE('IPTC_EDIT_STATUS', '007');
    DEFINE('IPTC_PRIORITY', '010');
    DEFINE('IPTC_CATEGORY', '015');
    DEFINE('IPTC_SUPPLEMENTAL_CATEGORY', '020');
    DEFINE('IPTC_FIXTURE_IDENTIFIER', '022');
    DEFINE('IPTC_KEYWORDS', '025');
    DEFINE('IPTC_RELEASE_DATE', '030');
    DEFINE('IPTC_RELEASE_TIME', '035');
    DEFINE('IPTC_SPECIAL_INSTRUCTIONS', '040');
    DEFINE('IPTC_REFERENCE_SERVICE', '045');
    DEFINE('IPTC_REFERENCE_DATE', '047');
    DEFINE('IPTC_REFERENCE_NUMBER', '050');
    DEFINE('IPTC_CREATED_DATE', '055');
    DEFINE('IPTC_CREATED_TIME', '060');
    DEFINE('IPTC_ORIGINATING_PROGRAM', '065');
    DEFINE('IPTC_PROGRAM_VERSION', '070');
    DEFINE('IPTC_OBJECT_CYCLE', '075');
    DEFINE('IPTC_BYLINE', '080');
    DEFINE('IPTC_BYLINE_TITLE', '085');
    DEFINE('IPTC_CITY', '090');
    DEFINE('IPTC_PROVINCE_STATE', '095');
    DEFINE('IPTC_COUNTRY_CODE', '100');
    DEFINE('IPTC_COUNTRY', '101');
    DEFINE('IPTC_ORIGINAL_TRANSMISSION_REFERENCE',     '103');
    DEFINE('IPTC_HEADLINE', '105');
    DEFINE('IPTC_CREDIT', '110');
    DEFINE('IPTC_SOURCE', '115');
    DEFINE('IPTC_COPYRIGHT_STRING', '116');
    DEFINE('IPTC_CAPTION', '120');
    DEFINE('IPTC_LOCAL_CAPTION', '121');

    class iptc {
        var $meta=Array();
        var $hasmeta=false;
        var $file=false;
       
       
        function iptc($filename) {
echo 'IPTC Loading for: '.$filename.'<br />';
            $size = getimagesize($filename,$info);
            $this->hasmeta = isset($info["APP13"]);
            if($this->hasmeta)
                $this->meta = iptcparse($info["APP13"]);
            $this->file = $filename;
        }

        function set($tag, $data) {
echo 'Updating IPTC Tag.<br />';
            $this->meta ["2#$tag"]= Array( $data );
            $this->hasmeta=true;
        }

        function get($tag) {
echo 'Getting IPTC data.<br />';
            return isset($this->meta["2#$tag"]) ? $this->meta["2#$tag"][0] : false;
        }

        function view() {
echo 'Print IPTC Data.<br />';
foreach(array_keys($this->meta) as $s) {             
$c = count ($this->meta[$s]);
for ($i=0; $i <$c; $i++)
{
                echo $s.' = '.$this->meta[$s][$i].'<br />';
            }
        }                  
    }

        function binary() {
echo 'Setting new binary block for IPTC writing.<br />';
            $iptc_new = '';
            foreach (array_keys($this->meta) as $s) {
$c = count ($this->meta[$s]);
for ($i=0; $i <$c; $i++)
    {
$tag = str_replace("2#", "", $s);
    $iptc_new .= $this->iptc_maketag(2, $tag, $this->meta[$s][$i]);
    }
            }       
            return $iptc_new;   
        }

        function iptc_maketag($rec,$dat,$val) {
echo 'Making IPTC Tag<br />';
            $len = strlen($val);
            if ($len < 0x8000) {
                   return chr(0x1c).chr($rec).chr($dat).
                   chr($len >> 8).
                   chr($len & 0xff).
                   $val;
            } else {
                   return chr(0x1c).chr($rec).chr($dat).
                   chr(0x80).chr(0x04).
                   chr(($len >> 24) & 0xff).
                   chr(($len >> 16) & 0xff).
                   chr(($len >> 8 ) & 0xff).
                   chr(($len ) & 0xff).
                   $val;     
            }
        }   
        function write() {
echo 'Writing file...<br />';
            if(!function_exists('iptcembed')) return false;
            $mode = 0;
            $content = iptcembed($this->binary(), $this->file, $mode);   
            $filename = $this->file;
               
            @unlink($filename); #delete if exists
           
            $fp = fopen($filename, "w");
            fwrite($fp, $content);
            fclose($fp);
        }   
       
        #requires GD library installed
        function removeAllTags() {
'Removing previous IPTC tags to re-write new data.<br />';
            $this->hasmeta=false;
            $this->meta=Array();
            $img = imagecreatefromstring(implode(file($this->file)));
            @unlink($this->file); #delete if exists
            imagejpeg($img,$this->file,100);
        }
    };
?>
And here's the test-call: Code: [Select]
<?php
require_once("iptceasy.php");

$i = new iptc("fortworden.jpg");
$keywords = array( "keywords" => "updatedkey1", "updatedkey2", "updatedkey3" , "updatedkey4" );
echo $i->set(IPTC_KEYWORDS, $keywords);
$i->write();
echo 'Done.';
?>
If I try to set any of the other IPTC fields with a string, the functions work fine.  I'm fairly certain the error is either in the set() function or the iptc_maketag() function.  And the iptc_maketag() function is the one I'm stumped about.  Is that binary that it's prepending to the data?

Thanks for any light you can shed and help you can give on this in advance!
-Mike

Friends,

Requirement:
I want to Extract the Keywords from All the Search Engine Referer URLs and save all the keywords in an Array so i can Echo/show all the "popular Terms" which drive traffic to my Site from Search Engines.

I already have the Code for Extracting the Keyword from URL, can someone tell me how can i save the $keyword in an array that whenever i visit my site, i can see that What all keywords brought visitors to my site from Search Engines?

Code to Extract Keywords from URL:
<?
$referrer = $_SERVER['HTTP_REFERER'];
$referrer ='http://www.google.co.id/search?hl=id&client=firefox-a&hs=IKn&rls=org.mozilla%3Aen-US%3Aofficial&channel=s&q=pemahaman+pelajaran+ips+tentang+endogen+dan+eksogen&aq=f&aqi=&aql=&oq=&gs_rfai=';
$referrer_query = parse_url($referrer);
$referrer_host = $referrer_query['host'];
$referrer_query = $referrer_query['query'];
$q = "[q|p|qkw|key|query|searchfor|Keywords|searchterm]"; //Yahoo uses both query strings, I am using switch() for each search engine
preg_match('/'.$q.'=(.*?)&/',$referrer,$keyword);
$keyword = urldecode($keyword[1]);

$potongnya = array('&q=','&p=','key=','query=','searchfor=','Keywords=','searchterm=');
$referrer_query = str_replace($potongnya, "&|pencarian=", $referrer_query);
$arr = explode("&", "$referrer_query");
for($k = 0, $l = count($arr); $k < $l; ++$k)
 {
 $ygdicari = "$arr[$k]";
$findmeyach = "|pencarian=";
$posnyaaa = strpos($ygdicari, $findmeyach);
if ($posnyaaa === false)
 {}
 else
 {
$keyword = str_replace('|pencarian=', "", $ygdicari);
$potongkeynya = array('+','%20');
$keyword = str_replace($potongkeynya, " ", $keyword);
 }
 }
if ($keyword=="")
 {
$potongnya = array('q=','p=');
$referrer_query = str_replace($potongnya, "&|pencarian=", $referrer_query);
$arr = explode("&", "$referrer_query");
for($k = 0, $l = count($arr); $k < $l; ++$k)
 {
 $ygdicari = "$arr[$k]";
$findmeyach = "|pencarian=";
$posnyaaa = strpos($ygdicari, $findmeyach);
if ($posnyaaa === false)
 {}
 else
 {
$keyword = str_replace('|pencarian=', "", $ygdicari);
$potongkeynya = array('+','%20');
$keyword = str_replace($potongkeynya, " ", $keyword);
 }
 }

 }
$keyword = strtolower($keyword);
$urikeyword = array('sex ','porn ','porno',', ','penis ','penis ','http://www.','http://','http','gamble','"',"'");
$keyword = str_replace($urikeyword, "", "$keyword");
echo "$keyword";
exit;
?>


Many Thanks
Natasha T