Hello i want to get the first value (uid) from the object that i fetch.
Here is the syntax
$sql2 = "SELECT **uid,**notification_created,username,name,profile_pic,tour,email, api_signature,first_name,last_name, artisticBehaviour,location,bio,last_login,first_login,updates_count,friend_count,profile_views,group_count,password FROM users WHERE username=:username "; $stmt2 = $db->prepare($sql2); $stmt2->bindParam("username", $username, PDO::PARAM_STR); $stmt2->execute(); $userData = $stmt2->fetch(PDO::FETCH_OBJ); $uid = ????????
I want to retrieve the first value (uid) so i may use it as a variable
Advertisement
Answer
First bind the result and then fetch them
you should test if the username is empty before using it
$sql2 = "SELECT uid,notification_created,username,name,profile_pic,tour,email, api_signature,first_name,last_name, artisticBehaviour,location,bio,last_login,first_login,updates_count,friend_count,profile_views,group_count,password FROM users WHERE username=:username "; $stmt2 = $db->prepare($sql2); $stmt2->bindParam("username", $username, PDO::PARAM_STR); $stmt2->execute(); $result = $stmt2->get_result(); if ($result->num_rows>0) { while ($row = $result->fetch_assoc()) { echo $row['uid']; } }