PHP - Grab Links From A Page

How do you have a script, after getting the page, search for and as the result, post *part* of every link that ends like...

&amp;v=ANYTHING">Link text</a>

and as the result, posting just

ANYTHING">Link text<BR>

I'm messing with...

<?php

$page = $_GET['page'];
$user = $_GET['user'];

$doc = new DOMDocument;
$doc->load('http://m.youtube.com/profile?gl=US&client=mv-google&hl=en&user=$user&view=videos&p=$page');

$items = $doc->getElementsByTagName('a');

foreach($items as $value) {
echo $value->nodeValue . "\n";
$attrs = $value->attributes;
echo $attrs->getNamedItem('href')->nodeValue . "\n";
};

?>

but it get's way too much stuff. Get's data from every link on the page, and posts it as

Page Text
/watch?gl=US&client=mv-google&hl=en&v=XXXXX

And I can't get

$page = $_GET['page'];
$user = $_GET['user'];

to get the data from the URL.

how do i grab and print on page in date order all .jpg files in a folder ?

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

Im trying to make a php program that will grab all the user's tweets they have ever done.. I'm using curl to request the twitter page and scrape the html.

It looks as though the maximum amount of tweets I can get is 20, which is the amount on the initial first page. There is some script that loads another 20 tweets once I scroll to the bottom of the page...

Does anyone know how to make the page automatically load a certain amount so I can scrape more than the first 20 at once.

Hey all, I'm currently coding a Few Blacklists for my Website, in which I want to code it so I'll have all blacklists on one page so the URL would be like:

localhost/blacklist.php?user
localhost/blacklist.php?staff

I've got a Blacklist coded which all works well, just I've attempted using the $_GET function to change the code to the blacklist that they clicked on...


<?php
session_start();

include ("includes/config.php");
include ("includes/functions.php");

logincheck();

$Username = $_SESSION['username'];

?>
<table width='50%' cellpadding='0' cellspacing='0' border='1' class='table' align='center'>
<tr>
     <td class='header' align='center' colspan='4'>Other Blacklists:</td>
    </tr>
    <tr>
     <td align='center'><a href='?user' target='mainFrame'>User Blacklist</a></td><td align='center'><a href='?money' target='mainFrame'>Most Money</a></td><td align='center'><a href='?racewins.php' target='mainFrame'>Race Wins</a></td><td align='center'><a href='?racelose' target='mainFrame'>Race Loses</a></td>
    </tr>
    <tr>
     <td align='center'><a href='?miles' target='mainFrame'>Most Miles</a></td><td align='center'><a href='?fosbl' target='mainFrame'>Faster Or Slower</a></td><td align='center'><a href='?police' target='mainFrame'>Police Chase</a></td>
    </tr>
</table>        
<br />
<table width='20%' cellpadding='0' cellspacing='0' border='1' class='table' align='center'>
     <tr>
         <td colspan='2' align='center' class='header'>User Blacklist:</td>
        </tr>
        <tr>
         <td align='center' class='omg' width='5%'>Num:</td><td align='center' class='omg' width='10%'>Username:</td>
        </tr>       

<?php
if ($_GET['user']){
$Query = mysql_query("SELECT * FROM users WHERE userlevel = '1' OR userlevel = '5' ORDER BY rep DESC LIMIT 25");
for ($Place < 25; $This = mysql_fetch_object($Query);){
$Place = $Place+1;
if ($This->username != $Username){
$Colour = "bgcolor=#424242";
}else{
$Colour = "bgcolor=#111111";
}
print ("<tr><td width='5%' align='center' $Colour>$Place</td><td width='20%' align='center' $Colour><a href='profile.php?viewuser=".$This->username."'>$This->username</a></td></tr>");
}
}


?>
    </table> 
    <br />

Soon as I added the $_GET['user]{ it stopped showing the Blacklist completely.

Sorry if it wasn't explained well, but hopefully you can catch what I'm trying to-do

Thanks.