Assignment 3 (Forum) Specifications

[Vicky]

Assignment 3 requires the creation of a web forum. The target date for
this assignment is the 13th of May. Everyone should mail a zip file of
his/her assignment to each of the web team heads, including an sql
file of his/her database, created and exported using XAMPP's
phpMyAdmin. The forum should have the following features:
1. The database for storing the forum's data, including the table for
users' details and that for all the threads/posts on the forum should
be made using XAMPP's phpMyAdmin.
2. The main page of the forum will display a login box and a link for
new registrations, if the user is not already logged in. If the user
is already logged in, it should display the appropriate page (use PHP
sessions for this).
3. The data in the registration form should be checked on clicking the
submit button, and it should lead to the same page if there are any
errors, with appropriate error messages (The valid form data should
"auto-populate", invalid form data should not be displayed).
4. There will be two types of users on the forum: Administrators and
Members. This will determined by a field in the users table called
"usertype".
5. Member privileges: create new post, create new thread, delete his
own posts.
6. Administrator privileges: create/delete any post/thread in the
forum.
7. Every user will have the option to become an Administrator at any
point of time, provided he knows a certain pre-defined "password".
Whenever a user enters the correct password, his "usertype" field will
be updated to that corresponding to an Administrator and he will be
granted Administrator privileges.
8. The forum should have a well-defined CSS theme. Every page on the
forum should display in accordance with this theme.
9. The passwords of users should be stored in the database in MD5
encrypted format, so that nobody except the user himself can know a
particular user's password, not even an Administrator (there exists a
pre-defined PHP function for this task).
10. The PHP code should be efficient and clean, with as less SQL
queries as possible. Code should be reused wherever possible (using
the PHP include() function).
11. A "Forgot Password" feature may be implemented (which will reset a
user's password in case he forgets it), though it is not necessary.
12. The data in the tables in the database should be stored
efficiently, with appropriate primary keys for each table.

[Sankhadeep Pal]

guys some of u have been reporting problems with using xampp. ppl have been saying that they are unable to run the php code as when they run it in a browser, the php file gets downloaded. this shdnt happen. the solution is:

1. 1st of all, check whether apache is running in the xampp control panel

2.secondly,, if u have saved ur file as home.php in the htdocs folder, then to run the file, go to the browser, n type the address as http://localhost/home.php n not as file://C:/xampp/htdocs/home.php

should u have any other doubts, ask me or esha or even amng urselvs

Best wishes,

sankhadeep

[Sankhadeep Pal]

guys, it seems that many of u are having quite a few basic doubts regarding php n database handling, or even phpmyadmin. so wht i suggest is whenever u do have a doubt, post it in this thread....the heads will clarify them asap...or even the other members can shed some light, if the had had a similar doubt....this way, interaction will be much better, and there are high chances that ur doubts will be cleared quickly and even others wud benefit from it.....AND PLEASE DONT KEEP UR DOUBTS TO URSELF FOR GOD'S SAKE..........THAT WAY U WUD DO NO GOOD TO ANYONE

cheers :)

sankhadeep

[Sajal Jain]

can someone tell me how to use the mysql provided by 0fees...

i have created the tables and other stuff....but how to link them up

Regards,
Sajal Jain

[Sankhadeep Pal]

see u must have got a mysql username n password from 0fees, use those to connect to mysql n it will work...

[Suvinay Seth]

do we have to make the form validation code ourselves...or can we use an external source?
__________________________
Suvinay Seth
IIT Kharagpur

[esha choukse]

we would ofcourse prefer self made codes. As this is ur assignment... DO NOT COPY/PASTE  code snippets.

--
Regards
Esha Choukse
Second Year Undergraduate Student
Department of Electronics and Electrical Communication Engg.
IIT Kharagpur

[Suvinay Seth]

no as in....do we have to embed captcha's in the registration form?
__________________________
Suvinay Seth
2nd Year Undergraduate Student,
Deparment of Mining Engineering,
IIT Kharagpur

[esha choukse]

ya..if u r using captcha code ...u can embed the standard code ofcourse... but the normal form validation  code should be ur own

[Sajal Jain]

In my forum i have put in the feature of unread posts/topics as salil told. the problem is that this feature is updated only when user logs in or out. what do i need to do to mark unread post as read if user visits it during the session

Regards,
Sajal Jain

[Aakash Bhowmick]

If we insert a new record in a table using INSERT command in SQL, is it guaranteed that the row will be inserted at the end of the table?

--
Aakash Bhowmick,
Undergraduate Student,
Department of Mechanical Engineering,
IIT Kharagpur.

[aayush agarwal]

yes....thats guaranted...

Aayush Agarwal
Core Team Head, Events Management
Kshitij 2011
Technology Students' Gymkhana
IIT Kharagpur.
Ph no. +919735485110
Email Id: aayush....@ktj.in
           aayush....@gmail.com

