PHP sqlQueries Beispiele

Beispiel #1

Datei: Download.php Projekt: katiemowat/websummit15-hack

<?php

require_once "config.php";
require_once "libs/db_mysql.php";
$SQL = new sqlQueries(PUBLIC_DATABASE_HOST, PUBLIC_DATABASE_DATABASE, PUBLIC_DATABASE_USER, PUBLIC_DATABASE_PASS);
for ($i = 1; $i < 200; $i++) {
    //print($i."\n");
    //this url is public :)
    $info = file_get_contents("https://api.cilabs.net/v1/conferences/ws15/info/attendees?page=" . $i);
    $list = json_decode($info, true);
    foreach ($list['attendees'] as $info) {
        //create company
        $query = "INSERT IGNORE INTO `" . PUBLIC_DATABASE_DATABASE . "`.`companies` ( `name`, `country`) VALUES ('" . addslashes($info['company']) . "', '" . addslashes($info['country']) . "')";
        //print($query."\n");
        $R = $SQL->query($query);
        //find company
        $query = "select `id_companies` from `" . PUBLIC_DATABASE_DATABASE . "`.`companies` where `name` = '" . addslashes($info['company']) . "' and  `country` ='" . addslashes($info['country']) . "' ";
        //print($query."\n");
        $R = $SQL->query2cell($query);
        //print($R."\n");
        //insert attendee
        $query = "INSERT IGNORE INTO `" . PUBLIC_DATABASE_DATABASE . "`.`persons` ( `name`, `position`, `description`, `id_ext`, `id_company`, `country`, `avatar`) \n\t\t\tVALUES ('" . addslashes($info['name']) . "', '" . addslashes($info['career']) . "', '" . addslashes($info['bio']) . "', " . $info['id'] . ", " . $R . ", '" . addslashes($info['country']) . "', '" . addslashes($info['avatar_url']) . "')";
        //print($query."\n");
        $R = $SQL->query($query);
    }
}
?>

Beispiel #2

Datei: Angelco_update.php Projekt: emkorybski/websummit15-hack

<?php

