 | News Feed |
Sections
|
| feed this: |  |
IBM developerWorks: Use an XML database in PHP and Java applications
by Chris Cornutt 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.
voice your opinion now!
xml database application tutorial db2 modify schema
Developer.com: Creating a Code Search Engine with PHP and MySQL
by Chris Cornutt 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.
voice your opinion now!
searchengine mysql fulltext html schema searchengine mysql fulltext html schema
WebReference.com: Creating a Custom RSS Feed with PHP and MySQL
by Chris Cornutt 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.
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
by Chris Cornutt 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.
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
by Chris Cornutt 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.
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
by Chris Cornutt 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.
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!
|