Support

Support Options

Report a problem

About you
This is a randomly generated image of letters and numbers. Letters not clear? Click to renew CAPTCHA.
About the problem

gyan guide45

Mastering Full Stack Web Development with AngularJS

Introduction: Full-stack web development involves creating both the front-end and back-end components of a web application. AngularJS, a JavaScript framework developed by Google, has become a popular choice for building dynamic and responsive web applications. In this article, we'll explore the fundamentals of full-stack web development using AngularJS, examining its key features, architecture, and how it fits into the overall development process. Understanding AngularJS: AngularJS is a front-end JavaScript framework that simplifies the process of building dynamic web applications. Developed and maintained by Google, it is open-source and has gained widespread adoption due to its flexibility, modularity, and the ability to create Single Page Applications (SPAs). SPAs provide a seamless user experience by loading only the necessary content, reducing page reloads and enhancing interactivity. Building Blocks of AngularJS Applications: 1. Controllers: Controllers in AngularJS handle the application logic. They are responsible for managing the data and behavior of a specific view. By separating concerns, AngularJS ensures a clean and organized codebase. 2. Views: Views represent the user interface and are responsible for displaying data to the user. They interact with controllers through data binding, updating dynamically as the underlying data changes. 3. Services: Services in AngularJS are singleton objects that carry out specific functions across the application. They encapsulate business logic, data manipulation, and communication with external APIs. 4. Filters: Filters allow developers to format and transform data in the views. They are particularly useful for enhancing the presentation of information to users. Key Features of AngularJS: 1. Two-way Data Binding: AngularJS employs a powerful two-way data binding system. This means that changes in the user interface (UI) are automatically reflected in the underlying data model and vice versa. This simplifies the development process and enhances the real-time responsiveness of applications. 2. Modularity with Dependency Injection: AngularJS promotes a modular approach to development by using dependency injection. Modules help organize and structure the application, while dependency injection facilitates the management of components and their dependencies. 3. Directives: Directives in AngularJS allow developers to create reusable components and extend HTML functionality. This promotes code reusability and maintainability, making it easier to build complex applications. 4. Routing: AngularJS provides a robust routing mechanism that enables developers to create single-page applications with multiple views. This enhances the user experience by allowing seamless navigation without page reloads. Building the Front-End: 1. Setting Up the AngularJS Environment: To start building with AngularJS, you need to include the AngularJS library in your project. You can either download it and host it locally or use a Content Delivery Network (CDN) for quick integration. 2. Creating Controllers and Views: Controllers in AngularJS handle the application's logic, while views define the presentation layer. By associating controllers with views, developers can create dynamic and interactive user interfaces. 3. Implementing Two-way Data Binding: Leverage AngularJS's two-way data binding to synchronize the user interface and application data. This eliminates the need for manual updates, enhancing the efficiency of your code. Building the Back-End: 1. Choosing a Server-Side Technology: AngularJS is a front-end framework, so you'll need a server-side technology to handle data storage, retrieval, and processing. Common choices include Node.js, Express.js, and Django. 2. Building RESTful APIs: RESTful APIs facilitate communication between the front-end and back-end. Design and implement APIs to enable data exchange between the AngularJS application and the server. 3. Integrating with a Database: Depending on your server-side technology, integrate a suitable database to store and manage your application's data. Popular choices include MongoDB, MySQL, and PostgreSQL. Bringing It All Together: 1. Connecting Front-End and Back-End: Use HTTP requests to connect the AngularJS front-end with the server-side logic. This involves sending requests to the server, processing the data, and updating the UI accordingly. 2. Handling Authentication and Authorization: Implement secure authentication and authorization mechanisms to protect your application and its data. This may involve using tokens, sessions, or other authentication protocols. 3. Deploying the Application: Once your application is ready, deploy it to a hosting service. Popular choices include AWS, Heroku, and Netlify. Ensure that both the front-end and back-end are configured correctly for a smooth deployment. Conclusion: Mastering full-stack web development with AngularJS requires a comprehensive understanding of both front-end and back-end technologies. By leveraging AngularJS's powerful features for front-end development and integrating it seamlessly with a robust back-end, developers can create dynamic and responsive web applications that deliver a superior user experience. As the web development landscape evolves, staying updated on the latest trends and best practices will further enhance your skills in building scalable and efficient full-stack applications. Looking for the best Angular JS training in Bangalore? Look no further than Infocampus! Our comprehensive courses will equip you with the skills and knowledge needed to become an expert in Angular JS development. Join us today and kickstart your career in web development! Limited seats available, so don't miss out! For more details Call: 8884166608 or 9740557058 Visit: https://infocampus.co.in/angularjs-training-in-bangalore.html
  1. Angular JS
  2. React Js
  3. Web Design
  4. Web Development

Comments on this entry

There are no comments at this time.

Add a comment

Please keep comments relevant to this entry.

