2. PHPRunner General questions
  3. [SOLVED]   code spinet
This topic is locked
[SOLVED]

  code spinet

 		4/5/2012 8:00:43 AM
PHPRunner General questions
J
 jura author

hello,
how user can see only they own values in dropdown field (on list page - code sinet)
//create dropdown box

$str = "";

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

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

//select values from database

global $conn;

$strSQL = "select Posprim from Evidencija where userID = ??????? group by Posprim";

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

while ($data = db_fetch_array($rs))

$str.="<option value=\"Evidencija_list.php?ctlSearchFor=".$data["Posprim"].

"&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=".

"integrated&id=1&criteria=and&type1=&value11=".$data["Posprim"].

"&field1=Posprim&option1=Contains&not1=a=search&value=1\">".

$data["Posprim"]."</option>";

$str.="</select>";

echo $str;
C
 		cgphp 4/5/2012

If userID is the username of the logged in user you can use $_SESSION['UserID']:

//create dropdown box

$str = "";

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

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

//select values from database

global $conn;

$strSQL = "select Posprim from Evidencija where userID = '".$_SESSION['UserID']."' group by Posprim";

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

while ($data = db_fetch_array($rs))

$str.="<option value=\"Evidencija_list.php?ctlSearchFor=".$data["Posprim"].

"&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=".

"integrated&id=1&criteria=and&type1=&value11=".$data["Posprim"].

"&field1=Posprim&option1=Contains&not1=a=search&value=1\">".

$data["Posprim"]."</option>";

$str.="</select>";

echo $str;


or if it is an int value, in the "After successful login" event enter the following code:

$_SESSION['int_UserID'] = $data['userID'];


and in the snippet:

//create dropdown box

$str = "";

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

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

//select values from database

global $conn;

$strSQL = "select Posprim from Evidencija where userID = ".$_SESSION['int_UserID']." group by Posprim";

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

while ($data = db_fetch_array($rs))

$str.="<option value=\"Evidencija_list.php?ctlSearchFor=".$data["Posprim"].

"&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=".

"integrated&id=1&criteria=and&type1=&value11=".$data["Posprim"].

"&field1=Posprim&option1=Contains&not1=a=search&value=1\">".

$data["Posprim"]."</option>";

$str.="</select>";

echo $str;