Single PHP file with functions and insterts into MySql

dickie · December 5, 2009

I currently working on a small class roster that will submit user data and class evaluation to a mysql data base. I have not coded in PHP for some time now so I am super rusty. This would be used by 3 different class instructor covering 3 different classes.

The idea is that once we complete a period of instruction the students would open the website which would display the 3 different icons for the classes. when clicking on one, it would then display the class roster form. fill in the blanks.. etc and it would be stored in my database. I was trying to utilize minimal different php files and have place the code below. (some of the code is incomplete, but you should get the general idea...)

// index.php

<?
/**
* Index.php
* 
* This is a Class Roster/registration form
* for the CLC2S, BCS3, and TCPT classes
* taught in III MEF. 
*
* Written by:  
* Last Updated: December 3, 2009
*/
include ("include/constants.php");
session_start();

class NewStudent
{
   /* Class constructor */
   function NewStudent(){
   // Checking to see our session is started
if (isset($_SESSION['name']))
	{
procRegister();
	}
Else
{
procHome();
exit;
};
  }
}

/**
* This displays the home page again.
**/
function procHome(){ 
//HTML code of the home page
?>

<html>
<body>	
     
    <form name="form1" action="" method="POST"> 
    <table width="400" height="600" border="0" align="center" valign="middle" cellpadding="20" cellspacing="0">
    <tr><td id="clc2s"><img src="include/CLC2S_Logo.gif" width="200" height="200" name="CLC2S" border="0" /></td><td id="bcs3"><a href="index.php?func=NewStudent"><input type="image" src="include/CLC2S_Logo.gif" height="200" width="200" name="BCS3" /></a></td><td id="tcpt"><img src="include/CLC2S_Logo.gif" width="200" height="200" /></td></tr>
    </table>
</form>
     

</body>
</html>	

<?	
//;
}


