PHP - Need Solution To My God Awful Urls For Page Links.

Hello,
 
I have a quick question about methods for retrieving records from a mysql table and displaying
them as a links

For example,  imagine I have three tables called countries, cities and city_info.
I'd like to be able to select a country and have a list of that country's city names returned as links. 
I'd then like to be able to click on the link for London, say, and that would trigger a mysql query to retrieve
the entry in city_info about London.

Are there any functions that allow this?

If anyone could point me in the right direction for further research I'd be grateful.

Thanks. 

Hello - hoping to find some direction with this. I think this is fairly simple for more experienced php coders but I'm having trouble with it. It's a php grep text string search that results in a list of files that contain the string.   Hoping to split the $results value (list of file names) into separate links to open the file. I was able to convert into a link for the first file listed, but it links to that same file for all the entries in the list. I assume that maybe an array of  $results needs to be created first rather than try and work with  $results at the end?

<?php

/**
* E.Yekta
* cafewebmaster.com
*/     

	define("SLASH", stristr($_SERVER[SERVER_SOFTWARE], "win") ? "\\" : "/");          

	$path    = ($_POST[path]) ? $_POST[path] : dirname(__FILE__) ;     
	$q        = $_POST[q];          

	function php_grep($q, $path){                  

		$fp = opendir($path);         
		while($f = readdir($fp)){             
			if( preg_match("#^\.+$#", $f) ) continue; // ignore symbolic links             
			$file_full_path = $path.SLASH.$f;             
			if(is_dir($file_full_path)) {                 
				$ret .= php_grep($q, $file_full_path);             
			} else if( stristr(file_get_contents($file_full_path), $q) ) {                 
				$ret .= "$file_full_path\n";             
			}         
		}         
		return $ret;     
	}     

	if($q){         
		$results = php_grep($q, $path);     
	}               



	echo <<<HRD     
	<pre >     
	<form method=post>         
		<input name=path size=100 value="$path" /> Path         
		<input name=q size=100 value="$q" /> Query         
		<input type=submit>     
	</form>              

		$results          

	</pre >     

HRD;

?> 

Attached Files  php_grep.php   908bytes   0 downloads

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.

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>

Below code is working fine but i need to redirect on 3 different pages and its giving me error. My table structure is as   User table Email                                  Password admin@yahoo.com             123 tariq@yahoo.com                987 bilal@yahoo.com                 456     if user name is like; admin@yahoo.com the page should redirect on welcome.php if user name is like; info@aiousoft.com the page should redirect to welcome2.php and if user doesnot exist in database then give error as ELSE "user doesnot exist"   thanks   signin.php   <html><head><title>Sign In</title></head><body>
<?php include 'header.php'; ?>
<?php include 'menu.php'; ?>
<center>
<form method="post" action="checklogin.php">
  <h3>Please Signin</h3>
  <table width="400" border="0">
    <tr><td>Email</td>
      <td><input name="email" type="text" id="email"></td></tr>
    <tr><td>Password</td>
      <td><input name="password" type="password" id="password"></td></tr>
  </table>  <p><label>
    <input type="submit" email="submit" value="Submit">
    </label><input email="reset" type="reset">
    </p>
  </form>
</center>
</body>
</html>   checklogin.php <html><head><title>Check Login</title></head><body>
<?php
include 'header.php';
include 'menu.php'; $email=$_POST['email'];
$password=$_POST['password']; @ $db = mysql_pconnect('localhost', 'root', '');
if (!$db)
{ echo 'Error: Could not connect to database. Please try again later.';
exit;}
mysql_select_db('car');
$q=mysql_query("select * from user where email='".$email."'  and password='".$password."' ") or die(mysql_error());
$res=mysql_fetch_row($q);
if($res)
{
 header('location:welcome.php');
}
else
{
  echo' Please signin again as your user name and password is not valid';
}
?>
</body>
</html>     Attached Files  header.php   284bytes   0 downloads  menu.php   308bytes   0 downloads