PHP - Script To Pull Html From Another Site

I have approximately 2,300 videos embedded on my site, and I am constantly adding more. The videos are hosted by YouTube. When a video is deleted from YouTube, it becomes unavailable on my site.

Each video's ID is in my MySQL database. A video ID looks like this:

ZFOuxAx-dkc

I need a script that will do the following: select the IDs from my database check if the videos are still available on YouTube create a list of the videos that are unavailable. If possible, it would be great if the script could also tell me if any of the videos have been blocked in certain countries.

The script has to be fully commented so that I can understand it.

I want to run the script manually every few days. I don't want to have to change my database tables.

I've been told that you can use YouTube's API or YouTube's oEmbed interface. I've also been told that, because there are so many videos, you will have to use cURL multi handles.

If interested in this project, please PM me your price.   This is an urgent project. I have placed ads elsewhere.

I wrote this basic script yesterday to process and generate a Google Site Map. And it works! BUT I want to advance this script to accommodate for something else and I don't know the correct path to take from here, but I will tell you what I've found out so far..

Current Situation:

1 - Currently my below script generates urls in the site map like:
http://abcdefg.com/index.php?dispatch=products.view&product_id=29826

2 - I have .htaccess configured to rewrite the urls to the products name data like:
http://abcdefg.com/pennies/wheat-pennies/lincoln-wheat-penny-cent.html (just an example) and these urls are ONLY active if clicking on the site links themselves - meaning if I enter: http://abcdefg.com/index.php?dispatch=products.view&product_id=29826 directly into the url, the url does not resolve to this natural friendly url name.

