Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

php[architect]:
February 2014 Issue Released - Databases
Feb 20, 2014 @ 11:37:32

The PHP-centric magazine php[architect] has released their latest edition, the February 2014 issue "Databases".

Before I got into coding I had no concept of what a database was, except that it was a place to store “data.” After reading about “tables” and “relations” I could visualize it better. Later, after working with databases for a few years, I can totally grok it. For years, relational databases were king. Now, it seems that non - relational databases are all the rage. Really, though, it’s like any other tool - you pick the one that suits the situation best.

In this month's edition articles include:

  • SQL to NoSQL Migration
  • I18n by Translation Proxy
  • The Confident Coder: Attention to Detail
  • Laravel Tips: Rapid Coding and Prototyping Through Generators

...and of course editorials from staff members Eli White and Beth Long Tucker. You can pick up a single copy (in PDF or print) of this issue from the php[architect] site or grab a full year's subscription.

tagged: phparchitect feb2014 issue release databases magazine

Link: http://www.phparch.com/magazine/2014-2/february/

SitePoint PHP Blog:
PHP and Neo4j: Introduction to Graph Databases
Jan 13, 2014 @ 12:18:52

On the SitePoint PHP blog today they've posted a new tutorial by Mehul Jain about combining PHP and Neo4J, a popular graph database tool as an alternative to the typical table-driven database structure. This is the first part of a series and only explains some of the basics behind the technology. The actual PHP implementation comes next.

For a long time, data has been typically stored in tabular form so as to increase the indexing and readability. Nowadays, the trends are changing as Graph databases are quickly gaining popularity. In fact, it would not be wrong to call them "the future of DBMS". New to the world of graphs and databases? Don't worry, by the end of this introductory article you will have sound theoretical knowledge about the topic – just enough to easily glide through the rest of the series – actual implementation.

He starts with the basics - introducing the ideas behind graph databases and some of the most basic concepts behind them. He continues, looking at common uses for them including dealing with connected data and how it lets you "move through" the data rather than jumping from record to record. He includes some real world examples if this kind of data ranging from social networks to network management.

tagged: graph databases introduction neo4j tutorial

Link: http://www.sitepoint.com/php-neo4j-introduction-graph-databases/

NetTuts.com:
Relational Databases for Dummies
Mar 14, 2013 @ 10:43:13

If you're relatively new to PHP development or have just meaning to get into using relational databases with your application, you should check out this new post from NetTuts giving a "for dummies" approach to learning about RDBMSes.

Web apps can be split into two major components: a front-end that displays and collects information, and a back-end for storing the information. In this article, I’ll demonstrate what a relational database is, and how to properly design your database to store your app’s information.

They describe the usage of a database in several steps (no code is included, just SQL at the end):

  • Get Some Data
  • Remove Repetitive Data Across Columns
  • Remove Repetitive Data Across Rows
  • Linking Tables with Keys

This is followed by links to a few of the different RDBMSes out there and a brief introduction to what SQL is and what it looks like.

tagged: relational databases introduction tutorial

Link:

International PHP Magazine:
Poll Question: Which one is your Favorite PHP Category?
Oct 17, 2006 @ 10:48:00

The International PHP Magazine has posted the results from their latest poll on their site today. The question of the week this time was "which of the following is your favorite category of PHP functionality?"

Among the options, there was "General PHP", "PHP Design", "PHP & XML" and "PHP Security". The one that came out on top, however, was "PHP & Databases" with 26.4% of the vote. Next in line was tied up between two options - "General PHP" and "PHP & Business/Ingegration" both with 15.3% of the votes.

Be sure anc check out (and vote on) their new poll for the week asking readers what they think is the biggest advantage of making to move to PHP5 for their scripts.

tagged: favorite category databases business general php5 favorite category databases business general php5

Link:

International PHP Magazine:
Poll Question: Which one is your Favorite PHP Category?
Oct 17, 2006 @ 10:48:00

The International PHP Magazine has posted the results from their latest poll on their site today. The question of the week this time was "which of the following is your favorite category of PHP functionality?"

Among the options, there was "General PHP", "PHP Design", "PHP & XML" and "PHP Security". The one that came out on top, however, was "PHP & Databases" with 26.4% of the vote. Next in line was tied up between two options - "General PHP" and "PHP & Business/Ingegration" both with 15.3% of the votes.

