× Form Help

DB Query Validation

  • techmgmt
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 66
  • Thank you received: 0

techmgmt created the topic: DB Query Validation

Hi,

I have a form called member_selection. The first page & field of this form asks the logged in user to enter the member's e-mail. The next page of that same form should be the results of the query. So, it looks like this:

Page 1
- Element: Enter Member E-Mail
----> Click Next
Page 2
- Element: Member Name
- Element: Member E-Mail
- Element: Is this the correct member
----> Click Proceed to Checkout

When the user enter's the e-mail in page 1 and presses next, a query should run against the DB that pulls the member name and e-mail from the Joomla User DB. Then, if they say yes, I want those two fields to carry to another form called aircraft_checkout.

Is this even possible?

Cheers,
Shane
#233230
  • Posts: 5789
  • Karma: 118
  • Thank you received: 534

MarioPuco replied the topic: DB Query Validation

Hi,

This is possible yes :)
This is how you would get logged in user info : crosstec.org/en/support/online-documenta...and-classicmode.html

Furthermore if you want to transfer values from one form to another this is how you would do it : crosstec.org/en/forums/3-breezingforms-f...n-form-b.html#189108

Regards,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#233238
  • techmgmt
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 66
  • Thank you received: 0

techmgmt replied the topic: DB Query Validation

Thanks, the issue is not getting logged in user info, I have that. I am looking to query the DB for someone that is not the logged in user.
#233246
  • techmgmt
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 66
  • Thank you received: 0

techmgmt replied the topic: DB Query Validation

Would it be possible to use the initscript on page entry to query the Joomla DB against the e-mail listed on the first page? So, when moving from page 1 to page 2, a query would be run to populate 2 fields if the person is found in the Joomla DB (not the logged in user).
#233360
  • Posts: 5789
  • Karma: 118
  • Thank you received: 534

MarioPuco replied the topic: DB Query Validation


Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#233384
Moderators: ForumSupporttomeperica
Time to create page: 0.052 seconds

New Icon Packs Category!

Crosstec is now offering icon packs.

If you are a paying subscriber, icon packs are automatically added to your account.

Check out our icon packs page!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Summer Sale!

50% discount on all of our extension subscription plans, templates and icon packs!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here