Hi sir I have watched all your video and liked it can you please give tutorial on how to get a value from another table field value matching select text box matching same in another table fields that will help thanks
Hi, Sir. How do you change the table fields with data from the table itself, not static like the example below $table_data = array( "status" => "1 "; ); $db->where("id", $rec_id); $bool = $db->update("bill2", $table_data); but I want the value of status 1 to be not static but to take the value from the textbox itself according to the dropdown option, thankyou
That is because it was built that way. So that when you try to add multiple record, it will be easier. Instead of clicking the add button always to bring up the modal.
@@willvin sorry sir. not ADD but EDIT, because i sometime or opten and ussualy always edit data and after edit automaticly reload new display while editing words
i have a question sir how can you make absents count in every employee if they put a leave reason then automatically update the days absent for example: james smith - 29 absents. I hope you make tutorial about this =) thank you.
Hi sir, I really need your help for my project. Can you please give me an idea on how to update a specific record to another table, after I add new record to a table I selected in Page Event? I hope you notice this because this will be a big for my thesis.
You will need to write a query that would update the other table with the details you want to update it with. From the right panel of the Page Event, when you select Action After Add or Action Before Add, you will see a list of code snippets. When you double click on them, the code snippet will be loaded for you and you can modify it with your own table and data.
Please not that paging is automatically done by the app. You can set record limit in page properties and if the records on that page exceed that number, you'll see the next page. You can also decide to change the paging style used by that page in the same page properties. The configuration, is called pagination Settings. You have to make sure pagination is set to true before before you continue.
Man, what a mess of code to show a data that must be shown in 1 or 2 clicks! A look up field to replace an index, just like in add/edit forms! PHPRad need to improve this feature REALLY urgent!
Hi, this is just an example showing you the ways and type of code you could use in Page Events. PHPRad has Master Details configuration for list and view page, and also Master/Details form on Add Page Properties, which is similar to what was shown in this tutorial. The essence of this tutorial is to let you know that if a configuration does not work properly for you, you might be able to achieve what you want with the Page Events.
@@willvin , got it, but for any reason in my case I tried 2 master/detail columns to get Category from an id, and Provider in the same way (from an index) in a same form, without luck. About Page Events, variable created in page events didn't work either, so in this point don't sure about what to do next, headache apart, of course.
@@willvin , furthermore, I don't think necessary to create master/detail column in any case with a link to details! Sometimes simply I need to show Category name in plain text, like in the last mentioned example, where I need simply list Category name to that product, not sure if could explain example in a simple way my point.
@@willvin after analyze DB, I noticed that error was in certain incorrect data in fields that were causing a mess. At the moment all is working just you mentioned, thank you so much for your help and comments.
thank you I was really helped by this video .. and I also can't wait for part 2
i like so much your video phprad Bro 🤩🤩🤩🤩🤩, please more new video Bro
Thank you, can you make tutorial how to connect to telegram bot for input form, example form register
HI, can you add notification to telegram/wa if new record added?
Yes, I can.
@@willvin can you create tutorial for it?
@@hdsst yes, i hope too
Hi sir I have watched all your video and liked it can you please give tutorial on how to get a value from another table field value matching select text box matching same in another table fields that will help thanks
Thank's a lot
Hi, Sir. How do you change the table fields with data from the table itself, not static like the example below
$table_data = array(
"status" => "1 ";
);
$db->where("id", $rec_id);
$bool = $db->update("bill2", $table_data);
but I want the value of status 1 to be not static but to take the value from the textbox itself according to the dropdown option, thankyou
i wanna ask to @wilvin....... why on phprad classic 2.7..3 cannot update reload automaticly after edit use Edit Modal Popup.. thnks
That is because it was built that way. So that when you try to add multiple record, it will be easier. Instead of clicking the add button always to bring up the modal.
@@willvin ok thank u sir .. for attention.. keep make tuto sir to more... iam very glad with phprad and easy to all learn people basicly🙏
@@willvin sorry sir. not ADD but EDIT, because i sometime or opten and ussualy always edit data and after edit automaticly reload new display while editing words
i have a question sir how can you make absents count in every employee if they put a leave reason then automatically update the days absent for example: james smith - 29 absents. I hope you make tutorial about this =) thank you.
can you explain calculation with PHPRAD , for the example : total = price * qty , thanks
bisa kok
I will do a tutorial on it, soon.
Hi sir, I really need your help for my project. Can you please give me an idea on how to update a specific record to another table, after I add new record to a table I selected in Page Event? I hope you notice this because this will be a big for my thesis.
You will need to write a query that would update the other table with the details you want to update it with. From the right panel of the Page Event, when you select Action After Add or Action Before Add, you will see a list of code snippets. When you double click on them, the code snippet will be loaded for you and you can modify it with your own table and data.
@@willvin But when I try, it always doesn't work. Maybe my query is wrong. I'm just a newbie in PHPRad and I can't figure out the right syntax.
Sir how to page in paging next sequence from first page to page two etc
Please not that paging is automatically done by the app. You can set record limit in page properties and if the records on that page exceed that number, you'll see the next page. You can also decide to change the paging style used by that page in the same page properties. The configuration, is called pagination Settings. You have to make sure pagination is set to true before before you continue.
@@willvin sir i try page one sequence 1..20 continuoe page two 1..20..how to continue in page two 21..etc..i newbie sir
Man, what a mess of code to show a data that must be shown in 1 or 2 clicks! A look up field to replace an index, just like in add/edit forms! PHPRad need to improve this feature REALLY urgent!
Hi, this is just an example showing you the ways and type of code you could use in Page Events. PHPRad has Master Details configuration for list and view page, and also Master/Details form on Add Page Properties, which is similar to what was shown in this tutorial. The essence of this tutorial is to let you know that if a configuration does not work properly for you, you might be able to achieve what you want with the Page Events.
@@willvin , got it, but for any reason in my case I tried 2 master/detail columns to get Category from an id, and Provider in the same way (from an index) in a same form, without luck. About Page Events, variable created in page events didn't work either, so in this point don't sure about what to do next, headache apart, of course.
@@willvin , furthermore, I don't think necessary to create master/detail column in any case with a link to details! Sometimes simply I need to show Category name in plain text, like in the last mentioned example, where I need simply list Category name to that product, not sure if could explain example in a simple way my point.
@@willvin after analyze DB, I noticed that error was in certain incorrect data in fields that were causing a mess. At the moment all is working just you mentioned, thank you so much for your help and comments.