require_once "config.php";
require_once "libs/db_mysql.php";
$SQL = new sqlQueries(PUBLIC_DATABASE_HOST, PUBLIC_DATABASE_DATABASE, PUBLIC_DATABASE_USER, PUBLIC_DATABASE_PASS);
foreach ($SQL->query2assoc("SELECT `id`, `angellist_url`, `company_name` as `angellist_url` FROM " . PUBLIC_DATABASE_DATABASE . ".`startups` where `angel_startup` =''") as $r) {
    //print_r($r);
    //clean the Angellist url
    if ($r['angellist_url']) {
        $angel_search = str_replace("https://angel.co/", "", $r['angellist_url']);
        $angel_search = str_replace("www.angel.co/", "", $angel_search);
        $angel_search = str_replace("angel.co/", "", $angel_search);
        $angel_search = str_replace("http://", "", $angel_search);
        $angel_search = str_replace("https://", "", $angel_search);
        $angel_search = str_replace("http:/", "", $angel_search);
        $angel_search = str_replace("https:/", "", $angel_search);
        $angel_search = str_replace("/", "", $angel_search);
        $angel_search = str_replace("-1", "", $angel_search);
        $angel_search = str_replace("-2", "", $angel_search);
        print $angel_search . "\n";
        print "SEARCH FOR : {$angel_search} \n";
    } else {
        //we don't have a URL but can stuill search with the company_name
        $angel_search = str_replace(" ", "%20", $r['company_name']);
        print "SEARCH FOR COMPANY : {$angel_search} \n";
    }
    $couc = file_get_contents('https://api.angel.co/1/search?type=Startup&query=' . $angel_search . '&access_token=' . $Angellist_tokenauth);
    $info_search = json_decode($couc, true);
    print "SEARCH RESULT : \n";
    print_r($info_search);
    $info = "";

Beispiel #3

Datei: Download_startup.php Projekt: emkorybski/websummit15-hack

<?php

require_once "config.php";
require_once "libs/db_mysql.php";
require_once "libs/Websummit.php";
$SQL = new sqlQueries(PUBLIC_DATABASE_HOST, PUBLIC_DATABASE_DATABASE, PUBLIC_DATABASE_USER, PUBLIC_DATABASE_PASS);
$ws = new Websummit();
for ($i = 1; $i < 100; $i++) {
    $params = array("q" => "", "page" => $i, "auth_token" => $Websummit_tokenauth, "conference" => "ws15");
    $result = $ws->sendRequest('', $params);
    //print_r($ws->_response);
    $list = $ws->_response;
    foreach ($list['startups'] as $company) {
        //print_r($company);
        $SQL->insert(PUBLIC_DATABASE_DATABASE . '.startups', $company);
    }
}
?>

Beispiel #4

Datei: Dig_update.php Projekt: emkorybski/websummit15-hack

<?php

require_once "config.php";
require_once "libs/db_mysql.php";
$SQL = new sqlQueries(PUBLIC_DATABASE_HOST, PUBLIC_DATABASE_DATABASE, PUBLIC_DATABASE_USER, PUBLIC_DATABASE_PASS);
foreach ($SQL->query2assoc("SELECT `id`, `website_url` FROM " . PUBLIC_DATABASE_DATABASE . ".`startups`") as $r) {
    print $r['website_url'] . "\n";
    //clean the urls
    $url = str_replace("http://", "", $r['website_url']);
    $url = str_replace("https://", "", $url);
    $url = str_replace("http:/", "", $url);
    $url = str_replace("https:/", "", $url);
    $url = str_replace("www.", "", $url);
    if (strpos($url, "/") > 1) {
        $url = substr($url, 0, strpos($url, "/"));
    }
    //$url = substr($url, 0, strpos($url, "#"));
    //$url = substr($url, 0, strpos($url, "?"));
    print $url . "\n";
    $result = dns_get_record($url);
    print_r($result);
    print "\n\n";
    //extract MX and SPF records
    foreach ($result as $line) {
        if ($line['type'] == "MX") {
            print_r($line);
            $dns_mx .= $line['host'] . " - " . $line['target'] . "\n";
        }
        if ($line['type'] == "TXT" and preg_match("/spf1/", $line['txt'])) {
            print_r($line);
            $dns_spf .= $line['host'] . " - " . $line['txt'] . "\n";

Beispiel #5

Datei: Twitter_update.php Projekt: emkorybski/websummit15-hack

<?php

require_once "config.php";
require_once "libs/db_mysql.php";
$SQL = new sqlQueries(PUBLIC_DATABASE_HOST, PUBLIC_DATABASE_DATABASE, PUBLIC_DATABASE_USER, PUBLIC_DATABASE_PASS);
function checkTwitter($username)
{
    require_once 'libs/Twitter/tmhOAuth-master/tmhOAuth.php';
    require_once 'libs/Twitter/tmhOAuth-master/tmhUtilities.php';
    $tmhOAuth = new tmhOAuth(array('consumer_key' => TWITTER_CONSUMER_KEY, 'consumer_secret' => TWITTER_CONSUMER_SECRET, 'user_token' => TWITTER_USER_TOKEN, 'user_secret' => TWITTER_USER_SECRET));
    $code = $tmhOAuth->request('GET', 'https://api.twitter.com/1.1/users/lookup.json', array('screen_name' => $username));
    if ($code == 200) {
        return json_decode($tmhOAuth->response['response'], true);
    } else {
        return false;
    }
}
foreach ($SQL->query2assoc("SELECT `id`,`twitter_url` FROM " . PUBLIC_DATABASE_DATABASE . ".`startups` where `twitter_url`!='' and twitter_followers_count=0 and twitter_url_2 is Null") as $r) {
    //print_r($r);
    $twitter = str_replace("https://twitter.com/", "", $r['twitter_url']);
    $twitter = str_replace("http://twitter.com/", "", $twitter);
    $twitter = str_replace("www.twitter.com/", "", $twitter);
    $twitter = str_replace("twitter.com/", "", $twitter);
    $twitter = str_replace("http://", "", $twitter);
    $twitter = str_replace("https://", "", $twitter);
    $twitter = str_replace("http:/", "", $twitter);
    $twitter = str_replace("https:/", "", $twitter);
    $twitter = str_replace("@", "", $twitter);
    print $twitter . "\n";
    $res = checkTwitter($twitter);
    if ($res and $res[0]) {