PHPJunkyard support forum

Code: Select all

  <td style="text-align:right">
		<?php
        
			?>
			User:
</td>
<td>

            <select name="user">
			<option value="" selected="selected"><?php echo $hesklang['select']; ?></option>
			<?php
            if ($ticket['owner'])
            {
            	echo '<option value="-1"> > '.$hesklang['unas'].' < </option>';
            }

			foreach ($admins as $k=>$v)
			{
				if ($k != $ticket['owner'])
				{
					echo '<option value="'.$k.'">'.$v.'</option>';
				}
			}
			?>
			</select>
    </td>
	</tr>
	<tr>
	<td style="text-align:right">Email:</td>
	<td width="80%"><input type="text" name="user_email" size="40" maxlength="50" value=""/></td>
	</tr>
	</table>

Code: Select all

<script type="text/javascript">
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getemail.php?q="+str,true);
xmlhttp.send();
}
</script>

Code: Select all

<?php 

DEFINE ('DB_USER', 'user');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'users');

$con = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if (!$con) {
	echo 'Could not connect to MySQL: ' . mysqli_connect_error();
}
$sql="SELECT name, id FROM users ORDER BY name";
$result=mysqli_query($con, $sql);
?>
<select name="users" onchange="showUser(this.value)">
<option>Select your name</option>
<?php
while($row_list=mysqli_fetch_assoc($result)){
?>
<option value="<?php echo $row_list['id']; ?>"><?php echo $row_list['name']; ?></option>
<?php
}
?>
</select>

Code: Select all

<?php
$a=$_GET["q"];
function email($a){$dbc = @mysqli_connect('localhost', 'user', 'password', 'database');
$sql2="SELECT email FROM users WHERE id=$a";
$list2=mysqli_query($dbc,$sql2);
$row_list2=mysqli_fetch_assoc($list2); 
$nume=$row_list2['nume_fil']; 
return $last;}
echo email($a);
?> 

Code: Select all

<div id="txtHint"></div>

Code: Select all

<?php
$a=$_GET["q"];
function email($a){$dbc = @mysqli_connect('localhost', 'user', 'password', 'database');
$sql2="SELECT email FROM users WHERE id=$a";
$list2=mysqli_query($dbc,$sql2);
$row_list2=mysqli_fetch_assoc($list2);
 

Code: Select all

$email=$row_list2['email'];
return $email;}
echo email($a);
?>