stonefunk
Forum Replies Created
-
Forum: Plugins
In reply to: [Shortcoder β Create Shortcodes for Anything] mysql value in shortcode?Great, thank you @vaakash.
Forum: Plugins
In reply to: [Shortcoder β Create Shortcodes for Anything] mysql value in shortcode?Thank for your reply @vaakash.
Is it maybe possible to use MySql stored procedures instead then in shortcoder.
I belive there is a market for non coding database handling. πMost people use a formbuilder lika Caldera Forms and maybe a database tool like WP data Access. The one missing piece is to easy put a database value in a form textbox or dropdown.
Maybe it is really easy in PHP and that is why such plugin dont exist but i really dont want to edit my complex theme directly in the PHP-code so it chrashes. Therefore i got exited about Shortcoder that my Colibri Theme recommended. It would be fantastic to make “magic tags” in a plugin like Shortcoder.
/Svante
ok.
Thank you for your fast replies. π
Regards
/SvanteGreat i try that.
Thank you
Regards
/SvanteFound https://jqueryui.com/ π
i sort this out.Probably upgrade later on next week.
Best regards
/SvanteI just installed the trail version of your plugin and tested this morning and now it works. π
Is there a guide on css for the pro version? The looks dont blend in with our theme.
Best regards
/SvanteSorry Peter.
A very promesing plugin that i cant possibly get to work.
New clean wordpress site, bootstrap theme, no other plugin activated.Page or post – after the submit it redirect to wrong page and nothing is added or altered inte the table.
[wpdadiehard project_id=”1″ page_id=”1″] – bugged
[wpdadataaccess pub_id=”1″] – only shortcode show upp and no tablei give up…
Best regards
/SvanteHello again.
Now it is completly clear that the theme doesent like WP Data Access at all. It work just fine untill i put a form on the front end. After that its only to uninstall with complete removal and then install it again.
Back to the drawingboard for my booking project or is there a trail of the pro version? Or what is the minimum time for paying montly. In case it wont work as i need it to do.
Best regards
/SvanteThank you, i would try that.
I used WP-Optimize to remove all stuff related to it but it didnt help. I install the plugin once more and uninstall it like you suggested.
I started to belive it was incompatible with my theme Colibri.
hss1910.seBest regards
/SvanteThank’s Peter,
Yes there is. This is a project on my spare time but i work like a IT-Servicedesk and can ask the SQL-people.
Now i know itΒ΄s possible and going to give WP data Access a bit more attention. I am a Graphic Designer with some skills in programming but not a specialist in any way. A so called Google-programmer π
Regards
/SvanteHej Peter.
The plugin is a bit complex but i work my way thrue it. I managed to make some form on the front end. Made 2 lookup dropdowns in the booking form. The only thing left is to have a functioning booking form for the boat club is the WHERE Clause with a special action.
What is best practice for making the second dropdown only show the next avalable post in order. The table sublift_date contains the 12 dates the harbour service is available and next collumn the number of timeslots that day. The table sublift_time contains only 8 timeslots like 08:00-08-45, 08:45-09:30,,, and so on. The plan is when a customer choose a date only the first available timeslot vill show in sublift_time dropdown.
Is Subquery the way to go or how do you think works out the best in your plugin?
There is 3 tables.
sublift_bookings: all booking data like id, name, boatname, date, time,,,, and more
sublift_date: 3 columns – id, date, number of timeslots per/day
sublift_time: 2 columns – id, timeslotssublift_date and _time is for self service by the personal. They should fix the dates themself in the front end form (already done an functioning)
sublift-booking is for booking the service for customers. (already done with exeption of the action descriped above).
The last thing is css. I deal with that later on…
Best Ragards
/SvanteSorry for my poor english spelling…
Its a fantastic plugin, no doupt about that. π
This is however not what i ment by “form” in my comment. To fill the gap from customer –> database –> customer i need a nice looking form like Caldera Forms or simular. A Form to collect data from customer, process the data and then again present the data on the front end. Caldera Forms does just that but there is no easy way to manipulate the data in a nice SQL-matter. MySql sample “SELECT * FROM
moviesWHEREcategory_id= 2 ANDyear_released= 2008;”Your plugin does just that manupulation of the data but on the other hand missing out of the data front end collect part. I am probably wrong and if so correct me please.
Sorry to show this on your supportpage but its the easies way to explane. I remove it if you want directly offcource. Caldera Forms
The abolute perfect world i could grab a value from the database and put it into the front end formfield with a “magic tag” or whatever method you prefer. If so i belive your plugin would become a smash hit. π IΒ΄ve looked a long time on the internet to find a booking plugin that i can use with no luck. Your plugin is the closest yet to my goal.
The submitted data could then affect the choices when the next customer fills in the same form. With some sql arguments the values in the form becomes dynamic.
Best Regards
/Svante- This reply was modified 5 years, 6 months ago by stonefunk.
That sounds fine.
Looking forward to it πBest Regards
/Svante (stonefunk)