[Sajal Jain]

here's my submission

http://sajaljain4.0fees.net/SajalForum/index.php

Regards,
Sajal Jain

[Vicky]

I'm facing a problem with 0fees.net.... i'm unable to access
phpMyAdmin on 0fees.... it says:

"This webpage has a redirect loop.

The webpage at http://www.php-myadmin.com/login.php?phpMyAdmin=f0d8f3bbdf8f8f2bc25d201fef838d7a7c10e0d0
has resulted in too many redirects. Clearing your cookies for this
site or allowing third-party cookies may fix the problem. If not, it
is possibly a server configuration issue and not a problem with your
computer."

Please help.....

[Ananth SNC]

my website link :

http://a1ananth.0fees.net/login.php

[Vicky]

my forum link:

http://www.vicky2341992.0fees.net/forum/login.php

[shubham choudhary]

link to my forum

shubh3391.0fees.net/forum/login.php


--
Shubham Choudhary
Mechanical Department,
IIT Kharagpur

[PRASHANT SINGH]

here is the link to my forum. i was not able to upload it yesterday due to some error in 007gb website....

http://www.atiprashant39.0fees.net/home.php

--
Prashant .......

[PRASHANT SINGH]

here is the link for my forum

http://www.atiprashant39.0fees.net/home.php

On May 14, 8:55 am, PRASHANT SINGH <atiprash...@gmail.com> wrote:
> here is the link to my forum. i was not able to upload it yesterday due to
> some error in 007gb website....
>
> http://www.atiprashant39.0fees.net/home.php
>
> On Thu, May 13, 2010 at 11:41 PM, shubham choudhary

> <shubh030...@gmail.com>wrote:

[PRASHANT SINGH]

plz check the link again... i have changed the design

--
Prashant .......

[Sankhadeep Pal]

as many of u called me saying that they cudnt submit the assignmnt on time, we heads have decided to extend the deadline till 17th May. those who are yet to complete, buckle up n submit on time...and those who have submitted, i'll be telling u abt some changes that need to be done...and ur worked will e judged on the basis of ur site on the 17th of May.

cheers,

sankhadeep

[Sankhadeep Pal]

one common thing most of u have missed is tht u havnt made index.php as ur starting page. u shd either make it ur starting page or create an index.php n write a code in it to redirect the user to ur starting page. unless u do this, one can see all the files in ur htdocs or www folder, just by giving the url http://www.username.0fees.net   try it urself

[Aakash Bhowmick]

I have a doubt in a piece of code which I am not able to debug. I have written the following test code in PHP .Please see:

<?php 

$message="No value set<br/>";

if (isset($_POST[current_password]) and isset($_POST[new_password_first]) and isset($_POST[new_password_second]) )

{

$message="All Values set.<br/>";

}

?>

<html>

<title>test</title>

<body>

<?php echo $message; ?>

<form action="<?php $_SERVER[PHP_SELF]; ?>" method="post">

<input type="password" name="current_password">

<input type="password" name="new_password_first">

<input type="password" name="new_password_second">

<input type="submit" >

</form>

</body>

</html>

In this code, I expect the if condition at the top to be executed only if all the three fields "current_password" , "new_password_first" and "new_password_second" are set. Sadly....that's not what's happening :( . Even if any one of them has been set, the if block gets executed. Can anyone please resolve this anomaly??

[gaurav bajaj]

@akash:Hey akash i know what the problem is 

u might be thinking that if u dont make an entry in a text box(name="x") and u submit it then $_POST[x] is not set

but its not like that its set to null hence ur if block is executed

 

[manisha barnwal]

i m facing problem with phpmyadmin. whenever, I try to access it, it returns:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

i tried to fix the error by specifying  the password in the config.inc.php file for phpmyadmin.
but vain !!! plz help me.

[rajeev s]

this is my web forum
http://rajeev.0fees.net/
administrater password is 'admin'

[Aakash Bhowmick]

Link to my assignment : http://aakashbhowmick.0fees.net/forum/

I was trying to implement a notification system but it is still not complete as of now. I'll do that soon. Right now no notifications will be displayed on the sidebar.

The code to become admin is : admin123

[Ankit]

i'm facing some difficulties in validating the various forms used ... i have taken help from sumone and have used JS form validation.. Is that fine..??
also i am facing problem with 0fees.net ..so, shall i attach all my files along with the database file..??

[Gunjan Honhaga]

Link to my assignment:

http://gunjan7.0fees.net/index.htm

[PRASHANT SINGH]

here is the final link for my forum.

this link is totally different from previous one.

please do not evaluate the previous one .....

http://www.atiprashant39.0fees.net/homea.php

On Thu, Apr 29, 2010 at 9:01 PM, Vicky <vickyc...@gmail.com> wrote:

Assignment 3 requires the creation of a web forum. The target date for
this assignment is the 13th of May. Everyone should mail a zip file of
his/her assignment to each of the web team heads, including an sql
file of his/her database, created and exported using XAMPP's
phpMyAdmin. The forum should have the following features:
1. The database for storing the forum's data, including the table for
users' details and that for all the threads/posts on the forum should
be made using XAMPP's phpMyAdmin.
2. The main page of the forum will display a login box and a link for
new registrations, if the user is not already logged in. If the user
is already logged in, it should display the appropriate page (use PHP
sessions for this).
3. The data in the registration form should be checked on clicking the
submit button, and it should lead to the same page if there are any
errors, with appropriate error messages (The valid form data should
"auto-populate", invalid form data should not be displayed).
4. There will be two types of users on the forum: Administrators and
Members. This will determined by a field in the users table called
"usertype".
5. Member privileges: create new post, create new thread, delete his
own posts.
6. Administrator privileges: create/delete any post/thread in the
forum.
7. Every user will have the option to become an Administrator at any
point of time, provided he knows a certain pre-defined "password".
Whenever a user enters the correct password, his "usertype" field will
be updated to that corresponding to an Administrator and he will be
granted Administrator privileges.
8. The forum should have a well-defined CSS theme. Every page on the
forum should display in accordance with this theme.
9. The passwords of users should be stored in the database in MD5
encrypted format, so that nobody except the user himself can know a
particular user's password, not even an Administrator (there exists a
pre-defined PHP function for this task).
10. The PHP code should be efficient and clean, with as less SQL
queries as possible. Code should be reused wherever possible (using
the PHP include() function).
11. A "Forgot Password" feature may be implemented (which will reset a
user's password in case he forgets it), though it is not necessary.
12. The data in the tables in the database should be stored
efficiently, with appropriate primary keys for each table.

--
Prashant .......

[Tushar Gupta]

here's the link of my forum:

http://tushariitkgp.0fees.net/signin.php

[Ankit]

i am facing difficulties with my 0fees.net account..
so i am attaching my assignment files here..

thanks,
ankit singla

[esha choukse]

@gunjan wats the admin pass?

On 17 May 2010 21:56, Tushar Gupta <tusharg...@gmail.com> wrote:

here's the link of my forum:

http://tushariitkgp.0fees.net/signin.php

--
Regards
Esha Choukse
Third Year Undergraduate Student

[Ankit]

my admin pass: 'iwanttobeanadmin'

[Suvinay Seth]

The link to my forum: 

http://suvinay.0fees.net/

Admin pass: Administrator

__________________________
Suvinay Seth
2nd Year Undergraduate Student,
Deparment of Mining Engineering,
IIT Kharagpur

On Mon, May 17, 2010 at 11:14 PM, Ankit <chat2...@gmail.com> wrote:

my admin pass: 'iwanttobeanadmin'

[Suvinay Seth]

Please first login as admin and create new subforums....then u can make an account without the admin capabalities and check out the rest....

Thanks!

__________________________
Suvinay Seth
2nd Year Undergraduate Student,
Deparment of Mining Engineering,
IIT Kharagpur

[manisha barnwal]

the link to my forum:

http://barnwal2manisha.0fees.net.

[Vinay Kola]

My forum link:

http://vinaykola.0fees.net/forum/index.php

[Gunjan Honhaga]

the admin password for my assgn is gunjan .

[gaurav bajaj]

link to my forum 

http://gauravbajaj007.0fees.net/home.php

  

for becoming admin the secret password is 111111

[Dheeraj Mundhra]

here is the link to my forum http://www.dheerajmundhra.0fees.net/index.php

password for administrator is administrator

--
DHEERAJ MUNDHRA
1ST YR. UG STUDENT,
IIT KHARAGPUR.

[gaurav bajaj]

sorry there was some problem in topic.php ............i have fixed that now

[master mind]

@all

for past few days i was not in delhi due to some emergency..sorry
i will submit my assignment this sunday..definitely.!!
 

[Sankhadeep Pal]

your assignments are being evaluated....and your next assignment will be posted soon....till then increase your knowledge on AJAX as much as possible...for the time being refer to w3schools.....

cheers

sankhadeep

[Suvinay Seth]

sorry there was a bug in my new post notifications, i guess it shd work now!

__________________________
Suvinay Seth
2nd Year Undergraduate Student,
Deparment of Mining Engineering,
IIT Kharagpur

[master mind]

Sorry guys for late posting..

 

my forum is on - jugal101.007gb.com/index.php

 

 

 

Regards,

 

Jugal

 

--

Jugal Anchalia

09EE1015

[Sankhadeep Pal]

check ur site.....its not loading

--
Regards,
Sankhadeep Pal,
2nd Year, Undergraduate Student,
Department of Electronics and Electrical Communication Engineering,
IIT Kharagpur.