My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
DevelopersGuide  

Featured
Updated Feb 4, 2010 by philli...@gmail.com

Setup XAMPP & Symfony

Create Database

Generate three tables

Create three tables called collaborations, organizations, researchers.

CREATE TABLE `collaborations` (
  `c_id` int(100) NOT NULL auto_increment,
  `c_name` varchar(20) collate latin1_general_ci NOT NULL,
  `c_organizations` varchar(100) collate latin1_general_ci default NULL,
  `c_types` varchar(100) collate latin1_general_ci default NULL,
  `c_years` varchar(100) collate latin1_general_ci NOT NULL,
  `c_outcome_types` varchar(100) collate latin1_general_ci default NULL,
  `c_description` varchar(200) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`c_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=45 ;
CREATE TABLE `organizations` (
  `o_id` int(100) NOT NULL auto_increment,
  `o_name` varchar(20) collate latin1_general_ci NOT NULL,
  `o_type` varchar(20) collate latin1_general_ci NOT NULL,
  `o_contact` varchar(20) collate latin1_general_ci NOT NULL,
  `o_aff_researchers` varchar(50) collate latin1_general_ci NOT NULL,
  `o_country` varchar(20) collate latin1_general_ci NOT NULL,
  `o_res_keywords` varchar(20) collate latin1_general_ci NOT NULL,
  `o_res_description` varchar(100) collate latin1_general_ci NOT NULL,
  `o_home_page` varchar(30) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`o_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;
CREATE TABLE `researchers` (
  `r_id` int(100) NOT NULL auto_increment,
  `r_name` varchar(20) collate latin1_general_ci NOT NULL,
  `r_organization` varchar(50) collate latin1_general_ci default NULL,
  `r_email` varchar(50) collate latin1_general_ci default NULL,
  `r_pic` varchar(60) collate latin1_general_ci default NULL,
  `r_bio_statement` varchar(250) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`r_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;

Javascript

  • We add some javascript for "Select All" and create a new window for edit page.

SQL statement

  • we use SQL statement to populate data for each type. Also use SQL statement for add, edit, and delete.

process.php page

  • This page carry each single action from add, edit and delete page.

db_conn.php page

$DB_HOST	= "localhost";
$DB_LOGIN	= "username";  // type in MySQL username
$DB_PASSWORD	= "password";  // type in MySQL password
$DB_NAME	= "myisern";   // type in Database name here
	
$conn = mysql_connect($DB_HOST, $DB_LOGIN, $DB_PASSWORD);
mysql_select_db($DB_NAME);
  • The developer can configure this page for connection between MySQL database to Myisern system.
Powered by Google Project Hosting