What Id like to achieve (which I don't know what direction I should be looking!):

- I'd like my xml output urls (as current) to be written in the natural format (as in #2 above).

FYI here is a current example output item in my sitemap:

Code: [Select]
<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=29803</loc>
  <changefreq>weekly</changefreq>
  <lastmod>2010-09-24T08:00:00+04:00</lastmod>
 </url>
Can anyone give me some guidance on what method might work for this? Do you think it's more a mod_rewrite issue? Or can this be handled easier with straight up modifications to my below? I'm just a bit confused on what direction I should be looking.. Thanks for any input.

<?php
header("Content-Type: text/xml;charset=iso-8859-1");
  echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
 //include('config.local.php');
  $cxn = mysqli_connect($config['db_host'], $config['db_user'], $config['db_password'], $config['db_name']);
  $query = "SELECT cscart_product_descriptions.product_id, cscart_products.product_id, cscart_products.timestamp
FROM cscart_product_descriptions JOIN cscart_products ON cscart_product_descriptions.product_id = cscart_products.product_id
WHERE cscart_products.status='A' LIMIT 10000";
  $result = mysqli_query($cxn, $query);
  $row = mysqli_fetch_array($result);
  while ($row = mysqli_fetch_array($result)) {
  $formatedTime = $row['timestamp'];
      echo '<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=' . $row['product_id'] . '</loc>
  <changefreq>weekly</changefreq>
  <lastmod>'. date('c',$formatedTime) .'</lastmod>
  </url>';
  } //while ($row = mysqli_fetch_array($result))
  echo '</urlset>';
?>

Nothing fancy, I am just looking for a simple php script that would check a text file on my server that has a bunch of domains in it. I want the script to ping a random 5 or 10 sites in the list, and then redirects the visitor to the fastest one, or at least one that responds, and is not down. If all that are checked are down, then it would need to recheck the list.

I want it to pick random domains out of the list, as I don't want users directed to the same site(s) all the time, just because it pings the best.

When I say ping, I am talking about making sure the user isn't directed to a website that is down, or a slow loading website. I am not sure if "ping" is the correct word for that tho?

Can anybody offer me code like this for free, or is this type of request getting into something that would need to be paid code? (and if so, any idea how much? I didn't post this in the freelancing forum, because it sounds like it might be something simple to code.

I am not a coder, so I am looking for something complete that I can add to a php file and it works.

Thanks for any code, pointers/problems with this idea, or price quotes (if necessary) on this little script I am looking for.

fIXED

Hi

I'm currently in the process of re-developing a website for a client in Wordpress. I've completed the work apart from the fact that on the old site the client has a webpage with an email subscription form for subscribing to a newsletter. The form takes a 'Name' and 'Email Address' and writes these to a MySQL database in the back end.

I've tried adding the code to a page in wordpress and have a few plugins which allow PHP code execution on both the sidebar and page but when the button is clicked to submit the subscription nothing appears to happen as on the origonal page.

I really need to know whether this type of code could be imported into Wordpress and made to work or how to go about writing a wordpress page that will write to the same database.

Any advice on this would be helpful as I'm not a strong php coder.

The Code is as follows:

There's a contact.php page on the origoanl site that calls inc-mailing-list.php that also referrences a mysqlconnections.php file

I've put all the code below for referrence.

Origonal Site: contact.php
Code: <?php
session_start();
$string = strtoupper($_SESSION['string']);
$userstring = strtoupper($_POST['userstring']);
session_destroy();

?>

HTML PAGE FORMATTING (REMOVED FOR THE POST)

<?php include("inc-mailing-list.php"); ?></TD>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-9716450-1");
pageTracker._trackPageview();
} catch(err) {}</script></body>

</html>


INC-MAILING-LIST.PHP

<?php require_once('Connections/mysqlconnection.php'); ?>
<?php

/* In contact.php
session_start();
$string = strtoupper($_SESSION['string']);
$userstring = strtoupper($_POST['userstring']);
session_destroy(); 
*/

///// Anti sql injection
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
//// Site config
$siteName = "South Wales Art Society";
$siteURL = "www.southwalesartsociety.co.uk";
$siteEmail = "info@southwalesartsociety.co.uk";

///// Establish the current date/time as a variable
$now = date('Y-m-d H:i:s'); // Current date

//// Call mailing lists
mysql_select_db($database_mysqlconnection, $mysqlconnection);
$query_callMailingLists = "SELECT * FROM content WHERE contenttype = 501 AND onlinestatus = '1' ORDER BY displayorder ASC";
$callMailingLists = mysql_query($query_callMailingLists, $mysqlconnection) or die(mysql_error());
$row_callMailingLists = mysql_fetch_assoc($callMailingLists);
$totalRows_callMailingLists = mysql_num_rows($callMailingLists);



//// Unsubscribe
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "elist") && ($_POST["subscription"] == "unsubscribe") && (strlen($_POST["email"]) > 4) && ($string == $userstring) && (strlen($string) > 4)) {

  $deleteSQL = sprintf("DELETE FROM content WHERE email=%s AND contenttype = 500", GetSQLValueString($_POST['email'], "text"));

  mysql_select_db($database_mysqlconnection, $mysqlconnection);
  $Result1 = mysql_query($deleteSQL, $mysqlconnection) or die(mysql_error());
  $status = "1";
 
 
 
//SEND CONFIRMATION EMAIL
   
$to      = $_POST['email'];
$subject = $siteName.' Mailing List';
$body = 'Your email address has been removed from the '.$siteName.' mailing list.' . "\n\r";
$body .= $siteURL . "\n\r";       
$headers = 'From: '.$siteEmail . "\r\n" .
           'X-Mailer: PHP/' . phpversion();
       
mail($to, $subject, $body, $headers);



}


/////////////////// SUBSCRIPTION ////////////////////////



