Final Task

When will details be given regarding the final task? I would like to get the task over and done with as soon as possible.

www.newshost.za.net

OK, I've made it available.

Am i just very tired that i cant find it?

www.newshost.za.net

It is in the downloads on the course website.....under tutorial letters...

Dont think i should have looked at that - realised there is a long way to go !!

That seems pretty simple. Do we need to create the database tables using code or may we manually create the tables in phpmyadmin? I did not see mention of a login requirement for registered students? May we vary our approach to the assignment or do we strictly have to follow the guidelines?

www.newshost.za.net

Creat with phpmyadmin. We provide the outline of what we want - what you add, and how you add it, is what determines your mark.

Hi,
What about the field attributes? Can we make them as we wish?
Do we just dump our databases in the end and send it together with our php5 code?
Regards
Reinie

We will just dump your code on our server and run the app, so the main thing is that your db schema must be the same as ours (which is in the tut letter). Other than that, it would be good if we can change your db connection details on one page (which you include in all tyour other pages where a connection is required). For the rest do as you wish.

(1)Can you please give us the database IP and login details or a virtual one so we can test our code on it? Because if one bit of code doesnt correpond to your DB the programme wont run

(2) Where can we upload the project?

Mac, is there any use us submitting before the required date? Will the assignments only be moderated on or after that final date?

www.newshost.za.net

Hi,
I don't see the field attributes in the tutorial letter. Only the db,table and field names in point 4 (Detailed Table Attributes).
Can I get the detailed field attributes too please.
Regards
Reinie

There are just two requirements for your app to run on our server:

As per the tut letter, your db should be named "registration". The tables and fields are named as per the tut letter. That's all. Nothing else.

A dump of our db is provided hereunder. Use that to create your tables.

You should also provide us with a single file where we can change the db login details to ours.

We can't provide you with access to our db since that not only creates a security risk, but an added administrative process.

email the project in a zipped file to me. Name the zip file your student number, e.g. 1234567.zip


--
-- Database: `registration`
--

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

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
`cname` varchar(50) NOT NULL default '',
`cid` int(6) NOT NULL auto_increment,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

--
-- Table structure for table `course_student`
--

CREATE TABLE `course_student` (
`sno` int(6) NOT NULL default '0',
`cid` int(6) NOT NULL default '0',
`year` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
`sno` int(6) NOT NULL auto_increment,
`sname` varchar(40) NOT NULL default '',
`init` varchar(5) NOT NULL default '',
`fname` varchar(40) NOT NULL default '',
`title` varchar(4) NOT NULL default '',
`msname` varchar(40) NOT NULL default '',
`dob` varchar(8) NOT NULL default '',
`sex` char(2) NOT NULL default '',
`lang` varchar(10) NOT NULL default '',
`idno` varchar(13) NOT NULL default '',
`telh` varchar(12) NOT NULL default '',
`telw` varchar(12) NOT NULL default '',
`cel` varchar(12) NOT NULL default '',
`fax` varchar(12) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`address` tinytext NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

Awesome!!

Thanks!

Will mark all assignments together...

Maybe, if Mac will allow, ill allow users to upload their final projects to my server for testing and maybe to let others see and compare?

www.newshost.za.net

You're welcome.... I'll even mark it from there, but you must still send me your code as I need to look at your code.

Cool stuff. Well closer to the assignment date we'll rethink the server thing.
Mac, how long u been coding mate? Just in PHP or other languages aswell?

www.newshost.za.net

Coded in ASP from about 1997. Then discovered PHP in 2000, and that was that. Not interested in something like Java, since I am of the opinion that whereas PHP started of and developed as a language for the web, Java is primarily a desktop language trying to be a web language... Lots of arguments about this - google for Java versus PHP. However, if you can program in one language, it is not too difficult to program in others - programming principles cut across languages. It is just the syntax that needs to be learned. Your next step should be OO-programming in PHP, but don't rush it

Ive been coding in several languages for some time now. Have focused alot on Delphi in the last 5 years and only recently coded a community site > www.newshost.za.net which inspired me to take the php course. Java, i must agree is pulling in opposite directions, its a language ive never enjoyed and never given much thought to. PHP is such a diverse and powerful language that incorporating it into Delphi is also a blessing for me.

www.newshost.za.net

When is the project due for? My code is running but its not looking nice on the html side. I can send it now or if there is some time left I can make it look better/ more user friendly?

Dont worry! Forgot to look in the tut.

Project details: Due date 9 June 2007

Whew!

The 9th of June is around the corner...

A Successful Nature Inspires Other People...

Hello Mac,

Are we allowed to add extra tables/field to the database desgin?

Nino Cloete

Nope - then I cannot test it since I run your code on our database which is as set out in the assignment. If you are able to host your app on a server which I can access, u.e. yousend me the URL, then you can do what you want. But you must still send my your code so I can evaluate your coding skills....

Im using last years software. I think php 4.4.4 and mysql 2.something. Please list the Apache / Mysql and php you are using so I know mine will be compatible.

I switch to whatever version you are using....

From prac letter: "Clicking the Edit link will open the course details in a form, where the user can edit the details and do an update of the course name."

This little line makes it sound like each course has a rather large set of details, but according to "course" table in registration, isn't the course name the only thing you can actually edit, without creating more fields in the course table? I'm thinking the user probably shouldn't be able to edit the 'cid', to prevent duplicte 'cid's.

Is it correct that my form only allows the user to add, edit and delete course names and no other course info?

Yes, for this task that is correct. Only the name. If there were more fields (maybe like a description of the course), that would be added to the edit form. You can't edit the cid - you just use that to point to the field that must be updated/deleted

Hi,
For the purpose of the final task, how are prospective students to access 'Register a Student' if the admin interface is for admin/lecturers?
Is it assumed that both students and admins will access the same link on admin.php but that students wont have access to the other options? (also assumed, as login/password implementation isn't mentioned)