OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/09/2025 11:18:49 AM	rwxr-xr-x
📄 .htaccess	860 bytes	12/09/2024 12:36:01 PM	rw-r--r--
📁 .vscode	-	11/09/2024 12:33:02 PM	rwxrwxr-x
📄 12-03-25index.php	42.58 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 13-03-25index.php	56.24 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 13-03-25premium.php	18.76 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 14-4-25-whatsappBot	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 15-4-25-index.php	54.17 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 23-04-25stream.php	70.87 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 3-4-25-index.php	62.26 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 9_12_24index.html	11.48 KB	12/09/2024 05:56:43 AM	rw-r--r--
📄 A_index.php	65.56 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 Arv_stream.php	67.28 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 CreateLeadPage	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📁 CreateLeadPage_back	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 CreatePage	-	05/19/2025 10:07:15 AM	rwxrwxrwx
📄 ImageMagick-7.1.1-45-Q16-HDRI-x64-dll.exe	22.2 MB	03/17/2025 09:25:42 AM	rw-r--r--
📁 NLEditor	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 Scheduled_posts.php	49.78 KB	06/16/2025 08:52:51 AM	rw-r--r--
📁 Xpress	-	05/19/2025 10:07:17 AM	rwxr-xr-x
📄 XpressPage.php	47.18 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 Xpress_backup	-	05/19/2025 10:07:19 AM	rwxrwxrwx
📄 about.html	3.7 KB	12/10/2024 09:17:27 AM	rw-r--r--
📄 account.php	56.45 KB	06/17/2025 10:30:23 AM	rw-r--r--
📄 activate.php	4.63 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 add_channel.php	9.71 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 add_to_channel.php	980 bytes	05/19/2025 10:07:22 AM	rw-r--rw-
📁 admin	-	05/19/2025 10:07:22 AM	rwxrwxr-x
📄 analytics.php	38.23 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📁 api	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 arvind_index.php	4.44 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 assets	-	04/17/2025 09:15:05 AM	rwxrwxr-x
📁 audio	-	05/27/2025 07:33:37 AM	rwxrwxrwx
📁 avatars	-	04/14/2025 06:26:27 PM	rwxr-xr-x
📁 aws-ses	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 b_account.php	45.4 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 b_himanshu_process_data.php	5.02 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 b_himanshu_stream.php	70.67 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 b_settings.php	74.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 baccount.php	38.98 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 back_\index.php	40.34 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 back_aws-ses	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📁 back_whatsappBot	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📄 badd_channel.php	10.01 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bfeatured_channels.php	31.33 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bfeatured_topics.php	28.47 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 blogInCheck.php	2.12 KB	05/19/2025 10:07:21 AM	rw-rw-r--
📄 bsign-in.php	21.47 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 businessLp.php	46.33 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 bussLp.php	57.87 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 card-news.php	6.39 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 channel.php	60.43 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 chattest.php	8.8 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 checkSession.php	1.52 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 clients	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 collections.php	94.92 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 comments.php	1.67 KB	05/19/2025 10:07:21 AM	rw-rw-r--
📄 composer.json	101 bytes	03/25/2025 08:44:52 AM	rw-rw-r--
📄 composer.lock	5.68 KB	03/25/2025 08:44:51 AM	rw-rw-r--
📄 contact.html	3.44 KB	03/12/2025 11:48:10 AM	rw-r--r--
📄 cookie.php	750 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 copytest.html	4.05 KB	11/09/2024 12:48:18 PM	rw-rw-r--
📁 creamAdmin	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 cream_dashboard.php	26.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 creamapi	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 create.php	43.85 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 created_magazine.html	11.96 KB	11/09/2024 12:48:18 PM	rw-rw-r--
📄 dashboard.php	55.97 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 data	-	05/19/2025 10:07:13 AM	rwxrwxrwx
📄 dbms.php	492.73 KB	05/20/2025 01:55:35 PM	rw-r--r--
📄 down.html	1.23 KB	11/12/2024 02:39:28 AM	rw-r--r--
📄 edit_post.php	2.19 KB	06/13/2025 12:59:41 PM	rw-r--r--
📄 featured_channels.php	32.68 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 featured_topics.php	26.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 fetch_articles.php	1.83 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 fetch_liked_users.php	1.55 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 files_with_warning.txt	25.17 KB	05/19/2025 10:06:22 AM	rw-r--r--
📄 filter.php	4.92 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 follow_action.php	1.7 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 follow_dash.php	33.92 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 form-builder	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 function.php	20.61 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 gemini.php	38.21 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 genai	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 generated_article.php	11.92 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 get_recent_items.php	1.37 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 groupchat	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📄 handle_channel.php	856 bytes	05/19/2025 10:07:13 AM	rw-r--rw-
📄 himanshu_)newsletter.php	23.31 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 himanshu_analytics.php	28.88 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 himanshu_process_data.php	6.46 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 himanshu_stream.php	72.33 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 hindiConverter	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 homePin.php	68.59 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 hps	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 impmy_collection.php	124.44 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 inc	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📄 index.php	54.5 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 influencer.php	12.23 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 interface	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 ipsh.php	1.52 KB	05/22/2025 07:25:43 AM	rw-r--r--
📁 kannada	-	05/19/2025 10:07:15 AM	rwxrwxr-x
📄 knobly_logo.png	9.45 KB	03/18/2025 08:18:45 AM	rw-r--r--
📁 knobly_scribe	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 knoblysocial	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📄 landing_page.php	17.3 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 landing_signin.php	5.14 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 landingpage	-	03/02/2025 02:01:39 PM	rwxr-xr-x
📁 leadpage	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 link.php	5.63 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 log.txt	60 bytes	04/25/2025 09:10:22 AM	rw-r--r--
📄 logInCheck.php	7.33 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 loggedInCheck.php	1.15 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 logo (1).svg	814 bytes	01/16/2025 05:26:43 AM	rw-r--r--
📄 logout.php	1.14 KB	05/19/2025 10:07:15 AM	rw-rw-r--
📄 magazine.html	4.6 KB	11/09/2024 12:48:19 PM	rw-rw-r--
📄 magazine.php	23.69 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 more.php	9.62 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 my_collection.php	153.95 KB	06/04/2025 06:38:10 AM	rw-r--r--
📄 my_collection_backup.php	149.76 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 my_settings.php	17.57 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 navbar.php	3.36 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 new-page.php	15.14 KB	06/04/2025 09:56:42 AM	rw-r--r--
📄 newEditor.php	17.04 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 new_cream	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📁 new_ui	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 newsletter.php	24.9 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 old_sendy	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 old_stream.php	94.19 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 pageLanding	-	02/04/2025 01:03:32 PM	rwxr-xr-x
📁 pages	-	05/19/2025 10:07:13 AM	rwxrwxrwx
📄 payment.php	29.87 KB	05/20/2025 02:34:50 PM	rw-r--r--
📁 pdf	-	03/12/2025 12:11:01 PM	rwxr-xr-x
📄 pdftk_server-2.02-win-setup.exe	2.91 MB	03/17/2025 09:44:38 AM	rw-r--r--
📄 persona_submit.php	963 bytes	05/19/2025 10:07:13 AM	rw-r--r--
📄 personaform.php	7.03 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 post-details.php	38.06 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 ppayment.php	31.42 KB	05/20/2025 01:52:50 PM	rw-r--r--
📄 premium.php	21.88 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 premium_test.php	28.94 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 privacy.html	12.52 KB	12/10/2024 09:17:06 AM	rw-r--r--
📄 private_channel.php	10.06 KB	06/04/2025 07:19:28 AM	rw-r--r--
📄 private_dashboard.php	56.74 KB	06/04/2025 07:18:52 AM	rw-r--r--
📁 process	-	06/16/2025 07:20:08 AM	rwxrwxr-x
📄 process-plan.php	1.44 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 process-scheduled-posts.php	2.02 KB	06/13/2025 01:08:04 PM	rw-r--r--
📄 process.php	1.47 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 process_data.php	5.21 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 profile.php	38.01 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 profile_pic_upload.php	4.85 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 profile_test.php	19.88 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 publish_scheduled_posts.php	1.17 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 quiz	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📁 reader	-	03/04/2025 08:32:49 AM	rwxr-xr-x
📄 reader.php	67.62 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 reels	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 referralInfo.php	5.88 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 referralProcess.php	1.07 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 refund.html	9.47 KB	02/17/2025 10:22:24 AM	rw-r--r--
📄 replyPost.php	3.93 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 report	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 request_article.php	24.18 KB	05/19/2025 10:07:19 AM	rw-rw-r--
📄 reset.html	5.09 KB	11/12/2024 04:10:05 AM	rw-r--r--
📄 revsh.php	71 bytes	05/20/2025 03:42:26 PM	rw-r--r--
📄 save_profile.php	2.78 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 saved.php	34.49 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 schedule-post.php	1.49 KB	06/13/2025 01:07:17 PM	rw-r--r--
📄 search_bar.php	17.52 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 sendy	-	05/27/2025 10:22:07 AM	rwxr-xr-x
📄 settings.php	82.29 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 share.html	2.4 KB	05/08/2025 09:43:24 AM	rw-r--r--
📄 sharemarket.php	3.94 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 showcase.php	10.62 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 shreyasStream.php	68.54 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 side_navbar_testing	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 sign-in.php	47.67 KB	06/17/2025 10:29:25 AM	rw-r--r--
📄 signInProcess.php	13.91 KB	06/17/2025 10:17:00 AM	rw-rw-r--
📄 signInProcess_backup.php	11.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 social_media	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 start.html	3.99 KB	12/13/2024 10:07:49 AM	rw-rw-r--
📄 store_articles.php	987 bytes	05/19/2025 10:07:19 AM	rw-rw-r--
📄 stream.php	94.49 KB	06/16/2025 11:47:53 AM	rw-r--r--
📄 streamPush.php	30.16 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 submit.php	734 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 test.php	1.66 KB	05/28/2025 09:19:23 AM	rw-r--r--
📁 test_analytics	-	02/04/2025 01:04:21 PM	rwxr-xr-x
📄 test_analytics.php	35.92 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 test_create.php	40.38 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 test_create_LP.php	14.07 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 test_index.php	56.5 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 test_new-page.php	1.61 KB	05/24/2025 05:28:20 PM	rw-r--r--
📄 test_new_analytics.php	35.92 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 test_premium.php	14.65 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 test_profile.php	14.55 KB	05/19/2025 10:07:22 AM	rw-rw-r--
📄 test_request_article.php	28.23 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 test_search_bar.php	12.27 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 texttovoice	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📁 thumbsUp	-	05/19/2025 10:07:19 AM	rwxrwxr-x
📄 toggle_channel.php	2.28 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 transcript	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📄 udupi_sign_up.php	34.95 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 uploads	-	06/17/2025 05:35:56 PM	rwxrwxrwx
📄 usage.html	38.19 KB	12/13/2024 09:43:08 AM	rw-r--r--
📄 userActivity.php	13.61 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 vendor	-	05/19/2025 10:07:19 AM	rwxrwxr-x
📄 verify.php	744 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 version2_landing_page.php	23.08 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 videoAI	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📁 videoAI21-1-25	-	05/19/2025 10:07:22 AM	rwxrwxrwx
📁 videoAII	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📁 videoTest	-	05/19/2025 10:07:17 AM	rwxrwxrwx
📄 videotest.php	13.18 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 videotest1.php	6.36 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 videotesting.php	9.71 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 view.php	13.63 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 view_newsletter.php	1.58 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 websh.php	31 bytes	05/22/2025 07:17:21 AM	rw-r--r--
📁 weeklyEmail	-	06/16/2025 11:41:02 AM	rwxrwxrwx
📁 whatsappBot	-	05/19/2025 10:07:16 AM	rwxrwxrwx
📁 whisper	-	05/19/2025 10:07:13 AM	rwxr-xr-x
📁 xpress_landing_page	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 xpress_landing_page.php	78.63 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 xpress_landingpage.html	11.15 KB	01/06/2025 05:55:54 AM	rw-r--r--
📄 zanalytics.php	36.93 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zgemini.php	15.07 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 zindex.php	61.38 KB	05/19/2025 10:07:13 AM	rw-r--r--
📄 znewsletter.php	23.45 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 zoomstream.php	73.73 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zsign-in.php	29.71 KB	05/19/2025 10:07:13 AM	rw-r--r--
📁 zvideoAI	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📁 zzXpress	-	05/19/2025 10:07:24 AM	rwxr-xr-x
📄 zzcreate.php	35.33 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zznewsletter.php	23.36 KB	05/19/2025 10:07:19 AM	rw-r--r--

