This PHPMaker project file is useful if you want to create a web application from scratch using PHPMaker version 10.0.5. Please note that there are some new fields that were added into settings table. So, this project is useful for you to compare the changes in that table with yours. Also, the Demo of I Love PHPMaker 10 project file has been updated with this change.
Many advantages you will get after using this PHPMaker project file:
- You will have already had the minimum tables that needed for your project using Masino Extensions.
- Since you will have the basic needed tables, then you only need to add your another tables into the database, and then synchronize to this project.
- You don't need to configure the Fields setup for the certain tables, such as settings, users, announcements, help, help_categories, etc.
- You don't need to configure the Security settings for your web application since they have been included in this project.
- You will have the most needed PHPMaker project setup, especially if you implement Masino Extensions into your PHPMaker project.
- You will have some useful servent events ready-code in it so that you can use for the project basis.
- You will have a new Application Settings menu that contains almost all web application configuration settings which will be easily configured by Admin on-the-fly.
- Your End-Users (non-sysadmin) will be able to configure their preferences easily by using the ready-configuration settings.
To implement this new project file for your new web application, then make sure you have downloaded ALL the latest version of Masino Extensions files that I made for PHPMaker version 10 from this link.
If you are not sure which ones that I customized for the latest time, just download ALL the extensions for PHPMaker 10, as I also customized some other related extensions for this changes. Extract them, and then replace all the existing extensions with the new ones.
Edited: Make sure you have already altered the settings table by using the following script so that the latest extension will work properly for your PHPMaker project:
ALTER TABLE `settings` ADD COLUMN `Use_Javascript_Message` enum('1','0') DEFAULT '1', ADD COLUMN `Login_Window_Type` enum('popup','default') DEFAULT 'default', ADD COLUMN `Forgot_Password_Window_Type` enum('popup','default') DEFAULT 'default', ADD COLUMN `Change_Password_Window_Type` enum('popup','default') DEFAULT 'default', ADD COLUMN `Registration_Window_Type` enum('popup','default') DEFAULT 'default', ADD COLUMN `Reset_Password_Field_Options` enum('EmailOrUsername','Username','Email') DEFAULT 'Email', ADD COLUMN `Action_Button_Alignment` enum('Right','Left') DEFAULT 'Right';
muhamad furqon says
I have this error :
The ‘MasinoPosIndonesiaOTP10’ extension is not found! Do you want to ignore …..
Masino Sinaga says
Yes, please ignore my another extensions which are not listed in the Download section of this website.
muhamad furqon says
When exported, the title of the column is not a caption that I was setting in PHPMaker but still same with the original setting in mysql tables…. how to fix it?
Can I request a tutorial, step by step how to integrate phpmaker dan phpreportmaker with your new project file….
Masino Sinaga says
Make sure you have already defined the related setting from MasinoFixedWidthSite10 extension. Go to Advanced -> Tables and then enable ExportFieldCaption for your desired table. Also, make sure you have enabled UseTableSettingForExportFieldCaption from Advancced -> Project of the extension.
Andrew says
NICE JOB, Massino!
This is EXACTLY what I was looking for a few months back – really good work.
Just about all the little quirks I had been experienced are solved because the essential tables (i.e. – users, userlevels, userlevelpermissions, etc.) are now crafted to the code you created.
I used to have to manually remark out so many lines on various add/edit/view pages to make things work, then save them specially, copy them back to the webserver….huge pain. But now, you’ve solved 99% of that by including a demo db to work.
Really appreciate this.
🙂
Masino Sinaga says
Thanks, Andrew. 🙂
muhamad furqon says
I have table list from two table (Countries and Cities) with relation like this :
# Countries Cities
1. Country1 City1
2. Country1 City2
3. Country2 City3
Countries : id_countries, countries name
Cities : id_cities, id_countries, cities name
But when I export that list, result like this :
# Countries Cities
1. 1 City1
2. 1 City2
3. 2 City3
countries name not show but id_countries.
How to fix it?
Masino Sinaga says
Make sure you have disabled Export original values from Tools -> Advanced Settings.
muhamad furqon says
I forget about that. thanks Masino.
Still in exporting table list. I have hundreds of records in one table.
How do I make a table heading row repeat on each page?
Masino Sinaga says
To repeat the heading row on each page, then it should be handled from the exported file side.
keithh0427 says
Masino,
Do your extensions work seamlessly with MySQLi ?
Masino Sinaga says
Keith, I have not tested it yet. It should work. Did you find something wrong with my extensions in your PHPMaker project? Please let me know. Thanks.
keithh0427 says
Yes. I only changed the flag to use MySQLi and then recompiled ALL of the scripts.
I encountered multiple errors and the “export to email” panel remained visible. I could not close or remove it. The errors are from the function fields( $field ) within the class mysqlt_driver_ResultSet.
Some of the errors are:
Notice: Undefined index: Use_Javascript_Message in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Login_Window_Type in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Forgot_Password_Window_Type in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Change_Password_Window_Type in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Registration_Window_Type in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Reset_Password_Field_Options in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Reset_Password_Field_Options in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Notice: Undefined index: Action_Button_Alignment in C:\xampp\htdocs\WeekendAdminSystem.org\ewmysql10.php on line 870
Masino Sinaga says
Keith, I just remembered that there are some new fields were added to settings table. It seems you have not adjusted this change to your settings table (?).
So, please follow this post to compare those new fields with yours. Make sure you have added those new fields into your settings table.
keithh0427 says
That solved the problem. Part of my problem is that when I download the updated extensions, I don’t see a remark on the download page that your underlying tables have been upgraded as well.
Can you let us know when something else needs to be considered when an extension is upgraded. There have been many times when I see a newer date and when I check the extension post, I don’t see a matching entry detailing the changes for the extension. Sometimes it will take several days for you to catch up on that piece of information.
Thanks for pointing me in the right direction. I need to move toward MySQLi.
Masino Sinaga says
Great. I am so sorry not to explicitly let you know about the changes in settings table. I just updated this article by adding the SQL script to alter the table.
muhamad furqon says
I try to integrating php report maker and php maker with your extension, but I have error :
Fatal error: Call to undefined function CheckActiveFontName()
Masino Sinaga says
Thanks for the feedback. Will try to update the extensions for PHP Report Maker, too. Please stay tuned within the next three days.
muhamad furqon says
Okay… , I will wait for the update.
Masino Sinaga says
I just checked my extensions both for PHPMaker and PHP Report Maker. They already had CheckActiveFontName() function defined.
So, make sure you have already downloaded and used the latest extensions I made both for PHPMaker and PHP Report Maker for your project. Also, don’t forget to generate ALL the script files, both for your PHPMaker and PHP Report Maker project.
Andrew says
Any solution yet for generating a blankpage that will follow the selected theme, font, font size selections?
Have several hand coded pages within the apps I build that need to do joins with external (cloud dbs), validations, etc…
Masino Sinaga says
Thanks for reminding about the custom settings for the generated blankpage.php. Please re-download MasinoFixedWidthSite10 extension.
Andrew says
Nice….that did the trick.
THANK YOU!!!
Oscar says
Hi Masino,
I can’t import the procedures of your sql file, because I dont have super-privilegies. Do I need these lines of the sql file to work with your project and extensions?
Masino Sinaga says
As long as you do not manage the breadcrumb links using breadcrumblinksaddsp.php, breadcrumblinkschecksp.php, breadcrumblinksdeletesp.php, and breadcrumblinksmovesp.php, then you don’t have to import it at the moment. However, try to import it as possible later.