PHP MYSQL Gradebook

[joeedel89]

Hello and Thanks,
I am trying to create a teacher grade book for my school, I have a mysql database 'gradebook' and two tables 'students' and 'data' (mysql code below) to start, I am also using PHP. I have googled this to death and can't seem to come up with anything that I can understand; I have a two part question.

First Part:
How do I get the data arranged into a table like to one below:

|   Test1 (100pts)  |   Test2(100pts)  |
-----------------------------------------------------------------------------
Joe Edel        |   100                  |     80                |
-----------------------------------------------------------------------------
Angela Edel   |   99                    |    95                 |
-----------------------------------------------------------------------------

Second Part:
Is there a term for the way/method I am extracting the data and arranging it (multi-diemsional array?). The reason I ask is that this type of query seems different at a fundamental level than a standard mysql query that most website use as an example.

Thanks,
Joe

-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 06, 2009 at 02:01 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `gradebook`
--

-- --------------------------------------------------------

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `id` int(11) NOT NULL auto_increment,
  `student_id` int(11) default NULL,
  `assignment_name` varchar(25) default NULL,
  `points_possible` int(3) default NULL,
  `points_earned` int(3) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `data`
--

INSERT INTO `data` VALUES(1, 1, 'test1', 100, 90);
INSERT INTO `data` VALUES(2, 1, 'test2', 100, 85);
INSERT INTO `data` VALUES(3, 2, 'test1', 100, 99);
INSERT INTO `data` VALUES(4, 2, 'test2', 100, 100);

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL auto_increment,
  `student_name` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `students`
--

INSERT INTO `students` VALUES(1, 'Joe Edel');
INSERT INTO `students` VALUES(2, 'Angela Edel');

[zortec]

The answer to your first question is to create a table using HTML.

This link should help you out with the basics.

As to the second part of your question, you need to fetch the data in rows and display it in the table.

[joeedel89]

Hello,
Sorry I should have been more specific, I need to know how to extract data from the aforementioned tables in a way that would lend itself to the table that I described. I don't think the standard SELECT students.student_name, data.points_possible, data.points_earned WHERE data.student_id = students.id would give me the results in a what that I could easily put them into the table the way that I want.

[Arianna]

You could use a $content variable.
So basically:

$content="<table>";
while($i<$numrows) { //while there are still rows in the table
$grade=@mysql_result($result,$i,"grade"); //The grade
$name=@mysql_result($result,$i,"name"); //Student's name
$content=$content."<tr><td>".$name."</td><td>".$grade."</td>";
}
$content=$content."</table>";

That would put a table in the variable $content. Just echo it where you want it... You need to use the select query and stuff, but those are the basics.

[sallecpt]

We;ve been using a custom developed gradebook for our school in Robenson, but changed to, ummm... fox gradebook? about a year ago. Its really effective and easy and instead of having a guru to load the exam marks, each class sup now only update his/her own excel file. yes the gradebook works with an excel file, and then only the excel file is loaded with a click, and walla.

excellent software, and saves us so much time and effort (and money)

thank address is foxgradebook.com

oh btw i dunno much of programming but i know that we got the source files which our it guy said is magnicifent for the price.

Hello and Thanks,
I am trying to create a teacher grade book for my school, I have a mysql database 'gradebook' and two tables 'students' and 'data' (mysql code below) to start, I am also using PHP. I have googled this to death and can't seem to come up with anything that I can understand; I have a two part question.

First Part:
How do I get the data arranged into a table like to one below:

|   Test1 (100pts)  |   Test2(100pts)  |
-----------------------------------------------------------------------------
Joe Edel        |   100                  |     80                |
-----------------------------------------------------------------------------
Angela Edel   |   99                    |    95                 |
-----------------------------------------------------------------------------

Second Part:
Is there a term for the way/method I am extracting the data and arranging it (multi-diemsional array?). The reason I ask is that this type of query seems different at a fundamental level than a standard mysql query that most website use as an example.

Thanks,
Joe

-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 06, 2009 at 02:01 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `gradebook`
--

-- --------------------------------------------------------

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `id` int(11) NOT NULL auto_increment,
  `student_id` int(11) default NULL,
  `assignment_name` varchar(25) default NULL,
  `points_possible` int(3) default NULL,
  `points_earned` int(3) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `data`
--

INSERT INTO `data` VALUES(1, 1, 'test1', 100, 90);
INSERT INTO `data` VALUES(2, 1, 'test2', 100, 85);
INSERT INTO `data` VALUES(3, 2, 'test1', 100, 99);
INSERT INTO `data` VALUES(4, 2, 'test2', 100, 100);

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL auto_increment,
  `student_name` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `students`
--

INSERT INTO `students` VALUES(1, 'Joe Edel');
INSERT INTO `students` VALUES(2, 'Angela Edel');