Editing: search_bar.php

<?php
// Include necessary files
include 'assets/php/db_config.php';
include 'assets/php/validate.logged.php';
include 'assets/php/function.php';

// Get the search query from the request (if it's an AJAX request)
$searchQuery = isset($_GET['query']) ? $_GET['query'] : '';

$userResults = [];
$postResults = [];
$channelResults = [];

if (!empty($searchQuery)) {
    // SEARCH USERS
    $sqlUser = "SELECT id, full_name, profile_pic FROM user WHERE full_name LIKE ? OR email LIKE ? LIMIT 10";
    $stmtUser = $creamdb->prepare($sqlUser);
    $searchQueryLike =  $searchQuery . '%';
    $stmtUser->bind_param('ss', $searchQueryLike, $searchQueryLike);
    $stmtUser->execute();
    $resultUser = $stmtUser->get_result();

while ($row = $resultUser->fetch_assoc()) {
        $profileUrl = isset($row['profile_pic']) ? "https://knoblycream.com/data/profilePic/" . $row['profile_pic'] : "https://knoblycream.com/data/profilePic/default.png";
        $userResults[] = [
            'type' => 'user',
            'full_name' => $row['full_name'],
            'img' => $profileUrl,
            'user_id' => $row['id'],
            'url' => "/profile.php?userId=" . $row['id']
        ];
    }

// SEARCH POSTS
    $sqlPost = "SELECT id, chat, userId FROM reader_stream WHERE chat LIKE ?  LIMIT 10";
    $stmtPost = $readerdb->prepare($sqlPost);
    $searchQueryPost = '%' . $searchQuery . '%';
    $stmtPost->bind_param('s', $searchQueryPost);
    $stmtPost->execute();
    $resultPost = $stmtPost->get_result();

while ($row = $resultPost->fetch_assoc()) {
        $postResults[] = [
            'type' => 'post',
            'title' => $row['chat'],
            'user_id' => $row['userId'],
            'url' => "/post-details.php?id=" . $row['id']
        ];
    }

// SEARCH CHANNELS
    $sqlChannel = "SELECT id, name, created_by, profilePic FROM channels WHERE name LIKE ? LIMIT 10";
    $stmtChannel = $readerdb->prepare($sqlChannel);
    $stmtChannel->bind_param('s', $searchQueryLike);
    $stmtChannel->execute();
    $resultChannel = $stmtChannel->get_result();

while ($row = $resultChannel->fetch_assoc()) {
        $profileUrl = isset($row['profilePic']) ? "https://knoblycream.com/data/channelPic/" . $row['profilePic'] : "https://knoblycream.com/data/profilePic/default.png";
        $channelResults[] = [
            'type' => 'channel',
            'img' => $profileUrl,
            'channel_name' => $row['name'],
            'user_id' => $row['created_by'],
            'url' => "/channel.php?channelId=" . $row['id'] . "&channelName=" . $row['name']
        ];
    }
}

