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

Little help please with one php script.

Discussion in 'Other Languages' started by GinoCorad, Apr 12, 2012.

  1. GinoCorad

    GinoCorad Newbie

    Joined:
    Apr 6, 2012
    Messages:
    8
    Likes Received:
    0
    Here is my php script , i want to know if is possible to post my result from : wesite/folder/script.php?id=$i to Twitter , Facebook or other site like this two .

    Result are like : name , description and link


    thanks and sorry for my bad English

    Code:
    <?
    $con = mysql_connect("localhost","base","base");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
      mysql_select_db("base", $con);
      
      $result = mysql_query("SELECT * FROM cronjob");
      while ($row = mysql_fetch_array($result)) 
        {
          $lastcheck = $row['lastcheck'];
          $addvideo  = $row['addvideo']; 
        }
      $i = $lastcheck;
      $end = $lastcheck+$addvideo;
      $result = mysql_query("UPDATE cronjob SET lastcheck='$end'") or die(mysql_error());
      do {  
            echo "<font color=green> $i > $end </font>";
            $ch   = curl_init();
            curl_setopt($ch, CURLOPT_URL, "wesite/folder/script.php?id=$i");
            curl_setopt($ch, CURLOPT_USERPWD, "admin:admin");  
            curl_setopt($ch, CURLOPT_HEADER, false);
            curl_exec($ch);
            curl_close($ch);
         ++$i;
         } 
    while ($i <= $end);
    ?>
    
     
  2. cb.ikt

    cb.ikt Newbie

    Joined:
    Feb 18, 2012
    Messages:
    18
    Likes Received:
    5
    Your code is seriously strange. You need to comment your code and give a more detailed instruction. However, I took the time to figure it out. For Twitter use:

    Code:
    <?
    $con = mysql_connect("localhost","base","base") OR die('Could not connect: ' . mysql_error());
    mysql_select_db("base", $con);
      
    $result = mysql_query("SELECT * FROM cronjob");
    while ($row = mysql_fetch_array($result)) {
          $lastcheck = $row['lastcheck'];
          $addvideo  = $row['addvideo'];
    }
    
    $i = $lastcheck;
    $end = $lastcheck+$addvideo;
    
    $result = mysql_query("UPDATE cronjob SET lastcheck='$end'") or die(mysql_error());
    do {  
        echo "<font color=green> $i > $end </font>";
    
        //Here goes the twitter url. can't post urls thats why the string looks so messed up
        $url = 'http:" . "//" . "twitter" . "." . "com/statuses/update.xml';
        $curl_handle = curl_init();
        curl_setopt($curl_handle, CURLOPT_URL, "$url");
        curl_setopt($curl_handle, CURLOPT_CONNECTTIMEOUT, 2);
        curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($curl_handle, CURLOPT_POST, 1);
        curl_setopt($curl_handle, CURLOPT_POSTFIELDS, "status=$TWITTERMESSAGE");
        curl_setopt($curl_handle, CURLOPT_USERPWD, "$TWITTERUSERNAME:$TWITTERPASSWORD");
        //Post to twitter
        $buffer = curl_exec($curl_handle);
        curl_close($curl_handle);
        if (empty($buffer)) {
            echo "Error!";
        } else {
            echo "Done!";
        }
    
         ++$i;
    }while ($i <= $end);
    ?>
    
    Replace $TWITTERMESSAGE, $TWITTERUSERNAME, $TWITTERPASSWORD with your variables.
     
    • Thanks Thanks x 1
  3. GinoCorad

    GinoCorad Newbie

    Joined:
    Apr 6, 2012
    Messages:
    8
    Likes Received:
    0
    thanks for you help i will try right now :p


    on : wesite/folder/script.php?id=$i , website to run , folder is protec by password via httacces to prevent acces from other and script.php is a video grabber that i want to run via cronjob every 10 minutes . now you seee why i so strange ? :)

    Ps. and vairables : $lastcheck = last id saved in db and $addvideo = how many times to run the script ex : 100
     
    Last edited: Apr 12, 2012