PHP coding insert 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>

</table>

</form>

</body>

</html>

<?

//;

}

/**

* This displays the Class roster page.

**/

function procRegister(){

?>

<html>

<head>

</head>

<body>

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

<!-- 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>

<!--

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>

<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>Rank:</td><td><select name="rank"><option selected>Select</option>

<option>GySgt</option>

<option>MGySgt</option>

<option>SgtMaj</option>

<option>LtCol</option>

<tr><td>Rotation Date:</td><td><input type="text" name="rtd" maxlength="10"></td><td></td></tr>

<tr><TD>Location:</TD><td>

<div>

</select>

</div>

</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>

<!--

-->

</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...

oni-kun · December 5, 2009

What is it that you exactly need help with? This is a PHP help forum. Pleas use code tags around your code as well, and show us the relevant code you actually need help constructing, functions etc.

Sign In

PHP coding insert into mysql

Recommended Posts

dickie

Link to comment

Share on other sites

oni-kun

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information