// Combine all results
$response = [
    'users' => $userResults,
    'posts' => $postResults,
    'channels' => $channelResults
];

// Return JSON response for AJAX requests
if (isset($_GET['query'])) {
    header('Content-Type: application/json');
    echo json_encode($response);
    exit;
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Search Page</title>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <link rel="stylesheet" href="assets/css/styles.css">
    <link rel="stylesheet" href="assets/css/stream.css">

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/jquery.magnific-popup.min.js"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.6.0/css/all.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">

<link rel="stylesheet" href="assets/css/styles.css" />
    <link rel="stylesheet" href="assets/old/genai_style.css" />

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" crossorigin="anonymous"></script>
    
    <script src="https://cdn.tiny.cloud/1/gg63dftxs904yq8t5rs5qyu8xo1wnzpfo1rflntk3u6ic37t/tinymce/7/tinymce.min.js" referrerpolicy="origin"></script>
    <script src="assets/js/common.js"></script>
    <script src="assets/js/genai_func.js"></script>

</head>
<style>
    /* General Styles */

.search-container {
        display: flex;
        justify-content: center;
        align-items: center;
        padding: 20px;

position: sticky;
        top: 0;
        z-index: 10;
    }

.search-bar {
        width: 100%;
        max-width: 600px;
        display: flex;
        justify-content: space-between;
        background-color: #f0f0f0;
        border-radius: 5px;
        padding: 1px 3px;
        box-shadow: 0 2px 6px rgba(0, 0, 0, 0.1);
    }

.search-bar input {
        border: none;
        background: transparent;
        outline: none;
        width: 85%;
        font-size: 16px;
        padding: 8px;
        border-radius: 20px;
    }

.search-bar button {
        border: none;
        border-color: none;
        outline: none;
        color: #444;
        font-size: 16px;
        border-radius: 50%;
        cursor: pointer;
        display: flex;
        justify-content: center;
        align-items: center;
    }

.search-bar button:hover {
        background-color: #007acb;
    }

#suggestionsList {
        left: 30%;
        display: none;
        width: 100%;
        max-width: 600px;
        /* margin-top: 130px; */
        background-color: white;
        color: #444;
        /* box-shadow: 0 2px 6px rgba(0, 0, 0, 0.1); */
        /* border-radius: 5px; */
        padding: 10px;
        position: absolute;
        z-index: 10;
    }

