Im making search button and i want when user is searched to give all tickets received by that user i have this code but its just showing the last record of that db table and if i try to search other users gives me No ticket received from that user. but this is false, i have tickets from that user.
functions.php
function show_tickets($sender_tickets="") {
global $conn;
$user = getUserData('users', 'UserUsername');
$sql = "SELECT senderName, receiverName, `Date`, ticketID, match1, match2, match3, match4, match5, match6, match7, match8, match9, match10, match11, match12, match13, match14, match15, match16, tip1, tip2, tip3, tip4, tip5, tip6, tip7, tip8, tip9, tip10, tip11, tip12, tip13, tip14, tip15, tip16, Bet, Gain, Odd, seen FROM ticket WHERE receiverName='".$user."'";
$result = $conn->query($sql);
if(!$result) {
trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
} else {
if($result->num_rows == 0) {
echo "You have not received any ticket";
} else if($result->num_rows >= 1) {
while($row = $result->fetch_assoc()) {
$ticket_id = $row['ticketID'];
$sender_tickets = array($ticket_id);
}
foreach($sender_tickets as $key => $value) {
echo " " . $value . " ";
return $sender_tickets;
}
}
}
}
messages.php Search Button
if(isset($_POST['searchBtn'])){
$search_btn = $_POST['searchBtn'];
$user = getUserData('users', 'UserUsername');
$sql = "SELECT senderName FROM ticket WHERE receiverName='{$user}'";
$result = $conn->query($sql);
if(!$result) {
trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
} else {
if($result->num_rows == 0) {
echo "You have not received any ticket";
} else if($result->num_rows >= 1) {
while($row = $result->fetch_assoc()) {
$senderName = $row['senderName'];
}
if(strtolower($search_btn) == strtolower($senderName)) {
echo "Sender found, " . $senderName;
show_tickets($senderName);
} else {
?>
<p>No ticket received from that user.</p>
<?php
}
}
}
}
