110 comments found.
Hi there.
In an overall, its just a CRUD creator?
I didnt find any place to customise the tables and the menus insite the template dont work.
I can’t get it to work with utf8 characters:
CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` enum(‘ä’,’ö’,’ü’) CHARACTER SET utf8 NOT NULL, `test` varchar(256) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
The whole db is set to utf8 and querying the db from the commandline works too. PhpMyAdmin shows all characters properly. But code generator fails: either it shows no ‘umlaut’ characters, or it throws errors.
Inserting a string into a varchar-field doesn’t work either…
This is mySQL 5.529 and php 5.4.10 on OSX 10.8.2
Any idea?
Could you pls send me a mail through
http://codecanyon.net/user/hezecom
So I can explain to you better? Thanks.
Warning: include(views/menu.php) [function.include]: failed to open stream: No such file or directory…
What’s up ?
Thanks for your purchase precode, Try again by first clicking on the Generate Code button before you preview the admin else it will complain of missing file error.
Hello,
Just installed your script but after configuring, when i launch the admin panel i have messages errors for example my codeOutPut/views is empty…
Thanks for your purchase precode,
First click on the Generate Code button before you preview the admin else it will complain of missing file error.
Thank you for this great product! It does exactly what I want it to and I have had no problems with it.
My issue is more that I am not incredibly experienced with programming. I have easily figured out how to customize the files, but what I would like to do is a join, so that on my “products_add.php” page, for field “brand_name” I can have a select box that is populated from a field from another table.
Does that make sense? What file do I need to edit and place the join SQL code in to be able to make that select box on my products_add.php form? Is it in the class file for the table itself?
Thank you for any help!!! 
Tiffany
Thanks for your purchase fourtinkerbells. I will like to look at the database, the products_add.php and the “brand_name” . You can send them to my email.
Ok I just sent you an email!
I have adjusted the codes for you.
I have a pre-sale question: is this script suitable for this operation: 1) create dynamic content 2) the summary of this content can be shown in a html page, in a kind of list of arguments 3) Clicking an argument go to the argument page. 4) these content pages are created dynamically, they have a fixed header and footer
THanks a lot
Hi travelbaba, You’ll need little adjustment to the codes to fit this purpose. When you purchase I can guide you through. Thanks.
Hi hezecom, did you test this with SQLite3 as well? Are there limitations? thx
Yes! tiptronic it works with SQLite3.
How do I configure it for SQLite3? I can only select mysql in the setup. There’s also no mention of it in neither the help nor the code.
self::$instance = new PDO("".'sqlite'.":".'/path/to/dbase.sdb'."");
Thanks for your purchase.
hm… so I need to change back and forth everytime I want to use SQLite or MySQL. It seems it would be easier to implement a switch for that…
Yes! I will fix it in the next update. Thanks.
btw, there’s a bit more to do, since the ‘show tables’ statement doesn’t work for SQLite (I think it doesn’t work for Postgres either).
For SQLite you need to query the sqlite_master:
“SELECT * FROM sqlite_master where type = ‘table’”;
to get the tablenames and then get the column names from:
“PRAGMA table_info(” . $table_name . “)”;
otherwise your code currently fails in index.php from line 177-191.
From your statement on the Details page, I thought you support all the mentioned databases already, but the code as it is right now will just work with MySQL…
I’ll fix that for me, but I usually bought the classes to save me time, not to add more work 
Thanks tiptronic. Really appreciate your effort. I have downloaded it.
You’re welcome. But you should either fix the remaining files, or take your promotional statements about multi-database out; because as it is now – it just works with MySQL.
The generated codes support sqlite database and others I have tried that. That is, after generating it with MySQL. Though I will work on others, majorly SQLite.
Hm… I really don’t understand how the current version will work with SQLite, since the PDO “show columns” and “show tables” is not supported in SQLite… But anyway, I would love to use it with SQLite, and using MySQL works great! So great job there… If you work on SQLite and you want me to test before release, just drop me a note.
Hello, Script is great, simple and easy to customize. Just want to say what could be a nice upgrade in next version.
You could use table and fields comments as labels. I know what I mean, when I named my column evt_w_hist, but my client doesn’t have to I can change it manually, but it would be nice if you can show column comment as label (of course if comment is not null). it should be easy upgrade.
And second, more complicated. It would be great if you include handling of foreign keys. Just the same way like select of enum types.
Thank you
Great suggestion allgranite, I have noted all your points and I will look into them in the next version. Thanks.
Hi there,
Good script, already started with a DB. I need to add multiple values via checkboxes. How can I go about it from the SQL?
Regards
Thnanks for your purchase PlayaX
In your database table field, set the field you want use for checkboxes to enum as shown in the (e.g ‘Home’,’School’...). After generating the code, you can change the select menu to either checkbox or radio for now. The feature version will support the option to choose between (select, checkboxe and radio buttton) for enum option.
Hi. Thanks for the advice. I have changed it to the following:
Line 34 on form_class.php (changed)
//enum
public function enum_list($fieldname){
return'<input type="checkbox" value="'.$fieldname.'">' . $fieldname;
}
private function enum_select($fieldname,$value=null,$required=null){
return'
<input type="checkbox" name="'.$fieldname.'" value="'.$value.'">' . $value;
}
Line 174 on form_class.php (removed)
$hezeform.='</select>';
I actually display the checkboxes, but it does not save the value as ticked or not ticked.
Sorry I mentioned checkboxes, you can only use RADIO or SELECT for now. For checkboxes, you’ll need some adjustment to your code structure.
I sent a message via your contact form, please let me know.
Hi… Have you received my message? Need this checkbox feature added asap, please let me know if you can do the job
Yes! I have replied you. Thanks.
Hello, I have a pre-sales question. Would I be able to add a timestamp to the filenames and generate a download link? What I am trying to do is to have three groups of users for this script. First group consists of the clients from different companies who need to upload files to a single folder. They must not see anyone else’s files nor are they permitted to download anything. Theirs is an upload only interface with a spot to attention to a staff member. The second group is the staff who need to be able to access the files, recognize which ones they are supposed to work on and download them. The third group is the administrator who would be responsible for managing the users and making sure files are deleted once the work is complete. Is this possible with your PHP Code Generator Pro? Thank you!
It add random numbers to filename not timestamp. Though you can change the random numbers to timestamp.
Yes! it generates a download link for each uploaded files.
But as for the users access levels you will need to customize the generated code to meet this need. Thanks
tick or untick table not working, untick table will generate too
Thanks for your purchase velf. It won’t generate code for the unticked, But will only create links for all the tables (ticked or unticked) of your selected database on the output menu list. You can delete the unticked link from the menu at: CodeOutput/view/menu.php .
When you check the classes, views and the controllers folder, you will notice is only the picked table(s) you’ll see. Thanks.
is that possible to me to put my custom javascript, php and chart script?
Yes! you can customize the code to fit your purpose.
I would love to see multiple image support
Ok! thanks for your purchase and your suggestion, I will look into it.
Excellent update!!
but lacked option to choose sqlite database.
Every time I have to change the file linha10 class_dbcon.php for:
self::$instance = new PDO("".DB_TYPE.":".DB_NAME."");
Thank you
Oh! thanks equipexq for reminding me, I didn’t remember I will look into it. Thanks.
Thank you buddy. You have listened to your customer well and incorporated the requested features very promptly. I can’t wait to get home tonight to play around with this code generator. Looks very awsome.
Thanks aqsharif, I realy appreciate your interest. Also thanks for your contribution. If you like to add any other thing just let me know I will try…
Does the genrated code for say a form or query have any sanitization of data or anti-hacking prevention like XSS and SQL Injection?
Yes! the generated code uses PDO prepared statements which already handles SQL injection.
Awesome and version 2.0 double bonus.
Works great
Q: What are the menu options for ‘Projects’, ‘Comments’, and ‘Reports’ for. In the installed version they don’t do anything… same as on the demo. Q: On the demo I see a graph; Is that something that I should be able to produce from my installed version?
Very easy to install and use. Just not sure that I understand all the functionality and there is nothing in the instructions on those options.
Thanks for your purchase bax2020 the horinzontal menue are just example link. You can add more links or change links to your desire location. You can even change the vertical menu to horizontal menu, it all depend on your taste. The graph is just a template you can code it to work with your project. If you still have any difficulty using the functionality, you can send message through:
http://codecanyon.net/user/hezecom
Basically i have the files here, now i want to create a registration script for SQL Server (MSSQL), what do i do?
Thanks for your purchase matid1994.
Change mysql to mssql in your config.php then Update Settings before you generate codes so that it can update the CodeOuput config.php.
Also make sure the extension=php_pdo_mssql.dll is enabled in php.ini if not already…
extension=php_pdo_mssql.dll You do not thats only valid for php versions 5.3.1 and below?
It’s a discontinued driver you really should release a newer version designed for SQL_SRV driver.
If you have SQL_SRV driver then change mysql to sqlsrv.
I dont understand i do the setup but nothing appears to work…
1. Run the ProcodeGen/setup.php 2. Enter your settings and submit.
Pls check the documentation for details. Thanks. You can contact me here for details:
http://codecanyon.net/user/hezecom