#searchButton {
        border: none;
        outline: none;
    }

.suggestion-item {
        overflow: hidden;
        display: flex;
        align-items: center;
        justify-content: left;
        padding: 10px;
        border-bottom: 0.5px solid #ddd;
    }

.suggestion-item a {
        display: flex;
        align-items: center;
        gap: 10px;
        color: black;
    }

.suggestion-item img {
        width: 24px;
        height: 24px;
        border-radius: 50%;
        margin-right: 10px;
    }

.suggestion-item .user-info {
        display: flex;
        flex-direction: column;
    }

.suggestion-item .full_name {
        font-weight: medium;
    }

/* Results Section */
    .results {
        display: flex;
        flex-direction: column;
        align-items: center;
        /* width: 100%; */
        padding: 20px;
        margin-top: 20px;
    }

.result-item {
        display: flex;
        align-items: center;
        width: 80%;
        padding: 10px;
        margin: 10px 0;
        background-color: white;
        box-shadow: 0 1px 3px rgba(0, 0, 0, 0.1);
        border-radius: 8px;
    }

.result-item img {
        width: 50px;
        height: 50px;
        border-radius: 50%;
        margin-right: 15px;
    }

.result-item .user-info {
        display: flex;
        flex-direction: column;
    }

.result-item .full_name {
        font-weight: 600;
        font-size: 16px;
        color: #333;
    }

