Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - nofeara

1
Issues / Re: Error Handler - Adding New Duplicate Records
Bumping up!

This application is very good and i am really saving up to buy for a license, however one drawback i have is the lack of immediate support i will be getting. Do the license users get faster support in case?
2
Issues / Error Handler - Adding New Duplicate Records
Hello :)

So i have here a table (tbl_items_itemdetails) wherein i have index 2 columns (items_itemdetails_itemsid and items_itemdetails_itemdetails_id) that should be unique.



As you can see in the list below i should only have 1 Author details for Item The Book of Codes unless i would add another details for Author 2 or Author 3.



Having added the proper index in mysql it is successfully not allowing duplicate values for a particular item and its details however it is still prompting a wrong information, "New Record Added Successfully" but i was not able to add a record successfully.





If i am editing the record, it prompts a correct information that i have a duplicate record but only in adding it gives wrong information that i have added a new record successfully wherein fact i am not.

How can i handle this error?

Thanks in advance.
4
Questions / How to list data filtering record for current logged user?
Hi,

I have a transactions list having data containing user information.





I want this data to be automatically filtered for the current user. Example if i am currently logged in as 20046554. The transactions above should be only be showing details for ID number 1, User: Jodill James A. Esteban, Item: The Anonymous Book.



I tried using the WHERE in the default query configuration with the following statement:

transaction_user=USER_NAME



However, after republishing, i still get the same results details in my list



I also tried using the following statement hoping it works:

transaction_user='$_GET[USER_NAME]'

But this only resulted into a loading screen:



This are my joins and my user authentication details:





What proper statement should i add in the default query WHERE? or there are other things that i should do?

P.S. (Sql Where Statment eg. status='active')

Thanks in advance :)
7
Issues / Redirect to After Add (with + this.id) does not work
I am badly needing a fix or a work around for this error

As you can see in the pics below, i am trying to redirect to view the auto generated ID that has been created upon adding my new record, however it prompts out that i don't have that record but i have it. Please help us to make a work around regarding this issue. I am making a transactions table and i need to view the generated ID because i will be using it as value into other table.









Thanks in advance.
8
Questions / Re: WHERE Active user
Quote from: Emman –
If you edit the file manually, you should disable publishing the file to avoid overwriting the file everytime you publish your project.
Click on the publish button and select the file that you don't want to overwrite.

Hi yes, that actually helps however there are other things that i really want to work with client since i am just a newbie in php (or in coding)...

One example is,

in adding a record, i have set in mysql that the value should be unique. Well it does make sure that it is unique, but when i am adding a record, the duplicate will not be added but still the success message shows up. I can only see duplicate error when editing...

I am planning to get a license for the software because somehow i find it good despite of some bugs or idk things i am experiencing, however do i get a faster support for my queries? The forums seems not that active
9
Questions / WHERE Active user
Hi, how do you get the current id of the logged user in WHERE???

i am not getting anything xd:

transaction_user_id='$_GET[USER_ID]'   >>> just keeps the list loading

transaction_user_id=ActiveUser.user_id >>> errors

transaction_user_id=USER_ID >>> just list everything

transaction_user_id='4' >>> this filters the list but only if u are user with user_id = 4 xd?

Any help?????

Edit okay..... i am really a beginner with this all sorts of stuffs however i was able to tweak the file making it work in this way:

i went to Tbl_transactionsController.php and added some lines of codes:

$cu=get_active_user('user_id');
$db->where("transaction_user_id=$cu");

i manually defined $cu and it works. However everytime i go to the client and the files reload ofc and it will dissapear making it not work again? So how do you add this properly? in the mean time ill stick with this since it works somehow.