jump.php help, NOT resolved

[iownslaves]

Hi!

Okay, I have been trying to do this jump.php :

http://www.programmingtalk.com/showthread.php?t=3972

i want to do

"but if you want something like jump.php?siteID=120 you will need a diffirnet file from the above ...
using a MySQL SELECT statment to bring the url from a database using the site ID is the way to do it .."

I have a table named departments and in it are the records:

Department_name | Department_number | Shortened Name|
ART | 32 | ART |

okay,so I have a combobox that is already populated, but I don't know how to make a jump.php . Also the PK is department Number.

The idea is here:

http://www.christian-web-masters.com/articles/web_user-friendly-urls__page_1.html

BUT IT DOES NOT WORK AT ALL!!!!!!!!! IF YOU CAN CORRECT THIS DUDE"S SCRIPT, PLEASE HELP! I tried it 8 times, but i keep getting a parse error.

[Mordecai]

Since you get a parse error, you may wish to post the code that gives you the parse error.. Contrary to popular belief, we're not (all) psychics.

I looked at the code on that page, the syntax is correct. He is, however, using some bad programming methods and sending complete garbage through that header(). I'd advise that you find a better tutorial.

[iownslaves]

Here's what my DB looks like:

link_id | DEPARTMENT_NAME | SHORTENED_NAME
1 | ART | ART
2 | COMPUTER SCIENCE | CSCI
3 | BIOLOGY | BISC

Link_id is my PK.

here is my page from a combo box (index2.php) :

<?
include("db.php");
?>

<FORM ACTION="jump.php">
<SELECT NAME="link_id">

<?
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database"); 
@mysql_select_db(DB) or die( "Unable to select database");

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() ); 

while($row=mysql_fetch_array($result)){ 

echo "<OPTION VALUE=".$row['SHORTENED_NAME'].">".$row['DEPARTMENT_NAME']."</OPTION>";
}
?>
</SELECT>
<INPUT TYPE="submit" VALUE="Jump!" />
</FORM>

Here is my jump page (jump.php):

<?php
include("db.php"); // this should include the CONNECT and BD SELECT
$query = "SELECT url FROM link WHERE link_id = '$link_id';
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$newloc = $myrow["url"];
mysql_free_result($result);
header(Location: $newloc); 
?>

When you click on the box, it should display a record such as
3 | BIOLOGY | BISC

If you want to take a gander at the page, it's
http://www.pooka.mine.nu/bookstore/secret2/index2.php

Thanks for helping and thanks for telling me that the tutorial sucked! I tried looking for it all over the net! If you found a better tutorial please show me.

Thanks and I am a NOOB,
T

[drawmack]

<?
include("db.php");
?>
<!-- always provide forms with a method -->
<FORM ACTION="jump.php" method="POST">
<SELECT NAME="link_id">

<?
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database"); 
@mysql_select_db(DB) or die( "Unable to select database");

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() ); 

while($row=mysql_fetch_array($result)){ 

echo "<OPTION VALUE=\"".$row['SHORTENED_NAME']."\">".$row['DEPARTMENT_NAME']."</OPTION>";
}
?>
</SELECT>
<INPUT TYPE="submit" VALUE="Jump!" />
</FORM>

Here is my jump page (jump.php):

<?php
include("db.php"); // this should include the CONNECT and BD SELECT

//first off let's make sure that link_id is a number
if(intval($_POST['link_id']) != $_POST['link_id'])) {
    header("Location: " $_SERVER['HTTP_REFERER']);
    exit;
} //end if

//$link_id is a number, so you need not quote it in the
//query and also you need to close the quotes around
//the string
$query = "SELECT url FROM link WHERE link_id = $link_id";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$newloc = $myrow["url"];
mysql_free_result($result);
header(Location: $newloc); 
?>

[iownslaves]

hi yall, it's still not working:

i get this

Parse error: parse error, unexpected T_VARIABLE in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 15

in this area

12      //first off let's make sure that link_id is a number 
13      if((intval($_POST['link_id']) != $_POST['link_id'])) 
14      { 
15          header("Location: " $_SERVER['HTTP_REFERER']); 
16          exit; 
17      } //end if 

I decided to take that code out and i was left with:

17     MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to 18     connect to database");  

19     @mysql_select_db(DB) or die( "Unable to select database"); 
20
21     $query = "SELECT url FROM link WHERE link_id = $link_id"; 
22     $result=mysql_query($query); 
23     $row=mysql_fetch_array($result); 
24     $newloc = $myrow["url"]; 
25     mysql_free_result($result); 
26     header(Location: $newloc);  

27?> 

and i get this error:

Parse error: parse error, unexpected ':' in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 26

oh yeah, in my database, there is a URL field.

[laserlight]

Next time read the PHP Manual first, in this case on [man]header[/man].

header("Location: $newloc");

[iownslaves]

hi!

still having problems. I think i am high. I am not sure what is going on.

Here's the error:

Parse error: parse error, unexpected T_STRING in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 29

and here's teh code for jump.php

<?php 
include("db.php"); // this should include the CONNECT and BD SELECT 

