News Feed
Sections

News Archive
feed this:

Padraic Brady's Blog:
ZF Blog Tutorial Addendum #1 Base URL, Magic Quotes, Database Schema & UTF-8
May 29, 2008 @ 16:12:03

Padraic Brady has an addendum he's posted to his "making a blogging application with the Zend Framework" series dealing with a few random issues from along the way.

The interesting thing about live publishing of a long tutorial series is that it's not flawless. In fact it's the opposite. [...] To cover all these I'll occasionally highlight the more important ones both in notes to new entries, or where they slip past me, in Addendum entries like this one.

There's four sections in this update - one dealing with the referencing of base URLs, another worrying about magic_quotes settings, an updated database schema for the project and the final about removing non-english characters in the title URLs.

0 comments voice your opinion now!
addendum base url magicquotes database schema utf8



IBM developerWorks:
Use an XML database in PHP and Java applications
April 03, 2008 @ 09:33:36

The IBM developerWorks site has posted a tutorial (you'll need to log in) showing how to use native XML databases to speed up development time for your applications.

Native XML databases have grown in popularity along with XML, because data is stored as native XML, rather than through tables in a traditional database. Using a native XML database means that a change to the schema requires minimal changes to your code and no change to the database. PHP and Java developers can benefit greatly from using native XML databases

IT talks about how to connect to the database (in this case DB2), grab the XML data via a query and how to insert information back in via a web-based form. There's also an example showing how to make a "search" on the data and how to change the schema of the database on the fly as well.

0 comments voice your opinion now!
xml database application tutorial db2 modify schema


Greg Beaver's Blog:
Update to libxml2 in PHP - progress hath been acquired
June 06, 2007 @ 11:45:00

Related to an issue from a previous post, Greg Beaver has posted a solution to his Relax NG schema problem in PHP.

Shortly after my last blog post, I got a very helpful email from Rob Richards, who offered to help me with my trials and tribulations. He took a quick look at the schema for package.xml, and a sample package.xml and was able to find two small tweaks to make parsing actually work (gasp). This changes everything. I am abandoning the creation of a relax NG schema in favor of the battle-tested xsd. The error messages for xsd validation are far clearer than the rng ones.

The code included shows how much simpler the error messages are with the XSD validation option versus the RNG ones.

0 comments voice your opinion now!
rng schema libxml2 validate error message rng schema libxml2 validate error message


Raphael Stolt's Blog:
Validating XML files within PHP 4 applications
April 24, 2007 @ 14:49:10

Raphael Stolt has posted a new tutorial today talking about how to validate the content of XML files within a PHP 4 application.

Today I ran into a small problem, validating import XML data against a DTD(Document Type Definition), and discovered a neat way to solve this without PHP4's own means, as the PHP 4 version on the running system wasn't supporting the DOM XML Functions. Xmllint, a command line XML tool, parses provided XML files and can be used to verify that these files are well formed and are satisfying an associated DTD/XML Schema.

In his example he shows a simple implementation of the tool, grabbing the file's information and pushing it through a command line request to check the file.

0 comments voice your opinion now!
validate xml file php4 application xmllint schema dtd validate xml file php4 application xmllint schema dtd


Developer.com:
Creating a Code Search Engine with PHP and MySQL
April 12, 2007 @ 09:30:00

Developer.com has posted a new tutorial by Jason Gilmore about the creation of a simple search engine based around a MySQL database and using PHP to perform the queries.

In this article I'll offer a simplified version of this search engine, introducing you to some compelling PHP and MySQL features along the way. You might adopt what you learn towards building your own search engine, or towards other applications.

He starts with the base of the application - the database schema (including loading data into it) - and works up from there. He opts to go with the fulltext search type as it can provide a huge performance boost over just using something like LIKE statements in your query. He also includes a bit of HTML for help make the output easier to use.

1 comment voice your opinion now!
searchengine mysql fulltext html schema searchengine mysql fulltext html schema


WebCheatSheet.com:
Two New Tutorials - Database Export & Sending Email
February 09, 2007 @ 12:36:00

WebCheatSheet.com has two new tutorials posted today - one dealing with the export of a database schema in an XML format and the other about sending emails from PHP.

Here's a link to the first article.

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema.

And a link to article number two.

So, you want to send automated email messages from your PHP application. This can be in direct response to a user's action, such as signing up for your site, or a recurring event at a set time, such as a monthly newsletter. Sometimes email contains file attachments, both plain text and HTML portions, and so on. To understand how to send each variation that may exist on an email, we will start with the simple example and move to the more complicated.
1 comment voice your opinion now!
database export xml schema sending email text html attachment database export xml schema sending email text html attachment


WebReference.com:
Creating a Custom RSS Feed with PHP and MySQL
October 25, 2006 @ 09:56:00

The WebReference.com site has a new tutorial posted today - a look at the creation of a custom RSS feed with the help of a a dash of both PHP and MySQL.

You'll learn how to syndicate your own custom RSS feeds using PHP and MySQL. We'll first learn how to create two database tables and then how to retrieve data from them which will be formatted into an RSS feed.

They start from scratch instead of trying to integrate with your pre-existing database schema. They choose to go with a news system that includes the contents of the post, an image associated with it, and a link back to it. They create a class to make the RSS that contains methods like GetFeed, getDetails, and getItems to help build the RSS output. It's all done by appending the tags and information togethter, so don't look for any XML handling here.

0 comments voice your opinion now!
rss feed mysql tutorial class schema custom database rss feed mysql tutorial class schema custom database


DevShed:
Creating a Login Script for a PHP Invoicing System
September 07, 2006 @ 06:53:25

DevShed is starting another new series today with part one of their look at "Building an Invoicing System" - building the login script.

In this first part of "Building an Invoicing System," we are going to look at invoice management. Why would anyone want an online invoicing system? Well, if you are a freelance web developer like myself, you will undoubtedly need to invoice your clients so as to be able to get paid at the end of the month. This application will help you to manage your client details as well as your invoices.

It's a basic level tutorial, and starts from the basics - being sure PHP and MySQL are installed and working together. They offer a few troubleshooting tips if things aren't working right before giving you the database schema and the actual (simple) script to use for logging in a user.

1 comment voice your opinion now!
invoicing system login tutorial beginner mysql schema invoicing system login tutorial beginner mysql schema


DevShed:
Generating View from MySQL to Simulate the Model-View-Controller Schema in PHP
August 21, 2006 @ 08:46:30

DevShed has posted part three in their "Simulating the Model-View-Controller Schema in PHP" series today, this time focusing on the last of the three, the View.

All right, after refreshing the topics covered previously, as well as clarifying some key concepts with reference to the concrete subject of this series, this journey will continue by constructing yet another practical example to expand your overall knowledge of object-based programming with PHP. In particular, it's designed to show you to use a MVC-driven relationship in another real-world situation.

If you're wondering to what other cases this relationship can be specifically applied, then I have good news for you. In this final article, I'll show you how to implement the MVC schema, in order to generate different outputs (or views) from a given MySQL data set.

They start over with their code, generating a new schema based around a MySQL processing class. The controller pulls its information from the database (our model) as to how the results should be displayed. Next they describe the model to help interface with the actual table and finishing it off with the output class, resulting in either XML or plain-text output of the user information.

1 comment voice your opinion now!
model view controller simulate mysql part3 schema tutorial model view controller simulate mysql part3 schema tutorial


Lukas Smith's Blog:
php|tek wrap up
May 02, 2006 @ 07:14:43

Lukas Smith was one of the attendees of the just-past php|tek conference in Orlando, Florida and has posted his own wrap up of his experiences.

I spend the past week in florida. First visiting my parents and then spending time at php|tek where I was invited to give two talks. I was quite nervous about the first talk about "database schema deployment". My original intention was to create a working solution to handle scripting the necessary DDL and DML statements to manage schema updates. However while researching the topic I found that its even less trivial than I expected.

My second talk "beyond SQL" went fairly smooth, although I kind of suffered from the lack of a flip chart to draw on. I really need to sit down and draw some diagrams to include in my slides. The talk was essentially a stripped down version of my "fast, portable, SQL" talk. However I did not strip it down enough so I was short on time. I was talking to a mostly MySQL using crowd so I ended up giving a lot of MySQL specific advice.

Besides his talks, he also shares some of the experiences outside of his talks too, including perspectives on the hotel, the area, his participation in the panel discussion on PEAR and, of course, the goodies handed out.

0 comments voice your opinion now!
php phptek wrapup talks database schema deployment SQL php phptek wrapup talks database schema deployment SQL



Community Events











Don't see your event here?
Let us know!


database package cakephp ajax job developer conference example mysql PEAR application release book zend code zendframework releases security framework PHP5

All content copyright, 2008 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework