15 replies to this topic

[efim]

Hi every one,
I am new in php but currently doing a project in web-based conference management system.
I have created a database but have to develop some web pages /php forms etc to interact with my database.
I want to do at least three of the following transactions; I am using WAMP localhost server ie apache, php, mysql).



A.Registration of User/Reviewer/PC-Chair.
1) Verify User details.
2) Read Author/Reviewer/PC-Chair.
3) Verify no duplicate registration (done by checking email, phone number etc).
4) Update Author/Reviewer/PC-Chair table.
B.Login.
1) Verify Username and password fields for synthetic correctness.
2) Read Author/Reviewer/PC-Chair table.
3) Match specified username and password.
4) Update session table with correct session id if successful.
C.Upload Paper.
1) Check if session id is valid, else run Login Transaction.
2) Verify Author names, Title, and other information synthetic errors.
3) Verify name of the author exist in PC-Chair/Reviewer tables (part of the requirements)
4) Read paper table and check for duplicate submission.
5) Update paper table with new paper information.

Bellow is an exported sql codes for my db pls import these codes and help me out asap.

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
--
--
-- Host: localhost
-- Generation Time: Jan 30, 2010 at 07:14 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `conference management system`
--

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

--
-- Table structure for table `author`
--

CREATE TABLE IF NOT EXISTS `author` (
`AuthorID` varchar(32) NOT NULL,
`SSNumber` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `author` (`AuthorID`, `SSNumber`) VALUES
('A002', 'SS1121'),
('A001', 'SS1120');

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

--
-- Table structure for table `authoredby`
--

CREATE TABLE IF NOT EXISTS `authoredby` (
`PaperID` varchar(100) NOT NULL DEFAULT '',
`AuthorID` text NOT NULL,
PRIMARY KEY (`PaperID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `authoredby` (`PaperID`, `AuthorID`) VALUES
('PP000', 'A001'),
('PP001', 'A002');

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

--
-- Table structure for table `conference`
--

CREATE TABLE IF NOT EXISTS `conference` (
`ConferenceName` text NOT NULL,
`Date` date NOT NULL,
`Place` text NOT NULL,
`Topic` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Conference is handled by ProgramCommittee';

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

INSERT INTO `conference` (`ConferenceName`, `Date`, `Place`, `Topic`) VALUES
('LONDON2010', '2010-02-24', 'ICT', 'BATABASEDESIGN'),
('HAMBURG', '2010-02-04', 'CITY HALL', 'TV-ONLINE');

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

--
-- Table structure for table `journal`
--

CREATE TABLE IF NOT EXISTS `journal` (
`JournalID` varchar(50) NOT NULL,
`YearOfPublication` date NOT NULL,
`Topic` text NOT NULL,
PRIMARY KEY (`JournalID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `journal` (`JournalID`, `YearOfPublication`, `Topic`) VALUES
('JN11', '2008-01-02', 'DATABASE DESIGN'),
('JN12', '2006-12-05', 'TV-ONLINE');

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

--
-- Table structure for table `membership`
--

CREATE TABLE IF NOT EXISTS `membership` (
`ConferenceName` varchar(50) NOT NULL,
`MemberID` varchar(20) NOT NULL,
PRIMARY KEY (`ConferenceName`,`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `membership` (`ConferenceName`, `MemberID`) VALUES
('Hamburg', '00003'),
('LONDON2010', '00002');

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

--
-- Table structure for table `paper`
--

CREATE TABLE IF NOT EXISTS `paper` (
`PaperID` varchar(20) NOT NULL,
`JournalID` varchar(20) NOT NULL,
`ConferenceID` varchar(20) NOT NULL,
`Content` text NOT NULL,
`Category` text NOT NULL,
`Title` text NOT NULL,
`AuthorID` varchar(20) NOT NULL,
PRIMARY KEY (`PaperID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `paper` (`PaperID`, `JournalID`, `ConferenceID`, `Content`, `Category`, `Title`, `AuthorID`) VALUES
('PP000', 'JN11', 'Conf2010', 'Text-Based', 'Presentation', 'Computer Evolution', 'A001');

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

--
-- Table structure for table `pc-chair`
--

CREATE TABLE IF NOT EXISTS `pc-chair` (
`MemberID` varchar(50) NOT NULL,
`SSNumber` varchar(50) NOT NULL,
`NoConfHeaded` int(11) NOT NULL,
`Fname` text NOT NULL,
`Mname` text NOT NULL,
`Lname` text NOT NULL,
`user` varchar(32) NOT NULL,
`password` varchar(32) NOT NULL,
PRIMARY KEY (`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pc-chair`
--

INSERT INTO `pc-chair` (`MemberID`, `SSNumber`, `NoConfHeaded`, `Fname`, `Mname`, `Lname`, `user`, `password`) VALUES
('00001', 'SS1120', 27, 'Ayuk', 'Thaddeus', 'Ojong', 'Ojong', 'ojong');

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

--
-- Table structure for table `person`
--

CREATE TABLE IF NOT EXISTS `person` (
`SSNumber` varchar(50) NOT NULL,
`Fname` text NOT NULL,
`Mname` text NOT NULL,
`Lname` text NOT NULL,
`DOB` date NOT NULL,
PRIMARY KEY (`SSNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `person` (`SSNumber`, `Fname`, `Mname`, `Lname`, `DOB`) VALUES
('SS1120', 'Ayuk', 'Thaddeus', 'Ojong', '1985-11-18'),
('SS1121', 'Effim', 'Marcel', 'Etta', '1998-01-25');

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

--
-- Table structure for table `phonedetails`
--

CREATE TABLE IF NOT EXISTS `phonedetails` (
`SSNumber` varchar(50) NOT NULL,
`PhoneNumber` varchar(20) NOT NULL,
PRIMARY KEY (`SSNumber`,`PhoneNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `phonedetails` (`SSNumber`, `PhoneNumber`) VALUES
('SS1120', '07958542120'),
('SS1121', '07536176421');

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

--
-- Table structure for table `programcommittee`
--

CREATE TABLE IF NOT EXISTS `programcommittee` (
`ConferenceName` varchar(20) NOT NULL,
`MemberID` varchar(20) NOT NULL,
`Strength` text NOT NULL,
PRIMARY KEY (`ConferenceName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ProgramCommittee consist of Members, PC-Chair heads ProgramC';

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

INSERT INTO `programcommittee` (`ConferenceName`, `MemberID`, `Strength`) VALUES
('Hamburg', '00001', 'strong'),
('London2010', '00003', 'average');

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

--
-- Table structure for table `reviewedby`
--

CREATE TABLE IF NOT EXISTS `reviewedby` (
`PaperID` varchar(20) NOT NULL,
`MemberID` varchar(20) NOT NULL,
`Result` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `reviewedby` (`PaperID`, `MemberID`, `Result`) VALUES
('PP000', '00001', 'perfect'),
('PP001', '00003', 'pending');

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

--
-- Table structure for table `reviewer`
--

CREATE TABLE IF NOT EXISTS `reviewer` (
`MemberID` varchar(20) NOT NULL,
`SSNumber` varchar(20) NOT NULL,
`SubjectOfExpertise` text NOT NULL,
PRIMARY KEY (`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Paper is reviewed by Reviewer';

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

INSERT INTO `reviewer` (`MemberID`, `SSNumber`, `SubjectOfExpectation`) VALUES
('00002', 'SS1120', 'IT'),
('00003', 'SS1121', 'business');

I will appreciate new suggestions.
Thanks

[LevonNikox]

wich one do you want exactly??we can help you with all of them!

[efim]

Thanks for your quick response, to the best of my knowledge every web site starts with an index(front page) with the menu that links it to the other pages such as login by pc-chair, registration by users or authors, paper upload etc. Infact there is a list given to me. just figure out and advise me on what to do.
Thanks

[LevonNikox]

at first you want to make a registration page?

[WingedPanther]

You may want to have a look at my tutorial series on "building a large project". It will give you some ideas on how to approach this.

[efim]

i would like to ve a registration page with menu for author, reviewers,pc-chair. the authors menu should promt him with a page to register, pc-chair menu should anable him to accept author's registration, upon registration, authors should be able to upload their paper/journal. etc. 4-5 transactions will be enough for now. but the must essention is for the database to be updated by the pc-chair since he is the only db admin.
Thanks

[phpforfun]

It doesnt seem like you are asking for help, but more... for someone to do it for you... Am I wrong?

[WingedPanther]

This is not entirely trivial.
http://forum.codecal...t-part-1-a.html
http://forum.codecal...t-part-2-a.html
http://forum.codecal...t-part-3-a.html
http://forum.codecal...t-part-4-a.html
http://forum.codecal...t-part-5-a.html

[efim]

Sorry, i think i am asking too much. can u start with a registration form for the database conference management system.
thanks

[efim]

Not really, i have some codes for registration unfortunately it is not working. I even created a login table for the db but nothing.bellow re the codes

for regis

/* i am using WAMP server with assess previledge (<hidden> & <hidden>) , have a table called conference management system.

<?php

$host = localhost 


$dbuser = <hidden>

dbpass = <hidden>

dbname = conference management system


// connecting to the db


$connection = mysql_connect( $host, $dbuser, $dbpass);

$db = mysql_select_db( $dbconference management system, $connection) // $connection is the whole line above;


//now we get data from form


$name = $_POST[8888];

$pass = $_POST[8888];

$pass_conf = $_POST[pass_conf];

$mail = $_POST[mail];

$login_id = $_POST[login_id];


  if($name = false || $pass = false || $pass_conf = false || $mail = false || $login_id = false){

echo " Please provide all info";

};


  if ($pass != pass_conf) {

  echo "Password do not match.";

  } else {

  

  $connection = mysql_connect( $host, $dbuser, $dbpass);

$db = mysql_select_db( $dbconference management system, $connection) // $connection is the whole line above;

  $sql= "INSERT INTO login(username, password, mail, login_id) VALUE($name,$pass,$mail,$login_id)

  $result = mysql_query($sql);

  

  echo "Thank you for regustrying for the CMS."

  };

  ?>

    



 [B]logn[/B]



<html xmlns="l">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>index.php</title>

</head>


<body>

<form action="index.php" method="POST">

Username: <input type="text" name="user" /> <br/>

Password: <input type="password" name="pass"  /> <br />

<input type="submit" value="Send" /> <p>

</form>


<?php

$user = $_POST[user];

$pass = $_POST[pass];

/*

if(($user=="yyy") && $pass="yyy" )) echo " Assess Granted!";

else echo "Assess Denied!";

*/

?>

</body>

</html> 

 

</body>

</html>

  

It it very frustrating when nothing is working out thats why i am seeking for help here
thanks

Edited by efim, 10 February 2010 - 05:41 AM.

[Feral]

1.) go change the username and password for you database as you have just posted it in a public place.

2.) edit your post and remove them and replace with *** or something else.

3.)

[COLOR="Red"]$[/COLOR]dbpass = *******
[COLOR="Red"]$[/COLOR]dbname = conference management system

// connecting to the db

$connection = mysql_connect( $host, $dbuser, $dbpass);
$db = mysql_select_db( $[COLOR="Red"]dbname [/COLOR], $connection) // $connection is the whole line above;

The areas marked in red have been changed from your posted code, without these changes your code will not work.

I did not look at anything past this part of your code so there might be other problems

4.) Ask specific questions and describe the problem you are having.

5.) use the [ code] [/ code] (remove spaces) tags when posting code like so

[ code]
your code here
[/ code]

[Orjan]

Quite a lot that doesn't work here: from the beginning:
you first line,

$host = localhost

is just totally lost in php space, there are two major errors about this line of code, and those errors repeats further down as well.

localhost is supposed to be a string value. string values are written inside " " or ' ', like this: "localhost".

every line of code shall end with an semicolon, ; or it won't work

so your first line of code should look like this:

$host = "localhost";

then to your seventh line of code,
$db = mysql_select_db( $dbconference management system, $connection)

You try to get a value from a variable that does not exist. either, you want to use your earlier created variable $dbname here or, you can use the full name directly, but in quotes as earlier mentioned. Variable names in PHP can not contain spaces.

later in your code, you seem to once again, try to connect to the database (whichy is totally unneccesary, you are already connected if you have done correct), and then specify a SQL code that I suppose you want to send to the server, but here, you've forgotten to close the text string with an ". that line shall also end with an ; as all other lines.

Try to fix your code up by this extremely basic php knowledge things and try again to improve your skills in understanding proper PHP syntax before developing your code further. There are many books and tutorials online that can help you with this basic syntax skills.