// Insert comment if sent and valid
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "elist") && ($_POST["email"] != "") && ($_POST["subscription"] == "subscribe") && ($string == $userstring) && (strlen($string) > 4)) {

////////////////////////////////////////////////////////////////////////////////////
///////////////////////////// COUNT AND JOIN TAGS //////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////
$tagCombination1 = ""; // Default value to define variable.
$tagTotal = ""; // Default value to define variable.
if (isset($_POST['TagsTotal1'])) { $tagTotal = $_POST['TagsTotal1'];}
$tagNumber = 0;

do { $tagNumber = $tagNumber+1;

if (isset($_POST['Tag-1-'.$tagNumber])) $tagCombination1 = $tagCombination1.",".$_POST['Tag-1-'.$tagNumber]; // DISREGARD UNSELECTED TAGS

} while ($tagNumber <= $tagTotal); // LOOP UNTIL ALL TAGS HAVE BEEN COMBINED

$tagCombination1 = $tagCombination1.","; // ADD A COMMA TO THE END TO GET CORRECT SEARCH PARAMETERS
$tagCombination1 = str_replace(",,",",",$tagCombination1); // CLEAR OUT ANY DOUBLE COMMAS
////////////////////////////////////////////////////////////////////////////////////
/////////////////////////// COUNT AND JOIN TAGS END ////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////

  $insertSQL = sprintf("INSERT INTO content (contenttype, title1, email, date_added, tags1) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString(500, "int"),
                       GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($now, "text"),
                       GetSQLValueString($tagCombination1, "text"));

  mysql_select_db($database_mysqlconnection, $mysqlconnection);
  $Result1 = mysql_query($insertSQL, $mysqlconnection) or die(mysql_error());
  $status = "2";
 
 
 
//SEND CONFIRMATION EMAIL
   
$to      = $_POST['email'];
$subject = $siteName.' Mailing List';
$body = 'Thank you. Your name has been added to the '.$siteName.' mailing list.' . "\n\r";
$body .= $siteURL . "\n\r"; 
$headers = 'From: '.$siteEmail . "\r\n" .
           'X-Mailer: PHP/' . phpversion();
       
mail($to, $subject, $body, $headers);



}
?>

<div id="signup" >
<H5>Sign Up For Our Mailing List</H5>

<?php if (($_POST['email']) && ($status == "1")) { ?>
<br /><strong>Thank you, you have been removed from the mailing list.</strong>

<?php } elseif (($_POST['email']) && ($status == "2")) { ?>
<br /><strong>Thank you, you have been added to the mailing list.</strong>

<?php } else { ?>


<form name="elist" method="POST" action="">
<?php if (($_POST['email']) && ($status != "2")) { ?><p class="red"><strong>Please complete your details and enter the code.</strong></p><?php } // Error ?>

<br />

Name: <input name="name" type="text" value="<?php echo $_POST['name']; ?>" /><br />
Email: <input name="email" type="text" value="<?php echo $_POST['email']; ?>" /><br />

<input name="subscription" type="radio" id="subscription_0" value="subscribe" <?php if($_GET['unsubscribe']!="yes") { ?>checked="checked"<?php } // ?> />
Subscribe<br />
<input type="radio" name="subscription" value="unsubscribe" id="subscription_1" <?php if($_GET['unsubscribe']=="yes") { ?>checked="checked"<?php } // ?>/>
Unsubscribe<br />

<br />

<?php /*?>Select which information you would like to receive:<br />
      
<?php $tagNumbers = 0; do { $tagNumbers = $tagNumbers+1;?>
<label><input <?php if (!(strcmp($row_callMailingLists['id'],1000))) {echo "checked=\"checked\"";} ?> name="Tag-1-<?php echo $tagNumbers; ?>" type="checkbox" value="<?php echo $row_callMailingLists['id']; ?>" /><?php echo $row_callMailingLists['title1']; ?></label><br />
<?php } while ($row_callMailingLists = mysql_fetch_assoc($callMailingLists)); ?><br /><br />

<input type="hidden" name="TagsTotal1" value="<?php echo $totalRows_callMailingLists; ?>" />

USE THE TWO HIDDEN FIELDS BELOW AS THERE IS ONLY ONE LIST

<?php */?>
<input type="hidden" name="Tag-1-1" value="1000" />
<input type="hidden" name="TagsTotal1" value="1" />
 
<img src="/captcha/imagebuilder.php" alt="" border="0" /><br /><br />

<small>Please enter the code shown above.</small><br />

<input maxlength="8" size="8" name="userstring" type="password" value="" /><br /><br />

<input name="Submit" type="submit" value="Submit" /><br />


<input type="hidden" name="datesubscribed" value="<?php echo date('Y-m-d H:i:s'); ?>" />
<input type="hidden" name="MM_insert" value="elist" />
</form>
</div>
<?php } // ?>
<?php
mysql_free_result($callMailingLists);
?>

