× Form Help

DB Query Validation

  • techmgmt
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 63
  • 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: 5209
  • Karma: 111
  • Thank you received: 483

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: 63
  • 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: 63
  • 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: 5209
  • Karma: 111
  • Thank you received: 483

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.047 seconds

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

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€

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!

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