PHP full help part2....

[maze027]

good day experts... kindly help me with this situation.... i wanted to view/display all the inputted data of a certain student in table form.... how will i do it??? i am using PHP and MySQL,....and also am i able to do a SQL code creating a table??? pls help... thanks in advance....

[Lazlo90]

It's a bit unclear to me what you want to do, basically you're saying that you want to create a form so that a student can input their data, correct?

Then after they do that you want that data to be stored via SQL and then be able to view it.

Well once that data is stored onto the SQL, you just need access to the SQL to view the info. As for creating this, perhaps the following tutorial might help: SQL Form - SQL File - Upload File

[sam]

if(isset($_POST['summary'])) {
$show_summary = true;
} else {
$show_summary = false;
}

< FORM method="POST" action="testpage.php" >
< INPUT type="submit" name="summary" value="Show Summary" >
< /FORM >

< ?php if ($show_summary == true) { ? >
< table border="1" cellpadding="3" >
<tr>
< td class="smallText" align="center" width="80%"><?php echo "URL" ;
?></td>
</tr>
</table>
<?php } ?>

Please check the above to insert table on your page:drunk:

[maze027]

ahm.... here is the situation... a professor will log in to the site then he will input students grade then save it to the database via SQL statement..... if the user is a student then he will log on to the site inputting his student number then automatically he will view his grades in a table form.... actually we wanted to have 3 type of users... the ADMIN, PROFESSOR, and the STUDENT.....

[php_rules]

Originally Posted by maze027

ahm.... here is the situation... a professor will log in to the site then he will input students grade then save it to the database via SQL statement..... if the user is a student then he will log on to the site inputting his student number then automatically he will view his grades in a table form.... actually we wanted to have 3 type of users... the ADMIN, PROFESSOR, and the STUDENT.....

ahh, for that you want to SELECT

so, lets say you have in your database a field called 'jobrole' inside the database called 'grades', then you would

SELECT * FROM grades.jobrole WHERE grades.jobrole = student

you can find a lot more info here
MySQL :: MySQL 5.0 Reference Manual :: 12.2.8 SELECT Syntax

[maze027]

SELECT * FROM grades.jobrole WHERE grades.jobrole = student


>>>> is this a direct code on the SQL statement????? actually i am really on a hard time doing PHP and MySQL....