Archive for July 20th, 2006
PHP Developer - July 20th, 2006
The Adobe Developer Source has posted a new tutorial showing how to, with the combination of PHP and Flex, to browse the contents of a MySQL database.
One critical element to remember about programming with Flex is that it cannot connect to a database directly - it requires some form of middleware in order to access data. You’ll be using PHP in order to generate the XML files that Flex will use to manipulate the data from the database.
PHP plays the middle-man in this lengthy tutorial, passing XML messages back and forth between the Flex application and interpreting it into MySQL queries and results. They take the PHP script through, step by step, to ensre you know exactly how it works. Next up is the Flex, complete with the code listing to create the simple database browsing application.
There’s explainations, screenshots, and even a little ActionScript here and there, but in the end, you’ll have a light, simple database browser to view the contents of your table.
Continue Reading ·
PHP Developer - July 20th, 2006
On the SearchOpenSource.com site today, there’s this new article combining two popular things together to make one powerful and productive tool using the Amazon web services and the Zend Framework.
Web frameworks have been all the rage lately, and for good reason. They eliminate a great deal of the mindless repetition involved in creating Web applications large and small.
Spurred on by the enormous success of Rails, PHP developers have been hard at work creating a number of framework solutions. Notable efforts include Cake, Symfony, and, more recently, the Zend Framework.
They start with the output of the scripts, two tables worth of data - a list of the sales rank and the details on a specific book. Then it’s on to the good stuff - the creation of the controller to connect to Amazon, the views to output the data, and the method to make the request and populate the database.
Continue Reading ·
Dev Shed - July 20th, 2006
Last week we began our discussion of MySQL database security. This week we continue that discussion with user account management. The second of several parts this article is excerpted from chapter 12 of the em MySQL 5. Certification Guide em written by Paul Dubois et al. Sams 2 5 ISBN 672328127 ….
(Advertisement) Hit your SQL Server 2005 performance target Get the most from your SQL Server 2005 platform with Quest Software. Identify, rewrite & benchmark poor SQL. Isolate SQL Server stress factors. Discover, diagnose and resolve performance issues in real time. And forecast & trend storage requirements.
Continue Reading ·
PHP Developer - July 20th, 2006
PHPBuilder.com has posted part six of their “Using XML” series today with a focus on validation techniques using both normal PHP abilities and the XSL functionality in PHP5 with the Schematron language.
This series has so far focused on XML technologies and how they can be utilised using PHP 5. A subject we have not touched upon yet, is XML validation. This article will explore the application independent XML validation standards of DTD’s, the XML Schema Language and the XSLT-based Schematron language.
They point back to part one of the series for the XML library they’ll use and waste no time getting right into the code. They demonstrate a simple validation first before moving on to the use of DTDs to ensure the correct content. Next up is more work with the XML schemas continuing on to the Schematron functionality (their use and validation).
Continue Reading ·
PHP Developer - July 20th, 2006
For those that might of missed it, Zend put on a webcast/screencast yesterday on the topic of “Web Services with PHP”. The good news is, though, that if you weren’t able to make it, the fine folks over at the Zend Developer Zone have a recorded version of it.
Due to technical limitations with our streaming software, we could only allow the first 550 folks into the presentation. Because of the network load, this was a difficult presentation to pull off due to lag. Paging from slide-to-slide was very delayed, so showing the code-completion capabilities of Zend Studio was nearly impossible. Despite the technical difficulties, several good questions were asked and feedback was very positive.
In order for everyone to see the presentation, I re-recorded it this afternoon, and it’s available for your viewing. This one is much smoother, and I expanded on some of the topics that I glanced over in the first one. So even if you viewed the first attempt, you’ll probably get more out of the second.
The presentation can be viewed here and the Zend DevZone post also has the question/answer section as well.
Continue Reading ·