/**
* This displays the Class roster page.
**/
function procRegister(){ 
?>
<html>
<head>
<link href="include/register.css" rel="stylesheet" type="text/css" />
</head>
<body>

<h1><? echo $_SESSION['name'] ?> Class Roster</h1>

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
var mikExp = /[$\\@\\\#%\^\&\*\(\)\[\]\+\_\{\}\`\~\=0123456789\-\|]/;
function dodacheck(val) {
var strPass = val.value;
var strLength = strPass.length;
var lchar = val.value.charAt((strLength) - 1);
if(lchar.search(mikExp) != -1) {
var tst = val.value.substring(0, (strLength) - 1);
val.value = tst;
   }
}
function doanothercheck(form) {
if(form.value.length < 1) {
alert("You must have a name.");
return false;
}
if(form.value.search(mikExp) == -1) {
alert("Your Input Was Accepted");
return false;
}
else {
alert("Sorry, but the following characters\n\r\n\r@ $ % ^ & * # ( ) [ ] \\ { + } ` ~ =  | \n\r\n\rare not allowed!\n");
form.select();
form.focus();
return false;
}
}
//  End -->
</script>

<script language="JavaScript" type="text/JavaScript">
<!--
function jm_datemask(t)
{var donepatt = /^(\d{2})\/(\d{2})\/(\d{4})$/;
var patt = /(\d{2}).*(\d{2}).*(\d{4})/;
var str = t.value;
if (!str.match(donepatt))
{result = str.match(patt);
if (result!= null)
{t.value = t.value.replace(/[^\d]/gi,'');
str = result[1] + '/' + result[2] + '/' + result[3];
t.value = str;
}else{
if (t.value.match(/[^\d]/gi))
t.value = t.value.replace(/[^\d]/gi,'');
}}}

function jm_phonemask(t)
{var patt1 = /(\d{3}).*(\d{3}).*(\d{4})/;
var patt2 = /^\((\d{3})\).(\d{3})-(\d{4})$/;
var str = t.value;
var result;
if (!str.match(patt2))
{result = str.match(patt1);
if (result!= null)
{t.value = t.value.replace(/[^\d]/gi,'');
str = '(' + result[1] + ') ' + result[2] + '-' + result[3];
t.value = str;
}else{
if (t.value.match(/[^\d]/gi))
t.value = t.value.replace(/[^\d]/gi,'');
}}}

function jm_ssnmask(t)
{var patt = /(\d{3}).*(\d{2}).*(\d{4})/;
var donepatt = /^(\d{3})-(\d{2})-(\d{4})$/;
var str = t.value;
var result;
if (!str.match(donepatt))
{result = str.match(patt);
if (result!= null)
{t.value = t.value.replace(/[^\d]/gi,'');
str = result[1] + '-' + result[2] + '-' + result[3];
t.value = str;
}else{
if (t.value.match(/[^\d]/gi))
t.value = t.value.replace(/[^\d]/gi,'');}
}}
//-->
</script>
<form name=register action="process.php" method="POST">
<table align="left" border="2" cellspacing="1" cellpadding="3">
<tr><td>First Name:</td><td><input type="text" name="fname" maxlength="20"></td><td></td></tr>
<tr><td>Middle Name:</td><td><input type="text" name="mname" maxlength="15"></td><td></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lname" maxlength="25"></td><td></td></tr>
<tr><td>Last 4 SSN:</td><td><input type="text" name="last4" maxlength="4"></td><td></td></tr>
<tr><td>Rank:</td><td><select name="rank"><option selected>Select</option>
<option>Pvt</option>
<option>PFC</option>
<option>LCpl</option>
<option>Cpl</option>
<option>Sgt</option>
<option>SSgt</option>
<option>GySgt</option>
<option>MSgt</option>
<option>1st Sgt</option>
<option>MGySgt</option>
<option>SgtMaj</option>
<option>2nd LT</option>
<option>1st LT</option>
<option>Capt</option>
<option>Maj</option>
<option>LtCol</option>
<option>Col</option></selected></td><td></td></tr>
<tr><td>MOS:</td><td><input type="text" name="mos" maxlength="4"></td><td></td></tr>
<tr><td>Rotation Date:</td><td><input type="text" name="rtd" maxlength="10"></td><td></td></tr>
<tr><td>RUC/UIC:</td><td><input type="text" name="ruc" maxlength="6"></td><td></td></tr>

<input type="hidden" value="campSelect" name="cs_config_country_field" id="cs_config_country_field">
<input type="hidden" value="unitSelect"   name="cs_config_state_field"   id="cs_config_state_field">
<!-- The id of the the fields holding the default values.  If more than one, seperate with spaces -->
<input type="hidden" value="countryDefault" name="cs_config_country_default" id="cs_config_country_default">
<input type="hidden" value="stateDefault"   name="cs_config_state_default"   id="cs_config_state_default">
<!-- The actual default values -->
<input type="hidden" value="" name="countryDefault" id="countryDefault">
<input type="hidden" value=""   name="stateDefault"   id="stateDefault">
<SCRIPT type="text/javascript" SRC="camp_unit.js"></SCRIPT>
<tr><TD>Location:</TD><td>
<div>
	     <select id='campSelect' name='camp' onchange='updateState(this.id)'>
      </select>
	</div>
<tr><td>Unit:</td><td><div>
	  <select id='unitSelect' name='unit'>
	  </select>
   </div></td><td></td></tr>
<SCRIPT  type="text/javascript">initCountry(); </SCRIPT>

<tr><td>Company/Section:</td><td><input type="text" name="co" maxlength="25" ></td><td></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" maxlength="75" ></td><td></td></tr>
<tr><td>Phone #:</td><td><input type="text" name="phone1" maxlength="14" onkeyup="jm_phonemask(this)" value="<? $_POST['phone1']; ?>"></td><td></td></tr>
<tr><td>Alt Phone #:</td><td><input type="text" name="phone2" maxlength="14" value="<? $_POST['phone2']; ?>"></td><td></td></tr>



<!--
<input type="hidden" name="date" value="1">
<input type="hidden" name="bcs3" value="<? IF ($_POST['clname'] == 'BCS3') { echo "Y";} else { echo "N";} ?>">
<input type="hidden" name="clc2s" value="<? IF ($_POST['clname'] == 'CLC2S') { echo "Y";} else { echo "N";} ?>">
<input type="hidden" name="tcpt" value="<? IF ($_POST['clname'] == 'TCPT') { echo "Y";} else { echo "N";} ?>">

-->

<tr><td colspan="2" align="right"><input type="submit" name="Process" value="Register"></td></tr>
<tr><td colspan="2" align="left"><a href="#" target="_top">Back to Home</a></td></tr>
</table>
</form>


</body>
</html>

<?	}   


/**
* This function will process the user registration data
**/
function procProcess(){
mysql_select_db($db_name, $conn);

$fname = isset($_POST['fname']) ? mysql_real_escape_string($_POST['fname']) : "";
$mname = isset($_POST['mname']) ? mysql_real_escape_string($_POST['mname']) : "";
$lname = isset($_POST['lname']) ? mysql_real_escape_string($_POST['lname']) : "";
$last4 = isset($_POST['last4']) ? mysql_real_escape_string($_POST['last4']) : "";
$rank = isset($_POST['rank']) ? mysql_real_escape_string($_POST['rank']) : "";
$mos = isset($_POST['mos']) ? mysql_real_escape_string($_POST['mos']) : "";
$rtd = isset($_POST['rtd']) ? mysql_real_escape_string($_POST['rtd']) : "";
$ruc = isset($_POST['ruc']) ? mysql_real_escape_string($_POST['ruc']) : "";
$camp = isset($_POST['camp']) ? mysql_real_escape_string($_POST['camp']) : "";
$unit = isset($_POST['unit']) ? mysql_real_escape_string($_POST['unit']) : "";
$co = isset($_POST['co']) ? mysql_real_escape_string($_POST['co']) : "";
$email = isset($_POST['email']) ? mysql_real_escape_string($_POST['email']) : "";
$phone1 = isset($_POST['phone1']) ? mysql_real_escape_string($_POST['phone1']) : "";
$phone2 = isset($_POST['phone2']) ? mysql_real_escape_string($_POST['phone2']) : "";



$sql = "INSERT INTO 'roster' (fname,mname,lname,last4,rank,mos,rtd,ruc,camp,unit,co,email,phone1,phone2) VALUES ('".$fname."','".$mname."','".$lname."','".$last4."','".$rank."','".$mos."','".$rtd."','".$ruc."','".$camp."','".$unit."','".$co."','".$email."','".$phone1."','".$phone2."')";

mysql_query($sql);

mysql_close($conn);

}

/* Initialize process */
new NewStudent;	

?>

the other php file is just the mysql connection variables.

Thanks for any assistance...

devang23 · December 5, 2009

Hey man, i got the same problem, im trying to get information from a site to mysql database as well, apprently that database has to know your information is coming in, but i dont know how to set the mysql tables so that it shows up

haku · December 5, 2009

What exactly are you asking? There was no question in your post or even a description of a problem.

fenway · December 5, 2009

And next time, don't post entire scripts unless you're asked to.

devang23 · December 5, 2009

im asking how do i make information from a script go into a mysql database table

Sign In

Single PHP file with functions and insterts into MySql

Recommended Posts

dickie

Link to comment

Share on other sites

devang23

Link to comment

Share on other sites

haku

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

devang23

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information