{"id":156,"date":"2017-09-07T11:58:43","date_gmt":"2017-09-07T11:58:43","guid":{"rendered":"https:\/\/codingfix.com\/?p=156"},"modified":"2018-07-12T12:18:09","modified_gmt":"2018-07-12T12:18:09","slug":"phreeze-build-basic-crud-application","status":"publish","type":"post","link":"https:\/\/codingfix.com\/phreeze-build-basic-crud-application\/","title":{"rendered":"Phreeze: how to get it set up and running"},"content":{"rendered":"

Phreeze is an amazing application generator which allows to have an entire database management application built just in minutes.<\/p>\n

Sometime ago I was working for a customer who, for reasons I couldn’t know, didn’t want give me a full access to his hosting provide control panel. That’s was not a big issue: in fact I could do the most part of work just using an FTP client. But the database management was difficult having to always give sql dump files to my customer and then wait that he performed the queries against the database.<\/p>\n

I couldn’t even use a remote database management software like MySql Workbench, because the hosting provider didn’t allow that.<\/p>\n

So I have finally decided to look for a solution which give me a workaround to all these difficulties and allowed me to directly perform all CRUD operations without having to interact with the customer. This way I have discovered Phreeze.<\/p>\n

As authors say<\/a>:<\/p>\n

Phreeze is a framework for building PHP applications. A framework is basically a toolkit of helper classes along with a consistent application structure.<\/p><\/blockquote>\n

Phreeze is comprised of three components. The one we’ll look at in this small guide is Phreeze Builder:<\/em><\/p>\n

…is a utility that analyzes a database and auto-generates a basic application that is ready to use and\/or customize.<\/p><\/blockquote>\n

What I want is just to show you how to build\u00a0 a basic database management application with Phreeze Builder, beacuse it tooke me a bit of time before to get it working (probably because I’m a bit stupid, but we can ignore that for the moment…)<\/p>\n

Getting started<\/h2>\n

First, go to https:\/\/github.com\/jasonhinkle\/phreeze<\/a> and download the compressed file to your machine, then uncompress it in a convenient location.<\/p>\n

You should now have in your target directory a folder called phreeze-master<\/em> which holds all application files: I suggest you to rename it to phreeze<\/em> (just to avoid issues with internal links) and to upload it to your server (let’s call it www.mydomain.com).<\/p>\n

Now, use your browser of choice to visit www.mydomain.com\/phreeze\/builder<\/em>.<\/p>\n

If you get some error (as it happened to me), you have to open the .htaccess you find in phreeze\/builder directory and uncomment the
\nRewriteBase<\/strong> rule, that is replace this line:<\/p>\n

#RewriteBase \/phreeze\/builder\/<\/pre>\n
with this one:<\/p>\n
RewriteBase \/phreeze\/builder\/<\/pre>\n
Maybe you still get an error about timezone settings<\/strong>: if this is the case, open in your code editor the file phreeze\/builder\/_machine_config.php<\/em> and uncomment following line<\/p>\n
\/\/date_default_timezone_set(\"UTC\");<\/pre>\n
in order to have:<\/p>\n
date_default_timezone_set(\"UTC\");<\/pre>\n
Running the Builder<\/h2>\n
Now navigating to\u00a0http:\/\/www.mydomain.com\/phreeze\/builder<\/em> you should correctly access the builder wizard. In the first page you have to put your connection data: database host, username, password, database name and the type of mysql connection (mysql, mysqli or PDO).<\/p>\n
\"PhreezeWhen you have done, just click Analyze Database<\/em> button.<\/p>\n
Using the Analyzer<\/h2>\n
The next page shows you a complete list of your database tables (if you don’t want some table be managed <\/em>by your application, just uncheck it<\/em>) and ask you to adjust some more settings:<\/p>\n
\"Phreeze<\/a>Hover your mouse over the question marks to get a quick and clear explanation of the option; below I report them here showing my settings:<\/p>\n
[embedit snippet=”phreeze-options”] <\/b><\/p>\n
If you want to know how to build an accordion like this one with a few lines of code you can read my article The simplest jQuery Accordion ever!<\/a><\/em><\/span><\/p>\n
Generating the application<\/h2>\n
And now we can finally click the Generate application<\/em> button. Depending on the size of your database, after some time your browser will download an archive with your application. Uncompress this archive in the choosen directory (in our example it was ‘db_admin’, do you remember?).<\/p>\n
I’ts almost done. We have just to repeat some steps we did above to configure Phreeze Builder:<\/p>\n
    \n
  1. open the .htaccess<\/em> file in your \/db_admin\/<\/em> directory and set the value of RewriteBase rule correctly: RewriteBase \/dbman\/<\/span><\/li>\n
  2. then open the _machine_config.php<\/em> file in your \/db_admin\/<\/em> directory and set the timezone: date_default_timezone_set(“UTC”);<\/span><\/li>\n<\/ol>\n
    Now you can visit the URL\u00a0 www.mydomain.com\/db_admin<\/em> and start to manage your database!<\/p>\n
    Warning.<\/strong> Browsing through your database you could find that not always table has all columns you would expect to see: that’s strange and it took me a bit to discover the issue. Since I’m a generous man, I want to reveal the secret right now! By default, Phreeze applications doesn’t show more than 5 columns per table. To change this, you have to open \/db_admin<\/em>\/templates\/<\/em> directory and look for the template which refers to the table you want to show more columns (virtually all of them) and open it in you code editor of choice. Around line 30 you’ll find something like this:<\/p>\n
    \t<!-- underscore template for the collection -->\r\n\t<script type=\"text\/template\" id=\"ftThemesCollectionTemplate\">\r\n\t\t<table class=\"collection table table-bordered table-hover\">\r\n\t\t<thead>\r\n\t\t\t<tr>\r\n\t\t\t\t<th id=\"header_Column1\">Column11<% if (page.orderBy == 'Column1') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column2\">Column12<% if (page.orderBy == 'Column2') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column3\">Column3<% if (page.orderBy == 'Column3') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column4\">Column4<% if (page.orderBy == 'Column4') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column5\">Column5<% if (page.orderBy == 'Column5') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n<!-- UNCOMMENT TO SHOW ADDITIONAL COLUMNS\r\n\t\t\t\t<th id=\"header_Column6\">Column6<% if (page.orderBy == 'Column6') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column7\">Column7<% if (page.orderBy == 'Column7') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n\t\t\t\t<th id=\"header_Column8\">Column8<% if (page.orderBy == 'Column8') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' \/><% } %><\/th>\r\n-->\r\n\t\t\t<\/tr>\r\n\t\t<\/thead>\r\n\t\t<tbody>\r\n\t\t<% items.each(function(item) { %>\r\n\t\t\t<tr id=\"<%= _.escape(item.get('Column1')) %>\">\r\n\t\t\t\t<td><%= _.escape(item.get('Column1') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column2') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column3') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column4') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column5') || '') %><\/td>\r\n<!-- UNCOMMENT TO SHOW ADDITIONAL COLUMNS\r\n\t\t\t\t<td><%= _.escape(item.get('Column6') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column7') || '') %><\/td>\r\n\t\t\t\t<td><%= _.escape(item.get('Column8') || '') %><\/td>\r\n-->\r\n\t\t\t<\/tr>\r\n\t\t<% }); %>\r\n\t\t<\/tbody>\r\n\t\t<\/table>\r\n\r\n\t\t<%=  view.getPaginationHtml(page) %>\r\n\t<\/script><\/pre>\n
    Okay: just do what they say and “UNCOMMENT TO SHOW ADDITIONAL COLUMNS” \ud83d\ude42<\/p>\n
    Hope this help<\/p>\n","protected":false},"excerpt":{"rendered":"
    Phreeze is an amazing application generator which allows to have an entire database management application built just in minutes. Sometime ago I was working for a customer who, for reasons I couldn’t know, didn’t want give me a full access to his hosting provide control panel. That’s was not a big issue: in fact I […]<\/p>\n","protected":false},"author":3,"featured_media":299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_gspb_post_css":"","footnotes":""},"categories":[34],"tags":[24,22,29,21,30],"post_folder":[142],"class_list":["post-156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-other-stuff","tag-crud","tag-database","tag-database-admin","tag-mysql","tag-mysql-admin"],"_links":{"self":[{"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/posts\/156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":0,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/posts\/156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/media\/299"}],"wp:attachment":[{"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/categories?post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/tags?post=156"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/codingfix.com\/wp-json\/wp\/v2\/post_folder?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}