Source code for:
addrecord.php
<html>
<head>
<title>Q7310: Add Records </title>
</head>
<body>
<?php
// ======================DEBUG DATA ======================
SETTYPE ($formdata,'array');
$max=40;
FOR ($counter=0; $counter<=$max; $counter++){
$formdata[$counter]= "0";
// prtBR ("$counter: $formdata[$counter]");
}
$formdata[1]= "FR";
$formdata[2]= " ";
$formdata[3]= "Eligibility";
$formdata[4]= "Soccer";
$formdata[5]= $GPA;
//$formdata[6]= $APD;
$formdata[6]= "Yes";
$formdata[29]= "t11";
$formdata[30]= "t12";
$formdata[31]= "t13";
$formdata[32]= "t14";
$formdata[33]= "Y";
$formdata[34]= "Y";
$formdata[35]= "NA-G";
$formdata[36]= "NA-B";
$formdata[37]= "no comment";
/*
==================================================================
SAVE VALID RECORD TO DATABASE
==================================================================
*/
$user = "flatfilsoc";
$pass = "q7310";
$db = "iac_survey";
$table = "iac_test";
// CONNECT TO SERVER =================================
$link = mysql_connect("mysql", $user, $pass)OR DIE ( "Could not connect to MySQL" );
PRINT "Successfully <b> connected </b> to server<P>";
// SELECT DATABASE ============================================
mysql_select_db($db) OR DIE ( "Couldn't open $db: ".mysql_error() );
PRINT "Successfully selected database <b> \"$db\" </b><P>";
// SELECT TABLE ===============================================
$query = "SELECT * FROM $table";
$result = mysql_query($query);
PRINT "Successfully selected table <b> \"$table\" </b> <P>";
/*
===================================================================
INSERT NEW RECORD
===================================================================
*/
$sql = "INSERT INTO $table(record,Level, OtherLevel2, Eligibility, Sport, GPA, APD, Transfer, Scholarship, Unit, study, Mentor, Mentor2, Tutor,Tutor2, SHall, SHall2, TGroup, TGroup2, t1, t2, t3, t4, t5, t6, t7, t8, t9, t10,
t11, t12, t13, t14,Pro, Scareer, good, Bcomment, Ocomment)
VALUES
(NULL,'$Formdata[1]', '$Formdata[2]','$Formdata[3]', '$Formdata[4]',
'$Formdata[5]','$Formdata[6]','$formdata[7]', '$formdata[8]',
'$formdata[9]','$formdata[10]', '$formdata[11]', '$formdata[12]',
'$formdata[13]','$formdata[14]', '$formdata[15]',
'$formdata[16]', '$formdata[17]','$formdata[18]',
'$formdata[19]',
'$formdata[20]', '$formdata[21]','$formdata[22]', '$formdata[23]',
'$formdata[24]', '$formdata[25]', '$formdata[26]', '$formdata[27]',
'$formdata[28]', '$formdata[29]', '$formdata[30]','$formdata[31]',
'$formdata[32]', '$formdata[33]', '$formdata[34]', '$formdata[35]',
'$formdata[36]', '$formdata[37]')";
$result = @mysql_query($sql, $link) OR DIE (mysql_error());
PRINT "<center> $formdata[4] Player, your survey was successfully saved to <b> \"$table\" </b> </center>";
// CLOSE SERVER =================================================
mysql_close($link);
PRINT "Successfully <b> disconnected</b> from server<P>";
/*
BREAK;
CASE "1":
PRINT "<center> Return to Survey </center>";
BREAK;
DEFAULT:
prtBR ("<h2> Database Insertion Error - Contact ryh352@mizzou.edu </h2>");
}
*/
?>
</body>
</html>
|