AppGini Community Forums

you shouldn't be executing a query with this get request parameter without the makeSafe() function shielding from a mysql injection.

Hey Folks,

People that stare at appgini based apps throughout their days have reported that using a darker theme like the chrome extension below can significantly help reduce stress on your eyes:

https://chrome.google.com/webstore/deta ... hnkhdbieeh


Hope it helps!

...I don't think BigProf can afford to double development cost... $79 is just too cheap for what Appgini offers in my opinion, I would explore charging subscription options and raising the base price if that's what it takes to expand development, but yeah at the end of the day this is not my decisi...

I understand backwards compatibility is a major driver to sustain the business side of things, but that doesn't mean BigProf can't fork the project in light of the benefits and create a separate product even though I understand this would take tremendous effort and so far Appgini has been brilliant ...

...Next version of AppGini Helper Javascript Library... Very interesting, hopefully you can add a quick one-liner repositioning feature to this collapsable panels as well, I don't see Appgini heading towards the object oriented programming approach trend within the PHP world nowadays, I think it wi...

It's a bit off topic but I'm not particularly a fan of the bottom panel for children tables, in my workflow I usually hide the whole panel and insert each table block in the section that pertains that information, otherwise you have to keep scrolling up and down to access it. Usually I create a chec...

you can use the .click() js method on the element that closes the modal an run this on the parent js in case you wanna trigger any action after modal has been closed: $j(function() { $j(window).on('child-modal-closed', function(e, data) { // do something $j('form').submit(); // reload the current DV...

Hello,

There are modern more viable options nowadays, even though I don't use scanning in my workflow anymore, I would look at:

https://github.com/mubaidr/Javascript-Barcode-Reader

I guess Appgini's creator has said something about this before:

viewtopic.php?t=743

Here's some help: <div id="my_div"> A Text Value </div> <script type="text/javascript"> jQuery(function(){ var pass_val = 'passing_value'; var received_val = null; $j.ajax({ url: 'ajax-file.php', data: { ajax_pass: pass_val }, success: function(data){ if (data) { console.log(data); received_val = da...

you can filter the table, get the url param, after condition met add .css or javascript in hooks/footer-extras.php

I support Jan's idea running mac os xampp 8.1.6 PHP version: 8.1.6 Server version: 10.4.21-MariaDB - Source distribution AppGini 22.14 no language settings no problems, running smoothly ( was running well with PHP 7.3 and 7.4 as well) (only problem when executing sql() method without second error pa...

PHP 8.1 will throw so many errors for older appgini versions, change php version to 7.x on cpanel or update your app to 22.14

code note tested tablename-dv.js -> replace table name for your tablename and put this file inside hooks directory $j(function()){ $j('#field_name').on('change', function(){ if( $j('#field_name').val() <= 4 ){ $j('#another_field').val('low'); }else if( $j('#field_name').val() == 5 ){ $j('#another_fi...

Hey guys, have you ever wanted to hide some columns inside a child table but did not want to mess with the original table view setup? Just use the following code in your hooks/footer-extras.php :) <?php ?> <script type="text/javascript"> var my_table = window.location.href; var parts = my_table.spli...

Thank you both for helping, that did it!!! removing the quote and adding second parameter =)))

Hi there, thank you for replying =) I'm still getting status 500 with this code, it seems to only work when using sqlValue() all other functions keep returning 500 jquery-3.5.1.min.js:2 GET http://localhost/tigercontrol2/hooks/ajax/ajax-po.php?ajax_pass=6&ajax_pass1=workbook_gutter 500 (Internal Ser...

found the solution for this one as well but be cautious because you will have to change a core appgini file named incCommom.php duplicate the function getTableList(), give it another name and only keep the tables you want to search, then in your global script change the function name to reflect that...

still not ideal but that way you dont need multiple ajax files: $ajax_pass = makeSafe($_REQUEST['ajax_pass']); $ajax_pass1 = makeSafe($_REQUEST['ajax_pass1']); $ajax_pass2 = makeSafe($_REQUEST['ajax_pass2']); $ajax_pass3 = makeSafe($_REQUEST['ajax_pass3']); $query_start = "SELECT ct_name FROM {$ajax...

this is weird because sqlValue() works but that not efficient ( field by field.... ) using mtsqli_fetch_array() would save way more time returning all values, if anyone knows how to fix this please share, in the meanwhile the following code works but you will have to query every field... $query_star...

hey guys, can anyone help me figure out why it is returning 500 error? js var pass_val = $j('#tender1-container').val(); var tblname = 'workbook'; $j.ajax({ url: 'hooks/ajax/ajax-po.php', data: { ajax_pass: pass_val, ajax_pass1: tblname }, success: function(data){ if (data) { console.log(data); var ...

Hey guys, does anyone know a mod for the global search script to search just specific tables instead of all tables? I would like to create separate search pages with each searching specific tables <?php /** * Basic script to perform global search on all tables of an AppGini application. * Create a n...

Hey folks, I'm just wondering if any of you had reached a limit of concurrent connections in your apps and how you scaled horizontally once scaling vertically stops being a feasible option, I'm assuming the most practical way is to host your db in a separate vps server and leverage load balancer to ...

in your main app directory find tablename_view.php

then locate:

find your lookup field and insert a query for the output value, now your csv file has the actual data of the lookup instead of the ID, hope that helps.

this sounds like a permissions issue you can try running sudo chmod 755 or going straight to the directory and changing writing permissions, hope that helps.