//first off let's make sure that link_id is a number 
if(intval($_POST['DEPARTMENT_NUMBER']) != $_POST['DEPARTMENT_NUMBER'])
{ 
  header("Location:  $_SERVER ['HTTP_REFERER']); 
exit; 
} //end if 

//$link_id is a number, so you need not quote it in the 
//query and also you need to close the quotes around 
//the string 

$query = ("select url from departments where DEPARTMENT_Number = $department_number)"; 

$result=mysql_query($query); 
$row=mysql_fetch_array($result); 
$newloc = $myrow["url"]; 
mysql_free_result($result); 
header("Location: $newloc");  

?> 

here's the index2.php

<? 
include("db.php"); 
?> 
<!-- always provide forms with a method --> 
<FORM ACTION="jump.php" method="POST"> 
<SELECT NAME="link_id"> 

<? 
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database");  

@mysql_select_db(DB) or die( "Unable to select database"); 

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc"); 

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );  

while($row=mysql_fetch_array($result)){  

echo "<OPTION VALUE=\"".$row['SHORTENED_NAME']."\">".$row['DEPARTMENT_NAME']."</OPTION>"; 
} 
?> 
</SELECT> 
<INPUT TYPE="submit" VALUE="Jump!" /> 
</FORM> 

i fixed the header errors. i just spaced them apart, but now the error is located in jump.php where:

$query = ("select url from departments where DEPARTMENT_Number = $department_number)"; 

thanks for helping me!

[sidney]

 header("Location:  $_SERVER ['HTTP_REFERER']);   

you havent closed the "

if you look at th colour parsing of your code in your post you will see all the red down to your query which should not be red

 header("Location:  ".$_SERVER ['HTTP_REFERER']);   

and

 $query = ("select url from departments where DEPARTMENT_Number = $department_number)"; 

should be

 $query = ("select url from departments where DEPARTMENT_Number = $department_number"); 

[iownslaves]

HOLY CRAP!

I am almost there!!!!!

one more thing dealing with jump.php is this error:

Parse error: parse error, unexpected T_VARIABLE in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 36

I read about how to do a header file but i do everything they list, and i still get this mofo error!!

here's there code AGAIN:

 15    <?php 
16    include("db.php"); // this should include the CONNECT and BD SELECT 
17
18    //first off let's make sure that link_id is a number 
19     if(intval($_POST['DEPARTMENT_NUMBER']) != $_POST['DEPARTMENT_NUMBER'])
20     { 
21      header("Location:  ".$_SERVER ['HTTP_REFERER']);
22     exit; 
23}      //end if 
24
25     //$link_id is a number, so you need not quote it in the 
26     //query and also you need to close the quotes around 
27     //the string 
28
29     $query = ("select url from departments where DEPARTMENT_NUMBER = $DEPARTMENT_NUMBER");
30
31     $result = mysql_query ($query); 
32     $row = mysql_fetch_array ($result); 
33     $newloc = $myrow ["url"]; 
34     mysql_free_result ($result); 
35
36     header("Location:  "$newloc);  

37     ?> 

there error is in this line:

header("Location: "$newloc);

ALSO,

if i do this

header("Location: $newloc");

then my slutful of errors are

Notice: Undefined variable: DEPARTMENT_NUMBER in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 29

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 32

Notice: Undefined variable: myrow in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 33

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 34

Warning: Cannot modify header information - headers already sent by (output started at c:\inetpub\wwwroot\bookstore\SECRET2\jump.php:15) in c:\inetpub\wwwroot\bookstore\SECRET2\jump.php on line 36

sorry about the header junk, i am still a NOOB and I am really learning a lot from you all since it's like java, blah

[PallaviDalvi]

well i wud suggest u to have a look at the two 'header' lines in ur own peice of code.

header("Location: ".$_SERVER ['HTTP_REFERER']);
header("Location: "$newloc);

spot the differences!!! 🙂

[sidney]

$DEPARTMENT_NUMBER where does it get its value as it remains unset

[iownslaves]

I already tried screwing with the headers but it gives me an error each time: index2.php has a combobox and a submit button, and then when you hit it, it is supposed to go to the url that is contained in the table such as if i choose option X it will take me to yahoo.com. The primary key in that table is DEPARTMENT_NUMBER

<? 
include("db.php"); 
?> 
<!-- always provide forms with a method --> 
<FORM ACTION="jump.php" method="POST"> 
<SELECT NAME="DEPARTMENT_NUMBER"> 

<? 
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database");  

@mysql_select_db(DB) or die( "Unable to select database"); 

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc"); 

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );  

while($row=mysql_fetch_array($result)){  

echo "<OPTION VALUE=\"".$row['SHORTENED_NAME']."\">".$row['DEPARTMENT_NAME']."</OPTION>"; 

} 
?> 
</SELECT> 
<INPUT TYPE="submit" VALUE="Jump!" /> 
</FORM> 

jump.php

<?php 
include("db.php"); // this should include the CONNECT and BD SELECT 

//first off let's make sure that link_id is a number 
if(intval($_POST['DEPARTMENT_NUMBER']) != $_POST['DEPARTMENT_NUMBER'])
{ 
 header("Location:  ".$_SERVER ['HTTP_REFERER']);
exit; 
} //end if 

//$link_id is a number, so you need not quote it in the 
//query and also you need to close the quotes around 
//the string 

$query = ("select url from departments where DEPARTMENT_NUMBER = $DEPARTMENT_NUMBER");

$result = mysql_query ($query); 
$row = mysql_fetch_array ($result); 
$newloc = $myrow ["url"]; 
mysql_free_result ($result); 

//header("Location: " ,  $newloc);  

header("Location:  ".$_SERVER ['HTTP_REFERER']);
?> 

Y'all helped me on the department_number thing earlier in the post. And I followed it.

Thanks!