[Resolved] Seeking some information

badgoat

Hi!

I am seeking some information about how to do what I am trying to do..

so, I have an order.. I enter some information (order title, salesman, phone, cell#, etc.) Everything successfully saves to the database. I have a page which lists all orders in order of when they are due. Now what I'd like to do is to be able to click the title which would take me to the specifics of the order, where I could edit the information if needed.

Since I am a noob, I am not sure what the concept is called, so I am not sure what to Google. Anyone able to give me a hint as to what it's called, and how I might go about it?

Many thanks!

thorpe

your table will need an auto incrimenting field... as an example we'll call it 'id'.

on the page that lists the page by orders due. you simply create your links to a detail page, and put the id in the querystring.

eg;

<a href="details.php?id=<?php echo $row['id'] ?>"><?php echo $row['title'] ?></a>

then on your details page you run a query to get the details based in this id.

eg;

mysql_query("SELECT * FROM orders WHERE id=".$_GET['id'])

i would need to see your existing code, or atleast have an idea of your table design to make this example fit into your code exactly, but hopefully you can see what i meen form the examples.

hope this helps.

badgoat

Hi Thorpe!

Yep, I have an auto-incrementing field in my db, called 'id'. Here is the code for an abbreviated version of my much larger project:

This page sums the info entered:

<?PHP
$connect= mysql_connect("localhost","root") 
   or die("Could not connect to database in localhost !");
$result=mysql_select_db("testdiw") 
   or die("Could not select that database !");

$depmonth=$HTTP_POST_VARS['depmonth'];	
$depday=$HTTP_POST_VARS['depday'];	
$depyear=$HTTP_POST_VARS['depyear'];
$diwtitle=$HTTP_POST_VARS['diwtitle'];
$date_string = $depyear . "-" . $depmonth . "-" . $depday;

$sqlquery = "INSERT INTO mktime VALUES('','". $depmonth ."','". $depday ."','".$depyear."','". $diwtitle. "','".$date_string."')";
$queryresult = mysql_query($sqlquery) or die(" Could not execute mysql query !");
$sqlquery = "SELECT * from mktime  ";



echo '<table>
<tr>
<td>Deposition Date</td>
<td>'.$date_string.'</td>
</tr>		 
<TR>
						<TD COLSPAN=2><form method=get action="spoon3.php">
<input type="submit" value="next"> </form></TD></FORM>
						</TR>		';


?>

This page is where I view the orders which are current:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>NEW DIW</title>
</head>
<body>
<?PHP
$connect= mysql_connect("localhost","root") 
   or die("Could not connect to database in localhost !");
$result=mysql_select_db("testdiw") 
   or die("Could not select that database !");

 $curdate = date("F j, Y");

$sqlquery = "SELECT id, diwtitle, date_string FROM mktime WHERE date_string >= CURDATE() ORDER BY date_string";

$queryresult = mysql_query($sqlquery) or die(" Could not execute mysql query !");
$row = mysql_fetch_row($queryresult);
$date_string = $row[0];
$diwtitle = $row[1];
$id = $row[2];


$tdcount = 1; 
$numtd = 1; // number of cells per row 
echo '<table border="0" width="" bgcolor="">
<tr>
<td colspan=3 bgcolor="#000080"><font face="Tahoma" size="5" color="white"> I-DEP - Current Depositions</font></td>
</tr>
<tr>
<td  bgcolor="#ccccff" width=100><font face="Tahoma" size=2 color="black"><b> Date of Dep </b></font></td>
<td  bgcolor="#ccccff" width=400><font face="Tahoma" size=2 color="black"><b> Title </b></font></td>
<td  bgcolor="#ccccff" width=60><font face="Tahoma" size=2 color="black"><b> Dep ID </b></font></td>';
while($row = mysql_fetch_array($queryresult)) { 
if ($tdcount == 1) echo "<tr>";
echo "<td>",$row['date_string'],"</td><td>",$row['diwtitle'],"</td><td>",$row['id'],"</td>";
 if ($tdcount == $numtd) { 
 echo "</tr>"; 
 $tdcount = 1; 
 } else { 
 $tdcount++; 
 } 
} 
// time to close up our table 
if ($tdcount!= 1) { 
 while ($tdcount <= $numtd) { 
 echo "<td>&nbsp;</td>"; 
 $tdcount++; 
 } 
 echo "</tr>"; 
} 
echo "</table>";
?>
</body>
</html>

From the sound of your post, it doesn't seem to be an extremely complicated thing.. That makes me happy 😉

thorpe

yeah... pretty simple stuff.

just change this line;

echo "<td>",$row['date_string'],"</td><td>",$row['diwtitle'],"</td><td>",$row['id'],"</td>";

echo '<td>'.$row['date_string'].'</td><td><a href="details.php?id='.$row['id'].'"</a>'.$row['diwtitle'],'</td><td>'.$row['id'].'</td>';

then create a page called details.php, and run a query like the one i posted above to get all the info related to that one order.

ps: in your code above it seemed you were using , instead . as a string concatination. was this throwing any errors?

badgoat

Thank you thorpe! I follow you on the first half of editing in the a href part. However I am having trouble visualizing how to do the details.php page.. Just a simple page which will display the variables of any order, which will be displayed per the id provided?

badgoat

I thorpe, I tried as you suggested as such:

echo '<td>'.$row['date_string'].'</td><td><a href="details.php?id='.$row['id'].'" '.$row['diwtitle'],'</a></td><td>'.$row['id'].'</td>';

but the diwtitle, which should be clickable disappears from the page that is displayed. When I view page source, I do get this:<td><a href="details.php?id=35" Craig is tired></a></td>
so it looks like it gets to the browser correctly, but the text which should be clickable is completely gone. What did I do wrong?

mrhappiness

print_r($row);
put this in front of your echo

what does the html source look like now?

badgoat

mrhappiness: Now the page source for the ebtry I showed above is:

<td>2005-11-17</td><td><a href="details.php?id=35" Craig is tired></a></td><td>35</td></tr><tr>Array
(
[0] => 43
[id] => 43
[1] => Craig is anxious
[diwtitle] => Craig is anxious
[2] => 2006-03-25
[date_string] => 2006-03-25
)

and viewing the page shows

Array ( [0] => 35 [id] => 35 [1] => Craig is tired [diwtitle] => Craig is tired [2] => 2005-11-17 [date_string] => 2005-11-17 )

above the table.

mrhappiness

Originally posted by badgoat
<a href="details.php?id=35" Craig is tired></a>

should be

<a href="details.php?id=35">Craig is tired</a>

thorpe

its missing a >. try this;

echo '<td>'.$row['date_string'].'</td><td><a href="details.php?id='.$row['id'].'">'.$row['diwtitle'],'</a></td><td>'.$row['id'].'</td>';

badgoat

mrhappiness: Yep! Trying to understand all these new conecpts in PH makes me forget the basics of HTML.. Correct placement of a > in the code makes the links appear now. Thank you!