1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

how to creat above 1 million key words list ?

Discussion in 'Black Hat SEO Tools' started by NX_NULL, Apr 26, 2010.

  1. NX_NULL

    NX_NULL Regular Member Premium Member

    Joined:
    Dec 31, 2008
    Messages:
    309
    Likes Received:
    425
    Is there any website or software to be able to create +1 million unique keywords (phrase) list ?
     
  2. showbizvet

    showbizvet Power Member

    Joined:
    Oct 1, 2008
    Messages:
    795
    Likes Received:
    260
    Occupation:
    IM
    Location:
    Tennessee and around
    I use keywordtopia for my lists. Lots of great tools on there, not free however. I haven't tried to create 1mil, however by adding the city/state combination's, it should be possible. Good customer support, has my vote.
     
  3. casius

    casius Junior Member

    Joined:
    Apr 18, 2010
    Messages:
    186
    Likes Received:
    20
    Home Page:
    Hello,

    I used seobook.com to create keywords.
     
  4. danielsun174

    danielsun174 Newbie

    Joined:
    Nov 30, 2009
    Messages:
    28
    Likes Received:
    24
    Home Page:
    Create a mysql database:

    PHP:
    CREATE TABLE IF NOT EXISTS `worte` (
      `
    idint(99NOT NULL AUTO_INCREMENT,
      `
    keywortvarchar(300CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
      `
    sematicvarchar(1000NOT NULL,
      `
    benutztint(1NOT NULL,
      `
    cacheint(5NOT NULL,
      `
    ger_searchvarchar(20NOT NULL,
      `
    global_searchvarchar(20NOT NULL,
      `
    cpcvarchar(7NOT NULL,
      
    KEY `id` (`id`)
    ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13876 ;
    and use my php code:
    keywords are scraped from http://www.semager.de/api/keyword.php


    PHP:
    <?php
    include('start.php');

    $null="0";
    $abfrage "Select * FROM worte where benutzt!='1' ORDER BY RAND() LIMIT 30";
    $ergebnis mysql_query($abfrage);
    while(
    $row mysql_fetch_object($ergebnis))
    {
    $key=$row->keywort;
    $key=utf8_encode($key);
    $r_url="http://www.semager.de/api/keyword.php?q=".$key."&lang=en&out=html&count=&threshold=";
    $r_file file_get_contents("$r_url");

     
    //sonderzeichen umwandeln
    $r_file=utf8_decode($r_file);


    preg_match_all('~<span style="font-size:(.*)%;">(.*)</span>  ~U'$r_file$new);
    unset(
    $new[0]);

    //neue worte einspeichern
    $anzahl_neu=count($new[1]);
    $a=0;
    while(
    $a<$anzahl_neu)
    {
    $new_key=$new[2][$a];
    $new_cache=$new[1][$a];
    //schauen ob schon da
      
    $kg="Select * FROM worte WHERE keywort='$new_key' LIMIT 1";
      
    $er mysql_query($kg);
      while(
    $ruw mysql_fetch_object($er))
      { 
    $id=$ruw->id;}
      if(
    $id=="")
      {
      
    mysql_query("INSERT INTO worte
      (keywort,cache) VALUES ('
    $new_key','$new_cache')");
      }
      else
      {
    $aendern "UPDATE worte Set cache='$new[1][$a]' WHERE id='$id'";
      
    $update mysql_query($aendern);
      }
      
    $a++;
      
    $id="";
    }
    $a=0;

    //sematic einschreiben
      
    $kg="Select * FROM worte where cache>'0' ORDER BY cache";
      
    $er mysql_query($kg);
      while(
    $ruw mysql_fetch_object($er))
    {
    $sematic=$sematic."|".$ruw->id."|";}
    echo 
    "<p>".$key." ->".$sematic."</p>";
    $aendern "UPDATE worte Set sematic='$sematic' WHERE keywort='$key'";
    $update mysql_query($aendern);

    //cache leeren
    $aendern "UPDATE worte Set cache='0'";
    $update mysql_query($aendern);

    //benutzt einschreiben
    $aendern "UPDATE worte Set benutzt='1' WHERE keywort='$key' LIMIT 1";
    $update mysql_query($aendern);

    $sematic="";
    }


    echo 
    "<meta http-equiv=\"refresh\" content=\"0; URL=http://localhost/search/scrape_key.php\">";
    ?>
     
  5. zverr

    zverr Regular Member

    Joined:
    Nov 11, 2009
    Messages:
    412
    Likes Received:
    125
    scrapebox + english language dictionary = unlimited number of keywords :)
     
  6. polas

    polas Newbie

    Joined:
    Jul 8, 2009
    Messages:
    11
    Likes Received:
    0
    Oh i tryed it but it rolls only 20 keywords not 1 milens :(
    How it can work?