Question

I need help showing the first column of the table to show up exactly with the mysql table into the php page. Is there a way to fix it ?

So I created a php form where the user enters the information. sand.truman.edu/~jyl6557/assignment5/hw5-dataentry.php . it asks for name, hometown, gender(only male and female) and status (freshman, sophmore, junior, senior). once it checks and passes through those tests, it would say added successfully and then show the links to add another enry or display the table.

here is the data entry page code:

Submission Form

// form with questions
function printform()
{
echo <<

Fill out the Information

Name:

Hometown:

Gender:

Year-status:

Info

END;
}
function process_form()
{
//local variables
$hostname='mysql.truman.edu';
$username='jyl6557';
$password='obookevo';
$db='jyl6557CS315';
$name=$_POST['Name'];
$hometown=$_POST['hometown'];
$gender=$_POST['gender'];
$status=$_POST['status'];

$connectDB=new PDO("mysql:host=$hostname;dbname=$db", $username,$password);

$sql_insert=$connectDB->prepare( "INSERT INTO People(Name, hometown, gender, status) VALUES (:Name, :hometown, :gender, :status)");
$sql_insert->bindParam(':Name',$name);
$sql_insert->bindParam(':hometown',$hometown);
$sql_insert->bindParam(':gender',$gender);
$sql_insert->bindParam(':status',$status);
$sql_insert->execute();

". $e->getMessage();

$connectDB=null;

echo <<

Added

ADD another entry
END;
}
//main program
if(isset($_POST['Submit']))
{
//matches any set of letters and specific words.
   $nameregrex="/^[A-z_\-]/";
   $hometownregrex="/^[A-z_\-]/";
   $genderregrex="/(M|f)emale|(M|m)ale/";
   $statusregrex="/(F|f)freshman|(S|s)ophmore|(J|j)unior|(S|s)enior/";
if(preg_match($nameregrex, $_POST['Name']) && preg_match($hometownregrex, $_POST['hometown']) && preg_match($genderregrex, $_POST['gender'])
&& preg_match($statusregrex, $_POST['status']))
{

echo << Add another entry


Display table
END;

process_form();
}
}
else
{
printform();
}

?>

the table that suppose to be like this:

Name	hometown	gender	status
john	kansas city	male	senior
bob matthews	kirksville	male	freshman

here is the display table code pulled from mysql table:

Student Information Form



   
  

     
//sorts and displays data
function doGetAll($connectDB)
{
$sortby="name";
$sql="SELECT * from People order by $sortby";
$result=$connectDB->query($sql) or die ("mysql failed");
echo <<

List of students

END;

foreach ($result as $r)
{
extract($r);
print"

";
}
print"

name	hometown	gender	year-status
$name	$hometown	$gender	$status

";
echo <<

Successfully added

Add another information
END;
}
//connects to database
$hostname='mysql.truman.edu';
$username='jyl6557';
$password='obookevo';
$dbname='jyl6557CS315';
$connectDB= new PDO("mysql:host=$hostname;dbname=$dbname" ,$username,$password);

if(!$connectDB)
{
print "Error";
exit;
}
doGetAll($connectDB);

?>


   

Answer 1

<?php
echo "<table border='1' id= results>
<tr>
<th>FILEID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Issue Date</th>
<th>Interest Rate</th>
<th>Terms</th>
<th>Balance Outstanding</th>
<th>Balance Outstanding</th>
<th>New Loan</th>
<th>Principal Repayment for $l_month</th>
<th>Principal Repaid</th>
<th>Balance Outstanding</th>
<th>Interest Payment for $l_month </th>
<th>INTEREST ACCUMULATED DURING FINNANCIAL YEAR</th>
</tr>";

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


  echo "<tr>"; 

    echo "<td>" . $row['app_file_id'] . "</td>";
    echo"<td>". $row['app_fname']."</td>";
    echo"<td>". $row['app_lname']."</td>";
    echo"<td>". $row['commit_date'] ."</td>";
    echo"<td>". $row['computer_interest'] ."</td>";
    echo"<td>". $row['loan_life'] ."</td>";
    echo"<td>". $row['avg(app_ln_amnt)'] ."</td>";
    echo"<td>". $row['Balance Outstanding'] ."</td>";
    echo"<td>". $row['New Loan'] ."</td>";
    echo"<td>". $row['SUM(r.receipt_on_principal)'] ."</td>";
    echo"<td>". $row['Principal Repaid'] ."</td>";
    echo"<td>". $row['avg(app_amnt_owed)'] ."</td>";    
    echo"<td>". $row['SUM(r.receipt_on_interest)'] ."</td>";
    echo"<td>". $row['Interest Accumilated'] ."</td>";
  echo "</tr>";
  }
echo "</table>";
?>
<button onclick="javascript:window.print();"></button>