include ( "head1.inc" ); /* Script Name: index.phtml Script Purpose: Simple Contact Database Script Version: 1.1 Script Author: Michael J. Miller Jr. (mke@netcom.com) */ /* First let's set some variables. */ $hostname = "luna"; $password = "fzr400dead"; $user = "maggot"; /* Now to define functions. */ /* The main screen. Printed when $state is empty. */ Function start_page (){ global $location, $list, $edit, $search, $state; echo "
"; mysql_connect("luna", "maggot", "fzr400dead"); $result = mysql("cit","SELECT * FROM Faculty_List"); echo "
| UID | Last Name | First Name | Department | Phone Number | Password | Code | Login | |
| \n"; echo mysql_result($result,$counter, uid); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Last_Name); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, First_Name); echo " | \n"; $Email = mysql_result($result,$counter, Email); echo "\n"; echo mysql_result($result,$counter, Email); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Department); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Phone); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Password); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Code); echo " | \n"; echo "\n"; echo mysql_result($result,$counter, Login); echo " | \n"; echo "
\n"; echo "
\n"; } Function Insert_Record () { global $state, $Last_Name, $First_Name, $Email, $Phone, $uid, $Department, $Password, $password, $hostname, $user, $Code, $Login ; mysql_connect("$hostname","$user","$password"); $result = mysql("cit","SELECT now()"); $now = mysql_result($result,0,"now()"); $result = mysql("cit","INSERT INTO Faculty_List (uid, Last_Name, First_Name , Email, Department, Phone, Password, Code, Login) VALUES ('$uid', '$Last_Name', '$First_Name', '$Email', '$Department', '$Phone', '$Password', '$Code', '$Login')"); $new_uid = mysql_insert_id(); $uid = $new_uid; start_page(); } /**************LAST DONE****** Function Show_Full_Record (){ global $state, $Last_Name, $First_Name, $Email, $Phone, $uid, $Department, $Password, $password, $hostname, $user ; mysql_connect("$hostname","$user","$password"); $result = mysql("cit","SELECT * FROM contacts WHERE uid=$uid"); $name = mysql_result($result,0,first_name); $name = $name . " " . mysql_result($result,0,last_name); mysql_connect("luna","maggot","fzr400dead"); $result = mysql("cit","SELECT * FROM organization WHERE uid=$uid"); $org = mysql_result($result,0,"org"); echo ""; echo ""; echo "
"; echo "
| Name | "; echo ""; echo mysql_result($result,0,"org"); echo " |
| Phone | "; echo ""; echo mysql_result($result,0,"phone"); echo " |
| Fax | "; echo ""; echo mysql_result($result,0,"fax"); echo " |
| Email Address | "; echo "$email"; echo " |
"; echo "
"; $result = mysql("cit","SELECT * FROM service WHERE uid=$uid"); $total_rows = mysql_numrows($result); $counter = 0; echo "
| Date Entered | Services Available | "; while($counter < $total_rows) { echo "
| "; echo mysql_result($result,$counter,"entry_date"); echo " | "; echo mysql_result($result,$counter,"service"); echo " |
"; echo "
Add new service below."; echo "
"; echo "
\n"; } ***************/ Function Show_in_Form (){ global $state, $Last_Name, $First_Name, $Email, $Phone, $uid, $Department, $Password, $password, $hostname, $user, $Code, $Login ; mysql_connect("$hostname", "$user", "$password"); $result = mysql("cit","SELECT * FROM Faculty_List WHERE uid=$uid"); $uid = mysql_result($result,0,"uid"); $Last_Name = mysql_result($result,0,"Last_Name"); $First_Name = mysql_result($result,0,"First_Name"); $Email = mysql_result($result,0,"Email"); $Department = mysql_result($result,0,"Department"); $Phone = mysql_result($result,0,"Phone"); $Password = mysql_result($result,0,"Password"); $Code = mysql_result($result,0,"Code"); $Login = mysql_result($result,0,"Login"); echo "
\n"; echo "
\n";
}
/*
echo " Service Organization:
\n";
echo " Phone:
\n";
echo " Fax:
\n";
echo " Campus Address:
\n";
echo " URL:
\n"; echo "
\n"; echo "\n"; } */ Function Update_Record (){ global $state, $Last_Name, $First_Name, $Email, $Phone, $uid, $Department, $Password, $password, $hostname, $user, $Code, $Login ; mysql_connect("luna","maggot","fzr400dead"); $result = mysql("cit","UPDATE Faculty_List SET Last_Name = '$Last_Name', First_Name = '$First_Name', uid = '$uid', Email = '$Email', Department = '$Department', Phone = '$Phone', Password = '$Password', Code = '$Code', Login = 'Login' WHERE uid = $uid"); start_page(); } /* Function Append_Service (){ global $hostname, $password, $user, $state, $org, $email, $phone, $fax, $address1, $address2, $service, $URL, $uid, $first_name, $last_name; mysql_connect("luna","maggot","fzr400dead"); $result = mysql("cit","SELECT now()"); $now = mysql_result($result,0,"now()"); $result = mysql("cit","INSERT INTO service (uid, entry_date, service) VALUES ('$uid', '$now', '$service')"); $state = ""; // start_page(); } */ /* The main loop. Call functions based on the value of $state, which gets set via a hidden INPUT TYPE. */ switch($state) { case ""; start_page(); break; case "list"; Show_Table(); break; case "create"; Empty_Form(); break; case "insert"; Insert_Record (); break; case "edit"; Show_Table(); break; case "fullrecord"; Show_Full_Record(); break; case "update"; Show_in_Form($state, $uid); break; case "addchanges"; Update_Record(); break; case "appendservice"; Append_Service($service); break; case "search"; break; } include ( "head2.inc" ); ?>