Jump to content

rwachowiak

Members
 View Profile  See their activity

  • Posts

    50

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by rwachowiak

  1. rwachowiak
    Ok, so what im trying to achieve is this... you come to this page: http://www.hutcommunity.com/Database/playercard.php You click on a player... and his information is loaded into the table. You can then add "training cards" to the players stats... eg, +5skt or +9 skt, etc, to get them higher stats. each player has a set amount of training slots. below is my code, and its pretty close, but when you do a +9skt and +9hnd, its adding +9 and +9 to stats 1 and 2 instead of 9 for each one... because of the code... so how would i be able to achieve this?? i feel like im really close!!! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Player Card</title> <script type="text/javascript" src="jquery-1.3.2.js"></script> <script type="text/javascript" src="jquery.form.js"></script> <script type="text/javascript"> // wait for the DOM to be loaded $(document).ready(function() { // bind 'myForm' and provide a simple callback function $('#myForm').ajaxForm(function() { alert("Thank you for your comment!"); }); }); </script> </head> <body> <table cellpadding="0" cellspacing="0" class="display" id="example"> <thead> <tr> <th></th> <th align="left">FIRST NAME</th> <th align="left">LAST NAME</th> <th align="center">OVR</th> <th align="center">POT</th> <th align="left">TEAM</th> <th align="left">LEAGUE</th> <th align="center">SKT</th> <th align="center">SHT</th> <th align="center">HND</th> <th align="center">CHK</th> <th align="center">DEF</th> <th>SALARY</th> <th>CAREER</th> <th align="center">POSITION</th> <th>TYPE</th> <th>SLOTS</th> </tr> </thead> <tbody> <? $username="???"; $password="???"; $database="???"; mysql_connect('hutcommunity.db.6977873.hostedresource.com',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM Players WHERE Team='Buffalo Sabres'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $First_Name=mysql_result($result,$i,"First_Name"); $Last_Name=mysql_result($result,$i,"Last_Name"); $Team=mysql_result($result,$i,"Team"); $League=mysql_result($result,$i,"League"); $Career_Games=mysql_result($result,$i,"Career_Games"); $Salary=mysql_result($result,$i,"Salary"); $Position=mysql_result($result,$i,"Position"); $Player_Type=mysql_result($result,$i,"Player_Type"); $Training_Slots=mysql_result($result,$i,"Training_Slots"); $Stat_1=mysql_result($result,$i,"Stat_1"); $Stat_2=mysql_result($result,$i,"Stat_2"); $Stat_3=mysql_result($result,$i,"Stat_3"); $Stat_4=mysql_result($result,$i,"Stat_4"); $Stat_5=mysql_result($result,$i,"Stat_5"); $Overall=mysql_result($result,$i,"Overall"); $Potential=mysql_result($result,$i,"Potential"); $Mugshot=mysql_result($result,$i,"Mugshot"); echo "<tr> <td><img src=\"http://cdn.nhl.com/photos/mugs/thumb/$Mugshot.jpg\" width=\"37\" height=\"47\" /></td> <td><strong><span class=\"Name\"><a href=\"playercard.php?id=$Mugshot\">$First_Name</a></strong</span></td> <td><strong><span class=\"Name\"><a href=\"playercard.php?id=$Mugshot\">$Last_Name</a></strong</span></td> <td align=\"center\"><span class=\"Overall\"><strong>$Overall</strong></span></td> <td align=\"center\"><span class=\"Potential\"><strong>$Potential</strong></span></td> <td>$Team</td> <td align=\"center\">$League</td> <td align=\"center\"><strong>$Stat_1</strong></td> <td align=\"center\"><strong>$Stat_2</strong</td> <td align=\"center\"><strong>$Stat_3</strong</td> <td align=\"center\"><strong>$Stat_4</strong</td> <td align=\"center\"><strong>$Stat_5</strong</td> <td align=\"center\">$Salary</td> <td align=\"center\">$Career_Games</td> <td align=\"center\">($Position)</td> <td align=\"center\">$Player_Type</td> <td>0 / $Training_Slots</td> </tr> "; $i++; } ?> </tbody> </table> <? $username="???"; $password="???"; $database="???"; $id = $_GET['id']; $Slot1=$_POST['Slot1']; $Slot2=$_POST['Slot2']; $Slot3=$_POST['Slot3']; $Slot4=$_POST['Slot4']; $Slot5=$_POST['Slot5']; $Slot6=$_POST['Slot6']; $Slot7=$_POST['Slot7']; $Slot8=$_POST['Slot8']; $Slot9=$_POST['Slot9']; $Slot10=$_POST['Slot10']; $Slot11=$_POST['Slot11']; $Slot12=$_POST['Slot12']; mysql_connect('hutcommunity.db.6977873.hostedresource.com',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM Players WHERE Mugshot='$id'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $First_Name=mysql_result($result,$i,"First_Name"); $Last_Name=mysql_result($result,$i,"Last_Name"); $Team=mysql_result($result,$i,"Team"); $League=mysql_result($result,$i,"League"); $Career_Games=mysql_result($result,$i,"Career_Games"); $Salary=mysql_result($result,$i,"Salary"); $Position=mysql_result($result,$i,"Position"); $Player_Type=mysql_result($result,$i,"Player_Type"); $Training_Slots=mysql_result($result,$i,"Training_Slots"); $Stat_1=mysql_result($result,$i,"Stat_1"); $Stat_2=mysql_result($result,$i,"Stat_2"); $Stat_3=mysql_result($result,$i,"Stat_3"); $Stat_4=mysql_result($result,$i,"Stat_4"); $Stat_5=mysql_result($result,$i,"Stat_5"); $Overall=mysql_result($result,$i,"Overall"); $Potential=mysql_result($result,$i,"Potential"); $Mugshot=mysql_result($result,$i,"Mugshot"); $S1M99 = 99-$Stat_1; $S2M99 = 99-$Stat_2; $S3M99 = 99-$Stat_3; $S4M99 = 99-$Stat_4; $S5M99 = 99-$Stat_5; $SKATE5=5; $SKATE7=7; $SKATE9=9; $HAND5=5; $HAND7=7; $HAND9=9; $SKATETOTAL = $Stat_1+$Slot1+$Slot2; $HANDTOTAL = $Stat_2+$Slot1+$Slot2; echo " <table width=\"500\" border=\"2\" cellspacing=\"2\" cellpadding=\"2\"> <tr> <td colspan=\"3\" rowspan=\"3\"><img src=\"http://cdn.nhl.com/photos/mugs/$Mugshot.jpg\"/></td> <td width=\"294\">$League</td> </tr> <tr> <td>$Team</td> </tr> <tr> <td>$Overall $Potential</td> </tr> <tr> <td colspan=\"4\">$First_Name $Last_Name</td> </tr> <tr> <td width=\"67\">SKT</td> <td width=\"58\">$Stat_1</td> <td width=\"43\">$S1M99</td> <td>$SKATETOTAL</td> </tr> <tr> <td>SHT</td> <td>$Stat_2</td> <td>$S2M99</td> <td>$HANDTOTAL</td> </tr> <tr> <td>HND</td> <td>$Stat_3</td> <td>$S3M99</td> <td> </td> </tr> <tr> <td>CHK</td> <td>$Stat_4</td> <td>$S4M99</td> <td> </td> </tr> <tr> <td>DEF</td> <td>$Stat_5</td> <td>$S5M99</td> <td> </td> </tr> </table> "; $i++; } ?> <form id="myForm" method="post"> <? $username="???"; $password="???"; $database="???"; $id = $_GET['id']; mysql_connect('hutcommunity.db.6977873.hostedresource.com',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM Players WHERE Mugshot='$id'"; $result=mysql_query($query); $var = $Training_Slots; foreach(range(1,$var) as $num) { echo "Training Slot $num: <select name=\"Slot$num\" id=\"Slot$num\"> <option value=\"\">Choose Training</option> <option value=\"$SKATE5\">+5 SKT</option> <option value=\"$SKATE7\">+7 SKT</option> <option value=\"$SKATE9\">+9 SKT</option> <option value=\"$HAND5\">+5 HND</option> <option value=\"$HAND7\">+7 HND</option> <option value=\"$HAND9\">+9 HND</option> </select><br> "; } ?> <input type="Submit"> </form> </body> </html>
  2. rwachowiak
    yup got it! thanks guys! <form id="myForm" method="post"> <? $username="??"; $password="??"; $database="??"; $id = $_GET['id']; mysql_connect('hostname',$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM Players WHERE Mugshot='$id'"; $result=mysql_query($query); $var = $Training_Slots; foreach(range(1,$var) as $num) { echo "Training Slot $num: <select name=\"Slot$num\" id=\"Slot$num\"> <option value=\"\">Choose Training</option> <option value=\"5\">5 SKT</option> <option value=\"7\">7 SKT</option> <option value=\"9\">9 SKT</option> </select><br> "; } ?> <input type="Submit"> </form> edit: removed hostname from mysql_connect
  3. rwachowiak
    Thanks for the input... what im really looking for is this: I have a query that pulls a number from a database... the number will change based on the WHERE clause... and with each different number, i need an output that adds a form input, 1 for each number... so if the variable = 5, there needs to be 5 inputs in the form, if the variable is 3, then 3 inputs in the form... and so on. so would i have something like: <form> <?php $var = $Training_Slots; foreach(range(1,$var) as $num) { echo "<input id=\"Slot$num\"><br />"; } my code is way off, but you get the idea? ?>
  4. rwachowiak
    Lets say I have: $var=5; What would an output look like to get me: 1<br> 2<br> 3<br> 4<br> 5<br> Im at a complete loss! Thanks!
  5. rwachowiak
    Came up with something... thoughts? http://www.hutcommunity.com/Database/playercard.php
  6. rwachowiak
    https://spreadsheets.google.com/ccc?key=0ArqmVVzMUYNadDZzekE2WWdlX3lNMFlieWRUQkZzM3c&hl=en&authkey=CI3uhqUB I uploaded it to google... hows that?
  7. rwachowiak
    Well sorry... its just a spreadsheet... ive got 40+ posts here... anyways... how would i post a excel spreadsheet code chief?
  8. rwachowiak
    Hey all, I hope this is the right forum... if not someone can move it! So, here is my idea: I have a database of "Cards" for the game NHL 11, for the mode Hockey Ultimate Team,... check out the database/page here: http://www.hutcommunity.com/Database/ Basically, all that info is a direct representation of the MySQL Database. Now, in the game, you can add "Training" Cards to the players, as per however many "Training Slots" they have. The training cards can be like +5 SKT, +9 SKT, +3 All, which adds +3 to all their stats. So my idea is that when you click on a players name or picture, you get a new page, called "Training Page" or something, and you get all the player info, with... well its hard to describe, but ive made a excel 2010 spreadsheet to kind of give you the idea im looking for. See the attachment for the spreadsheet. Now, the information that these people wont be able to be saved, just observed to see how they can train X player... So, I have no idea where to start, and if anyone can give me some ideas or point me in the right direction, that would be great! Thanks! [attachment deleted by admin]
  9. rwachowiak
    uh... ive looked and looked it all i can see is that it replaces the 0 no matter what... i cant figure it out i been searching for a while now...
  10. rwachowiak
    ah nice thats how! perfect!!!! ok... but now it changes 10 to 1-... VERY CLOSE THOUGH!! how can i make it exact?? hmm
  11. rwachowiak
    how do i do the replace? there are 0's in the wk1act and week1 fields... but there are also other numbers, but in the query, i want all the numbers that arent 0 to show properly, and if a zero is found i want it as a -... any ideas?
  12. rwachowiak
    yes perfect, now what about if i got this going on: $id = (isset($_GET['Userid']))? mysql_escape_string($_GET['Userid']) : "1"; $query = "SELECT (wk1act-week1), week1, wk1act FROM staff JOIN project ON project.staff_id=staff.id WHERE project.staff_id='$id' GROUP BY project.id"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "<tr>". "<td width='40' height='20' class='vertspreader'><div align='center'>{$row['week1']}</div></td>" . "<td width='40' height='20' class='topspreader'><div align='center'>{$row['wk1act']}</div></td>" . "<td width='40' height='20' class='topspreader'><div align='center'>{$row['(wk1act-week1)']}</div></td>" . } </tr> thanks!!!
  13. rwachowiak
    whats the easiest way to a query turn 0's (zeros) into "-" in the display? this is my code so far... but say Field 1 is a 0, i want a - there instead but i cant use a and if then statement because the actual query is massive... $query = "SELECT * FROM table"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "Instead of 0 this is a -: {$row['field1']}"; } thanks!
  14. rwachowiak
    sorry to be a huge pain, i might be missing something. nothing is showing up on the page for this query =(
  15. rwachowiak
    what would the whole thing look like? including the echo and stuff? sorry im still pretty new to mysql =(
  16. rwachowiak
    TABLE: project FIELDS: id, staff_id, clientname, projecttype, partner, manager, week1, week2 ~ week 59, week 60, wk1act, wk2act ~ wk59act, wk60act id staff_id clientname projecttype partner manager week1 week2 1 1 Mader Construction Audit KGB EDC 10 10 2 1 Taber Industries 1120S Review CWC CAJ 5 5 TABLE: staff FIELDS: id, firstname, lastname, skilllevel, week1hours, week2hours ~ week59hours, week60hours id firstname lastname skilllevel week1hours week2hours 1 Ryan Wachowiak Intern 40 40 So, what i want it to do is add up Week1 hours from PROJECT, and do the following formula: "week1hours - SUM of week1" So, for Ryan Wachowiak, it would be -25 That help?
  17. rwachowiak
    hmm, i put that in place of what i had and it breaks the page, makes it all white... hmmm
  18. rwachowiak
    whoops sorry did it get moved already?
  19. rwachowiak
    <?php include 'libs/dbopen.php'; $id = (isset($_GET['Userid']))? mysql_escape_string($_GET['Userid']) : "1"; $query = "SELECT SUM(week1-week1hours) FROM staff JOIN project ON project.staff_id=staff.id WHERE project.staff_id='$id'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ if ($row['SUM(week1-week1hours)'] >= 0) { echo "{$row['SUM(week1-week1hours)']}"; } else { echo "<span class='red'>({$row['SUM(week1-week1hours)']})</span>"; } } include 'libs/dbclose.php';?> Ok, so what i want this to do is SUM up all of week1 and minus week1hours... but what its doing is its multiplying week1hours by how many ever rows there are of week1... so if theres 5 rows it looks like: "week1-week1hours*5" any ideas?! thanks!!
  20. rwachowiak
    wow duh thanks!
  21. rwachowiak
    <?php include 'libs/dbopen.php'; $id = (isset($_GET['Userid']))? mysql_escape_string($_GET['Userid']) : "1"; $query = "SELECT SUM(week2-(week2hours*.25)) FROM staff JOIN project ON project.staff_id=staff.id WHERE project.staff_id='$id'"; $result = mysql_query($query); $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ if ($query >= 0) { echo "{$row['SUM(week2-(week2hours*.25))']}"; } else { echo "<span class='red'>({$row['SUM(week2-(week2hours*.25))']})</span>"; } } include 'libs/dbclose.php';?> $query is either positive or negative, if its positive, i want it to just show as black text, if its negative i want it to show as red text with () around it... but no matter what number $query gives me, it stays black every time help! thanks!
  22. rwachowiak
    ok i must be missing something... heres what i got and its not working <?php if(isset($_POST['q1a'])||isset($_POST['q1b'])){ include 'libs/dbopen.php'; $q1a = mysql_real_escape_string($_POST['q1a']); $q1b = mysql_real_escape_string($_POST['q1b']); $q2a = mysql_real_escape_string($_POST['q2a']); $q2b = mysql_real_escape_string($_POST['q2b']); $q3a = mysql_real_escape_string($_POST['q3a']); $q3b = mysql_real_escape_string($_POST['q3b']); $q4a = mysql_real_escape_string($_POST['q4a']); $q4b = mysql_real_escape_string($_POST['q4b']); $q5a = mysql_real_escape_string($_POST['q5a']); $q5b = mysql_real_escape_string($_POST['q5b']); $q6a = mysql_real_escape_string($_POST['q6a']); $q6b = mysql_real_escape_string($_POST['q6b']); $q7a = mysql_real_escape_string($_POST['q7a']); $q7b = mysql_real_escape_string($_POST['q7b']); $q8a = mysql_real_escape_string($_POST['q8a']); $q8b = mysql_real_escape_string($_POST['q8b']); $q9a = mysql_real_escape_string($_POST['q9a']); $q9b = mysql_real_escape_string($_POST['q9b']); $q10a = mysql_real_escape_string($_POST['q10a']); $q10b = mysql_real_escape_string($_POST['q10b']); $q11a = mysql_real_escape_string($_POST['q11a']); $q11b = mysql_real_escape_string($_POST['q11b']); $q12a = mysql_real_escape_string($_POST['q12a']); $q12b = mysql_real_escape_string($_POST['q12b']); $q121a = mysql_real_escape_string($_POST['q121a']); $q121b = mysql_real_escape_string($_POST['q121b']); $q122a = mysql_real_escape_string($_POST['q122a']); $q122b = mysql_real_escape_string($_POST['q122b']); $q123a = mysql_real_escape_string($_POST['q123a']); $q123b = mysql_real_escape_string($_POST['q123b']); $q124a = mysql_real_escape_string($_POST['q124a']); $q124b = mysql_real_escape_string($_POST['q124b']); $q125a = mysql_real_escape_string($_POST['q125a']); $q125b = mysql_real_escape_string($_POST['q125b']); $q13a = mysql_real_escape_string($_POST['q13a']); $q13b = mysql_real_escape_string($_POST['q13b']); $q14a = mysql_real_escape_string($_POST['q14a']); $q14b = mysql_real_escape_string($_POST['q14b']); $q15a = mysql_real_escape_string($_POST['q15a']); $q15b = mysql_real_escape_string($_POST['q15b']); $q16a = mysql_real_escape_string($_POST['q16a']); $q16b = mysql_real_escape_string($_POST['q16b']); $q17a = mysql_real_escape_string($_POST['q17a']); $q17b = mysql_real_escape_string($_POST['q17b']); $q18 = mysql_real_escape_string($_POST['q18']); $q19 = mysql_real_escape_string($_POST['q19']); $q20 = mysql_real_escape_string($_POST['q20']); $q21 = mysql_real_escape_string($_POST['q21']); $name = mysql_real_escape_string($_POST['name']); $query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name) VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')"; mysql_query($query) or die('Error, insert query failed: '.mysql_error()); include 'libs/dbclose.php'; echo "Your Survey has been added, Thank You.<br><br><a href='index.php'>Go to Index</a>"; } else { $errMsg = 'You missed a field.'; echo $errMsg; ?>
  23. rwachowiak
    instead of an error for EACH one because there are a lot, how about just a simple one that says "you missed a field" or something like that. and could u be a bud and give me the exact code, im really new!!! and explain it too plz so i can learn!! thanks!!!!!!!!
  24. rwachowiak
    thanks for the quick response... they are all mostly option fields... theres like 30+ of them... and what do i put in for "// Display the error and the form again." ??? thanks!
  25. rwachowiak
    so i have a php form, it works fine, but i want to have required fields, on all but 1 field. heres my code: <?php if(isset($_POST['add'])) { include 'libs/dbopen.php'; $q1a = mysql_real_escape_string($_POST['q1a']); $q1b = mysql_real_escape_string($_POST['q1b']); $q2a = mysql_real_escape_string($_POST['q2a']); $q2b = mysql_real_escape_string($_POST['q2b']); $q3a = mysql_real_escape_string($_POST['q3a']); $q3b = mysql_real_escape_string($_POST['q3b']); $q4a = mysql_real_escape_string($_POST['q4a']); $q4b = mysql_real_escape_string($_POST['q4b']); $q5a = mysql_real_escape_string($_POST['q5a']); $q5b = mysql_real_escape_string($_POST['q5b']); $q6a = mysql_real_escape_string($_POST['q6a']); $q6b = mysql_real_escape_string($_POST['q6b']); $q7a = mysql_real_escape_string($_POST['q7a']); $q7b = mysql_real_escape_string($_POST['q7b']); $q8a = mysql_real_escape_string($_POST['q8a']); $q8b = mysql_real_escape_string($_POST['q8b']); $q9a = mysql_real_escape_string($_POST['q9a']); $q9b = mysql_real_escape_string($_POST['q9b']); $q10a = mysql_real_escape_string($_POST['q10a']); $q10b = mysql_real_escape_string($_POST['q10b']); $q11a = mysql_real_escape_string($_POST['q11a']); $q11b = mysql_real_escape_string($_POST['q11b']); $q12a = mysql_real_escape_string($_POST['q12a']); $q12b = mysql_real_escape_string($_POST['q12b']); $q121a = mysql_real_escape_string($_POST['q121a']); $q121b = mysql_real_escape_string($_POST['q121b']); $q122a = mysql_real_escape_string($_POST['q122a']); $q122b = mysql_real_escape_string($_POST['q122b']); $q123a = mysql_real_escape_string($_POST['q123a']); $q123b = mysql_real_escape_string($_POST['q123b']); $q124a = mysql_real_escape_string($_POST['q124a']); $q124b = mysql_real_escape_string($_POST['q124b']); $q125a = mysql_real_escape_string($_POST['q125a']); $q125b = mysql_real_escape_string($_POST['q125b']); $q13a = mysql_real_escape_string($_POST['q13a']); $q13b = mysql_real_escape_string($_POST['q13b']); $q14a = mysql_real_escape_string($_POST['q14a']); $q14b = mysql_real_escape_string($_POST['q14b']); $q15a = mysql_real_escape_string($_POST['q15a']); $q15b = mysql_real_escape_string($_POST['q15b']); $q16a = mysql_real_escape_string($_POST['q16a']); $q16b = mysql_real_escape_string($_POST['q16b']); $q17a = mysql_real_escape_string($_POST['q17a']); $q17b = mysql_real_escape_string($_POST['q17b']); $q18 = mysql_real_escape_string($_POST['q18']); $q19 = mysql_real_escape_string($_POST['q19']); $q20 = mysql_real_escape_string($_POST['q20']); $q21 = mysql_real_escape_string($_POST['q21']); $name = mysql_real_escape_string($_POST['name']); $query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name) VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')"; mysql_query($query) or die('Error, insert query failed: '.mysql_error()); if (!($q1a && $q1b && $q18 && $q19)) {echo "You must complete the form to send it"; } else { } include 'libs/dbclose.php'; echo "Your Survey has been added, Thank You.<br><br><a href='index.php'>Go to Index</a>"; } else { ?> <br><span class="titlebar">THE EMPLOYEE CTBK SATISFACTION SURVEY</span><br> <br> <form method="post" enctype="multipart/form-data"> <table width="850" border="0" cellspacing="1" cellpadding="2"> <tr> <td height="25"> </td> <td width="150" height="25"><div align="center"><span class="titlebar2">OVERALL EVALUATION</span></div></td> <td width="150" height="25"><div align="center"><span class="titlebar2">ATTRIBUTE IMPORTANCE</span></div></td> </tr> <tr> <td height="25"> </td> <td width="150" height="25" valign="top"><div align="left" class="description">Please rate each of the following attributes: </div></td> <td width="150" height="25" valign="top"><div align="left" class="description">Please rate the following attributes in accordance with how you perceive their importance to you as an employee at CTBK</div></td> </tr> <tr> <td height="25"> </td> <td height="25" colspan="2"><div align="center" class="titlebar4">1 = Poor, 3 = Average, 5 = Excellent </div> <div align="center"></div></td> </tr> <tr> <td height="30" bgcolor="#F0F3F8">1. The overall quality of the phsyical work environment.</td> <td width="150" height="30" bgcolor="#F0F3F8"> <div align="center"> <select name="q1a" id="q1a"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30" bgcolor="#F0F3F8"> <div align="center"> <select name="q1b" id="q1b"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">2. Your overall satisfaction with the work load assigned.</td> <td width="150" height="30"><div align="center"> <select name="q2a" id="select4"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q2b" id="select26"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">3. Your overall satisfaction with the challenge of work assignments. </td> <td width="150" height="30"><div align="center"> <select name="q3a" id="select5"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q3b" id="select27"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">4. Your overall satisfaction with the engagement mix. </td> <td width="150" height="30"><div align="center"> <select name="q4a" id="select7"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q4b" id="select28"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">5. Do you feel you have the opportunity available to advance. </td> <td width="150" height="30"><div align="center"> <select name="q5a" id="select6"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q5b" id="select29"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">6. Your overall satisfaction with the compensation/salary you recieve. </td> <td width="150" height="30"><div align="center"> <select name="q6a" id="select8"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q6b" id="select30"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">7. Your overall satisfaction with the fringes available. </td> <td width="150" height="30"><div align="center"> <select name="q7a" id="select9"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q7b" id="select31"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">8. The quality and quantity of recognition you recieve from superiors. </td> <td width="150" height="30"><div align="center"> <select name="q8a" id="select10"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q8b" id="select32"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">9. The quality and quantity of recognition you recieve from peers. </td> <td width="150" height="30"><div align="center"> <select name="q9a" id="select12"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q9b" id="select33"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">10. The overall quality and quantity of guidance received from superiors.</td> <td width="150" height="30"><div align="center"> <select name="q10a" id="select11"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q10b" id="select34"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">11. The overall quality and quantity of external training you are recieving. </td> <td width="150" height="30"><div align="center"> <select name="q11a" id="select13"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q11b" id="select35"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">12. The overall communications available within the office: </td> <td width="150" height="30"><div align="center"></div></td> <td width="150" height="30"><div align="center"></div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">- Top Down (ie. partner to manager to senior to staff) </td> <td width="150" height="30"><div align="center"> <select name="q121a" id="select14"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q121b" id="select36"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30"> - Electronic </td> <td width="150" height="30"><div align="center"> <select name="q122a" id="select15"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q122b" id="select37"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">- Phones </td> <td width="150" height="30"><div align="center"> <select name="q123a" id="select16"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q123b" id="select38"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">- Upwards (ie. staff to senior to manager to partner) </td> <td width="150" height="30"><div align="center"> <select name="q124a" id="select17"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q124b" id="select39"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">- Mentoring Program </td> <td width="150" height="30"><div align="center"> <select name="q125a" id="select18"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q125b" id="select40"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">13. Do you feel you have the tools and or resources necessary to do the job. </td> <td width="150" height="30"><div align="center"> <select name="q13a" id="select19"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q13b" id="select41"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">14. The overall satisfaction with the office hardware. </td> <td width="150" height="30"><div align="center"> <select name="q14a" id="select20"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q14b" id="select42"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">15. The overall satisfaction with the office software. </td> <td width="150" height="30"><div align="center"> <select name="q15a" id="select21"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q15b" id="select43"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">16. The overall quality of process improvements. </td> <td width="150" height="30"><div align="center"> <select name="q16a" id="select22"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q16b" id="select25"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td height="30">17. Your overall satisfaction with working at CTBK </td> <td width="150" height="30"><div align="center"> <select name="q17a" id="select23"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> <td width="150" height="30"><div align="center"> <select name="q17b" id="select24"> <option value="" selected></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30" colspan="3">18. What do you like best about working at CTBK? <div align="center"></div> <div align="center"></div></td> </tr> <tr> <td height="30" colspan="3"><textarea name="q18" rows="6" id="q18" cols="90"></textarea></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30" colspan="3">19. What one area could we improve to make your job easier or improve the overall quality of the operations of the practice? <div align="center"></div> <div align="center"></div></td> </tr> <tr> <td height="30" colspan="3"><textarea name="q19" rows="6" id="q19" cols="90"></textarea></td> </tr> <tr bgcolor="#F0F3F8"> <td width="455" height="30">20. What is your age demographic? </td> <td height="30" colspan="2"><div align="left"> <select name="q20" id="select"> <option value="18-25">18-25</option> <option value="26-33">26-33</option> <option value="34-41">34-41</option> <option value="42+">42+</option> </select> </div></td> </tr> <tr> <td width="455" height="30">21. What is your position at CTBK? </td> <td height="30" colspan="2"><div align="left"> <select name="q21" id="select2"> <option value="Administrative">Administrative</option> <option value="Staff">Staff</option> <option value="Senior">Senior</option> <option value="Manager">Manager</option> <option value="Principal or Director">Principal or Director</option> </select> </div></td> </tr> <tr bgcolor="#F0F3F8"> <td height="30">(Optional) What is your name? </td> <td height="30" colspan="2"><div align="left"> <input name="name" type="text" id="name" size="40" /> </div></td> </tr> <tr> <td width="455" height="25"> </td> <td width="150" height="25"> <div align="center"> <input name="add" type="submit" id="add" value="Finish"> </div></td> <td width="150" height="25"><div align="center"></div></td> </tr> </table> </form> <?php } ?> thanks for looking!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.