Hello guys,

I currently have a problem with echoing text coming from an external site, using file_get_contents. I won't consider myself a great PhP programmer, so I'll gladly appraciate any help! The code I am using is very simple:

<?php
$homepage = file_get_contents('http://www.live365.com/scp/web/stn/playlist.html?station=kolonku');

echo $homepage;
?>

However, the result comes out blank. If I change the link to a page made out of HTML, the code works, but the text here is a tracklist of a Live365 radio station. It changes dynamically according to what song is currently playing. I guess the code behind all this is formidable, to say the least, and I can't tell if it's made out of Javascript or PhP, or something else. Is there any way that I can solve this? I was thinking of getting the contents, then have the function updating every 10 seconds or so, so that the text is up to date most of the time. The current problem however, is getting something at all in the first place!

Link to the site I want to get the contents from (it updates atomatically! The source code won't give me a clue to what's going on..):
http://www.live365.com/scp/web/stn/playlist.html?station=kolonku

Hi all-
I need some help figuring out a select query... I have a view made from two tables with a user ID as the common key. I need to retrieve all rows from the view where the email address is NOT equal to the session variable stated [EMAIL].

I built it using what I thought was a fairly simple query, and what it gives me back are any rows where the EMAIL field has a value (not equal to the session variable) which is fine.. but I ALSO need to get the other rows where the email field has NO value assigned to it currently.

How can I write this?

I need to pull all the mysql data by the order of it's date/time . How can I write the code?

I'm using this as a serverside script and I'm not a php person. But i believe the below code will not pull the data. Will it work if I remove the text marked in red?

$query = "SELECT * FROM  sub_db WHERE the_code = '".$abc."'" ORDER BY timestampz ASC";

how do I call only a single column in a MySQL?

This is not working.
$SomeVar = $_POST['finco'];
$query = "SELECT * FROM idb WHERE name = '".$SomeVar."'";
$results = mysql_query($query);
$psend = $results["fincos"];
echo($psend);

This is my code. Data is been pulled from db_faq and Db_2 and then match the records against each other using array_intersect(). And as you see the data from db_faq is been pulled based on the $username.

My question is how can I ignore the $username and match all rows in db_faq against the data in db_2? Basically I need to get the matching records between the 2 databases regardless of the username.

$Array1 = array();
$Array2 = array();
$var1 = '$username';
$query1 =  "SELECT * FROM db_faq WHERE username = '".$var1."'";
$result1 = mysql_query($query1);
$score1 = mysql_fetch_assoc($result1);
foreach (range('25','35') as $ltr) {
$Array1[] = array($score1['roundzA' . $ltr]);
}

$var2 = 'new';
$query =  "SELECT * FROM db_2 WHERE place = schedule";
$result = mysql_query($query);
$score2 = mysql_fetch_assoc($result);
foreach (range('25','35') as $ltr) {
$Array2[] = array($score2['points' . $ltr]);
}
$count = array();
for($i=0;$i<count($Array1);++$i) {
$count[$i] = count(array_intersect($Array1[$i],$Array2[$i]));
}
$countResult = array_sum($count);