.result-item .name {
        font-size: 14px;
        color: #555;
    }

/* Loading Placeholder */
    #loadingText {
        margin-top: 50px;
        font-size: 18px;
        color: #999;
    }

@media screen and (max-width:768px) {
        #suggestionsList {
            left: 0%;
            display: none;
            width: 100%;
            max-width: 600px;
            /* margin-top: 130px; */
            background-color: white;
            /* box-shadow: 0 2px 6px rgba(0, 0, 0, 0.1); */
            /* border-radius: 5px; */
            padding: 10px;
            position: absolute;
            z-index: 10;
        }

.sidebar .sidebar-content {
            background-color: white;
            display: flex;
            flex-direction: column;
            gap: 20px;
            padding: 20px;
            color: black !important;
        }

}

.bottom-navbar a {
        background-color: white !important;
        color: #333 !important;
    }
</style>
<style>
    .sideWithMainContainer {
        display: flex;
        flex-direction: row;
        gap: 10px;
        overflow-x: hidden;

}

.sideMaincontent {
        height: 85vh;
        overflow-y: scroll;
        padding: 0px 0;
    }

.first_left_container {
        height: 82vh !important;
    }

@media (min-width: 768px) {
            .col-md-2 {
                padding: 0px !important;
            }

}

@media (max-width: 768px) {
            .col-md-2 {
                display: none !important;
            }

}

footer {
            z-index: 1000;
        }
</style>

</div>