Be sure anc check out (and vote on) their new poll for the week asking readers what they think is the biggest advantage of making to move to PHP5 for their scripts.

tagged: favorite category databases business general php5 favorite category databases business general php5

Link:

Ana Aman's Blog:
PHPMyAdmin freezes on databases with too many tables
Jun 15, 2006 @ 12:37:48

From Ana Aman's Blogspot blog today, there's a quick post with a helpful hint for anyone working with PHPMyAdmin experiencing freeze-ups.

If you are using phpmyadmin on a database with more 1500 or more tables, you may experience problems. The page will not load at all so you will not be able to operate propery with phpmyadmin.

Of course you can still run commands from a terminal or console but it is not as confortable as using phpmyadmin.

The solution? Following a bit of digging, Ana discovered that upping the memory limit for the server PHPMyAdmin installed on makes a world of difference.

tagged: phpmyadmin many databases tables memory_limit php.ini phpmyadmin many databases tables memory_limit php.ini

Link:

Ana Aman's Blog:
PHPMyAdmin freezes on databases with too many tables
Jun 15, 2006 @ 12:37:48

From Ana Aman's Blogspot blog today, there's a quick post with a helpful hint for anyone working with PHPMyAdmin experiencing freeze-ups.

If you are using phpmyadmin on a database with more 1500 or more tables, you may experience problems. The page will not load at all so you will not be able to operate propery with phpmyadmin.

Of course you can still run commands from a terminal or console but it is not as confortable as using phpmyadmin.

The solution? Following a bit of digging, Ana discovered that upping the memory limit for the server PHPMyAdmin installed on makes a world of difference.

tagged: phpmyadmin many databases tables memory_limit php.ini phpmyadmin many databases tables memory_limit php.ini

Link:

Sitening.com:
Getting Real With Databases in PHP
Jun 01, 2006 @ 06:11:58

This new post on the Sitening.com blog (written up by Tyler Hall) today takes a look at PHP and databases (MySQL specifically in this case) and "getting real" with them.

many of the ideas behind Ruby on Rails are spot on. I particularly like how well it abstracts database queries into separate objects for each table. That’s very cool and can save having to write a lot of repetitive code. But having to run a Rails script to generate new files is a little too cumbersome for me. Like I said, I prefer to keep things simple. Can we do the same thing with PHP? Using just one file?

Yes.

He proceeds to show a class that can perform operations similar to those styled in RoR - creating the object, applying proterties to it and performing the action (inserts/delete/etc). It's all made possible through the use of the __get and __set functions offered in PHP5. From there, it's just a simple matter of defining the functions for the actions.

To bring the point home, he also includes some examples of how to use this kind of functionality with a bit more than the previous example - selecting, updating, deleting, and inserting a new record (including the action function for each). Lastly, he gives an example of extending this base class, as mentioned in his first example (creating an object like "Animal" or "User" to abstract out the connections even more.

tagged: getting real databases rubyonrails class __get __set getting real databases rubyonrails class __get __set

Link:

Sitening.com:
Getting Real With Databases in PHP
Jun 01, 2006 @ 06:11:58

This new post on the Sitening.com blog (written up by Tyler Hall) today takes a look at PHP and databases (MySQL specifically in this case) and "getting real" with them.

many of the ideas behind Ruby on Rails are spot on. I particularly like how well it abstracts database queries into separate objects for each table. That’s very cool and can save having to write a lot of repetitive code. But having to run a Rails script to generate new files is a little too cumbersome for me. Like I said, I prefer to keep things simple. Can we do the same thing with PHP? Using just one file?

Yes.

He proceeds to show a class that can perform operations similar to those styled in RoR - creating the object, applying proterties to it and performing the action (inserts/delete/etc). It's all made possible through the use of the __get and __set functions offered in PHP5. From there, it's just a simple matter of defining the functions for the actions.

To bring the point home, he also includes some examples of how to use this kind of functionality with a bit more than the previous example - selecting, updating, deleting, and inserting a new record (including the action function for each). Lastly, he gives an example of extending this base class, as mentioned in his first example (creating an object like "Animal" or "User" to abstract out the connections even more.

tagged: getting real databases rubyonrails class __get __set getting real databases rubyonrails class __get __set

Link: