Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getProfileData($username){
- $data = TBWebcam::MySQLQurey("SELECT * FROM `new_user` WHERE `user_name` = "AndrewAubury";");
- if($data =! null){
- $userimage = $data["user_image"];
- if($userimage =! ""){
- $userimage = str_replace("%s","",$userimage);
- $userimage = "https://A LINK YOU DONT NEED TO KNOW.net/PF.Base/file/pic/user/".$userimage;
- }else{
- $userimage = null;
- }
- $usergender = $data["gender"];
- if($usergender == "1"){
- $usergender = "Male";
- }else{
- $usergender = "Female";
- }
- //echo($data["user_id"]."<br><br><br><br>");
- $userData = array(
- "id" => $data["user_id"],
- "name" => $data["full_name"],
- "username" => $data["user_name"],
- "image" => $userimage,
- "gender" => $usergender,
- );
- echo("Data: ".$data."<br><br><br>");
- return($userData);
- }else{
- return null;
- }
- }
- public function MySQLQurey($queryToDo){
- $servername = "my server";
- $username = "um my username :P";
- $password = "why do u need to know";
- $dbname = "the one i set it up on";
- $conn = new mysqli($servername, $username, $password, $dbname);
- if ($conn->connect_error) {return(null);}
- $sql = $queryToDo;
- $result = $conn->query($sql);
- $mehArray = array();
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- $mehArray[] = $row;
- }
- return($mehArray);
- } else {
- return(null);
- }
- $conn->close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement