Jump to content

[SOLVED] Form post


DarkPrince2005

Recommended Posts

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'>

<center><table width='100%' height='100%' cellpadding='0' cellspacing='0' border='0'>

<tr><td valign='top' width='140' bgcolor='#000000'><br>

<a href='home.html'>Home</a><br><br>

<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'></td></tr>

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

<tr><td align='center' valign='top'></td></tr>

 

<tr><td valign='top'><br><form action='view333333.php' method='post'><table cellpadding='2' border='0' cellspacing='0'>

<tr bgcolor='#ff9900' height='50'>

<td> </td><td> </td>

<td><b>File_Ref</b></td>

<td> </td><td> </td>

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

<td> </td><td> </td>

<td><b>Last Name</b></td>

<td> </td><td> </td>

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

<td> </td><td> </td>

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

<td> </td><td> </td>

<td><b>Unit</b></td>

<td> </td><td> </td>

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

<td> </td><td> </td>

<td><u><b>Age ( Days )</b></td>

<td> </td><td> </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 bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

<td align='left' bgcolor='$row_color' height='40'><input type='hidden' name='duh' value='$row[File_Ref]'>$row[File_Ref]</td>

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

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

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'> </td>

<td bgcolor='$row_color'><input type='submit' value='   View   '></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'>

<center><table width='100%' height='100%' cellpadding='0' cellspacing='0' border='0'>

<tr><td valign='top' width='140' bgcolor='#000000'><br>

<a href='home.html'>Home</a><br><br>

<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 align='center' valign='top'></td></tr>

 

<tr><td align='center' valign='top'><br><center>

<table cellpadding='0' border='0' cellspacing='0'><tr>

<td valign='top'><table width='400'>

<tr><td><b>File Ref</td><td> </td>

<td>".$row['File_Ref']."</td></tr>

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

<td>$el</td></tr>

<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>Race</td><td> </td>

<td>$row[Race]</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>Unit</td><td> </td>

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

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

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

<tr><td><b>Date Of DC</td><td> </td>

<td>$row[Date_Of_DC]</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>

<tr><td valign='top'></td><td> </td>

<td></td></tr>

<tr><td valign='top'><b>Age</td><td> </td>

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

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

</body>";

};

echo mysql_num_rows($r);

?>

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/69858-solved-form-post/
Share on other sites

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"]; 


?>

Link to comment
https://forums.phpfreaks.com/topic/69858-solved-form-post/#findComment-350924
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.