Discussion on PHP CRUD Generator

Gilles,

This is good news, indeed!  Some call the style of capitalizing each word in a name "camelback", while others call it "hungarian" notation.  Capitalization of each word is my preferred notation because I can easily read a data type, adjective, noun in the given name.  Another pleasant surprise is your request for ftp access.  I am honored you would go to such lengths to assist!  I am curious about how ftp access would help this installation project move along.  Another thought:  would your having read access to the database and folder be beneficial?

I have a long history of application development in the mainframe, client/server, database design and IT project management fields. I am new to the web development environment and I find some things are a bit confusing. I have developed some php crud, but when it came to adding conveniences (such as a dynamically populated list box or a live search box) for the end user I was entirely baffled. Despite attempts at researching these features, I was unable to come up with the ability. So I started researching PHP CRUD and found you, among others. After reading your extensive write-up, I decided to take a chance with PHPCG.

That said, I know what it is like to have customers who suck up all the available time you have. I want to become independent as soon as possible, so I will not be one of those. Somehow, I hope to make your interaction with me beneficial, as opposed to you providing all the benefit to me. I seek balance in all relationships.

Best Regards,

I downloaded and unzipped the installation files onto my desktop. I located index.php and read about moving folders and their files onto my web server’s project file.

I don’t have a project file, so I moved these folders into my pubic_html folder.

I invoke my web site by typing in trefethen.org. This works very well for me.

This time, I tried to invoke the PHPCG intallation file by typing in trefethen.org/install/index.php

However, when I do this, I get a blank screen and nothing to interact with. The url address bar of this blank screen shows “http://trefethen.org/install/do-install.php”

This has happened other times when the credentials haven’t been put into the code. So I looked at the php code and saw where it might be put in, but I don’t want to mess with the install code when others might have a better idea what should be done.

Can I get some help on this install?

Best Regards,

Andrew Trefethen

Hi Andrew,

You don’t have to change anything to the code. The page throws an error 500. This can be caused by different things: wrong PHP version, missing files on server or wrong paths in includes, ...

The 1st thing to do is to turn display_errors on in your php.ini Then instead of the error 500 you’ll see a message on your page which will give informations about the error.

I’m available for live help on chat at https://www.phpcrudgenerator.com or you can email me from https://www.miglisoft.com/#contact

Gilles

Hi,

Thanks for purchase and for your feedback about installation on IIS server.

1. The htaccess redirects all the admin’s queries to admin/index.php. I can’t test (don’t have any IIS server access), but this should work in your web.config:

   <?xml version="1.0" encoding="UTF-8"?>
   <configuration>
     <system.webServer>
       <rewrite>
         <rules>
           <rule name="Imported Rule 1" stopProcessing="true">
             <match url="^(.*)$" ignoreCase="false" />
             <conditions>
               <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
               <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
             </conditions>
             <action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
           </rule>
         </rules>
       </rewrite>
     </system.webServer>
   </configuration>

   If you confirm it’s ok I’ll add this to the documentation
2. <head/><verify_envato_purchase>: you shouldn’t get this , and it comes from your server, which adds the head tag to the answer. I previously had the same issue with all my Ajax requests, and it came from Pagespeed extension: https://github.com/apache/incubator-pagespeed-mod/issues/1405
3. Sorry, I don’t understand what you mean, can you explain please?

Gilles

Work fine!

Great!

Hi Renso,

Multiple select values should be registered in a single db field in JSON format.

When you send the values with the create/update form, do you get an error message?

Open your conf/con.php & replace

$environment = 'production';

$environment = 'development';

It’ll show the SQL query if there’s a recording error.

Feel free to send me your access for more help,

Gilles

Hi Gilles, ok but when this is stored as json in textfield are you able to filter on it in a list view. Eg. i want to filter if a specific market is filled in the json and then show the results. Renso

Your request is a bit specific.

It would be of course a lot more simple to have a boolean db column for each market.

Another way would be to have a separate “market” table in which you can add/edit/remove markets, and a relation table to link inventories & markets.

But if you want to keep your unique a db column with JSON markets, it’s possible to edit the file which creates the filters: admin/class/crud/ElementsFilters.php

• The returnForm function creates the select list.
  Option value is $option_value L.154
• The returnWhereQry creates the “WHERE” SQL statement.

For both, I would test if data is in JSON format, then split to create an option for each value, or edit the WHERE statement with OR conditions for each value.

It can be helpful to change $debug to true in __construct This will show informations.

HELLLO SALUDO BONJOUR,

2 days for install, because i have local server testing, and is this for you production version.

No, this is absolutely wrong.

always show me 404 error.

This comes from your server settings or htaccess or anything else. Not from PHPCG

Fatal error

Again it comes from your server settings or htaccess. Nothing to do with PHPCG

i want refund

Since you prefer to give up the first problem you encountered without asking for help, you’re right, it’s the best thing for you.

Gilles