connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT uid FROM smz_messages_users WHERE username='$uname'"; $result = $conn->query($sql); $conn->close(); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { return $row["uid"]; } } else { return false; } } function uid($uid){ global $dbservername; global $dbusername; global $dbpassword; global $dbname; $conn = new mysqli($dbservername, $dbusername, $dbpassword, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT username FROM smz_messages_users WHERE uid='$uid'"; $result = $conn->query($sql); $conn->close(); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { return $row["username"]; } } else { return false; } }