DreamNest Technology Web Net

Kae Verens recently posted a book review to his blog about the Packt publishing book “Mastering phpMyAdmin 3.1″ and describes how the book is different from its predecessor (covering phpMyAdmin 2.11).

There are many reviews of this book already, so I will mostly describe how this edition is different from the previous one. In short, though, I would say that this version is much more readable, and is still the best book to buy if you want a book on phpMyAdmin. The reviews I’ve read here all agree with my own assessment that phpMyAdmin is a surprise ‘” right when you think you know what it does, a book points out a load of stuff you didn’t know it did.

He breaks it into two sections – the things that have gotten better (like the removal of some unneeded items and he inclusion of some of the more minor features) and some things that, unfortunately, have not improved (such as the increased size of the table of contents and the addition of other, too large screenshots).

Related posts

• VideoWhisper Video Consultation Integration (0)
• Table Simple (0)
• Skunky Form (0)
• SitePoint.com: How To Handle File Uploads With PHP (0)
• Silicon Valley Elite Flock To Y Combinator Demo Day (0)

On the NETTUTS.com site today there’s a new (quite comprehensive) article focusing in on the Kohana framework:

Kohana is a PHP 5 framework that uses the Model View Controller (MVC) architectural pattern. There are several reasons why you should choose Kohana but the main ones are security, weightlessness and simplicity. In this tutorial, I’ll introduce its main features, and, with a simple demonstration, I’ll show you how much time Kohana can potentially save you.

The article covers everything from the download and install out to creating a simple project – a CD collection manager with a MySQL backend. Complete code (including a bit of CSS) is provided for you copy and paste pleasure.

Related posts

• YC-Funded RethinkDB: A MySQL Storage Engine Built From The Ground Up For Solid State Drives (0)
• XML DB (0)
• What is new in PHP 5.3 for PHP amateurs? (0)
• WebReference.com: XML and PHP Simplified – XML,PHP and the Database (0)
• WebReference.com: Data Filtering (0)

New on the SitePoint “PHP & MySQL Tutorials” blog today Kevin Yank has posted another excerpt from the “Build Your Own Database Driven Website Using PHP and MySQL” looking at handling file uploads in PHP.

An common challenge faced by PHP programmers is how to accept files uploaded by visitors to your site. In this bonus excerpt from Chapter 12 of [the book] you’ll learn how to accept file uploads from your web site visitors securely and store them.

The tutorial introduces the $_FILES superglobal and how you can use it to access the file information about the uploads the user’s can make. He also mentions some of the functions that can be used on the files (like is_uploaded_file).

Related posts

• Silicon Valley Elite Flock To Y Combinator Demo Day (0)
• What is new in PHP 5.3 for PHP amateurs? (0)
• WebReference.com: XML and PHP Simplified – XML,PHP and the Database (0)
• WebReference.com: Data Filtering (0)
• Web Open Patch (0)

Sebastian Nohn has posted a book review to his blog today covering the Packt Publishing book “Mastering phpMyAdmin 3.1 for Effective MySQL Management”.

I’ve been using phpMyAdmin since… Hmmm… Well… The times before I used to code in PHP. So when offered to review Mastering phpMyAdmin 3.1 by Marc Deslisle, I didn’t expected to learn anything new, but I was wrong.

He recommends the book to both beginners and experts to the software (more so to the beginners, obviously) and mentions some of the topics it covers – everything from a basic introduction to the interface out to using the SQL validator and advanced bookmarking.

Related posts

• Silicon Valley Elite Flock To Y Combinator Demo Day (0)
• YC-Funded RethinkDB: A MySQL Storage Engine Built From The Ground Up For Solid State Drives (0)
• VideoWhisper Video Consultation Integration (0)
• VideoWhisper 2 Way Video Chat Integration (0)
• User talk:Webscom (0)

Elizabeth Smith has posted about the latest release of a PHP extension she’s been working hard on – the Cairo 2D graphics extension.

The first alpha of the PECL Cairo extension I’ve been working on is finally out. Cairo is a 2D graphics library written in C with support for multiple output devices. The extension provides an Object Oriented API, but also includes procedural methods. This is similar to PHP’s date and mysqli extensions

The extension (for PHP 5.2.x and 5.3.x versions) requires the CairoGraphics library to work but it allows you to create some great graphics and output them in a number of ways (like PDF, SVG and PostScript). The extension is still in the alpha stages because the API isn’t quite complete, but you can still download this version if you’d like to give it a shot.

Related posts

• PreLoad Images (0)
• MySQL Slideshow (0)
• YC-Funded RethinkDB: A MySQL Storage Engine Built From The Ground Up For Solid State Drives (0)
• Yahoo Veterans Launch Rocket Fuel, A “Hybrid” Ad Network (0)
• XML DB (0)

Here’s what was popular in the PHP community one year ago today:

• Eran Gelperin’s Blog: Operator overloading in PHP

