Programming and Web Development

How to create a user in MySQL/MariaDB and grant permissions on a specific database

2 comments

Logos de MariaDB y MySQLCreating a user in MySQL or MariaDB and granting permissions to him to access a specific database and be able to write data on it is a very usual task that is necessary to perform each time you install a new application based on any of these database engines, like web applications running on top of LAMP stack. Whether it is a simple WordPress, or a more complex application tailor made, one way or another you will always have to complete these steps at some point before its deployment.

DanielHow to create a user in MySQL/MariaDB and grant permissions on a specific database

How to get a permanent token to access a Facebook page

2 comments

Through the following instructions you can easily get a permanent access_token to automatically connect your applications to a Facebook page and be able to obtain for example your number of followers periodically, get new likes or comments in real time, publish new entries in the timeline, or any of the possibilities offered by the Facebook Pages API.

DanielHow to get a permanent token to access a Facebook page

SugarCRM error when searching tasks related to custom modules with underscores within their names

No comments

When we create a custom module in SugarCRM (eg “grt_Providers_Contracts”) and create a link or relationship between that module and one that uses the “Related to” field type such as “Tasks”, we probably will want to search all the tasks related to our new module “grt_Providers_Contracts” from the simple or advanced search form from “Tasks” module.

However, there is a bug in SugarCRM that prevents us to retrieve tasks related to a custom module if that module has underscores (_) within his name, showing the following fatal error:

DanielSugarCRM error when searching tasks related to custom modules with underscores within their names

I am looking for freelance PHP programmers

4 comments

I am looking for freelance PHP programmers with initiative and entrepreneurial spirit to help me, first, take on the surplus of projects that my clients request to me and I can’t accept due to lack of time. On the other hand, but not least important, I would like to find reliable people to form a strong team to undertake and develop some projects I have in mind and others that someone may propose.

DanielI am looking for freelance PHP programmers

Using PHP to backup MySQL databases

81 comments

This post shows how to perform a partial or full backup of MySQL databases using only PHP code. This is very useful for example when a client doesn’t provide you with access data to the database of a web application and you only have an FTP connection available, or when you do have the connection data to the database but you can’t access it through the network (only available from localhost) and you can’t use tools like mysqldump to back up the information you need because you don’t have privileges for this, or simply because you have no access to a shell to which connect and run commands.

UPDATE (08-28-2017): moved the source code from myphp-backup.php and myphp-restore.php scripts to my GitHub daniloaz/myphp-backup repositoryhttps://github.com/daniloaz/myphp-backup

DanielUsing PHP to backup MySQL databases