Reply to thread

Message

<blockquote data-quote="Meap" data-source="post: 350672" data-attributes="member: 1553">yeah it works fine but im on about searching chatlogs on housekeeping, Ill post the code for the whole file I have for it for my housekeeping[PHP]&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $searchResults = null;if (isset($_GET['timeSearch'])){&nbsp; &nbsp; $_POST['searchQuery'] = $_GET['timeSearch'];&nbsp; &nbsp; $_POST['searchType'] = '4';}if (isset($_POST['searchQuery'])){&nbsp; &nbsp; $query = filter($_POST['searchQuery']);&nbsp; &nbsp; $type = $_POST['searchType'];&nbsp;&nbsp; &nbsp; &nbsp; $q = &quot;SELECT * FROM users_chatlogs WHERE &quot;;&nbsp;&nbsp; &nbsp; &nbsp; switch ($type)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; default:&nbsp; &nbsp; &nbsp; &nbsp; case '1':&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;user_id = '&quot; . $query . &quot;'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '2':&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;message LIKE '%&quot; . $query . &quot;%'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '3':&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;room_id = '&quot; . $query . &quot;'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '4':&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $cutMin = intval($query) - 300;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $cutMax = intval($query) + 300;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;timestamp &gt;= &quot; . $cutMin . &quot; AND timestamp &lt;= &quot; . $cutMax;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; $searchResults = mysql_query($q);}?&gt;&nbsp;&nbsp; &lt;?phpif (isset($searchResults)){&nbsp; &nbsp; echo '&lt;h2&gt;ShowResults: - You have Searched for &quot;&lt;span style=&quot;font-size: 125%;&quot;&gt;' . filter($_POST['searchQuery']) . '&lt;/span&gt;&quot;&lt;/h2&gt;';&nbsp; &nbsp; echo '&lt;br /&gt;&lt;p&gt;&lt;a href=&quot;chatlogs&quot; class=&quot;btn btn-small btn-primary&quot;&gt;Back to Search&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;table class=&quot;table table-striped&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;User&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Room&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Message&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Timestamp&lt;/th&gt;&nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; ';&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; while ($result = mysql_fetch_assoc($searchResults))&nbsp; &nbsp; {&nbsp;&nbsp; $grabRoom2 = mysql_query(&quot;SELECT * FROM rooms_data WHERE id = '&quot; . $result['room_id'] . &quot;'&quot;);&nbsp;&nbsp; while ($room2 = mysql_fetch_assoc($grabRoom2))&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp;&nbsp; $grabUser2 = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot; . $result['user_id'] . &quot;'&quot;);&nbsp;&nbsp; while ($user2 = mysql_fetch_assoc($grabUser2))&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; echo '&lt;tr&quot;&gt;';&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; // Username of sender&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . $user2['username'] . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; // Room ID&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . $room2['caption'] . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Message&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . htmlspecialchars($result['message']) . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Timestamp (UNIX Timestamp)&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . date('m.d.y, g:i a', $result['timestamp']) . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;/tr&gt;';&nbsp;&nbsp; &nbsp; &nbsp; echo '&lt;/tbody&gt;&nbsp; &nbsp; &lt;/thead&gt;&nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&lt;?php } else { ?&gt;&nbsp; &nbsp; &lt;?php&nbsp;&nbsp; &nbsp; &nbsp; echo '&lt;h2&gt;Search Chatlogs&lt;/h2&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;form method=&quot;post&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; Search Type:&amp;nbsp;&nbsp; &nbsp; &lt;select name=&quot;searchType&quot;&gt;&nbsp; &nbsp; &lt;option value=&quot;1&quot;&gt;By User&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;2&quot;&gt;By message content&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;3&quot;&gt;By Room (Single ID)&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;4&quot;&gt;By timestamp (600 seconds range)&lt;/option&gt;&nbsp; &nbsp; &lt;/select&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; Search:&amp;nbsp;&nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;searchQuery&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; class=&quot;btn btn-small btn-primary&quot; value=&quot;Search Records&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;h2&gt;Recent Activity&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;table class=&quot;table table-striped&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;User&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Room&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Message&lt;/th&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;th&gt;Timestamp&lt;/th&gt;&nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/thead&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; ';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; $getWhisper = mysql_query(&quot;SELECT * FROM users_chatlogs ORDER BY id DESC LIMIT 30&quot;);&nbsp; while ($whisper = mysql_fetch_assoc($getWhisper))&nbsp; {&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $getWhisper2 = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot; . $whisper['user_id'] . &quot;'&quot;);&nbsp; while ($whisper2 = mysql_fetch_assoc($getWhisper2))&nbsp; {&nbsp;&nbsp; $grabRoom = mysql_query(&quot;SELECT * FROM rooms_data WHERE id = '&quot; . $whisper['room_id'] . &quot;'&quot;);&nbsp;&nbsp; while ($room = mysql_fetch_assoc($grabRoom))&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; echo '&lt;tr&quot;&gt;';&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; // Username of sender&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . $whisper2['username'] . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; // Room ID&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . $room['caption'] . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Message&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . htmlspecialchars($whisper['message']) . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Timestamp (UNIX Timestamp)&nbsp; &nbsp;&nbsp; echo '&lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;' . date('m.d.y, g:i a', $whisper['timestamp']) . '&lt;/td&gt;';&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;/tr&gt;';&nbsp;&nbsp; &nbsp;&nbsp; }&nbsp; }&nbsp; }&nbsp; &nbsp; }?&gt;[/PHP]</blockquote>

[QUOTE="Meap, post: 350672, member: 1553"] yeah it works fine but im on about searching chatlogs on housekeeping, Ill post the code for the whole file I have for it for my housekeeping [PHP]<?php $searchResults = null; if (isset($_GET['timeSearch'])) { $_POST['searchQuery'] = $_GET['timeSearch']; $_POST['searchType'] = '4'; } if (isset($_POST['searchQuery'])) { $query = filter($_POST['searchQuery']); $type = $_POST['searchType']; $q = "SELECT * FROM users_chatlogs WHERE "; switch ($type) { default: case '1': $q .= "user_id = '" . $query . "'"; break; case '2': $q .= "message LIKE '%" . $query . "%'"; break; case '3': $q .= "room_id = '" . $query . "'"; break; case '4': $cutMin = intval($query) - 300; $cutMax = intval($query) + 300; $q .= "timestamp >= " . $cutMin . " AND timestamp <= " . $cutMax; } $searchResults = mysql_query($q); } ?> <?php if (isset($searchResults)) { echo '<h2>Show Results: - You have Searched for "' . filter($_POST['searchQuery']) . '"</h2>'; echo ' <a href="chatlogs" class="btn btn-small btn-primary">Back to Search</a> <table class="table table-striped"> <thead> <tr> <th>User</th> <th>Room</th> <th>Message</th> <th>Timestamp</th> </tr> </thead> <tbody> '; while ($result = mysql_fetch_assoc($searchResults)) { $grabRoom2 = mysql_query("SELECT * FROM rooms_data WHERE id = '" . $result['room_id'] . "'"); while ($room2 = mysql_fetch_assoc($grabRoom2)) { $grabUser2 = mysql_query("SELECT * FROM users WHERE id = '" . $result['user_id'] . "'"); while ($user2 = mysql_fetch_assoc($grabUser2)) { echo '<tr">'; // Username of sender echo '<td align="left" valign="top">' . $user2['username'] . '</td>'; // Room ID echo '<td align="left" valign="top">' . $room2['caption'] . '</td>'; // Message echo '<td align="left" valign="top">' . htmlspecialchars($result['message']) . '</td>'; // Timestamp (UNIX Timestamp) echo '<td align="left" valign="top">' . date('m.d.y, g:i a', $result['timestamp']) . '</td>'; echo '</tr>'; echo '</tbody> </thead> </table>'; } } } ?> <?php } else { ?> <?php echo '<h2>Search Chatlogs</h2> <form method="post"> Search Type:  <select name="searchType"> <option value="1">By User</option> <option value="2">By message content</option> <option value="3">By Room (Single ID)</option> <option value="4">By timestamp (600 seconds range)</option> </select> Search:  <input type="text" name="searchQuery"> <input type="submit" class="btn btn-small btn-primary" value="Search Records"> </form> <h2>Recent Activity</h2> <table class="table table-striped"> <thead> <tr> <th>User</th> <th>Room</th> <th>Message</th> <th>Timestamp</th> </tr> </thead> <tbody> '; $getWhisper = mysql_query("SELECT * FROM users_chatlogs ORDER BY id DESC LIMIT 30"); while ($whisper = mysql_fetch_assoc($getWhisper)) { $getWhisper2 = mysql_query("SELECT * FROM users WHERE id = '" . $whisper['user_id'] . "'"); while ($whisper2 = mysql_fetch_assoc($getWhisper2)) { $grabRoom = mysql_query("SELECT * FROM rooms_data WHERE id = '" . $whisper['room_id'] . "'"); while ($room = mysql_fetch_assoc($grabRoom)) { echo '<tr">'; // Username of sender echo '<td align="left" valign="top">' . $whisper2['username'] . '</td>'; // Room ID echo '<td align="left" valign="top">' . $room['caption'] . '</td>'; // Message echo '<td align="left" valign="top">' . htmlspecialchars($whisper['message']) . '</td>'; // Timestamp (UNIX Timestamp) echo '<td align="left" valign="top">' . date('m.d.y, g:i a', $whisper['timestamp']) . '</td>'; echo '</tr>'; } } } } ?>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members