• IBM developerWorks: Integrate your PHP application with Google Calendar
• Developer Tutorials Blog: Benchmarking PHP frameworks
• Community News: Symfonians – Symfony-based Social Networking Application
• Francois Zeninotto’s Blog: Comparing Propel, Doctrine and sfPropelFinder
• International Stock Exchange Forum: Getting RSS Feeds into Lively
• Gyorgy Fekete’s Blog: Web Development in Mac OS X – Complete Guide
• Jonathan Snook’s Blog: CakePHP Debug Styles
• Zend Developer Zone: Mastering phpMyAdmin for Effective MySQL Management – Marc Delisle
• Developer Tutorials Blog: Migrating legacy PHP 4 applications to PHP 5
• Alessandro Crugnola’s Blog: AMFPHP issue referencing ByteArray
• Fred Wu’s Blog: Zend Framework, where do you want to go tomorrow?
• PHPImpact Blog: Zend_Form Performance Issues
• IT Jungle: PHP and the Zend Framework
• Rob Allen’s Blog: Notes on Zend_Cache

Related posts

• Oracle To Sun Customers (And IBM): “We’re In It To Win It” (0)
• The Churchill Club: A Conversation With Facebook COO Sheryl Sandberg (0)
• TC50: 5to1 Lets Publishers Regain Control Over Unsold Ad Inventory (0)
• Silicon Valley Elite Flock To Y Combinator Demo Day (0)
• Live From Yahoo’s “What Matters Most” Event (0)

This SQL command creates a new database on the MySQL Server when run. It is phrased as create database [DatabaseName];. Let’s say you wanted to create a database named… (source: About) RSS feeds and News Widgets – in.feedzilla.com

Related posts

• Import Blogger Posts into WordPress Using Windows XP XAMPP (source: ASP Free) (0)
• TC50: CrowdFusion Merges The Best Features Of Blogs, Wikis, And More Into One Unified CMS (0)
• Site News: Popular Posts for the Week of 06.26.2009 (0)
• Site News: Job Postings for the week of 08.16.2009 (0)
• Site News: Blast from the Past – One Year Ago in PHP (0)

This article does not require any additional software installed on your machine to get your own cloud instance running other than your browser.

To start, Amazon EC2 (Elastic Compute Cloud) is a service by Amazon which lets anyone create, launch, and terminate server instances as needed, paying by the hour for active servers, hence the term “elastic”. The service starts as low as 0.11$ per hour. For this article an instance of LAMP server and a Windows Server 2003 was launched and cost under $0.25

1) Signup for Amazon EC2 here (If you have an amazon account you save more time!)
2) Login to the EC2 management console

AWS Management Console (Click to enlarge)

3) On the management console, Click on Launch Instances
4) Select an AMI (Amazon Machine Image). You will get a huge list ranging from windows servers to LAMP servers, Ruby on Rails server, Ubuntu, Debian, Open Solaris etc. If you also look at the community supplied options you will have nearly 3000 AMIs.

List of Amazon Machine Images

5) Create a key pair by following on screen instructions. This is to help you to login to your AMI once it is ready.
7) Configure firewall settings and limit access to the server (SSH, MySQL, Web, etc).

Authorise connection method

8 ) You will now arrive at the final step of your wizard. Enter number of instances. Select an instance type Small, High CPU, etc. You will also have to select the key pair that was generated for you at Step 5. Click Launch once set.

Set Number of Instances

9) Voila! your instance will be available in just a few minutes. Now you can pat yourselves on the back for all the hard work!

It is amazing how quickly you can get an instance running. Once your server is up and running how do you connect to this instance? Well, it is pretty simple if you are using windows you get to use RDP (Terminal Services). For non-windows instances you will have to use SSH to connect to the server.

Connecting to your now running Windows instance

It is easy to connect to a windows amazon instance via RDP compared to SSH connection to a linux server. To retrieve the RDP password, you will have to right click your instance and retrieve connection information using the key pair you have been given.

Connecting via RDP

You will have to connect using Administrator as your username. You will find all other info you need on the management console.

Connecting via SSH to your running Linux instance

You will need putty to connect to your linux server via SSH on a windows machine. If you are on a linux machine you will be able to use the ssh command as shown on the management console. With putty you will also need an additional tool to create a PPK file from the PEM file that you are given from the management console. To do this you will have to download an additional tool called PuttyGen.exe. You have to load the PPK file under the SSH Auth section of the putty client.

SSH Connection to your instance

Once your instance is up and running you will be able to connect to the webserver, connect to the MySQL server, if it is enabled with the AMI. The last two sections are to help you further configure your instance further. Technically you will have your services running after the first set of steps which can be complete in 15 minutes!

Related posts

• VideoWhisper Video Consultation Integration (0)
• VideoWhisper 2 Way Video Chat Integration (0)
• User talk:Webscom (0)
• Silicon Valley Elite Flock To Y Combinator Demo Day (0)
• Server-Side Magazine: Creating a PHP 5.3 Virtual Development Environment (0)