[SOLVED] Form post

DarkPrince2005 · September 19, 2007

I have two pages one that lists all the fields in the database with a button that should take you to the second page and only display the chosen record, but it isn't displaying anything.

nehw 3.php

<?

mysql_connect("localhost","root","");

mysql_select_db("npa");

// Begin your table outside of the array

echo "<html><head><title></title><link rel='stylesheet' href='stylesheet.css' type='text/css'>

<style>

a:link{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:none;

}

a:visited{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:None;

}

a:hover{font-family:'Times New Roman';

font-size:10pt;

text-decoration:none;

color:'#B37A04';

font-weight:700;

}

a:active{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

}

</style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'>

<a href='view.php'>View Records</a><br><br>

<a href='add.html'>Add Record</a><br><br>

<a href='edit1.php'>Edit Record</a><br><br>

<a href='delete1.php'>Delete Record</a><br><br>

<a href='report.php'>View Report</a><br><br>

<a href='q.php'>Query Report</a><br><br>

<a href='search1.php'>Search</a></td><td valign='top' align='center'><table><tr>

<tr><td align='center' valign='top'><h1>Disciplinaries: Age Analysis</h1></td></tr>

<td><b>First Name</b></td>

<td><b>Persal Number</b></td>

<td><b>Occupation</b></td>

<td><u><b>Region</b></td>

<td> </td><td> </td></tr>";

// Define your colors for the alternating rows

$color1 = "#FFBB55";

$color2 = "#CCEEFF";

$row_count = 0;

// Perform an statndard SQL query:

$date1= mysql_query("SELECT datediff(curdate(),Date_Recieved) from dis;");

$r = mysql_query ("UPDATE dis SET Date_Added=(SELECT datediff(curdate(),Date_Recieved));");

$q = mysql_query("SELECT * from dis order by Date_Added desc");

// We are going to use the "$row" method for this query. This is just my preference.

while ($row = mysql_fetch_assoc($q)) {

$file_ref=$row["File_Ref"];

$ef=$row["Employee_Firstname"];

$el=$row["Employee_Lastname"];

$persal=$row["Persal_Number"];

$occ=$row["Occupation"];

$unit=$row["Unit"];

$region=$row["Region"];

$date_added=$row["Date_Added"];

/* Now we do this small line which is basically going to tell

PHP to alternate the colors between the two colors we defined above. */

$row_color = ($row_count % 2) ? $color1 : $color2;

// Echo your table row and table data that you want to be looped over and over here.

echo "

<tr>

<td align='left' bgcolor='$row_color'>$persal</td>

<td align='left' bgcolor='$row_color'>$region</td>

<td align='left' bgcolor='$row_color'>$date_added</td>

<td bgcolor='$row_color'> </td></tr>";

// Add 1 to the row count

$row_count++;

}

// Close out your table.

echo "</table></form>";

?>

view333333.php

<?php

mysql_connect("localhost","root","");

mysql_select_db("npa");

$q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'");

while ($row = mysql_fetch_assoc($q))

$ef=$row["Employee_Firstname"];

$el=$row["Employee_Lastname"];

$persal=$row["Persal_Number"];

$occ=$row["Occupation"];

$level=$row["Level"];

$gender=$row["Gender"];

$race=$row["Race"];

$unit=$row["Unit"];

$region=$row["Region"];

$date_added=$row["Date_Added"];

{

echo "<html><head><title></title><link rel='stylesheet' href='stylesheet.css' type='text/css'>

<style>

a:link{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:none;

}

a:visited{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:None;

}

a:hover{font-family:'Times New Roman';

font-size:10pt;

text-decoration:none;

color:'#B37A04';

font-weight:700;

}

a:active{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

}

</style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'>

<a href='view.php'>View Records</a><br><br>

<a href='add.html'>Add Record</a><br><br>

<a href='edit1.php'>Edit Record</a><br><br>

<a href='delete1.php'>Delete Record</a><br><br>

<a href='report.php'>View Report</a><br><br>

<a href='q.php'>Query Report</a><br><br>

<a href='search1.php'>Search</a></td><td valign='top' align='center'><table><tr>

<td align='right' valign='top'><form action='search2.php' method='post'><b>Search by Persal Number:</b> <input type='text' name='search'> <input type='submit' value='Search'></form></td></tr>

<tr><td align='center' valign='top'><h1>View Disciplinary Records</h1></td></tr>

<tr><td><b>Employee Firstname</td><td> </td>

<tr><td><b>Employee Lastname</td><td> </td>

<td>$row[Employee_Lastname]</td></tr>

<tr><td><b>Persal Number</td><td> </td>

<td>$row[Persal_Number]</td></tr>

<tr><td><b>Occupation</td><td> </td>

<td>$row[Occupation]</td</tr>

<tr><td><b>Level</td><td> </td>

<td>$row[Level]</td</tr>

<tr><td><b>Gender</td><td> </td>

<td>$row[Gender]</td</tr>

<tr><td><b>Suspension</td><td> </td>

<td>$row[suspensions]</td</tr>

<tr><td><b>Period</td><td> </td>

<td>$row[Period]</td></tr>

<tr><td><b>Date Recieved</td><td> </td>

<td>$row[Date_Recieved]</td</tr>

<tr><td><b>Region</td><td> </td>

<td>$row[Region]</td</tr>

<tr><td><b>Status</td><td> </td>

<td>$row[status]</td</tr>

<tr><td><b>Category</td><td> </td>

<td>$row[Category]</td></tr>

<tr><td><b>Outcome</td><td> </td>

<td>$row[Outcome]</td></tr></table></td><td> </td><td valign='top'><table width='400'>

<tr><td valign='top'><b>Status Report</td><td> </td>

<td width='250'>$row[status_Report]</td></tr>

<td>$row[Date_Added] Days</td></tr>

</table></table></td></tr></table></td></tr></table>

</body>";

};

echo mysql_num_rows($r);

?>

JJohnsenDK · September 19, 2007

i think your problem is in your while loop in the view.php file:

<?php
$q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'");
while ($row = mysql_fetch_assoc($q))
$ef=$row["Employee_Firstname"];
$el=$row["Employee_Lastname"];
$persal=$row["Persal_Number"];
$occ=$row["Occupation"];
$level=$row["Level"];
$gender=$row["Gender"];
$race=$row["Race"];
$unit=$row["Unit"];
$region=$row["Region"];
$date_added=$row["Date_Added"]; 
{

?>

you need to put the variables into the embracer, like this:

<?php
$q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'");
while ($row = mysql_fetch_assoc($q))
{
   $ef=$row["Employee_Firstname"];
   $el=$row["Employee_Lastname"];
   $persal=$row["Persal_Number"];
   $occ=$row["Occupation"];
   $level=$row["Level"];
   $gender=$row["Gender"];
   $race=$row["Race"];
   $unit=$row["Unit"];
   $region=$row["Region"];
   $date_added=$row["Date_Added"]; 


?>

DarkPrince2005 · September 19, 2007

It actually doesn't seem to make a difference

JJohnsenDK · September 19, 2007

and the data is save into the database?

DarkPrince2005 · September 19, 2007

Yes,all the data is in the database

Sign In

[SOLVED] Form post

Recommended Posts

DarkPrince2005

Link to comment

Share on other sites

JJohnsenDK

Link to comment

Share on other sites

DarkPrince2005

Link to comment

Share on other sites

JJohnsenDK

Link to comment

Share on other sites

DarkPrince2005

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information