- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
 | I am trying to get user's information and show them in user's profile. And i found this query but it is in PDO and my work is in sqli here the query : if(isset($_SESSION['user'])){ $getuser=$con->prepare("SELECT * From users where username=?"); $getuser->execute(array($sessionuser)); Sinfo=$getuser->fetch(); And here the whole code <?php session_start(); $sessionuser=''; … |
| | Hi all, I have assigned a column called "friendshipstatus" as a default value =0 in addfriends table that user can add other users to it to be friends as the code bellow which will give any users added as friend in addfriendss table the "friendshipstatus" value of 1 <?php include …  |
| | How can i check if email exists i have this code but it is not working <?php include "Config.php"; function mksafe($data){ $data=trim($data); $data=strip_tags($data); $data=htmlspecialchars($data); $data=addslashes( $data); return $data; } $fname = mksafe($_POST["fname"]); $lname = mksafe($_POST["lname"]); $email = mksafe($_POST["email"]); $sql = "SELECT * FROM `users` WHERE `email`=$email"; $result = $conn->query($sql); if($result->num_rows … |