php / mysql assignment

Question

loloy123 0 Newbie Poster

13 Years Ago

Hi,

Ive been at this all weekend and can't figure it out.... I need to take it name and 3 results via a form and store this in a mysql database - done. Then I need to print on screen via php who got the highest score. The highest score is got by adding the 3 results together and the biggest sum of the 3 is the highest. I dont know how to do this.... code below is an idea of what i was trying to do but it wont work.. any help appreciated :)

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'exam';

mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to database');

mysql_select_db("$dbname") or die ("unable to conect to database");

$table = 'details';
$fname = $_POST['fname'];
$surname = $_POST['surname'];
$student_number = $_POST['student_number'];
$exam = $_POST['exam'];
$project = $_POST['project'];
$participation = $_POST['participation'];
$Totalmark = $exam + $project + $participation; 

$sqlquery = "INSERT INTO details VALUES ('$fname', '$surname', '$student_number', '$exam', '$project', '$participation', '$Totalmark')";
$results = mysql_query($sqlquery);

?>
<?php // code to get final grades
//$sqlquery2 = "SELECT max($Totalmark) $fname, $surname FROM details"; 
//$results2 = mysql_query($sqlquery2);

?>
	

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Exam Results</title>
</head>


<body>

<center><h1> Exam Results </h1></center>
<?php
while($row = mysql_fetch_array($results2))
{
?>

<?php
echo $Totalmark ['Totalmark'] ///plus name etc
?>
<?php
}
?>
</body>
</html>

php

Edited 13 Years Ago by nav33n because: Please use [code][/code] tags to wrap your code for easy readability.

5 Contributors
5 Replies
474 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by rajarajan2017

All 5 Replies

pssubashps 0 Newbie Poster

13 Years Ago

How you get $_POST variable on this page ?

sourcez 0 Junior Poster in Training

13 Years Ago

That shouldn't be too difficult. One way you could do it (there will be better ways).

SELECT fname, $surname FROM details ORDER BY totalmark DESC LIMIT 1

So you're selecting the info you want (I don't know what your table headers are) from your database.

You're ordering it by total mark, descending (so highest first), and you're only taking one (limit 1).

$row = mysql_fetch_assoc($query);
$name = $row['firstname']. ' ' .$row['lastname'];
echo $name;

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

loloy123 0 Newbie Poster · Answer 1 · 2010-04-26T20:24:30+00:00

How you get $_POST variable on this page ?

The post values are coming from a form I created where the user enters in the values....

pclfw 23 Junior Poster · Answer 2 · 2010-04-27T19:30:04+00:00

The code that you're using should work,

<?php // code to get final grades
//$sqlquery2 = "SELECT max($Totalmark) $fname, $surname FROM details";
//$results2 = mysql_query($sqlquery2);

If you inserted the missing comma between max($Totalmark) and $fname.
Might be worth a try.

rajarajan2017 · Answer 3 · 2010-04-27T20:24:47+00:00

Sample Table:

CREATE TABLE `highestScore` ( 
    `id` int(11) NOT NULL auto_increment, 
    `fname` varchar(255) NOT NULL default '', 
    `lname` varchar(255) NOT NULL default '', 
    `TotalMarks` int(11)NOT NULL default '', 
    PRIMARY KEY  (`id`) 
) TYPE=MyISAM;

Sample Datas:

INSERT INTO `highestscore` VALUES (1, 'Raja', 'Rajan',100);
INSERT INTO `highestscore` VALUES (2, 'Vino', 'Thini',55);
INSERT INTO `highestscore` VALUES (3, 'Rajendra', 'Kumar',150);
INSERT INTO `highestscore` VALUES (4, 'Senthil', 'Kumar',125);
INSERT INTO `highestscore` VALUES (1, 'John', 'Kamer',150);

Note that I have code more than one maximum value

<html> 
<head> 
<basefont face="Arial"> 
</head> 
<body> 

<?php 
$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$db = "testdb"; 

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
mysql_select_db($db) or die ("Unable to select database!"); 
$query = "select * from highestscore where totalmarks=(select max(totalmarks) from highestScore)";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
if (mysql_num_rows($result) > 0) { 
    echo "<table cellpadding=10 border=1>"; 
	echo "<tr align='center'><td colspan='3'>HighestScore</td></tr>";
    while($row = mysql_fetch_row($result)) { 
        echo "<tr>"; 
        echo "<td>".$row[1]."</td>"; 
        echo "<td>" . $row[2]."</td>"; 
        echo "<td>".$row[3]."</td>"; 
        echo "</tr>"; 
    } 
    echo "</table>"; 
} 
else { 
    echo "No rows found!"; 
} 
mysql_free_result($result); 
mysql_close($connection); 
?> 
</body> 
</html>

This will give you the good viewable output in a table. If a person have a highest score then It display a single record. if maximum marks achieved by two person. This will work at that scenario too.

SELECT fname, $surname FROM details ORDER BY totalmark DESC LIMIT 1SELECT fname, $surname FROM details ORDER BY totalmark DESC LIMIT 1

The above code will not work if you have more than one record

<?php // code to get final grades//$sqlquery2 = "SELECT max($Totalmark) $fname, $surname FROM details"; //$results2 = mysql_query($sqlquery2); ?>

The above code will not work because it only returns the maximum mark and the details of the person will be a first record. Thats wrong!

Hope this solve! COOL!

php / mysql assignment

Recommended Answers Collapse Answers

All 5 Replies

Recommended Answers