PHP GoogleImageAdGroup Examples

Example #1

File: create_image_campaign.php Project: sergrin/crawlers-il

require_once '../classes/Keyword.php';
$db = new DBAdapter2(array('host' => KWDB_HOST, 'username' => KWDB_USERNAME, 'password' => KWDB_PASSWORD, 'schema' => KWDB_SCHEMA));
$campaign = new GoogleCampaign($db);
$campaign->ga_campaign_name = CAMPAIGN_NAME_BASE . " " . date("Y-m-d H i");
$campaign->save();
$db->executeSQL("SELECT keyword_id, keyword, occurs, word_count, source_keyword_id , c.l_image, c.l_make, c.l_color, c.l_model\n\t\t\t\t\tFROM m2m_keywords_to_niches a \n\t\t\t\t\tleft join keywords b using(keyword_id)\n\t\t\t\t\tLEFT JOIN {$table} c USING(keyword_id)\nWHERE c.l_image!= '' and niche_id = " . NICHE . " and occurs > " . GROUP_SIZE . " and word_count > 2 order by word_count desc, occurs desc", $resultArry, $rowsAffected);
$total = $rowsAffected;
$left = $total;
echo $total . " keywords\r\n";
$start_time = date('U');
$kws = array();
$keyword = new Keyword($db);
$fp = fopen("../output/" . str_replace(" ", "_", $campaign->ga_campaign_name) . ".csv", "w+");
fputs($fp, "Campaign,Daily Budget,Language,Location,Proximity Targets,Ad Schedule,Ad Group,Max CPC,Keyword Type,Keyword,Image,Ad Name,Image Size,Display URL,Destination URL\r\n");
foreach ($resultArry as $val) {
    $adgroup = new GoogleImageAdGroup($db);
    $adgroup->giag_campaign_id = $campaign->ga_campaign_id;
    $adgroup->giag_display_url = DISPLAY_URL;
    $adgroup->buildDestinationUrl($val);
    $adgroup->save();
    $adgroup->giag_name = "Ad " . $adgroup->giag_id . " " . $val['keyword'];
    $adgroup->save();
    $ad = $adgroup->buildAds("http://images.kabel.co.il/photo/?url=" . $val['l_image'] . "&section=realestate");
    fputs($fp, "{$campaign->ga_campaign_name},20,iw,IL,,,{$adgroup}," . MAX_CPC . "\r\n");
    foreach ($adgroup->ads as $add) {
        fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup},,,," . $add->gia_image . "," . $add->gia_name . "," . $add->gia_size . "," . $adgroup->giag_display_url . ",\"" . $adgroup->giag_destination_url . "\"\r\n");
    }
    $tmp = explode(" ", $val['keyword']);
    $search = "";
    foreach ($tmp as $t) {
        $search .= " and (keyword LIKE '% " . addslashes($t) . " %' or keyword LIKE '% " . addslashes($t) . "' or keyword LIKE '" . addslashes($t) . " %')";

Example #2

File: google_image_ad_group_test.php Project: sergrin/crawlers-il

 function testBuildDestinationUrl()
 {
     $this->assertTrue($this->item->buildDestinationUrl(array('l_model' => 3, 'l_make' => 'Mazda', 'l_color' => 'white')));
     $this->assertEqual("http://vehicles.kabel.co.il/search/Mazda%203?&price=1000-&color=white", $this->item->giag_destination_url);
 }