Line breaks and paragraphs are automatically converted. URLs (starting with http://) or email addresses will automatically be linked.

Debug Console

Close15 MBRequestSessionTimelineDatabase93Events68
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/8396/blog/2023/12/mastering-full-stack-web-development-w... Array(
REDIRECT_SCRIPT_URL => /members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
HTTPS => on,
SSL_TLS_SNI => itmig.curie.fr,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => itmig.curie.fr,
HTTP_CONNECTION => Keep-Alive,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => itmig.curie.fr,
SERVER_ADDR => 192.168.25.26,
SERVER_PORT => 443,
REMOTE_ADDR => 44.200.27.215,
DOCUMENT_ROOT => /var/www/itmig,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/itmig,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/itmig/index.php,
REMOTE_PORT => 34344,
REDIRECT_URL => /members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/8396/blog/2023/12/mastering-full-stack-web-development-with-angularjs,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1714045352.779,
REQUEST_TIME => 1714045352
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 5c157cea2ea4edc2096c4143b6287e52
tracker.ssid 5c157cea2ea4edc2096c4143b6287e52
tracker.rsid 5c157cea2ea4edc2096c4143b6287e52
session.token cdfeeda54847dcac25b18b2c6b74b0f1
  • site 0.013 seconds (+0.013); 3.75 MB (+3.750) - afterInitialise
  • site 0.021 seconds (+0.008); 4.25 MB (+0.500) - afterRoute
  • site 0.115 seconds (+0.095); 14.50 MB (+10.250) - afterDispatch
  • site 0.122 seconds (+0.007); 14.50 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.124 seconds (+0.002); 14.75 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.124 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.127 seconds (+0.004); 14.75 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.128 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.137 seconds (+0.009); 14.75 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.137 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.140 seconds (+0.002); 15.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.140 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.147 seconds (+0.007); 15.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.152 seconds (+0.005); 15.00 MB (0.000) - onAfterRender
  • site 0.155 seconds (+0.003); 15.00 MB (0.000) - sessionStore
15 MB

93 Queries Logged: 0.019946813583374 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '9a93b92e7e1d62ec07b8229437b61d0a'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '9a93b92e7e1d62ec07b8229437b61d0a'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '5c157cea2ea4edc2096c4143b6287e52'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '5c157cea2ea4edc2096c4143b6287e52'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('5c157cea2ea4edc2096c4143b6287e52','0','1714045352','44.200.27.215')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8396'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  20. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  21. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  22. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  23. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  24. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  25. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-04-25 11:42:32'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  27. SELECT *
      FROM `jos_plugin_params`
      WHERE `jos_plugin_params`.`object_id` = '8396'
      AND `jos_plugin_params`.`folder` = '0'
      AND `jos_plugin_params`.`element` = '0'
  28. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`alias` = 'mastering-full-stack-web-development-with-angularjs'
      AND `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '8396'
      AND `jos_blog_entries`.`state` IN ('0','1')
      ORDER BY `state` DESC
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8396'
  30. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '7811'
      AND `jos_blog_comments`.`state` IN ('1','3')
  31. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'blog'
      AND `jos_tags_object`.`objectid` = '7811'
      AND `jos_tags`.`admin` = '0'
      GROUP BY jos_tags_object.label,jos_tags.id
  32. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '8396'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2024-04-25 11:42:32' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-04-25 11:42:32' )
      ORDER BY `hits` DESC
      LIMIT 5
  33. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('8396')
  34. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('7665','7668','7676','7683','7687')
  35. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8396'
  36. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '7811'
      AND `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`parent` = '0'
      ORDER BY `created` ASC
  37. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '0'
  38. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  39. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '7811'
      AND `jos_blog_comments`.`id` = '0'
      AND `jos_blog_comments`.`state` IN ('1','3')
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  41. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '8396'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2024-04-25 11:42:32' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-04-25 11:42:32' )
  42. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('7665','7668','7676','7683','7687','7711','7728','7737','7744','7753','7754','7755','7757','7761','7765','7768','7771','7773','7774','7775','7778','7781','7785','7787','7788','7790','7791','7793','7795','7799','7800','7804','7805','7807','7808','7809','7810','7811','7812','7813','7814','7815','7816','7818','7819','7820','7821','7822','7823','7824','7825','7826','7827')
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  44. SHOW FULL COLUMNS
      FROM `jos_collections`
  45. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='8396'
      AND b.object_type='member'
  46. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='8396'
      AND b.object_type='member'
  47. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  48. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` IN ('1')
      AND `jos_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '8396'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  50. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '8396'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  51. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`scope` = 'site'
      AND `jos_wiki_pages`.`id` IN ('')
  52. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  53. SHOW FULL COLUMNS
      FROM `jos_courses`
  54. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE m.user_id=8396
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  55. SHOW FULL COLUMNS
      FROM `jos_publications`
  56. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  57. SELECT COUNT(jos_publication_versions.id) AS count
      FROM `jos_publication_versions`
      INNER JOIN jos_publications
      ON jos_publications.id = jos_publication_versions.publication_id
      LEFT JOIN jos_publication_authors
      ON jos_publication_authors.publication_version_id = jos_publication_versions.id
      WHERE `jos_publication_versions`.`state` IN ('1')
      AND `jos_publication_authors`.`user_id` = '8396'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  58. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  59. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  60. SELECT r.*, (SELECT COUNT(m.user_id)
      FROM jos_courses_members AS m
      WHERE m.role_id=r.id
      AND m.`offering_id` IN (0,0)) AS total
      FROM jos_courses_roles AS r
      WHERE r.`offering_id` IN (0,0)
  61. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=8396
      AND m.student=0
      AND r.alias='instructor'
  62. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=8396
      AND m.student=0
      AND r.alias='manager'
  63. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state=1
      AND m.user_id=8396
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2024-04-25 11:42:32')
      AND s.state=1
      AND o.state=1
  64. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'gyanguide45@gmail.com'
  65. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 )
  66. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=8396
      WHERE `jos_xmessage_recipient`.`uid` = '8396'
      AND `jos_xmessage_recipient`.`state` = '0'
  67. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '8396'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=8396)
  68. SHOW TABLES
  69. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '8396'
  70. SHOW FULL COLUMNS
      FROM `jos_projects`
  71. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='8396'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='8396'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='8396')))
      AND p.provisioned = 0
  72. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  73. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='gyanguide45@gmail.com'
  74. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-04-25 11:42:32'
  75. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-04-25 11:42:32'
  76. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-04-25 11:42:32'
  77. SHOW TABLES
  78. SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
      FROM `jos_citations`
      LEFT JOIN jos_users AS u
      ON jos_citations.uid = u.id
      LEFT JOIN jos_citations_secondary AS CS
      ON jos_citations.id = CS.cid
      LEFT JOIN jos_citations_format AS F
      ON jos_citations.format = F.style
      WHERE `jos_citations`.`scope` = 'member'
      AND `jos_citations`.`scope_id` = '8396'
      AND `jos_citations`.`published` IN ('1')
  79. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '8396'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  80. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  81. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8396 )
  82. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '8396';
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  84. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2024-04-25 11:42:32' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-04-25 11:42:32' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  88. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  89. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  90. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  91. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  92. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  93. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714045352;s:18:\"session.timer.last\";i:1714045352;s:17:\"session.timer.now\";i:1714045352;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"5c157cea2ea4edc2096c4143b6287e52\";s:12:\"tracker.ssid\";s:32:\"5c157cea2ea4edc2096c4143b6287e52\";s:12:\"tracker.rsid\";s:32:\"5c157cea2ea4edc2096c4143b6287e52\";s:13:\"session.token\";s:32:\"cdfeeda54847dcac25b18b2c6b74b0f1\";}',`time` = '1714045352',`ip` = '44.200.27.215'
      WHERE `session_id` = '5c157cea2ea4edc2096c4143b6287e52'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:87
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:55
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:59
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:55
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:55
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:55
  • onMembersAreas Method plgMembersCourses::onMembersAreas /core/plugins/members/courses/courses.php:55
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:55
  • onMembersAreas Method plgMembersImpact::onMembersAreas /core/plugins/members/impact/impact.php:105
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:55
  • onMembersAreas Method plgMembersPoints::onMembersAreas /core/plugins/members/points/points.php:55
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:71
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:85
  • onMembersAreas Method plgMembersUsage::onMembersAreas /core/plugins/members/usage/usage.php:55
  • onMembersAreas Method plgMembersCitations::onMembersAreas /core/plugins/members/citations/citations.php:72
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:54
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:60
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:49
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:59
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:50
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:88
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:130
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:65
  • onBlogView Method plgBlogOpengraph::onBlogView /core/plugins/blog/opengraph/opengraph.php:44
  • onBlogView Method plgBlogTwitter::onBlogView /core/plugins/blog/twitter/twitter.php:44
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:88
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:53
  • onMembersContributionsAreas Method plgMembersCourses::onMembersContributionsAreas /core/plugins/members/courses/courses.php:379
  • onMembersContributionsAreas Method plgMembersImpact::onMembersContributionsAreas /core/plugins/members/impact/impact.php:221
  • onMembersContributionsAreas Method plgMembersPublications::onMembersContributionsAreas /core/plugins/members/publications/publications.php:90
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:142
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:90
  • onMembersContributions Method plgMembersCourses::onMembersContributions /core/plugins/members/courses/courses.php:417
  • onMembersContributions Method plgMembersImpact::onMembersContributions /core/plugins/members/impact/impact.php:266
  • onMembersContributions Method plgMembersPublications::onMembersContributions /core/plugins/members/publications/publications.php:127
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:113
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:75
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:85
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:75
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:75
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:75
  • onMembers Method plgMembersCourses::onMembers /core/plugins/members/courses/courses.php:78
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:81
  • onMembers Method plgMembersImpact::onMembers /core/plugins/members/impact/impact.php:138
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:81
  • onMembers Method plgMembersPoints::onMembers /core/plugins/members/points/points.php:81
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:96
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:185
  • onMembers Method plgMembersUsage::onMembers /core/plugins/members/usage/usage.php:75
  • onMembers Method plgMembersCitations::onMembers /core/plugins/members/citations/citations.php:92
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:78
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:85
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onDisplay Method plgCaptchaImage::onDisplay /core/plugins/captcha/image/image.php:80
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45