2. PHPRunner General questions
  3. [SOLVED]  Determine option selected from dropdown snippet
This topic is locked
[SOLVED]

 Determine option selected from dropdown snippet

 		2/10/2014 4:30:12 PM
PHPRunner General questions
I
 ISelb author

Hi -
I have a table of schools that includes schoolid, schoolname and schooldistrict.

I am following this link (Add dropdown list box with values for search) to limit the dropdown list of schools based on input district value (let's call this the restricted drop down list.)
Once the user makes a selection of the restricted dropdown list, I need to write that selection back to a different table.
How do I get the selected value of the restricted dropdown list?
Here is the code I am following at http://xlinesoft.com/phprunner/docs/add_dropdown_list_box_with_values_for_search.htm:

$str= "<select onchange=\"window.location.href=this.options[this.".

"selectedIndex].value;\"><option value=\"\">Please select</option>";

//select values from database

global $conn;

$strSQL = "select Make from Cars";

$rs = db_query($strSQL,$conn);

while ($data = db_fetch_array($rs))

$str.="<option value='cars_list.php?q=(Make~equals~".

$data["Make"].")'>".$data["Make"]."</option>";

$str.="</select>";

echo $str;


I am trying to capture the user selection from the restricted dropdown list while in the 'Before record added' event.
I
 		ISelb author 2/11/2014

Here is my actual code:



function OnBallot3_snippet() {
global $conn;

$cid = $_SESSION['cid'];

$str = "";
//get restricted school list

$sql = "SELECT coachschoolid FROM tblcoach WHERE coachid = '" . $cid . "'";

$cres = db_query($sql,$conn) or die("1: An error occured: " . mysqli_error($conn));

$cdata = db_fetch_array($cres) or die("2: An error occured: " . mysqli_error($conn));
$sql = "SELECT schooldivision FROM tblschool WHERE schoolid = '" . $cdata['coachschoolid'] . "'";

$sdres = db_query($sql,$conn) or die("3: An error occured: " . mysqli_error($conn));

$sddata = db_fetch_array($sdres) or die("4: An error occured: " . mysqli_error($conn));
$sql = "SELECT schoolid, schoolname FROM tblschool WHERE schooldivision = '" . $sddata['schooldivision'] . "' ORDER BY schoolname ASC";

$snres = db_query($sql,$conn) or die("5: An error occured: " . mysqli_error($conn));
$selschoolid = "";


$vid = $_SESSION['vid'];

$sql = "SELECT POYid FROM Voting WHERE voteid = '" . $vid . "'";

$vrecord = db_query($sql,$conn) or die("A: An error occured: " . mysqli_error($conn));

$vdata = db_fetch_array($vrecord) or die("B: An error occured: " . mysqli_error($conn));
if (empty($vdata['POYid'])) {}

else if (!isset($vdata['POYid'])) {}

else {

$sql = "SELECT schoolid FROM PlayerVote WHERE playervoteid = '" . $vdata['POYid'] . "'";

$psres = db_query($sql,$conn);

$psdata = db_fetch_array($psres);

$selschoolid = $psdata['schoolid'];

}
$str= "<select name=\"POYschoolid\"><option value=\"default\">Please select</option>";
while ($data = db_fetch_array($snres)) {

$sval = $data['schoolid'];

$sname = $data['schoolname'];

$str .="<option value = '" . $sval . "'";

if ($sval == $selschoolid) {

$str .= " selected";

}

$str .= ">" . $sname . "</option>";

}
//$str .= "<option value= '1'>one </option>";

$str .="</select>";

echo $str;
}




function BeforeProcessAdd($conn,$pageObject) {
global $dal;

global $conn;
$vid = $_SESSION['vid'];

$cid = $_SESSION['cid'];
$_SESSION['POYname'] = '';
$sql = "SELECT coachid, coachschoolid, POYid

FROM `Voting` WHERE `voteid` = '" . $vid . "'";
$vrecord = mysqli_query($conn,$sql) or die("A: An error occured: " . mysqli_error($conn));

$vdata = db_fetch_array($vrecord) or die("B: An error occured: " . mysqli_error($conn));
if (empty($vdata['POYid'])) return true;

if (!isset($vdata['POYid'])) return true;
// otherwise, retrieve all data so we can pre-fill the form

$sql = "SELECT name, schoolid, yearinschool, position, heightft, stats, comments, heightin FROM PlayerVote WHERE playervoteid = '" . $vdata['POYid'] . "'";

$pres = db_query($sql,$conn) or die("C: An error occured: " . mysqli_error($conn));

$pdata = db_fetch_array($pres) or die("D: An error occured: " . mysqli_error($conn));
$_SESSION['POYname'] = $pdata['name'];

$_SESSION['schoolid'] = $pdata['schoolid'];

$_SESSION['yearinschool'] = $pdata['yearinschool'];

$_SESSION['position'] = $pdata['position'];

$_SESSION['heightft'] = $pdata['heightft'];

$_SESSION['stats'] = $pdata['stats'];

$_SESSION['comments'] = $pdata['comments'];

$_SESSION['heightin'] = $pdata['heightin'];
}




function BeforeAdd($values,$inline,$pageObject) {

global $dal;

global $conn;
// Place event code here.

// Use "Add Action" button to add code snippets.
$vid = $_SESSION['vid'];

$vdata = array();
$poyselectedid = $values['POYschoolid'];
//POY

$tblplayervote = $dal->Table('PlayerVote');

$tblplayervote->Value['name'] = $values['POYname'];

$tblplayervote->Value['schoolid'] = /* $values['POYschoolid']; */ $poyselectedid;

$tblplayervote->Value['yearinschool'] = $values['POYyearinschool'];

$tblplayervote->Value['position'] = $values['POYposition'];

$tblplayervote->Value['heightft'] = $values['POYft'];

$tblplayervote->Value['heightin'] = $values['POYin'];

$tblplayervote->Value['stats'] = $values['POYstats'];

$tblplayervote->Value['comments'] = $values['POYcomments'];
$tblplayervote->Add();

$pvid = mysqli_insert_id($conn); // grab id

$vdata['POYid'] = $pvid;
// update Voting record

$sql = "UPDATE Voting

SET POYid = '" . $vdata['POYid'] . "'

WHERE voteid = '" . $vid . "'";

$result = db_query($sql,$conn) or die("An error occured: " . mysqli_error($conn));
// remove all session variables, but not the session itself

session_unset();
//********** Redirect to another page ************

//header("Location: http://mypage.com/expandedVE/thankyou.php";);

exit();
return true;

}