AppGini Community Forums

Hi,

please post the fields of your database, otherwise it is only stumling in the dark. Please with upper/lowercase.

sql("UPDATE accounts SET `LastOrderDate` = '".$data['LastOrderDate']."' WHERE `id` = '".$data['account']."'", $eo);

assuming that id is the PK.

Hi,

can you post your tabledefinitions? Are you using any lookups? Are the accounts login and the Orders Account the same?

sql("UPDATE accounts SET `LastOrderDate` = '".$data['LastOrderDate']."' WHERE `login` = '".$data['account']."'", $eo);

Hi, dont use echo in the file. Add the Script to the $footer variable Also $memberInfo = getMemberInfo(); echo $memberInfo['group']; is not needed. And you should use the appropriate are of your tableview (either tableview or tableview+detailview) as otherwise the code will also be applied to you di...

Agree with Jan,
Try

Hi, it would be helpful if you describe at the beginning what you try to acheive. So in your case you could change the code to: function special_sites_init(&$options, $memberInfo, &$args) { sql ("update special_sites set days_since=TIMESTAMPDIFF(day,date_attended,NOW())'", $eo); return TRUE; } This ...

Hi, true, sorry, overlooked that. Try not adding to the header, but the footer-extras.php the corrected version: <?php $is_homepage = (basename($_SERVER['PHP_SELF']) === 'index.php' && !isset($_REQUEST['signIn'])); if ($is_homepage) { ?> <script> $j(function() { $j('.collapse').not('.in,.navbar-coll...

Hi, function special_sites_init(&$options, $memberInfo, &$args) { if (isset ($_REQUEST ['SelectedID'])) { $id = makeSafe ($_REQUEST ['SelectedID']); sql ("update special_sites set days_since=TIMESTAMPDIFF(day,date_attended,NOW()) where id = '{$id}'", $eo); } return TRUE; } if (isset ($_REQUEST ['Sel...

true

Hi, you can try adding to the hooks/header-extras.php: <?php $is_homepage = (basename($_SERVER['PHP_SELF']) === 'index.php' && !isset($_REQUEST['signIn'])); if ($is_homepage) { ?> <script> $j(function() { $j('.collapse').addClass('in');$j('.collapser').children('.glyphicon').toggleClass('glyphicon-c...

Hi, if you do not want to edit the created file from AppGini (which will be overwritten as Jan stated), add the following to the hooks/header-extras.php file <?php $home_page = (basename($_SERVER['PHP_SELF'])=='index.php' ? true : false); if ($home_page) { ?> <script> $j(function() { var x = '<?php ...

sql ("update special_sites set days_since=TIMESTAMPDIFF(day,date_attended,NOW()) where id = '{$id}'", $ eo);

with $id having the ID of your selected record.

Hi, you may try to create a view of the membership_users with the field you need in your database. Then create a table in AppGini with the same fields. The important part is that you add a unique id to your view. One option could be that you use the memberID (which is not numeric) and convert it to ...

Hi,

what field do you have. Is it a text field, richt text, ... ? Is it read only or are you expecting the user to enter data? Maybe you can post a screenshot

Hi, you can use sql ("update unit set age=TIMESTAMPDIFF(year,DateOfBirth,NOW()), months=TIMESTAMPDIFF(month,DateOfBirth,NOW()) % 12, days=FLOOR(TIMESTAMPDIFF(day,DateOfBirth,NOW()) % 30.4375) where id = '{$ id}'", $ eo); Where you need to replace the DateOfBirth with the correct variable that you ha...

Hi,

you can add to the TABLENAME-tv.js in the hooks folder some code to add you button to there you want an upon click on the button
execute

$j('input[data-col="TABLENAME-FIELDNAME"]').click();

for each field that you want to hide.

Hi, you can try to edit the hooks/header-extras.php and add <?php $mi = getMemberInfo(); $url=basename($_SERVER['PHP_SELF'],".php"); if ($mi['group'] == 'anonymous' && $url == "index") { ?> <script> $j(function(){ $j('#login_splash').append('<iframe width="560" height="315" src="https://www.youtube....

Hi, can you explain what exactly you are looking for. From the sql statement I would assume that you set the age to amount of years of the diff between today and date (where date is an unfortune name for that field). Also you could use now() in the sql statement directly instead of getting the curre...

Hi,

have a look at

viewtopic.php?f=7&t=1740#p10877

Hi,

hmm, I would not expect it to do so. Can you post some sample values where you can show that it does not work correctly.

Hi,

can you post the SQL you use for the picture shown. Is the transaction date a date field?

Hi,

at this stage a user cannot be assigned to multiple groups (to my knowledge).

Hi,

can you explain what the other database is. Is it a MySQL (MariaDB)? Is it running on the same server?
As you say here you want basically reproduce the auto-fill feature, correct?

Maybe to add to this. The SQLVALUE function returns indeed one value that you look for. The statement you describe in your question would return all fields for the selected row in your database, which would probably not be only one field and hence the the SQLVALUE function would not be the choise. I...