Mr PHP provides this code library as a way to share code snippets, tech solutions and various information that my be helpful to other coders and the programming community at large.
If you have ever tried to deal with multiple primary keys in cakePHP then you have probably hit a brick wall at some stage.
Although you still need to add a single id field, this example will allow you to save your data without needing to know the id.
Usage
SQL generated when row does not exist
A few years ago I decided phpShop wasn't doing much and the community was nothing near the size of osCommerce so I switched. Managing and supporting the modules I had for phpShop became tedious so I removed them from the site.
This is a quick 1 page application to monitor your replicated MySQL servers.
Use it as you will. Enjoy!
This quick snippet of jQuery that will allow you to so do something before the user navigates away from a page or closes the browser or tab.
In this example I have mixed in some JavaScript Date functionality to give a timer of how long you were on the page.
This is a quick little method that lets you get some data from a CSV into a table.
It should work with very large CSV files as it only has to read one row at a time.
In this quick snippet of code I will be setting the ID of a model based on other fields given. We want to save a note about each Post that is different for every Client, however we do not want to have to get the ID every time we save the data.
Usually the client will request for me to give them a way to edit simple settings in their application.
I decided to read all the variables from the database in the beforeFilter to make them available in any controller.
In almost every project I need to setup some sort of login, and usually it requires group access to certain data depending on different criteria.
For example I may have groups Admin+Member and I want Members to only be able to see other Users Profiles if the other Profile is active.