Hi firends, there is a store named "baslik". i try to creating photo gallery. i am saving photo and photo's name in database. Photo's name store named "baslik". Now, For example i am saving called "Summer Photos". i saved 10 photos. When i pull the images and names, all photos and names are pulling. I want to pull one image and its name from "baslik" store. "baslik" store's type "varchar" When i click the image's name, it should post other "Summer Photos". Image gallery should creating next to next like 1. image. And When i clicked the image, other images should open. For example when i clicked "meeting" image, it should go other "meeting" images. So, i want to categorize the images.

You can look i put images.

 

anybody has any idea what the code is to put in a main image.

So far i was able to find this but it pulls up all the images added in the album. I am only looking for the first image. Thank you.

 <ul class="thumbs thumbs_nocaptions">
        <?php foreach( $this->paginator as $photo ): ?>
          <li>
            <a class="thumbs_photo" href="<?php echo $photo->getHref(); ?>">
              <span style="background-image: url(<?php echo $photo->getPhotoUrl('thumb.normal'); ?>);"></span>
            </a>
          </li>
        <?php endforeach;?>
      </ul>

field1 / field2
10  /  England
15  /  Italy
20  / France
15  /  France
30  /  USA

When searching for France:
SELECT DISTINCT field2, field1 FROM $tableName would return a distinct value. I want to ensure it returns the highest value in field1.

Something like this:

SELECT DISTINCT field2 (but ensure returns highest field 1 value), field1 FROM $tableName

On the home page I am having a problem pulling information from the MySql here is my code...and this is what I am trying to do... i am trying to pull 10 items from the database that have today's date...I am also trying to make the user name a link to a page called backpack.php where that page can use the user name that is clicked to retrieve more information. (the problem I am having is 10 results come up but it is a repeat of the same 10 results and when you click the link it doesn't show the user that is clicked info.) PLEASE someone help I have been trying to figure this out for the longest time.

Code: [Select]
   <form action="backpack.php" method="post">
           
         <?php
         // rows to return
         $limit=10; 
         $idcount=10;
         $date = date('Y-m-d');
         $count = 0;
            
         
while ($limit>=$count)   
{
   //open database
            $connect = mysql_connect("hostname","uname","pass") or die("Not connected");
            mysql_select_db("db_name") or die("could not log in");
   
            $query = "SELECT *,COUNT(name) FROM boox WHERE date='$date' ORDER BY date";
            $idcount = $row['COUNT(name)'];
            $result = mysql_query($query);
            while($row = mysql_fetch_array($result))

         echo "</br><table width='297' height='200' border='1' align='center' style='overflow:scroll'>
  <tr>
    <td width='152'>Book Title:</td>
    <td width='129'>$row[name]</td>
  </tr>
  <tr>
    <td>Author:</td>
    <td>$row[author]</td>
  </tr>
    <tr>
    <td>ISBN#</td>
    <td>$row[isbn]</td>
  </tr>
  <tr>
    <td>Date Posted:</td>
    <td>$row[date]</td>
  </tr>
  <tr>
    <td>Posted By:</td>
    <td><a href='backpack.php' onclick='document['packback'].submit()'>$row[username]</a></td>
  </tr>
  <tr>
    <td>School:</td>
    <td>$row[school]</td>
  </tr>
</table></br>";   

$count = $count + 1;
$idcount = idcount + 1;
         }
         
         ?>
            </form>

MOD EDIT: DB credentials removed, [code] . . . [/code] tags added.

Good afternoon:

I have added a database field to a table that has quiz questions in it.
the field I have added is for images and I have entered the image url that is stored on the server in an image folder.

Please could you tell me how I can include the image in the request by adding to the code below:

$Questions = $DB->query("select * from ".TABLE_PREFIX."quiz_questions where q_forquiz='{$Quiz['qid']}' order by qqid");

while($Question = $DB->fetch_array($Questions)){
$Q[$Question['qqid']] = $Question;
}

Fields in table quiz_questions:
qqid
q_question
q_type
q_params
q_forquiz
q_questionimages - This is the field I added.

Thank you for helping.
Amilo