[Wren182]

I'm working with Perl and MySQL to set up databasing for a site. I haven't used this scripting in about 5 years so I'm a little rusty. I'm trying to use a link in one table (through Perl scripting) that will then show the results from another table. For example... For what I'm working on there are 2 tables, one for dispatch info and then a second for dispatch details (more detail about the first table's info). The primary key for the the dispatch info is the dispatch number. I'd like to make it that the dispatch number shows up as a link (on the HTML table displayed on the screen) that can access the more detailed info about that dispatch number on the second table (and display this info in a HTML table for viewing also).

I've attached a Word file below that may expain and show this info better.

Can you please help??

Take care,

Tristina

Attached Files

•  example.doc   322.5KB   25 downloads

Edited by Wren182, 21 January 2007 - 03:55 PM.

[Advertisements]

I would do something like

<a href="/details.php?number=put the dispatch number here">Details</a>

And the get the variable number and use that to display all the details from the other table.

I can't really say much more as I don't know your code, and use PHP not Perl

Edited by Michael, 22 January 2007 - 02:23 AM.

[Michael]

I would do something like

<a href="/details.php?number=put the dispatch number here">Details</a>

And the get the variable number and use that to display all the details from the other table.

I can't really say much more as I don't know your code, and use PHP not Perl

Edited by Michael, 22 January 2007 - 02:23 AM.

[Wren182]

Hi Michael,

I appreciate you looking into this for me but I am not familiar with PHP. (Sorry) And I'm not sure how this command would tie in the mySQL table?

Tristina

[Michael]

I meant that to be HTML you put the dispatch number in when creating the page. It a links to another page the displays the details based to the dispatch number collected from the url.

I sure this would work in Perl as well as PHP

Is this what you wanted?

[Wren182]

Hi Michael (and anyone else reading this),

Okay on your suggestion and a friend of mine I've tried to get the login to work in PHP. Please be patient with me as I have NEVER used PHP and am trying to understand what it is I'm actually doing.

I have 2 questions:

1. Could you suggest a good book or site that would help me to understand the PHP better, since I have to do some really intense stuff.

&

2. What am I doing wrong with this script? It's connecting to MySQL and everything, but it keeps telling me the password is wrong. I really need to get this done so I can move on to the other pages.


All info is below. And you can view the problem at www.fr8ship.com/login.php

Thank you for all your helps so far. I really appreciate!

Tristina

Database info (MySQL):

Removed

Script:

<?php// Connects to your Database mysql_connect("MySQLA4.webcontrolcenter.com","********", "******") or die(mysql_error()); mysql_select_db("imperial") or die(mysql_error()); //Checks if there is a login cookieif(isset($_COOKIE['ID_my_site']))//if there is, it logs you in and directes you to themembers page{ 	$username = $_COOKIE['ID_my_site']; 	$pass = $_COOKIE['Key_my_site'];		$check = mysql_query("SELECT * FROM implogin WHEREnewuser = '$username'")or die(mysql_error());	while($info = mysql_fetch_array( $check )) 			{		if ($pass != $info['password']) 			{						}		else			{			header("Location: members.php");			}		}}//if the login form is submittedif (isset($_POST['submit'])) { // if form has beensubmitted// makes sure they filled it in	if(!$_POST['username'] | !$_POST['pass']) {		die('You did not fill in a required field.');	}	// checks it against the database	if (!get_magic_quotes_gpc()) {		$_POST['email'] = addslashes($_POST['email']);	}	$check = mysql_query("SELECT * FROM implogin WHEREnewuser = '".$_POST['username']."'")ordie(mysql_error());//Gives error if user dosen't exist$check2 = mysql_num_rows($check);if ($check2 == 0) {		die('That user does not exist in our database. <ahref=add.php>Click Here to Register</a>');				}while($info = mysql_fetch_array( $check )) 	{$_POST['pass'] = stripslashes($_POST['pass']);	$info['password'] = stripslashes($info['password']);	$_POST['pass'] = md5($_POST['pass']);//gives error if the password is wrong	if ($_POST['pass'] != $info['password']) {		die('Incorrect password, please try again.');	}else{// if login is ok then we add a cookie 	$_POST['username'] = stripslashes($_POST['username']);	$hour = time() + 3600; setcookie(ID_my_site, $_POST['username'], $hour);setcookie(Key_my_site, $_POST['pass'], $hour);	//then redirect them to the members areaheader("Location: members.php");}}} else {	// if they are not logged in?><form action="<?php echo $_SERVER['PHP_SELF']?>"method="post"><table border="0"><tr><td colspan=2><h1>Login</h1></td></tr><tr><td>Username:</td><td><input type="text" name="username" maxlength="40"></td></tr><tr><td>Password:</td><td><input type="password" name="pass" maxlength="50"></td></tr><tr><td colspan="2" align="right"><input type="submit" name="submit" value="Login"></td></tr></table></form><?php}?>

[Michael]

http://www.php.net/manual/en/ PHP manual

I can't see any PHP errors on that page, nor do I know the user name or password. I not exactly sure what is going wrong.

[ScHwErV]

I removed the username and password. Seriously, who posts their username and password on an open forum??

[Michael]

I removed the username and password. Seriously, who posts their username and password on an open forum??

Of course I knew it was you, what other mod/admin runs around in the web forums?

[Wren182]

I'm sorry, but I was desperate!! I need to have this work done by Monday night and I can't even get the stupid login to work. I went through it with a fine tooth comb and tried to figure out from other sites what I could have done wrong. I can always change my id and password once I get this figured out for security reasons and there is nothing sensitive in there right now until I can get it working.

Can I email someone directly for help with this?

Tristina

[Michael]

You could PM me?

A great place for quick help is #php in irc.freenode.org that is if you know how to use IRC.