Connecting to a website

jennifer_ann

I have php written in order for me to query information, however, I need to connect it to a certain website. This is what I have thus far.

[code=php]   <html>

<head>
	<title>Contact  </title>
	<link rel="stylesheet" href="eye01.css" type="text/css" />
</head>

<?php
$db = mysql_connect("localhost","root","");
if (!$db){
		print "error - Could not connect to MySQL";
		exit;
}

$er = mysql_select_db("touch_art1");
if(!$er){
	print "error - Could not select the database";
		exit;	
}
	$query =  $query = "SELECT * FROM `sperm` WHERE year_left =".$year; 
	$query2=  $query = "SELECT * FROM `cperm` WHERE year_left =".$year; 
	$result = mysql_query($query);
	$result2 =mysql_query($query2);
//check to see if query worked
if (!$result)
{
	echo "Query on Connection failed!";
	// exit	
}
else
{
	echo 'succees';
	// process results

while($row = mysql_fetch_row($result)) {
$date = $row[1];
echo "$date"; 
$name =$row[2];
echo"$name";
}
}
?>

</html>
</html>

Now, if I want it to go to a certain site, do I........

[code=php]//close connection
mysql_close();

header("Location: http://localhost/questions1.php")
?>

Could someone please clarify this for me? Also, when I make a query, do I need to set variables???

mrmigu

what exactly are you trying to do?

header("Location: http://localhost/questions1.php")

will only take your browser to this page. If you are planning on sending data to that page, you will have to do something else.

jennifer_ann

I am running the query from a webpage, and I want to display results on the specified web page. I'm not sure how to do that.

mrmigu

if youre trying to pass the data to the questions1.php file, you have two options

you could create a string of all the data in the query results, like:

$string = '?date='.$date.'&name='.$name;

and then do something like

header("Location: http://localhost/questions1.php".$string)

or write the results to hidden values of a form, and submit the form to that page once the queries have completed

though, it may be easiest to just output the query results in the file that runs the query

jennifer_ann

[code=php]<html>

<head>
	<title>Eye Contact - Century to Century</title>
	<link rel="stylesheet" href="eye01.css" type="text/css" />
</head>

<?php
$db = mysql_connect("localhost","root","");
if (!$db){
		print "error - Could not connect to MySQL";
		exit;
}

$er = mysql_select_db("touch_art1");
if(!$er){
	print "error - Could not select the database";
		exit;	
}

$query =  $query = "SELECT * FROM `sperm` WHERE year_left =".$year; 
$query2=  $query = "SELECT * FROM `cperm` WHERE year_left =".$year; 
$result = mysql_query($query);
$result2 =mysql_query($query2);
//check to see if query worked
if (!$result)
{
	echo "Query on Connection failed!";
	// exit	
}
else
{
	echo 'succees';
	// process results

while($row = mysql_fetch_row($result)) {
$date = $row[1];
echo "$date"; 
$name =$row[2];
echo"$name";

}
}
$string = '?date='.$date.'&name='.$name;
header("Location: http://localhost/startsearch.php".$string) 
?>

</html>

Still not working.......

laserlight

How does it not work?

thorpe

What does still not working meen? What code are you using on startsearch.php to retrieve these variables from the querystring?

Besides that... Why do you want to run your query on one page and display the results on another? This is'nt how its normally done.

jennifer_ann

Sorry, I am not good at explaining things. Ok I have this code here that I am using to run a query. Do I need to put anything in here about the webpage the query is being run on, or in my web page code, do I refer to the php? And also, in this code, do I need something like

//set access variables
$country_origin = "country"

or something like that?

Houdini

As it is now coded it will not work with a header() because the <html> will send a header which is output so you will get the familiar Warning: Cannot modify header information - headers already sent by (output started at blah blah blah You can have no output prior to using the header() function not even a space. You might need to look at a different approach like processing the data on the part of the website you are wanting it to display on.

jennifer_ann

I can run the query from my database, but I just can't get it to connect with my webpage now.

Blulagoon

I have to say its not entirely clear to me what you are trying to do, but if you are looking to go to another, possibly quite different website and pass the results then this might help:

echo 'succees'; 
    // process results 

while($row = mysql_fetch_row($result)) { 
$date = $row[1]; 
echo "$date"; 
$name =$row[2]; 
echo"$name"; 

echo "<a href='http://myothersite.com/index.php?name=".$name."&date=".$date."'>This is a link</a>";

}

This would output links to whatever new website you want and pass the information to that new page where it would be available as $GET['name'] and $GET['date']

As I say, I don't really understand what you are trying to do, but offer this just in case it gives you some useful idea.

Blu