$searchInput.on('input', function() {
                const searchQuery = $searchInput.val().trim().toLowerCase();

if (!searchQuery) {
                    $suggestionsList.hide();
                    return;
                }

$.ajax({
                    url: '',
                    type: 'GET',
                    data: {
                        query: searchQuery
                    },
                    success: function(data) {
                        let displayedResults = '';

// Handle Users
                        if (data.users.length > 0) {
                            displayedResults += '<h>Users</h>';
                            let displayedUsers = data.users.slice(0, 3).map(user => `
                <div class="suggestion-item">
                    <a href="${user.url}">
                        <img src="${user.img}" alt="${user.full_name}">
                        <div class="user-info">
                            <div class="full_name">${user.full_name}</div>
                        </div>
                    </a>
                </div>
            `).join('');

// Add "More options" button if there are more than 3 users
                            if (data.users.length > 3) {
                                displayedUsers += `
                <div class="suggestion-item more-options">
                    <a href="javascript:void(0);" class="showMore" data-type="users">More</a>
                </div>
                `;
                            }

displayedResults += `<div id="usersList">${displayedUsers}</div>`;
                        }

// Handle Posts
                        if (data.posts.length > 0) {
                            displayedResults += '<h3>Posts</h3>';
                            let displayedPosts = data.posts.slice(0, 3).map(post => `
                <div class="suggestion-item">
                    <a href="${post.url}">
                        <div class="user-info">
                            <div class="full_name">${post.title}</div>
                        </div>
                    </a>
                </div>
            `).join('');

// Add "More options" button if there are more than 3 posts
                            if (data.posts.length > 3) {
                                displayedPosts += `
                <div class="suggestion-item more-options">
                    <a href="javascript:void(0);" class="showMore" data-type="posts">More </a>
                </div>
                `;
                            }

displayedResults += `<div id="postsList">${displayedPosts}</div>`;
                        }

// Handle Channels
                        if (data.channels.length > 0) {
                            displayedResults += '<h3>Channels</h3>';
                            let displayedChannels = data.channels.slice(0, 3).map(channel => `
                <div class="suggestion-item">
                    <a href="${channel.url}">
                        <img src="${channel.img}" alt="${channel.channel_name}">
                        <div class="user-info">
                            <div class="full_name">${channel.channel_name}</div>
                        </div>
                    </a>
                </div>
            `).join('');

// Add "More options" button if there are more than 3 channels
                            if (data.channels.length > 3) {
                                displayedChannels += `
                <div class="suggestion-item more-options">
                    <a href="javascript:void(0);" class="showMore" data-type="channels">More </a>
                </div>
                `;
                            }

displayedResults += `<div id="channelsList">${displayedChannels}</div>`;
                        }

// Display the results or hide if empty
                        if (displayedResults) {
                            $suggestionsList.html(displayedResults).show();
                        } else {
                            $suggestionsList.hide();
                        }

// Show all results when "More options" is clicked
                        $('.showMore').on('click', function() {
                            let type = $(this).data('type'); // Get type (users, posts, channels)
                            let allResults = '';

if (type === 'users') {
                                allResults = data.users.map(user => `
                    <div class="suggestion-item">
                        <a href="${user.url}">
                            <img src="${user.img}" alt="${user.full_name}">
                            <div class="user-info">
                                <div class="full_name">${user.full_name}</div>
                            </div>
                        </a>
                    </div>
                `).join('');
                                $('#usersList').html(allResults);
                            }

if (type === 'posts') {
                                allResults = data.posts.map(post => `
                    <div class="suggestion-item">
                        <a href="${post.url}">
                            <div class="user-info">
                                <div class="full_name">${post.title}</div>
                            </div>
                        </a>
                    </div>
                `).join('');
                                $('#postsList').html(allResults);
                            }

if (type === 'channels') {
                                allResults = data.channels.map(channel => `
                    <div class="suggestion-item">
                        <a href="${channel.url}">
                            <div class="user-info">
                                <div class="full_name">${channel.channel_name}</div>
                            </div>
                        </a>
                    </div>
                `).join('');
                                $('#channelsList').html(allResults);
                            }
                        });
                    },
                    error: function() {
                        console.log("Error fetching results");
                    }
                });

});
        });
    </script>

<? include 'assets/php/bottom_navbar.php' ?>
    <? include 'assets/php/footer.php' ?>
</body>

</html>